A project to find out which maps are present at http://image.weather.com/web/radar/ (given the absence of a directory listing). From Dayton Dynamic Languages' Nov. 2014 meeting.
!pip install ddlgenerator
Requirement already satisfied (use --upgrade to upgrade): ddlgenerator in /home/catherine/proj/ddl-generator Requirement already satisfied (use --upgrade to upgrade): python-dateutil in /home/catherine/ve/ddl/lib/python3.4/site-packages/python_dateutil-2.2-py3.4.egg (from ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): sqlalchemy in /home/catherine/ve/ddl/lib/python3.4/site-packages/SQLAlchemy-0.9.7-py3.4-linux-x86_64.egg (from ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): dateutils in /home/catherine/ve/ddl/lib/python3.4/site-packages/dateutils-0.6.6-py3.4.egg (from ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): pyyaml in /home/catherine/ve/ddl/lib/python3.4/site-packages/PyYAML-3.11-py3.4-linux-x86_64.egg (from ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): beautifulsoup4 in /home/catherine/ve/ddl/lib/python3.4/site-packages (from ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): requests in /home/catherine/ve/ddl/lib/python3.4/site-packages (from ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): pymongo in /home/catherine/ve/ddl/lib/python3.4/site-packages (from ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): data-dispenser>=0.2.4 in /home/catherine/proj/data-dispenser (from ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): six in /home/catherine/ve/ddl/lib/python3.4/site-packages/six-1.8.0-py3.4.egg (from python-dateutil->ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): argparse in /home/catherine/ve/ddl/lib/python3.4/site-packages/argparse-1.1-py3.4.egg (from dateutils->ddlgenerator) Requirement already satisfied (use --upgrade to upgrade): pytz in /home/catherine/ve/ddl/lib/python3.4/site-packages/pytz-2014.7-py3.4.egg (from dateutils->ddlgenerator) Cleaning up...
!pip install ipython_sql
Requirement already satisfied (use --upgrade to upgrade): ipython-sql in /home/catherine/ve/ddl/lib/python3.4/site-packages Requirement already satisfied (use --upgrade to upgrade): prettytable in /home/catherine/ve/ddl/lib/python3.4/site-packages (from ipython-sql) Requirement already satisfied (use --upgrade to upgrade): ipython>=1.0 in /home/catherine/ve/ddl/lib/python3.4/site-packages (from ipython-sql) Requirement already satisfied (use --upgrade to upgrade): sqlalchemy>=0.6.7 in /home/catherine/ve/ddl/lib/python3.4/site-packages/SQLAlchemy-0.9.7-py3.4-linux-x86_64.egg (from ipython-sql) Requirement already satisfied (use --upgrade to upgrade): sqlparse in /home/catherine/ve/ddl/lib/python3.4/site-packages (from ipython-sql) Requirement already satisfied (use --upgrade to upgrade): six in /home/catherine/ve/ddl/lib/python3.4/site-packages/six-1.8.0-py3.4.egg (from ipython-sql) Cleaning up...
!ddlgenerator --inserts sqlite http://en.wikipedia.org/wiki/List_of_airports_in_the_United_States > airports.sql
!rm airports.sqlite
!sqlite3 airports.sqlite ".read airports.sql"
!sqlite3 airports.sqlite "alter table list_of_airports_in_the_united_states rename to airports"
%load_ext sql
%sql sqlite:///airports.sqlite
'Connected: None@airports.sqlite'
%sql select * from airports limit 10
Done.
city | faa | iata | icao | airport | role | enplanements |
---|---|---|---|---|---|---|
ALABAMA | None | None | None | None | None | None |
Birmingham | BHM | BHM | KBHM | Birmingham–Shuttlesworth International Airport | P-S | 1,335,014 |
Dothan | DHN | DHN | KDHN | Dothan Regional Airport | P-N | 48,423 |
Huntsville | HSV | HSV | KHSV | Huntsville International Airport (Carl T. Jones Field) | P-S | 505,541 |
Mobile | MOB | MOB | KMOB | Mobile Regional Airport | P-N | 287,661 |
Montgomery | MGM | MGM | KMGM | Montgomery Regional Airport (Dannelly Field) | P-N | 157,958 |
ALASKA | None | None | None | None | None | None |
Anchorage | ANC | ANC | PANC | Ted Stevens Anchorage International Airport | P-M | 2,325,030 |
Aniak | ANI | ANI | PANI | Aniak Airport | P-N | 14,334 |
Barrow | BRW | BRW | PABR | Wiley Post–Will Rogers Memorial Airport | P-N | 51,568 |
base_url = 'http://image.weather.com/web/radar/us_%s_closeradar_large_usen.jpg'
faa = %sql select faa, city from airports where faa is not null
Done.
faa[:10]
[('BHM', 'Birmingham'), ('DHN', 'Dothan'), ('HSV', 'Huntsville'), ('MOB', 'Mobile'), ('MGM', 'Montgomery'), ('ANC', 'Anchorage'), ('ANI', 'Aniak'), ('BRW', 'Barrow'), ('BET', 'Bethel'), ('CDV', 'Cordova')]
iata = %sql select iata, city from airports where iata is not null
Done.
results = set(tuple(f) for f in faa) | set(tuple(i) for i in iata)
len(results)
397
urls = [(base_url % r[0].lower(), r[1]) for r in results]
urls[:10]
[('http://image.weather.com/web/radar/us_rkd_closeradar_large_usen.jpg', 'Rockland'), ('http://image.weather.com/web/radar/us_gtr_closeradar_large_usen.jpg', 'Columbus / West Point / Starkville'), ('http://image.weather.com/web/radar/us_hln_closeradar_large_usen.jpg', 'Helena'), ('http://image.weather.com/web/radar/us_wrg_closeradar_large_usen.jpg', 'Wrangell'), ('http://image.weather.com/web/radar/us_grk_closeradar_large_usen.jpg', 'Fort Hood / Killeen / Temple'), ('http://image.weather.com/web/radar/us_ani_closeradar_large_usen.jpg', 'Aniak'), ('http://image.weather.com/web/radar/us_hts_closeradar_large_usen.jpg', 'Huntington'), ('http://image.weather.com/web/radar/us_myr_closeradar_large_usen.jpg', 'Myrtle Beach'), ('http://image.weather.com/web/radar/us_dro_closeradar_large_usen.jpg', 'Durango'), ('http://image.weather.com/web/radar/us_mtj_closeradar_large_usen.jpg', 'Montrose')]
import requests
response = requests.get(base_url % 'atl')
response
<Response [200]>
response.status_code
200
import time
valid_urls = []
for (url, city) in urls:
response = requests.get(url)
if response.status_code == 200:
valid_urls.append((url, city))
print(url, city, response.status_code)
time.sleep(2)
http://image.weather.com/web/radar/us_rkd_closeradar_large_usen.jpg Rockland 404 http://image.weather.com/web/radar/us_gtr_closeradar_large_usen.jpg Columbus / West Point / Starkville 404 http://image.weather.com/web/radar/us_hln_closeradar_large_usen.jpg Helena 404 http://image.weather.com/web/radar/us_wrg_closeradar_large_usen.jpg Wrangell 404 http://image.weather.com/web/radar/us_grk_closeradar_large_usen.jpg Fort Hood / Killeen / Temple 404 http://image.weather.com/web/radar/us_ani_closeradar_large_usen.jpg Aniak 404 http://image.weather.com/web/radar/us_hts_closeradar_large_usen.jpg Huntington 404 http://image.weather.com/web/radar/us_myr_closeradar_large_usen.jpg Myrtle Beach 404 http://image.weather.com/web/radar/us_dro_closeradar_large_usen.jpg Durango 404 http://image.weather.com/web/radar/us_mtj_closeradar_large_usen.jpg Montrose 404 http://image.weather.com/web/radar/us_fsm_closeradar_large_usen.jpg Fort Smith 404 http://image.weather.com/web/radar/us_roa_closeradar_large_usen.jpg Roanoke 404 http://image.weather.com/web/radar/us_rdd_closeradar_large_usen.jpg Redding 404 http://image.weather.com/web/radar/us_las_closeradar_large_usen.jpg Las Vegas 200 http://image.weather.com/web/radar/us_mke_closeradar_large_usen.jpg Milwaukee 404 http://image.weather.com/web/radar/us_ewb_closeradar_large_usen.jpg New Bedford 404 http://image.weather.com/web/radar/us_brd_closeradar_large_usen.jpg Brainerd 404 http://image.weather.com/web/radar/us_lck_closeradar_large_usen.jpg Columbus 404 http://image.weather.com/web/radar/us_sjc_closeradar_large_usen.jpg San Jose 404 http://image.weather.com/web/radar/us_rks_closeradar_large_usen.jpg Rock Springs 404 http://image.weather.com/web/radar/us_mvy_closeradar_large_usen.jpg Vineyard Haven 404 http://image.weather.com/web/radar/us_fnt_closeradar_large_usen.jpg Flint 404 http://image.weather.com/web/radar/us_ykm_closeradar_large_usen.jpg Yakima 404 http://image.weather.com/web/radar/us_dbq_closeradar_large_usen.jpg Dubuque 404 http://image.weather.com/web/radar/us_sea_closeradar_large_usen.jpg Seattle / Tacoma (SeaTac) 200 http://image.weather.com/web/radar/us_avp_closeradar_large_usen.jpg Wilkes-Barre / Scranton 404 http://image.weather.com/web/radar/us_mry_closeradar_large_usen.jpg Monterey 404 http://image.weather.com/web/radar/us_bis_closeradar_large_usen.jpg Bismarck 200 http://image.weather.com/web/radar/us_eug_closeradar_large_usen.jpg Eugene 404 http://image.weather.com/web/radar/us_gfk_closeradar_large_usen.jpg Grand Forks 404 http://image.weather.com/web/radar/us_msn_closeradar_large_usen.jpg Madison 404 http://image.weather.com/web/radar/us_cec_closeradar_large_usen.jpg Crescent City 404 http://image.weather.com/web/radar/us_lnk_closeradar_large_usen.jpg Lincoln 404 http://image.weather.com/web/radar/us_lbb_closeradar_large_usen.jpg Lubbock 404 http://image.weather.com/web/radar/us_san_closeradar_large_usen.jpg San Diego 404 http://image.weather.com/web/radar/us_leb_closeradar_large_usen.jpg Lebanon 404 http://image.weather.com/web/radar/us_bgr_closeradar_large_usen.jpg Bangor 404 http://image.weather.com/web/radar/us_bil_closeradar_large_usen.jpg Billings 200 http://image.weather.com/web/radar/us_rdm_closeradar_large_usen.jpg Redmond 404 http://image.weather.com/web/radar/us_1g4_closeradar_large_usen.jpg Peach Springs 404 http://image.weather.com/web/radar/us_abr_closeradar_large_usen.jpg Aberdeen 404 http://image.weather.com/web/radar/us_ewn_closeradar_large_usen.jpg New Bern 404 http://image.weather.com/web/radar/us_sux_closeradar_large_usen.jpg Sioux City 404 http://image.weather.com/web/radar/us_ggg_closeradar_large_usen.jpg Longview 404 http://image.weather.com/web/radar/us_bur_closeradar_large_usen.jpg Burbank 404 http://image.weather.com/web/radar/us_ase_closeradar_large_usen.jpg Aspen 404 http://image.weather.com/web/radar/us_imt_closeradar_large_usen.jpg Iron Mountain / Kingsford 404 http://image.weather.com/web/radar/us_mgw_closeradar_large_usen.jpg Morgantown 404 http://image.weather.com/web/radar/us_esc_closeradar_large_usen.jpg Escanaba 404 http://image.weather.com/web/radar/us_ord_closeradar_large_usen.jpg Chicago 200 http://image.weather.com/web/radar/us_okc_closeradar_large_usen.jpg Oklahoma City 200 http://image.weather.com/web/radar/us_ttn_closeradar_large_usen.jpg Trenton 404 http://image.weather.com/web/radar/us_sck_closeradar_large_usen.jpg Stockton 404 http://image.weather.com/web/radar/us_ege_closeradar_large_usen.jpg Eagle 404 http://image.weather.com/web/radar/us_spi_closeradar_large_usen.jpg Springfield 404 http://image.weather.com/web/radar/us_stx_closeradar_large_usen.jpg Christiansted, St. Croix 404 http://image.weather.com/web/radar/us_tul_closeradar_large_usen.jpg Tulsa 404 http://image.weather.com/web/radar/us_crq_closeradar_large_usen.jpg Carlsbad 404 http://image.weather.com/web/radar/us_sba_closeradar_large_usen.jpg Santa Barbara 404 http://image.weather.com/web/radar/us_cic_closeradar_large_usen.jpg Chico 404 http://image.weather.com/web/radar/us_sna_closeradar_large_usen.jpg Santa Ana 404 http://image.weather.com/web/radar/us_env_closeradar_large_usen.jpg Wendover 404 http://image.weather.com/web/radar/us_gso_closeradar_large_usen.jpg Greensboro 404 http://image.weather.com/web/radar/us_crw_closeradar_large_usen.jpg Charleston 200 http://image.weather.com/web/radar/us_msp_closeradar_large_usen.jpg Minneapolis 200 http://image.weather.com/web/radar/us_yum_closeradar_large_usen.jpg Yuma 404 http://image.weather.com/web/radar/us_gal_closeradar_large_usen.jpg Galena 404 http://image.weather.com/web/radar/us_blv_closeradar_large_usen.jpg Belleville 404 http://image.weather.com/web/radar/us_abq_closeradar_large_usen.jpg Albuquerque 200 http://image.weather.com/web/radar/us_hhh_closeradar_large_usen.jpg Hilton Head Island 404 http://image.weather.com/web/radar/us_ito_closeradar_large_usen.jpg Hilo 404 http://image.weather.com/web/radar/us_iad_closeradar_large_usen.jpg Washington, D.C. / Chantilly / Dulles 404 http://image.weather.com/web/radar/us_msy_closeradar_large_usen.jpg New Orleans 404 http://image.weather.com/web/radar/us_eyw_closeradar_large_usen.jpg Key West 404 http://image.weather.com/web/radar/us_hpn_closeradar_large_usen.jpg White Plains 404 http://image.weather.com/web/radar/us_dhn_closeradar_large_usen.jpg Dothan 404 http://image.weather.com/web/radar/us_ags_closeradar_large_usen.jpg Augusta 404 http://image.weather.com/web/radar/us_jan_closeradar_large_usen.jpg Jackson 200 http://image.weather.com/web/radar/us_eko_closeradar_large_usen.jpg Elko 404 http://image.weather.com/web/radar/us_bhb_closeradar_large_usen.jpg Bar Harbor 404 http://image.weather.com/web/radar/us_pbi_closeradar_large_usen.jpg West Palm Beach 404 http://image.weather.com/web/radar/us_pir_closeradar_large_usen.jpg Pierre 404 http://image.weather.com/web/radar/us_lny_closeradar_large_usen.jpg Lanai City (Lānaʻi City) 404 http://image.weather.com/web/radar/us_xna_closeradar_large_usen.jpg Fayetteville 404 http://image.weather.com/web/radar/us_sit_closeradar_large_usen.jpg Sitka 404 http://image.weather.com/web/radar/us_lwb_closeradar_large_usen.jpg Lewisburg 404 http://image.weather.com/web/radar/us_ida_closeradar_large_usen.jpg Idaho Falls 404 http://image.weather.com/web/radar/us_sbn_closeradar_large_usen.jpg South Bend 404 http://image.weather.com/web/radar/us_ind_closeradar_large_usen.jpg Indianapolis 200 http://image.weather.com/web/radar/us_hsv_closeradar_large_usen.jpg Huntsville 404 http://image.weather.com/web/radar/us_pln_closeradar_large_usen.jpg Pellston 404 http://image.weather.com/web/radar/us_pga_closeradar_large_usen.jpg Page 404 http://image.weather.com/web/radar/us_mlb_closeradar_large_usen.jpg Melbourne 404 http://image.weather.com/web/radar/us_elm_closeradar_large_usen.jpg Elmira / Corning 404 http://image.weather.com/web/radar/us_lbe_closeradar_large_usen.jpg Latrobe 404 http://image.weather.com/web/radar/us_fsd_closeradar_large_usen.jpg Sioux Falls 200 http://image.weather.com/web/radar/us_sgu_closeradar_large_usen.jpg St. George / Beaver 404 http://image.weather.com/web/radar/us_mkg_closeradar_large_usen.jpg Muskegon 200 http://image.weather.com/web/radar/us_dtw_closeradar_large_usen.jpg Detroit / Romulus 200 http://image.weather.com/web/radar/us_lws_closeradar_large_usen.jpg Lewiston 404 http://image.weather.com/web/radar/us_cha_closeradar_large_usen.jpg Chattanooga 404 http://image.weather.com/web/radar/us_alo_closeradar_large_usen.jpg Waterloo 404 http://image.weather.com/web/radar/us_rfd_closeradar_large_usen.jpg Rockford 404 http://image.weather.com/web/radar/us_bji_closeradar_large_usen.jpg Bemidji 404 http://image.weather.com/web/radar/us_gum_closeradar_large_usen.jpg Agana / Tamuning 404 http://image.weather.com/web/radar/us_sig_closeradar_large_usen.jpg San Juan / Miramar 404 http://image.weather.com/web/radar/us_dsm_closeradar_large_usen.jpg Des Moines 200 http://image.weather.com/web/radar/us_koa_closeradar_large_usen.jpg Kailua/Kona 404 http://image.weather.com/web/radar/us_aus_closeradar_large_usen.jpg Austin 404 http://image.weather.com/web/radar/us_btr_closeradar_large_usen.jpg Baton Rouge 404 http://image.weather.com/web/radar/us_orf_closeradar_large_usen.jpg Norfolk 404 http://image.weather.com/web/radar/us_bff_closeradar_large_usen.jpg Scottsbluff 404 http://image.weather.com/web/radar/us_mkk_closeradar_large_usen.jpg Kaunakakai 404 http://image.weather.com/web/radar/us_bgm_closeradar_large_usen.jpg Binghamton 404 http://image.weather.com/web/radar/us_mgm_closeradar_large_usen.jpg Montgomery 404 http://image.weather.com/web/radar/us_hns_closeradar_large_usen.jpg Haines 404 http://image.weather.com/web/radar/us_sav_closeradar_large_usen.jpg Savannah 404 http://image.weather.com/web/radar/us_ciu_closeradar_large_usen.jpg Sault Ste. Marie 404 http://image.weather.com/web/radar/us_gpt_closeradar_large_usen.jpg Gulfport / Biloxi 404 http://image.weather.com/web/radar/us_ear_closeradar_large_usen.jpg Kearney 404 http://image.weather.com/web/radar/us_dca_closeradar_large_usen.jpg Washington, D.C. / Arlington County 200 http://image.weather.com/web/radar/us_elp_closeradar_large_usen.jpg El Paso 404 http://image.weather.com/web/radar/us_pvd_closeradar_large_usen.jpg Providence / Warwick 404 http://image.weather.com/web/radar/us_guc_closeradar_large_usen.jpg Gunnison 404 http://image.weather.com/web/radar/us_cvg_closeradar_large_usen.jpg Covington 404 http://image.weather.com/web/radar/us_grb_closeradar_large_usen.jpg Green Bay 404 http://image.weather.com/web/radar/us_bna_closeradar_large_usen.jpg Nashville 404 http://image.weather.com/web/radar/us_ppg_closeradar_large_usen.jpg Pago Pago, Tutuila 404 http://image.weather.com/web/radar/us_swf_closeradar_large_usen.jpg Newburgh 404 http://image.weather.com/web/radar/us_scc_closeradar_large_usen.jpg Deadhorse / Prudhoe Bay 404 http://image.weather.com/web/radar/us_pie_closeradar_large_usen.jpg St. Petersburg 404 http://image.weather.com/web/radar/us_dlh_closeradar_large_usen.jpg Duluth 404 http://image.weather.com/web/radar/us_brw_closeradar_large_usen.jpg Barrow 404 http://image.weather.com/web/radar/us_act_closeradar_large_usen.jpg Waco 404 http://image.weather.com/web/radar/us_lan_closeradar_large_usen.jpg Lansing 404 http://image.weather.com/web/radar/us_inl_closeradar_large_usen.jpg International Falls 404 http://image.weather.com/web/radar/us_mht_closeradar_large_usen.jpg Manchester 404 http://image.weather.com/web/radar/us_mem_closeradar_large_usen.jpg Memphis 404 http://image.weather.com/web/radar/us_pbg_closeradar_large_usen.jpg Plattsburgh 404 http://image.weather.com/web/radar/us_pqi_closeradar_large_usen.jpg Presque Isle 404 http://image.weather.com/web/radar/us_pib_closeradar_large_usen.jpg Hattiesburg / Laurel 404 http://image.weather.com/web/radar/us_fll_closeradar_large_usen.jpg Fort Lauderdale 404 http://image.weather.com/web/radar/us_bro_closeradar_large_usen.jpg Brownsville 200 http://image.weather.com/web/radar/us_law_closeradar_large_usen.jpg Lawton 404 http://image.weather.com/web/radar/us_smf_closeradar_large_usen.jpg Sacramento 404 http://image.weather.com/web/radar/us_mqt_closeradar_large_usen.jpg Marquette / Gwinn 404 http://image.weather.com/web/radar/us_pns_closeradar_large_usen.jpg Pensacola 404 http://image.weather.com/web/radar/us_azo_closeradar_large_usen.jpg Kalamazoo / Battle Creek 404 http://image.weather.com/web/radar/us_cos_closeradar_large_usen.jpg Colorado Springs 404 http://image.weather.com/web/radar/us_rsw_closeradar_large_usen.jpg Fort Myers 404 http://image.weather.com/web/radar/us_vdz_closeradar_large_usen.jpg Valdez 404 http://image.weather.com/web/radar/us_syr_closeradar_large_usen.jpg Syracuse 404 http://image.weather.com/web/radar/us_adq_closeradar_large_usen.jpg Kodiak 404 http://image.weather.com/web/radar/us_lse_closeradar_large_usen.jpg La Crosse 404 http://image.weather.com/web/radar/us_rno_closeradar_large_usen.jpg Reno 200 http://image.weather.com/web/radar/us_akn_closeradar_large_usen.jpg King Salmon 404 http://image.weather.com/web/radar/us_geg_closeradar_large_usen.jpg Spokane 200 http://image.weather.com/web/radar/us_pia_closeradar_large_usen.jpg Peoria 404 http://image.weather.com/web/radar/us_gcw_closeradar_large_usen.jpg Peach Springs 404 http://image.weather.com/web/radar/us_fmn_closeradar_large_usen.jpg Farmington 404 http://image.weather.com/web/radar/us_cho_closeradar_large_usen.jpg Charlottesville 404 http://image.weather.com/web/radar/us_far_closeradar_large_usen.jpg Fargo 404 http://image.weather.com/web/radar/us_cae_closeradar_large_usen.jpg Columbia 404 http://image.weather.com/web/radar/us_spn_closeradar_large_usen.jpg Obyan, Saipan Island 404 http://image.weather.com/web/radar/us_hvn_closeradar_large_usen.jpg New Haven 404 http://image.weather.com/web/radar/us_alw_closeradar_large_usen.jpg Walla Walla 404 http://image.weather.com/web/radar/us_mso_closeradar_large_usen.jpg Missoula 404 http://image.weather.com/web/radar/us_bfi_closeradar_large_usen.jpg Seattle 404 http://image.weather.com/web/radar/us_clt_closeradar_large_usen.jpg Charlotte 200 http://image.weather.com/web/radar/us_cod_closeradar_large_usen.jpg Cody 404 http://image.weather.com/web/radar/us_tol_closeradar_large_usen.jpg Toledo 404 http://image.weather.com/web/radar/us_cid_closeradar_large_usen.jpg Cedar Rapids 404 http://image.weather.com/web/radar/us_fai_closeradar_large_usen.jpg Fairbanks 404 http://image.weather.com/web/radar/us_acy_closeradar_large_usen.jpg Atlantic City 404 http://image.weather.com/web/radar/us_phl_closeradar_large_usen.jpg Philadelphia 404 http://image.weather.com/web/radar/us_dlg_closeradar_large_usen.jpg Dillingham 404 http://image.weather.com/web/radar/us_hob_closeradar_large_usen.jpg Hobbs 404 http://image.weather.com/web/radar/us_mfr_closeradar_large_usen.jpg Medford 404 http://image.weather.com/web/radar/us_mwa_closeradar_large_usen.jpg Marion 404 http://image.weather.com/web/radar/us_tys_closeradar_large_usen.jpg Knoxville 404 http://image.weather.com/web/radar/us_lih_closeradar_large_usen.jpg Lihue (Līhuʻe) 404 http://image.weather.com/web/radar/us_stl_closeradar_large_usen.jpg St. Louis 200 http://image.weather.com/web/radar/us_pah_closeradar_large_usen.jpg Paducah 404 http://image.weather.com/web/radar/us_txk_closeradar_large_usen.jpg Texarkana 404 http://image.weather.com/web/radar/us_jax_closeradar_large_usen.jpg Jacksonville 404 http://image.weather.com/web/radar/us_roc_closeradar_large_usen.jpg Rochester 200 http://image.weather.com/web/radar/us_rop_closeradar_large_usen.jpg Rota Island 404 http://image.weather.com/web/radar/us_tyr_closeradar_large_usen.jpg Tyler 404 http://image.weather.com/web/radar/us_abe_closeradar_large_usen.jpg Allentown 404 http://image.weather.com/web/radar/us_uin_closeradar_large_usen.jpg Quincy 404 http://image.weather.com/web/radar/us_gpi_closeradar_large_usen.jpg Kalispell 404 http://image.weather.com/web/radar/us_ipt_closeradar_large_usen.jpg Williamsport 404 http://image.weather.com/web/radar/us_mli_closeradar_large_usen.jpg Moline 404 http://image.weather.com/web/radar/us_lax_closeradar_large_usen.jpg Los Angeles 200 http://image.weather.com/web/radar/us_flg_closeradar_large_usen.jpg Flagstaff 404 http://image.weather.com/web/radar/us_fwa_closeradar_large_usen.jpg Fort Wayne 404 http://image.weather.com/web/radar/us_phx_closeradar_large_usen.jpg Phoenix 200 http://image.weather.com/web/radar/us_bld_closeradar_large_usen.jpg Boulder City 404 http://image.weather.com/web/radar/us_atl_closeradar_large_usen.jpg Atlanta 200 http://image.weather.com/web/radar/us_grr_closeradar_large_usen.jpg Grand Rapids 404 http://image.weather.com/web/radar/us_gnv_closeradar_large_usen.jpg Gainesville 404 http://image.weather.com/web/radar/us_lft_closeradar_large_usen.jpg Lafayette 404 http://image.weather.com/web/radar/us_ama_closeradar_large_usen.jpg Amarillo 200 http://image.weather.com/web/radar/us_fat_closeradar_large_usen.jpg Fresno 200 http://image.weather.com/web/radar/us_mbs_closeradar_large_usen.jpg Saginaw 404 http://image.weather.com/web/radar/us_sgf_closeradar_large_usen.jpg Springfield 404 http://image.weather.com/web/radar/us_bli_closeradar_large_usen.jpg Bellingham 404 http://image.weather.com/web/radar/us_cpr_closeradar_large_usen.jpg Casper 200 http://image.weather.com/web/radar/us_sps_closeradar_large_usen.jpg Wichita Falls 404 http://image.weather.com/web/radar/us_iwa_closeradar_large_usen.jpg Mesa 404 http://image.weather.com/web/radar/us_jnu_closeradar_large_usen.jpg Juneau 404 http://image.weather.com/web/radar/us_rdu_closeradar_large_usen.jpg Raleigh 404 http://image.weather.com/web/radar/us_sfb_closeradar_large_usen.jpg Orlando 404 http://image.weather.com/web/radar/us_eri_closeradar_large_usen.jpg Erie 404 http://image.weather.com/web/radar/us_stc_closeradar_large_usen.jpg St. Cloud 404 http://image.weather.com/web/radar/us_twf_closeradar_large_usen.jpg Twin Falls 404 http://image.weather.com/web/radar/us_maf_closeradar_large_usen.jpg Midland 200 http://image.weather.com/web/radar/us_saw_closeradar_large_usen.jpg Marquette / Gwinn 404 http://image.weather.com/web/radar/us_iag_closeradar_large_usen.jpg Niagara Falls 404 http://image.weather.com/web/radar/us_ome_closeradar_large_usen.jpg Nome 404 http://image.weather.com/web/radar/us_pih_closeradar_large_usen.jpg Pocatello / Arbon Valley 404 http://image.weather.com/web/radar/us_sdf_closeradar_large_usen.jpg Louisville 404 http://image.weather.com/web/radar/us_unv_closeradar_large_usen.jpg State College 404 http://image.weather.com/web/radar/us_oth_closeradar_large_usen.jpg North Bend 404 http://image.weather.com/web/radar/us_cys_closeradar_large_usen.jpg Cheyenne 404 http://image.weather.com/web/radar/us_bvu_closeradar_large_usen.jpg Boulder City 404 http://image.weather.com/web/radar/us_oma_closeradar_large_usen.jpg Omaha 200 http://image.weather.com/web/radar/us_bet_closeradar_large_usen.jpg Bethel 404 http://image.weather.com/web/radar/us_jfk_closeradar_large_usen.jpg New York 404 http://image.weather.com/web/radar/us_hya_closeradar_large_usen.jpg Hyannis 404 http://image.weather.com/web/radar/us_bpt_closeradar_large_usen.jpg Beaumont / Port Arthur 404 http://image.weather.com/web/radar/us_bzn_closeradar_large_usen.jpg Bozeman 404 http://image.weather.com/web/radar/us_evv_closeradar_large_usen.jpg Evansville 404 http://image.weather.com/web/radar/us_art_closeradar_large_usen.jpg Watertown 404 http://image.weather.com/web/radar/us_iah_closeradar_large_usen.jpg Houston 404 http://image.weather.com/web/radar/us_hom_closeradar_large_usen.jpg Homer 404 http://image.weather.com/web/radar/us_drt_closeradar_large_usen.jpg Del Rio 404 http://image.weather.com/web/radar/us_cwa_closeradar_large_usen.jpg Wausau 404 http://image.weather.com/web/radar/us_otz_closeradar_large_usen.jpg Kotzebue 404 http://image.weather.com/web/radar/us_gst_closeradar_large_usen.jpg Gustavus 404 http://image.weather.com/web/radar/us_mdt_closeradar_large_usen.jpg Harrisburg / Middletown 404 http://image.weather.com/web/radar/us_mot_closeradar_large_usen.jpg Minot 404 http://image.weather.com/web/radar/us_shv_closeradar_large_usen.jpg Shreveport 200 http://image.weather.com/web/radar/us_pgd_closeradar_large_usen.jpg Punta Gorda 404 http://image.weather.com/web/radar/us_den_closeradar_large_usen.jpg Denver 200 http://image.weather.com/web/radar/us_jac_closeradar_large_usen.jpg Jackson 404 http://image.weather.com/web/radar/us_pwm_closeradar_large_usen.jpg Portland 404 http://image.weather.com/web/radar/us_stt_closeradar_large_usen.jpg Charlotte Amalie, St. Thomas 404 http://image.weather.com/web/radar/us_vps_closeradar_large_usen.jpg Valparaiso 404 http://image.weather.com/web/radar/us_ric_closeradar_large_usen.jpg Richmond 200 http://image.weather.com/web/radar/us_hib_closeradar_large_usen.jpg Hibbing 404 http://image.weather.com/web/radar/us_gri_closeradar_large_usen.jpg Grand Island 404 http://image.weather.com/web/radar/us_frd_closeradar_large_usen.jpg Friday Harbor 404 http://image.weather.com/web/radar/us_dab_closeradar_large_usen.jpg Daytona Beach 404 http://image.weather.com/web/radar/us_tri_closeradar_large_usen.jpg Bristol / Johnson City / Kingsport 404 http://image.weather.com/web/radar/us_hxd_closeradar_large_usen.jpg Hilton Head Island 404 http://image.weather.com/web/radar/us_sun_closeradar_large_usen.jpg Hailey 404 http://image.weather.com/web/radar/us_bqn_closeradar_large_usen.jpg Aguadilla 404 http://image.weather.com/web/radar/us_aex_closeradar_large_usen.jpg Alexandria 404 http://image.weather.com/web/radar/us_cou_closeradar_large_usen.jpg Columbia 404 http://image.weather.com/web/radar/us_clm_closeradar_large_usen.jpg Port Angeles 404 http://image.weather.com/web/radar/us_pit_closeradar_large_usen.jpg Pittsburgh 200 http://image.weather.com/web/radar/us_apn_closeradar_large_usen.jpg Alpena 404 http://image.weather.com/web/radar/us_mia_closeradar_large_usen.jpg Miami 200 http://image.weather.com/web/radar/us_sce_closeradar_large_usen.jpg State College 404 http://image.weather.com/web/radar/us_ict_closeradar_large_usen.jpg Wichita 404 http://image.weather.com/web/radar/us_btm_closeradar_large_usen.jpg Butte 404 http://image.weather.com/web/radar/us_pdx_closeradar_large_usen.jpg Portland 200 http://image.weather.com/web/radar/us_psc_closeradar_large_usen.jpg Pasco 404 http://image.weather.com/web/radar/us_mlu_closeradar_large_usen.jpg Monroe 404 http://image.weather.com/web/radar/us_ckb_closeradar_large_usen.jpg Clarksburg 404 http://image.weather.com/web/radar/us_shd_closeradar_large_usen.jpg Staunton / Waynesboro / Harrisonburg 404 http://image.weather.com/web/radar/us_sfo_closeradar_large_usen.jpg San Francisco 200 http://image.weather.com/web/radar/us_puw_closeradar_large_usen.jpg Pullman / Moscow, Idaho 404 http://image.weather.com/web/radar/us_rhi_closeradar_large_usen.jpg Rhinelander 404 http://image.weather.com/web/radar/us_smx_closeradar_large_usen.jpg Santa Maria 404 http://image.weather.com/web/radar/us_csg_closeradar_large_usen.jpg Columbus 404 http://image.weather.com/web/radar/us_sju_closeradar_large_usen.jpg San Juan / Carolina 200 http://image.weather.com/web/radar/us_lgb_closeradar_large_usen.jpg Long Beach 404 http://image.weather.com/web/radar/us_tpa_closeradar_large_usen.jpg Tampa 200 http://image.weather.com/web/radar/us_ena_closeradar_large_usen.jpg Kenai 404 http://image.weather.com/web/radar/us_hou_closeradar_large_usen.jpg Houston 404 http://image.weather.com/web/radar/us_ith_closeradar_large_usen.jpg Ithaca 404 http://image.weather.com/web/radar/us_tvc_closeradar_large_usen.jpg Traverse City 404 http://image.weather.com/web/radar/us_lrd_closeradar_large_usen.jpg Laredo 404 http://image.weather.com/web/radar/us_mob_closeradar_large_usen.jpg Mobile 404 http://image.weather.com/web/radar/us_srq_closeradar_large_usen.jpg Sarasota / Bradenton 404 http://image.weather.com/web/radar/us_oak_closeradar_large_usen.jpg Oakland 404 http://image.weather.com/web/radar/us_alb_closeradar_large_usen.jpg Albany 404 http://image.weather.com/web/radar/us_cmi_closeradar_large_usen.jpg Champaign / Urbana 404 http://image.weather.com/web/radar/us_tus_closeradar_large_usen.jpg Tucson 404 http://image.weather.com/web/radar/us_lit_closeradar_large_usen.jpg Little Rock 200 http://image.weather.com/web/radar/us_day_closeradar_large_usen.jpg Dayton 404 http://image.weather.com/web/radar/us_oaj_closeradar_large_usen.jpg Jacksonville 404 http://image.weather.com/web/radar/us_crp_closeradar_large_usen.jpg Corpus Christi / Kingsville 404 http://image.weather.com/web/radar/us_nyl_closeradar_large_usen.jpg Yuma 404 http://image.weather.com/web/radar/us_cmh_closeradar_large_usen.jpg Columbus 404 http://image.weather.com/web/radar/us_bmi_closeradar_large_usen.jpg Bloomington / Normal 404 http://image.weather.com/web/radar/us_anc_closeradar_large_usen.jpg Anchorage 404 http://image.weather.com/web/radar/us_mfe_closeradar_large_usen.jpg McAllen 404 http://image.weather.com/web/radar/us_unk_closeradar_large_usen.jpg Unalakleet 404 http://image.weather.com/web/radar/us_psp_closeradar_large_usen.jpg Palm Springs 404 http://image.weather.com/web/radar/us_tlh_closeradar_large_usen.jpg Tallahassee 200 http://image.weather.com/web/radar/us_pse_closeradar_large_usen.jpg Ponce 404 http://image.weather.com/web/radar/us_wst_closeradar_large_usen.jpg Westerly 404 http://image.weather.com/web/radar/us_gsp_closeradar_large_usen.jpg Greer 404 http://image.weather.com/web/radar/us_yng_closeradar_large_usen.jpg Youngstown / Warren 404 http://image.weather.com/web/radar/us_atw_closeradar_large_usen.jpg Appleton 404 http://image.weather.com/web/radar/us_btv_closeradar_large_usen.jpg Burlington 200 http://image.weather.com/web/radar/us_pvu_closeradar_large_usen.jpg Provo 404 http://image.weather.com/web/radar/us_cld_closeradar_large_usen.jpg Carlsbad 404 http://image.weather.com/web/radar/us_phf_closeradar_large_usen.jpg Newport News 404 http://image.weather.com/web/radar/us_slc_closeradar_large_usen.jpg Salt Lake City 200 http://image.weather.com/web/radar/us_gck_closeradar_large_usen.jpg Garden City 404 http://image.weather.com/web/radar/us_cle_closeradar_large_usen.jpg Cleveland 404 http://image.weather.com/web/radar/us_bfl_closeradar_large_usen.jpg Bakersfield 404 http://image.weather.com/web/radar/us_gtf_closeradar_large_usen.jpg Great Falls 404 http://image.weather.com/web/radar/us_sjt_closeradar_large_usen.jpg San Angelo 404 http://image.weather.com/web/radar/us_hnh_closeradar_large_usen.jpg Hoonah 404 http://image.weather.com/web/radar/us_hnl_closeradar_large_usen.jpg Honolulu 404 http://image.weather.com/web/radar/us_ont_closeradar_large_usen.jpg Ontario 404 http://image.weather.com/web/radar/us_ack_closeradar_large_usen.jpg Nantucket 404 http://image.weather.com/web/radar/us_mhk_closeradar_large_usen.jpg Manhattan 404 http://image.weather.com/web/radar/us_dik_closeradar_large_usen.jpg Dickinson 404 http://image.weather.com/web/radar/us_hdn_closeradar_large_usen.jpg Hayden 404 http://image.weather.com/web/radar/us_shr_closeradar_large_usen.jpg Sheridan 404 http://image.weather.com/web/radar/us_dut_closeradar_large_usen.jpg Unalaska 404 http://image.weather.com/web/radar/us_sts_closeradar_large_usen.jpg Santa Rosa 404 http://image.weather.com/web/radar/us_ktn_closeradar_large_usen.jpg Ketchikan 404 http://image.weather.com/web/radar/us_abi_closeradar_large_usen.jpg Abilene 404 http://image.weather.com/web/radar/us_mdw_closeradar_large_usen.jpg Chicago 404 http://image.weather.com/web/radar/us_bdl_closeradar_large_usen.jpg Hartford 404 http://image.weather.com/web/radar/us_gro_closeradar_large_usen.jpg Rota Island 404 http://image.weather.com/web/radar/us_sat_closeradar_large_usen.jpg San Antonio 200 http://image.weather.com/web/radar/us_mci_closeradar_large_usen.jpg Kansas City 404 http://image.weather.com/web/radar/us_boi_closeradar_large_usen.jpg Boise 200 http://image.weather.com/web/radar/us_cll_closeradar_large_usen.jpg College Station 404 http://image.weather.com/web/radar/us_mco_closeradar_large_usen.jpg Orlando 404 http://image.weather.com/web/radar/us_bqk_closeradar_large_usen.jpg Brunswick 404 http://image.weather.com/web/radar/us_fca_closeradar_large_usen.jpg Kalispell 404 http://image.weather.com/web/radar/us_rst_closeradar_large_usen.jpg Rochester 200 http://image.weather.com/web/radar/us_ecp_closeradar_large_usen.jpg Panama City Beach 404 http://image.weather.com/web/radar/us_owb_closeradar_large_usen.jpg Owensboro 404 http://image.weather.com/web/radar/us_pgv_closeradar_large_usen.jpg Greenville 404 http://image.weather.com/web/radar/us_mmh_closeradar_large_usen.jpg Mammoth Lakes 404 http://image.weather.com/web/radar/us_ewr_closeradar_large_usen.jpg Newark 404 http://image.weather.com/web/radar/us_psg_closeradar_large_usen.jpg Petersburg 404 http://image.weather.com/web/radar/us_jln_closeradar_large_usen.jpg Joplin 404 http://image.weather.com/web/radar/us_buf_closeradar_large_usen.jpg Buffalo 404 http://image.weather.com/web/radar/us_row_closeradar_large_usen.jpg Roswell 404 http://image.weather.com/web/radar/us_hrl_closeradar_large_usen.jpg Harlingen 404 http://image.weather.com/web/radar/us_cdv_closeradar_large_usen.jpg Cordova 404 http://image.weather.com/web/radar/us_pvc_closeradar_large_usen.jpg Provincetown 404 http://image.weather.com/web/radar/us_chs_closeradar_large_usen.jpg Charleston 200 http://image.weather.com/web/radar/us_aza_closeradar_large_usen.jpg Mesa 404 http://image.weather.com/web/radar/us_isn_closeradar_large_usen.jpg Williston 404 http://image.weather.com/web/radar/us_aby_closeradar_large_usen.jpg Albany 404 http://image.weather.com/web/radar/us_cvx_closeradar_large_usen.jpg Charlevoix 404 http://image.weather.com/web/radar/us_mod_closeradar_large_usen.jpg Modesto 404 http://image.weather.com/web/radar/us_eat_closeradar_large_usen.jpg Wenatchee 404 http://image.weather.com/web/radar/us_gjt_closeradar_large_usen.jpg Grand Junction 404 http://image.weather.com/web/radar/us_eau_closeradar_large_usen.jpg Eau Claire 404 http://image.weather.com/web/radar/us_bos_closeradar_large_usen.jpg Boston 200 http://image.weather.com/web/radar/us_fhr_closeradar_large_usen.jpg Friday Harbor 404 http://image.weather.com/web/radar/us_hgr_closeradar_large_usen.jpg Hagerstown 404 http://image.weather.com/web/radar/us_cmx_closeradar_large_usen.jpg Hancock / Calumet 404 http://image.weather.com/web/radar/us_ksm_closeradar_large_usen.jpg St. Mary's 404 http://image.weather.com/web/radar/us_sby_closeradar_large_usen.jpg Salisbury 404 http://image.weather.com/web/radar/us_flo_closeradar_large_usen.jpg Florence 404 http://image.weather.com/web/radar/us_rap_closeradar_large_usen.jpg Rapid City 200 http://image.weather.com/web/radar/us_riw_closeradar_large_usen.jpg Riverton 404 http://image.weather.com/web/radar/us_fay_closeradar_large_usen.jpg Fayetteville 404 http://image.weather.com/web/radar/us_lch_closeradar_large_usen.jpg Lake Charles 404 http://image.weather.com/web/radar/us_lmt_closeradar_large_usen.jpg Klamath Falls 404 http://image.weather.com/web/radar/us_ogg_closeradar_large_usen.jpg Kahului 404 http://image.weather.com/web/radar/us_lex_closeradar_large_usen.jpg Lexington 200 http://image.weather.com/web/radar/us_ifp_closeradar_large_usen.jpg Bullhead City 404 http://image.weather.com/web/radar/us_vqs_closeradar_large_usen.jpg Vieques 404 http://image.weather.com/web/radar/us_lga_closeradar_large_usen.jpg New York 404 http://image.weather.com/web/radar/us_isp_closeradar_large_usen.jpg Islip 404 http://image.weather.com/web/radar/us_lar_closeradar_large_usen.jpg Laramie 404 http://image.weather.com/web/radar/us_gcc_closeradar_large_usen.jpg Gillette 404 http://image.weather.com/web/radar/us_dal_closeradar_large_usen.jpg Dallas 404 http://image.weather.com/web/radar/us_gsn_closeradar_large_usen.jpg Obyan, Saipan Island 404 http://image.weather.com/web/radar/us_acv_closeradar_large_usen.jpg Arcata / Eureka 404 http://image.weather.com/web/radar/us_dfw_closeradar_large_usen.jpg Dallas-Fort Worth 200 http://image.weather.com/web/radar/us_vld_closeradar_large_usen.jpg Valdosta 404 http://image.weather.com/web/radar/us_bhm_closeradar_large_usen.jpg Birmingham 200 http://image.weather.com/web/radar/us_saf_closeradar_large_usen.jpg Santa Fe 404 http://image.weather.com/web/radar/us_yak_closeradar_large_usen.jpg Yakutat 404 http://image.weather.com/web/radar/us_lyh_closeradar_large_usen.jpg Lynchburg 404 http://image.weather.com/web/radar/us_bwi_closeradar_large_usen.jpg Baltimore / Glen Burnie 404 http://image.weather.com/web/radar/us_cak_closeradar_large_usen.jpg Akron / Canton 404 http://image.weather.com/web/radar/us_ilm_closeradar_large_usen.jpg Wilmington 404 http://image.weather.com/web/radar/us_sbp_closeradar_large_usen.jpg San Luis Obispo 404 http://image.weather.com/web/radar/us_avl_closeradar_large_usen.jpg Asheville 200 http://image.weather.com/web/radar/us_gcn_closeradar_large_usen.jpg Grand Canyon / Tusayan 404
len(valid_urls)
53
with open('valid_600mi_urls.txt', 'w') as outfile:
for (city, url) in valid_urls:
outfile.write("%s: %s\n" % (city, url))
!cat valid_600mi_urls.txt
http://image.weather.com/web/radar/us_las_closeradar_large_usen.jpg: Las Vegas http://image.weather.com/web/radar/us_sea_closeradar_large_usen.jpg: Seattle / Tacoma (SeaTac) http://image.weather.com/web/radar/us_bis_closeradar_large_usen.jpg: Bismarck http://image.weather.com/web/radar/us_bil_closeradar_large_usen.jpg: Billings http://image.weather.com/web/radar/us_ord_closeradar_large_usen.jpg: Chicago http://image.weather.com/web/radar/us_okc_closeradar_large_usen.jpg: Oklahoma City http://image.weather.com/web/radar/us_crw_closeradar_large_usen.jpg: Charleston http://image.weather.com/web/radar/us_msp_closeradar_large_usen.jpg: Minneapolis http://image.weather.com/web/radar/us_abq_closeradar_large_usen.jpg: Albuquerque http://image.weather.com/web/radar/us_jan_closeradar_large_usen.jpg: Jackson http://image.weather.com/web/radar/us_ind_closeradar_large_usen.jpg: Indianapolis http://image.weather.com/web/radar/us_fsd_closeradar_large_usen.jpg: Sioux Falls http://image.weather.com/web/radar/us_mkg_closeradar_large_usen.jpg: Muskegon http://image.weather.com/web/radar/us_dtw_closeradar_large_usen.jpg: Detroit / Romulus http://image.weather.com/web/radar/us_dsm_closeradar_large_usen.jpg: Des Moines http://image.weather.com/web/radar/us_dca_closeradar_large_usen.jpg: Washington, D.C. / Arlington County http://image.weather.com/web/radar/us_bro_closeradar_large_usen.jpg: Brownsville http://image.weather.com/web/radar/us_rno_closeradar_large_usen.jpg: Reno http://image.weather.com/web/radar/us_geg_closeradar_large_usen.jpg: Spokane http://image.weather.com/web/radar/us_clt_closeradar_large_usen.jpg: Charlotte http://image.weather.com/web/radar/us_stl_closeradar_large_usen.jpg: St. Louis http://image.weather.com/web/radar/us_roc_closeradar_large_usen.jpg: Rochester http://image.weather.com/web/radar/us_lax_closeradar_large_usen.jpg: Los Angeles http://image.weather.com/web/radar/us_phx_closeradar_large_usen.jpg: Phoenix http://image.weather.com/web/radar/us_atl_closeradar_large_usen.jpg: Atlanta http://image.weather.com/web/radar/us_ama_closeradar_large_usen.jpg: Amarillo http://image.weather.com/web/radar/us_fat_closeradar_large_usen.jpg: Fresno http://image.weather.com/web/radar/us_cpr_closeradar_large_usen.jpg: Casper http://image.weather.com/web/radar/us_maf_closeradar_large_usen.jpg: Midland http://image.weather.com/web/radar/us_oma_closeradar_large_usen.jpg: Omaha http://image.weather.com/web/radar/us_shv_closeradar_large_usen.jpg: Shreveport http://image.weather.com/web/radar/us_den_closeradar_large_usen.jpg: Denver http://image.weather.com/web/radar/us_ric_closeradar_large_usen.jpg: Richmond http://image.weather.com/web/radar/us_pit_closeradar_large_usen.jpg: Pittsburgh http://image.weather.com/web/radar/us_mia_closeradar_large_usen.jpg: Miami http://image.weather.com/web/radar/us_pdx_closeradar_large_usen.jpg: Portland http://image.weather.com/web/radar/us_sfo_closeradar_large_usen.jpg: San Francisco http://image.weather.com/web/radar/us_sju_closeradar_large_usen.jpg: San Juan / Carolina http://image.weather.com/web/radar/us_tpa_closeradar_large_usen.jpg: Tampa http://image.weather.com/web/radar/us_lit_closeradar_large_usen.jpg: Little Rock http://image.weather.com/web/radar/us_tlh_closeradar_large_usen.jpg: Tallahassee http://image.weather.com/web/radar/us_btv_closeradar_large_usen.jpg: Burlington http://image.weather.com/web/radar/us_slc_closeradar_large_usen.jpg: Salt Lake City http://image.weather.com/web/radar/us_sat_closeradar_large_usen.jpg: San Antonio http://image.weather.com/web/radar/us_boi_closeradar_large_usen.jpg: Boise http://image.weather.com/web/radar/us_rst_closeradar_large_usen.jpg: Rochester http://image.weather.com/web/radar/us_chs_closeradar_large_usen.jpg: Charleston http://image.weather.com/web/radar/us_bos_closeradar_large_usen.jpg: Boston http://image.weather.com/web/radar/us_rap_closeradar_large_usen.jpg: Rapid City http://image.weather.com/web/radar/us_lex_closeradar_large_usen.jpg: Lexington http://image.weather.com/web/radar/us_dfw_closeradar_large_usen.jpg: Dallas-Fort Worth http://image.weather.com/web/radar/us_bhm_closeradar_large_usen.jpg: Birmingham http://image.weather.com/web/radar/us_avl_closeradar_large_usen.jpg: Asheville
%sql select * from airports
Done.
city | faa | iata | icao | airport | role | enplanements |
---|---|---|---|---|---|---|
ALABAMA | None | None | None | None | None | None |
Birmingham | BHM | BHM | KBHM | Birmingham–Shuttlesworth International Airport | P-S | 1,335,014 |
Dothan | DHN | DHN | KDHN | Dothan Regional Airport | P-N | 48,423 |
Huntsville | HSV | HSV | KHSV | Huntsville International Airport (Carl T. Jones Field) | P-S | 505,541 |
Mobile | MOB | MOB | KMOB | Mobile Regional Airport | P-N | 287,661 |
Montgomery | MGM | MGM | KMGM | Montgomery Regional Airport (Dannelly Field) | P-N | 157,958 |
ALASKA | None | None | None | None | None | None |
Anchorage | ANC | ANC | PANC | Ted Stevens Anchorage International Airport | P-M | 2,325,030 |
Aniak | ANI | ANI | PANI | Aniak Airport | P-N | 14,334 |
Barrow | BRW | BRW | PABR | Wiley Post–Will Rogers Memorial Airport | P-N | 51,568 |
Bethel | BET | BET | PABE | Bethel Airport (also see Bethel Seaplane Base) | P-N | 152,084 |
Cordova | CDV | CDV | PACV | Merle K. (Mudhole) Smith Airport | P-N | 15,772 |
Deadhorse / Prudhoe Bay | SCC | SCC | PASC | Deadhorse Airport (Prudhoe Bay Airport) | P-N | 48,588 |
Dillingham | DLG | DLG | PADL | Dillingham Airport | P-N | 26,632 |
Fairbanks | FAI | FAI | PAFA | Fairbanks International Airport | P-S | 457,372 |
Galena | GAL | GAL | PAGA | Edward G. Pitka Sr. Airport | P-N [nb 1] | 14,141 |
Gustavus | GST | GST | PGST | Gustavus Airport | P-N [nb 2] | 14,141 |
Haines | HNS | HNS | PAHN | Haines Airport (also see Haines Seaplane Base) | P-N | 10,106 |
Homer | HOM | HOM | PAHO | Homer Airport | P-N | 37,705 |
Hoonah | HNH | HNH | PAOH | Hoonah Airport (also see Hoonah Seaplane Base) | P-N [nb 3] | 10,468 |
Juneau | JNU | JNU | PAJN | Juneau International Airport | P-N | 321,573 |
Kenai | ENA | ENA | PAEN | Kenai Municipal Airport | P-N | 99,821 |
Ketchikan | KTN | KTN | PAKT | Ketchikan International Airport | P-N | 109,433 |
King Salmon | AKN | AKN | PAKN | King Salmon Airport | P-N | 35,450 |
Kodiak | ADQ | ADQ | PADQ | Kodiak Airport | P-N | 79,930 |
Kotzebue | OTZ | OTZ | PAOT | Ralph Wien Memorial Airport | P-N | 61,274 |
Nome | OME | OME | PAOM | Nome Airport | P-N | 58,020 |
Petersburg | PSG | PSG | PAPG | Petersburg James A. Johnson Airport | P-N | 20,046 |
Sitka | SIT | SIT | PASI | Sitka Rocky Gutierrez Airport | P-N | 67,989 |
St. Mary's | KSM | KSM | PASM | St. Mary's Airport | P-N | 13,949 |
Unalakleet | UNK | UNK | PAUN | Unalakleet Airport | P-N | 14,011 |
Unalaska | DUT | DUT | PADU | Unalaska Airport (Tom Madsen Airport) | P-N | 28,556 |
Valdez | VDZ | VDZ | PAVD | Valdez Airport (Pioneer Field) | P-N | 13,318 |
Wrangell | WRG | WRG | PAWG | Wrangell Airport (also see Wrangell Seaplane Base) | P-N | 11,807 |
Yakutat | YAK | YAK | PAYA | Yakutat Airport (also see Yakutat Seaplane Base) | P-N | 10,135 |
ARIZONA | None | None | None | None | None | None |
Bullhead City | IFP | IFP | KIFP | Laughlin/Bullhead International Airport | P-N | 109,647 |
Flagstaff | FLG | FLG | KFLG | Flagstaff Pulliam Airport | P-N | 58,323 |
Grand Canyon / Tusayan | GCN | GCN | KGCN | Grand Canyon National Park Airport | P-N | 126,364 |
Mesa | IWA | AZA | KIWA | Phoenix–Mesa Gateway Airport | P-N | 725,048 |
Page | PGA | PGA | KPGA | Page Municipal Airport | P-N | 25,260 |
Peach Springs | 1G4 | GCW | None | Grand Canyon West Airport | P-N | 59,846 |
Phoenix | PHX | PHX | KPHX | Phoenix Sky Harbor International Airport | P-L | 19,525,829 |
Tucson | TUS | TUS | KTUS | Tucson International Airport | P-M | 1,570,329 |
Yuma | NYL | YUM | KNYL | Yuma International Airport / MCAS Yuma | P-N | 78,395 |
ARKANSAS | None | None | None | None | None | None |
Fayetteville | XNA | XNA | KXNA | Northwest Arkansas Regional Airport | P-S | 558,218 |
Fort Smith | FSM | FSM | KFSM | Fort Smith Regional Airport | P-N | 82,742 |
Little Rock | LIT | LIT | KLIT | Bill and Hillary Clinton National Airport (Adams Field) (was Little Rock National) | P-S | 1,055,608 |
Texarkana | TXK | TXK | KTXK | Texarkana Regional Airport (Webb Field) | P-N | 32,882 |
CALIFORNIA | None | None | None | None | None | None |
Arcata / Eureka | ACV | ACV | KACV | Arcata Airport | P-N | 56,682 |
Bakersfield | BFL | BFL | KBFL | Meadows Field | P-N | 143,175 |
Burbank | BUR | BUR | KBUR | Bob Hope Airport | P-M | 1,919,005 |
Carlsbad | CRQ | CLD | KCRQ | McClellan–Palomar Airport | P-N | 52,561 |
Chico | CIC | CIC | KCIC | Chico Municipal Airport | P-N | 16,835 |
Crescent City | CEC | CEC | KCEC | Del Norte County Airport (Jack McNamara Field) | P-N | 12,136 |
Fresno | FAT | FAT | KFAT | Fresno Yosemite International Airport | P-S | 684,849 |
Long Beach | LGB | LGB | KLGB | Long Beach Airport (Daugherty Field) | P-S | 1,438,948 |
Los Angeles | LAX | LAX | KLAX | Los Angeles International Airport | P-L | 32,427,115 |
Mammoth Lakes | MMH | MMH | KMMH | Mammoth Yosemite Airport | P-N [nb 4] | 30,970 |
Modesto | MOD | MOD | KMOD | Modesto City–County Airport (Harry Sham Field) | P-N | 11,310 |
Monterey | MRY | MRY | KMRY | Monterey Regional Airport (was Monterey Peninsula Airport) | P-N | 205,838 |
Oakland | OAK | OAK | KOAK | Oakland International Airport | P-M | 4,771,830 |
Ontario | ONT | ONT | KONT | Ontario International Airport | P-M | 1,970,538 |
Palm Springs | PSP | PSP | KPSP | Palm Springs International Airport | P-S | 876,428 |
Redding | RDD | RDD | KRDD | Redding Municipal Airport | P-N | 24,875 |
Sacramento | SMF | SMF | KSMF | Sacramento International Airport | P-M | 4,255,145 |
San Diego | SAN | SAN | KSAN | San Diego International Airport | P-L | 8,876,777 |
San Francisco | SFO | SFO | KSFO | San Francisco International Airport | P-L | 21,706,567 |
San Jose | SJC | SJC | KSJC | Norman Y. Mineta San José International Airport | P-M | 4,317,896 |
San Luis Obispo | SBP | SBP | KSBP | San Luis Obispo County Regional Airport (McChesney Field) | P-N | 135,844 |
Santa Ana | SNA | SNA | KSNA | John Wayne Airport – Orange County (was Orange County Airport) | P-M | 4,542,376 |
Santa Barbara | SBA | SBA | KSBA | Santa Barbara Municipal Airport (Santa Barbara Airport) | P-N | 365,036 |
Santa Maria | SMX | SMX | KSMX | Santa Maria Public Airport (Capt G. Allan Hancock Field) | P-N | 51,395 |
Santa Rosa | STS | STS | KSTS | Charles M. Schulz–Sonoma County Airport | P-N | 113,083 |
Stockton | SCK | SCK | KSCK | Stockton Metropolitan Airport | P-N | 71,757 |
COLORADO | None | None | None | None | None | None |
Aspen | ASE | ASE | KASE | Aspen-Pitkin County Airport (Sardy Field) | P-N | 208,682 |
Colorado Springs | COS | COS | KCOS | City of Colorado Springs Municipal Airport | P-S | 658,318 |
Denver | DEN | DEN | KDEN | Denver International Airport | P-L | 25,497,348 |
Durango | DRO | DRO | KDRO | Durango-La Plata County Airport | P-N | 192,797 |
Eagle | EGE | EGE | KEGE | Eagle County Regional Airport | P-N | 168,535 |
Grand Junction | GJT | GJT | KGJT | Grand Junction Regional Airport (Walker Field) | P-N | 211,270 |
Gunnison | GUC | GUC | KGUC | Gunnison-Crested Butte Regional Airport | P-N | 30,780 |
Hayden | HDN | HDN | KHDN | Yampa Valley Airport (Yampa Valley Regional) | P-N | 92,184 |
Montrose | MTJ | MTJ | KMTJ | Montrose Regional Airport | P-N | 84,579 |
CONNECTICUT | None | None | None | None | None | None |
Hartford | BDL | BDL | KBDL | Bradley International Airport | P-M | 2,681,718 |
New Haven | HVN | HVN | KHVN | Tweed New Haven Regional Airport | P-N | 37,434 |
FLORIDA | None | None | None | None | None | None |
Daytona Beach | DAB | DAB | KDAB | Daytona Beach International Airport | P-N | 293,843 |
Fort Lauderdale | FLL | FLL | KFLL | Fort Lauderdale–Hollywood International Airport | P-L | 11,509,361 |
Fort Myers | RSW | RSW | KRSW | Southwest Florida International Airport | P-M | 3,789,386 |
Gainesville | GNV | GNV | KGNV | Gainesville Regional Airport | P-N | 198,388 |
Jacksonville | JAX | JAX | KJAX | Jacksonville International Airport | P-M | 2,549,712 |
Key West | EYW | EYW | KEYW | Key West International Airport | P-S | 403,021 |
Melbourne | MLB | MLB | KMLB | Melbourne International Airport | P-N | 211,702 |
Miami | MIA | MIA | KMIA | Miami International Airport | P-L | 19,422,275 |
Orlando | MCO | MCO | KMCO | Orlando International Airport | P-L | 16,885,160 |
Orlando | SFB | SFB | KSFB | Orlando Sanford International Airport | P-S | 971,522 |
Panama City Beach | ECP | ECP | KECP | Northwest Florida Beaches International Airport [nb 5] | P-S | 391,893 |
Pensacola | PNS | PNS | KPNS | Pensacola International Airport (Pensacola Gulf Coast Regional Airport) | P-S | 744,259 |
Punta Gorda | PGD | PGD | KPGD | Punta Gorda Airport (was Charlotte County Airport) | P-N | 171,121 |
Sarasota / Bradenton | SRQ | SRQ | KSRQ | Sarasota–Bradenton International Airport | P-S | 595,423 |
St. Petersburg | PIE | PIE | KPIE | St. Petersburg–Clearwater International Airport | P-S | 514,595 |
Tallahassee | TLH | TLH | KTLH | Tallahassee Regional Airport | P-N | 336,129 |
Tampa | TPA | TPA | KTPA | Tampa International Airport | P-L | 8,268,207 |
Valparaiso | VPS | VPS | KVPS | Northwest Florida Regional Airport / Eglin Air Force Base | P-N | 353,953 |
West Palm Beach | PBI | PBI | KPBI | Palm Beach International Airport | P-M | 2,848,901 |
GEORGIA | None | None | None | None | None | None |
Albany | ABY | ABY | KABY | Southwest Georgia Regional Airport | P-N | 31,276 |
Atlanta | ATL | ATL | KATL | Hartsfield-Jackson Atlanta International Airport | P-L | 45,308,685 |
Augusta | AGS | AGS | KAGS | Augusta Regional Airport (Bush Field) | P-N | 261,079 |
Brunswick | BQK | BQK | KBQK | Brunswick Golden Isles Airport | P-N | 32,450 |
Columbus | CSG | CSG | KCSG | Columbus Metropolitan Airport | P-N | 59,675 |
Savannah | SAV | SAV | KSAV | Savannah/Hilton Head International Airport | P-S | 798,970 |
Valdosta | VLD | VLD | KVLD | Valdosta Regional Airport | P-N | 36,814 |
HAWAII | None | None | None | None | None | None |
Hilo | ITO | ITO | PHTO | Hilo International Airport | P-S | 640,411 |
Honolulu | HNL | HNL | PHNL | Honolulu International Airport / Hickam AFB | P-L | 9,466,995 |
Kahului | OGG | OGG | PHOG | Kahului Airport | P-M | 2,955,304 |
Kailua/Kona | KOA | KOA | PHKO | Kona International Airport at Keahole | P-S | 1,376,641 |
Kaunakakai | MKK | MKK | PHMK | Molokai Airport (Molokaʻi Airport) | P-N | 63,879 |
Lanai City (Lānaʻi City) | LNY | LNY | PHNY | Lanai Airport (Lānaʻi Airport) | P-N | 47,323 |
Lihue (Līhuʻe) | LIH | LIH | PHLI | Lihue Airport (Līhuʻe Airport) | P-S | 1,315,141 |
IDAHO | None | None | None | None | None | None |
Boise | BOI | BOI | KBOI | Boise Airport (Boise Air Terminal) (Gowen Field) | P-S | 1,313,741 |
Hailey | SUN | SUN | KSUN | Friedman Memorial Airport | P-N | 52,393 |
Idaho Falls | IDA | IDA | KIDA | Idaho Falls Regional Airport (Fanning Field) | P-N | 147,073 |
Lewiston | LWS | LWS | KLWS | Lewiston-Nez Perce County Airport | P-N | 62,209 |
Pocatello / Arbon Valley | PIH | PIH | KPIH | Pocatello Regional Airport | P-N | 23,775 |
Twin Falls | TWF | TWF | KTWF | Magic Valley Regional Airport (Joslin Field) | P-N | 28,601 |
ILLINOIS | None | None | None | None | None | None |
Belleville | BLV | BLV | KBLV | MidAmerica St. Louis Airport / Scott Air Force Base | P-N | 13,542 |
Bloomington / Normal | BMI | BMI | KBMI | Central Illinois Regional Airport at Bloomington-Normal | P-N | 211,957 |
Champaign / Urbana | CMI | CMI | KCMI | University of Illinois - Willard Airport | P-N | 84,853 |
Chicago | ORD | ORD | KORD | Chicago O'Hare International Airport | P-L | 32,278,906 |
Chicago | MDW | MDW | KMDW | Chicago Midway International Airport | P-L | 9,919,985 |
Marion | MWA | MWA | KMWA | Williamson County Regional Airport | P-N | 11,241 |
Moline | MLI | MLI | KMLI | Quad City International Airport | P-N | 384,198 |
Peoria | PIA | PIA | KPIA | General Downing - Peoria International Airport | P-M | 491,000 |
Quincy | UIN | UIN | KUIN | Quincy Regional Airport (Baldwin Field) | P-N | 10,679 |
Rockford | RFD | RFD | KRFD | Chicago Rockford International Airport | P-N | 109,384 |
Springfield | SPI | SPI | KSPI | Abraham Lincoln Capital Airport | P-N | 70,685 |
INDIANA | None | None | None | None | None | None |
Evansville | EVV | EVV | KEVV | Evansville Regional Airport | P-N | 161,279 |
Fort Wayne | FWA | FWA | KFWA | Fort Wayne International Airport | P-N | 294,968 |
Indianapolis | IND | IND | KIND | Indianapolis International Airport | P-M | 3,535,579 |
South Bend | SBN | SBN | KSBN | South Bend International Airport (was South Bend Regional) | P-N | 329,403 |
IOWA | None | None | None | None | None | None |
Cedar Rapids | CID | CID | KCID | The Eastern Iowa Airport | P-S | 520,360 |
Des Moines | DSM | DSM | KDSM | Des Moines International Airport | P-S | 1,079,189 |
Dubuque | DBQ | DBQ | KDBQ | Dubuque Regional Airport | P-N | 33,465 |
Sioux City | SUX | SUX | KSUX | Sioux Gateway Airport (Col. Bud Day Field) | P-N | 25,313 |
Waterloo | ALO | ALO | KALO | Waterloo Regional Airport | P-N | 20,984 |
KANSAS | None | None | None | None | None | None |
Garden City | GCK | GCK | KGCK | Garden City Regional Airport | P-N | 24,456 |
Manhattan | MHK | MHK | KMHK | Manhattan Regional Airport | P-N | 65,683 |
Wichita | ICT | ICT | KICT | Wichita Dwight D. Eisenhower National Airport (formerly Wichita Mid-Continent Airport) | P-S | 736,220 |
KENTUCKY | None | None | None | None | None | None |
Covington | CVG | CVG | KCVG | Cincinnati/Northern Kentucky International Airport | P-M | 2,776,377 |
Lexington | LEX | LEX | KLEX | Blue Grass Airport | P-S | 539,879 |
Louisville | SDF | SDF | KSDF | Louisville International Airport (Standiford Field) | P-S | 1,669,470 |
Owensboro | OWB | OWB | KOWB | Owensboro-Daviess County Regional Airport | P-N | 21,751 |
Paducah | PAH | PAH | KPAH | Barkley Regional Airport | P-N | 20,523 |
LOUISIANA | None | None | None | None | None | None |
Alexandria | AEX | AEX | KAEX | Alexandria International Airport | P-N | 183,899 |
Baton Rouge | BTR | BTR | KBTR | Baton Rouge Metropolitan Airport (Ryan Field) | P-S | 401,035 |
Lafayette | LFT | LFT | KLFT | Lafayette Regional Airport | P-N | 233,498 |
Lake Charles | LCH | LCH | KLCH | Lake Charles Regional Airport | P-N | 65,281 |
Monroe | MLU | MLU | KMLU | Monroe Regional Airport | P-N | 115,757 |
New Orleans | MSY | MSY | KMSY | Louis Armstrong New Orleans International Airport | P-M | 4,577,498 |
Shreveport | SHV | SHV | KSHV | Shreveport Regional Airport | P-N | 279,897 |
MAINE | None | None | None | None | None | None |
Bangor | BGR | BGR | KBGR | Bangor International Airport | P-N | 265,245 |
Bar Harbor | BHB | BHB | KBHB | Hancock County-Bar Harbor Airport | P-N | 10,625 |
Portland | PWM | PWM | KPWM | Portland International Jetport | P-S | 837,335 |
Presque Isle | PQI | PQI | KPQI | Northern Maine Regional Airport at Presque Isle | P-N | 11,488 |
Rockland | RKD | RKD | KRKD | Knox County Regional Airport | P-N | 15,724 |
MARYLAND | None | None | None | None | None | None |
Baltimore / Glen Burnie | BWI | BWI | KBWI | Baltimore/Washington International Thurgood Marshall Airport | P-L | 11,134,130 |
Salisbury | SBY | SBY | KSBY | Salisbury-Ocean City Wicomico Regional Airport | P-N | 62,670 |
Hagerstown | HGR | HGR | KHGR | Hagerstown Regional Airport (Richard A. Henson Field) | P-N | 12,941 |
MASSACHUSETTS | None | None | None | None | None | None |
Boston | BOS | BOS | KBOS | Gen. Edward Lawrence Logan International Airport | P-L | 14,721,693 |
Hyannis | HYA | HYA | KHYA | Barnstable Municipal Airport (Boardman/Polando Field) | P-N | 88,055 |
Nantucket | ACK | ACK | KACK | Nantucket Memorial Airport | P-N | 184,618 |
New Bedford | EWB | EWB | KEWB | New Bedford Regional Airport | P-N | 10,604 |
Provincetown | PVC | PVC | KPVC | Provincetown Municipal Airport | P-N | 11,288 |
Vineyard Haven | MVY | MVY | KMVY | Martha's Vineyard Airport | P-N | 56,763 |
MICHIGAN | None | None | None | None | None | None |
Alpena | APN | APN | KAPN | Alpena County Regional Airport | P-N | 15,914 |
Charlevoix | CVX | CVX | KCVX | Charlevoix Municipal Airport | P-N | 16,929 |
Detroit / Romulus | DTW | DTW | KDTW | Detroit Metropolitan Wayne County Airport | P-L | 15,683,787 |
Escanaba | ESC | ESC | KESC | Delta County Airport | P-N | 15,110 |
Flint | FNT | FNT | KFNT | Bishop International Airport | P-S | 398,132 |
Grand Rapids | GRR | GRR | KGRR | Gerald R. Ford International Airport | P-S | 1,123,257 |
Hancock / Calumet | CMX | CMX | KCMX | Houghton County Memorial Airport | P-N | 25,312 |
Iron Mountain / Kingsford | IMT | IMT | KIMT | Ford Airport | P-N | 11,271 |
Kalamazoo / Battle Creek | AZO | AZO | KAZO | Kalamazoo/Battle Creek International Airport | P-N | 129,211 |
Lansing | LAN | LAN | KLAN | Capital Region International Airport (was Lansing Capital City) | P-N | 216,925 |
Marquette / Gwinn | SAW | MQT | KSAW | Sawyer International Airport | P-N | 42,355 |
Muskegon | MKG | MKG | KMKG | Muskegon County Airport | P-N | 18,020 |
Pellston | PLN | PLN | KPLN | Pellston Regional Airport of Emmet County | P-N | 27,281 |
Saginaw | MBS | MBS | KMBS | MBS International Airport | P-N | 120,689 |
Sault Ste. Marie | CIU | CIU | KCIU | Chippewa County International Airport | P-N | 21,827 |
Traverse City | TVC | TVC | KTVC | Cherry Capital Airport | P-N | 189,644 |
MINNESOTA | None | None | None | None | None | None |
Bemidji | BJI | BJI | KBJI | Bemidji Regional Airport | P-N | 22,819 |
Brainerd | BRD | BRD | KBRD | Brainerd Lakes Regional Airport | P-N | 15,654 |
Duluth | DLH | DLH | KDLH | Duluth International Airport | P-N | 155,455 |
Hibbing | HIB | HIB | KHIB | Range Regional Airport (was Chisholm–Hibbing Airport) | P-N | 11,669 |
International Falls | INL | INL | KINL | Falls International Airport | P-N | 15,796 |
Minneapolis | MSP | MSP | KMSP | Minneapolis–St. Paul International Airport (Wold–Chamberlain Field) | P-L | 16,282,038 |
Rochester | RST | RST | KRST | Rochester International Airport | P-N | 110,104 |
St. Cloud | STC | STC | KSTC | St. Cloud Regional Airport (scheduled passenger service resumed Dec. 2012) | P-N | 15,842 |
MISSISSIPPI | None | None | None | None | None | None |
Columbus / West Point / Starkville | GTR | GTR | KGTR | Golden Triangle Regional Airport | P-N | 41,140 |
Gulfport / Biloxi | GPT | GPT | KGPT | Gulfport-Biloxi International Airport | P-N | 369,597 |
Hattiesburg / Laurel | PIB | PIB | KPIB | Hattiesburg-Laurel Regional Airport | P-N | 10,633 |
Jackson | JAN | JAN | KJAN | Jackson-Evers International Airport | P-S | 596,045 |
MISSOURI | None | None | None | None | None | None |
Columbia | COU | COU | KCOU | Columbia Regional Airport | P-N | 45,714 |
Joplin | JLN | JLN | KJLN | Joplin Regional Airport | P-N | 23,329 |
Kansas City | MCI | MCI | KMCI | Kansas City International Airport | P-M | 4,836,221 |
Springfield | SGF | SGF | KSGF | Springfield-Branson National Airport | P-N | 368,752 |
St. Louis | STL | STL | KSTL | Lambert-St. Louis International Airport | P-M | 6,213,972 |
MONTANA | None | None | None | None | None | None |
Billings | BIL | BIL | KBIL | Billings Logan International Airport | P-S | 387,368 |
Bozeman | BZN | BZN | KBZN | Bozeman Yellowstone International Airport (was Gallatin Field Airport) | P-S | 442,788 |
Butte | BTM | BTM | KBTM | Bert Mooney Airport | P-N | 29,490 |
Great Falls | GTF | GTF | KGTF | Great Falls International Airport | P-N | 182,390 |
Helena | HLN | HLN | KHLN | Helena Regional Airport | P-N | 97,310 |
Kalispell | GPI | FCA | KGPI | Glacier Park International Airport | P-N | 199,701 |
Missoula | MSO | MSO | KMSO | Missoula International Airport | P-N | 298,253 |
NEBRASKA | None | None | None | None | None | None |
Grand Island | GRI | GRI | KGRI | Central Nebraska Regional Airport | P-N | 57,165 |
Kearney | EAR | EAR | KEAR | Kearney Regional Airport (was Kearney Municipal) | P-N | 13,096 |
Lincoln | LNK | LNK | KLNK | Lincoln Airport (was Lincoln Municipal) | P-N | 138,787 |
Omaha | OMA | OMA | KOMA | Eppley Airfield | P-M | 1,977,480 |
Scottsbluff | BFF | BFF | KBFF | Western Nebraska Regional Airport (William B. Heilig Field) | P-N | 10,155 |
NEVADA | None | None | None | None | None | None |
Boulder City | BVU | BLD | KBVU | Boulder City Municipal Airport | P-N | 103,972 |
Elko | EKO | EKO | KEKO | Elko Regional Airport (J.C. Harris Field) | P-N | 19,510 |
Las Vegas | LAS | LAS | KLAS | McCarran International Airport | P-L | 19,923,594 |
Reno | RNO | RNO | KRNO | Reno/Tahoe International Airport | P-S | 1,672,139 |
NEW HAMPSHIRE | None | None | None | None | None | None |
Lebanon | LEB | LEB | KLEB | Lebanon Municipal Airport | P-N | 10,953 |
Manchester | MHT | MHT | KMHT | Manchester-Boston Regional Airport | P-S | 1,190,082 |
NEW JERSEY | None | None | None | None | None | None |
Atlantic City | ACY | ACY | KACY | Atlantic City International Airport | P-S | 534,204 |
Trenton | TTN | TTN | KTTN | Trenton Mercer Airport | P-N | 148,256 |
Newark | EWR | EWR | KEWR | Newark Liberty International Airport | P-L | 17,514,139 |
NEW MEXICO | None | None | None | None | None | None |
Albuquerque | ABQ | ABQ | KABQ | Albuquerque International Sunport | P-M | 2,477,960 |
Farmington | FMN | FMN | KFMN | Four Corners Regional Airport | P-N | 14,263 |
Hobbs | HOB | HOB | KHOB | Lea County Regional Airport | P-N | 17,246 |
Roswell | ROW | ROW | KROW | Roswell International Air Center | P-N | 32,616 |
Santa Fe | SAF | SAF | KSAF | Santa Fe Municipal Airport (scheduled passenger service resumed 2009) | P-N | 65,845 |
NEW YORK | None | None | None | None | None | None |
Albany | ALB | ALB | KALB | Albany International Airport | P-S | 1,196,753 |
Binghamton | BGM | BGM | KBGM | Greater Binghamton Airport (Edwin A. Link Field) | P-N | 95,210 |
Buffalo | BUF | BUF | KBUF | Buffalo Niagara International Airport | P-M | 2,568,018 |
Elmira / Corning | ELM | ELM | KELM | Elmira/Corning Regional Airport | P-N | 129,749 |
Islip | ISP | ISP | KISP | Long Island MacArthur Airport | P-S | 662,612 |
Ithaca | ITH | ITH | KITH | Ithaca Tompkins Regional Airport | P-N | 103,722 |
New York | JFK | JFK | KJFK | John F. Kennedy International Airport | P-L | 25,036,855 |
New York | LGA | LGA | KLGA | LaGuardia Airport (and Marine Air Terminal) | P-L | 13,353,365 |
Newburgh | SWF | SWF | KSWF | Stewart International Airport | P-N | 163,815 |
Niagara Falls | IAG | IAG | KIAG | Niagara Falls International Airport | P-N | 98,958 |
Plattsburgh | PBG | PBG | KPBG | Plattsburgh International Airport | P-N | 151,235 |
Rochester | ROC | ROC | KROC | Greater Rochester International Airport | P-S | 1,209,532 |
Syracuse | SYR | SYR | KSYR | Syracuse Hancock International Airport | P-S | 991,663 |
Watertown | ART | ART | KART | Watertown International Airport | P-N | 18,818 |
White Plains | HPN | HPN | KHPN | Westchester County Airport | P-S | 770,550 |
NORTH CAROLINA | None | None | None | None | None | None |
Asheville | AVL | AVL | KAVL | Asheville Regional Airport | P-N | 342,731 |
Charlotte | CLT | CLT | KCLT | Charlotte/Douglas International Airport | P-L | 21,347,428 |
Fayetteville | FAY | FAY | KFAY | Fayetteville Regional Airport (Grannis Field) | P-N | 244,345 |
Greensboro | GSO | GSO | KGSO | Piedmont Triad International Airport | P-S | 860,124 |
Greenville | PGV | PGV | KPGV | Pitt-Greenville Airport | P-N | 60,020 |
Jacksonville | OAJ | OAJ | KOAJ | Albert J. Ellis Airport | P-N | 167,528 |
New Bern | EWN | EWN | KEWN | Coastal Carolina Regional Airport (was Craven County Regional) | P-N | 121,479 |
Raleigh | RDU | RDU | KRDU | Raleigh-Durham International Airport | P-M | 4,482,973 |
Wilmington | ILM | ILM | KILM | Wilmington International Airport | P-S | 397,737 |
NORTH DAKOTA | None | None | None | None | None | None |
Bismarck | BIS | BIS | KBIS | Bismarck Municipal Airport | P-N | 238,929 |
Dickinson | DIK | DIK | KDIK | Dickinson Theodore Roosevelt Regional Airport | P-N | 34,979 |
Fargo | FAR | FAR | KFAR | Hector International Airport | P-S | 403,786 |
Grand Forks | GFK | GFK | KGFK | Grand Forks International Airport | P-N | 148,663 |
Minot | MOT | MOT | KMOT | Minot International Airport | P-N | 220,787 |
Williston | ISN | ISN | KISN | Sloulin Field International Airport | P-N | 96,078 |
OHIO | None | None | None | None | None | None |
Akron / Canton | CAK | CAK | KCAK | Akron-Canton Regional Airport | P-S | 852,332 |
Cleveland | CLE | CLE | KCLE | Cleveland-Hopkins International Airport | P-M | 4,375,822 |
Columbus | CMH | CMH | KCMH | Port Columbus International Airport | P-M | 3,065,569 |
Columbus | LCK | LCK | KLCK | Rickenbacker International Airport | P-N | 17,765 |
Dayton | DAY | DAY | KDAY | James M. Cox Dayton International Airport | P-S | 1,244,841 |
Toledo | TOL | TOL | KTOL | Toledo Express Airport | P-N | 86,221 |
Youngstown / Warren | YNG | YNG | KYNG | Youngstown-Warren Regional Airport / Youngstown ARS | P-N | 47,518 |
OKLAHOMA | None | None | None | None | None | None |
Lawton | LAW | LAW | KLAW | Lawton–Fort Sill Regional Airport | P-N | 55,526 |
Oklahoma City | OKC | OKC | KOKC | Will Rogers World Airport | P-S | 1,790,407 |
Tulsa | TUL | TUL | KTUL | Tulsa International Airport | P-S | 1,323,943 |
OREGON | None | None | None | None | None | None |
Eugene | EUG | EUG | KEUG | Eugene Airport (Mahlon Sweet Field) | P-S | 434,095 |
Klamath Falls | LMT | LMT | KLMT | Klamath Falls Airport (Kingsley Field) | P-N | 13,433 |
Medford | MFR | MFR | KMFR | Rogue Valley International-Medford Airport | P-N | 306,450 |
North Bend | OTH | OTH | KOTH | Southwest Oregon Regional Airport (was North Bend Municipal) | P-N | 16,864 |
Portland | PDX | PDX | KPDX | Portland International Airport | P-L | 7,453,098 |
Redmond | RDM | RDM | KRDM | Redmond Municipal Airport (Roberts Field) | P-N | 236,303 |
PENNSYLVANIA | None | None | None | None | None | None |
Allentown | ABE | ABE | KABE | Lehigh Valley International Airport | P-N | 301,969 |
Erie | ERI | ERI | KERI | Erie International Airport (Tom Ridge Field) | P-N | 109,520 |
Harrisburg / Middletown | MDT | MDT | KMDT | Harrisburg International Airport | P-S | 657,650 |
Latrobe | LBE | LBE | KLBE | Arnold Palmer Regional Airport | P-N | 127,040 |
Philadelphia | PHL | PHL | KPHL | Philadelphia International Airport | P-L | 14,705,014 |
Pittsburgh | PIT | PIT | KPIT | Pittsburgh International Airport | P-M | 3,813,007 |
State College | UNV | SCE | KUNV | University Park Airport | P-N | 131,220 |
Wilkes-Barre / Scranton | AVP | AVP | KAVP | Wilkes-Barre/Scranton International Airport | P-N | 216,536 |
Williamsport | IPT | IPT | KIPT | Williamsport Regional Airport | P-N | 23,371 |
RHODE ISLAND | None | None | None | None | None | None |
Providence / Warwick | PVD | PVD | KPVD | Theodore Francis Green State Airport | P-M | 1,951,566 |
Westerly | WST | WST | KWST | Westerly State Airport | P-N | 11,402 |
SOUTH CAROLINA | None | None | None | None | None | None |
Charleston | CHS | CHS | KCHS | Charleston International Airport / Charleston AFB | P-S | 1,470,901 |
Columbia | CAE | CAE | KCAE | Columbia Metropolitan Airport | P-S | 487,180 |
Florence | FLO | FLO | KFLO | Florence Regional Airport | P-N | 59,894 |
Greer | GSP | GSP | KGSP | Greenville-Spartanburg International Airport (Roger Milliken Field) | P-S | 917,937 |
Hilton Head Island | HXD | HHH | KHXD | Hilton Head Airport | P-N | 58,704 |
Myrtle Beach | MYR | MYR | KMYR | Myrtle Beach International Airport | P-S | 823,294 |
SOUTH DAKOTA | None | None | None | None | None | None |
Aberdeen | ABR | ABR | KABR | Aberdeen Regional Airport | P-N | 20,089 |
Pierre | PIR | PIR | KPIR | Pierre Regional Airport | P-N | 14,686 |
Rapid City | RAP | RAP | KRAP | Rapid City Regional Airport | P-N | 284,126 |
Sioux Falls | FSD | FSD | KFSD | Sioux Falls Regional Airport (Joe Foss Field) | P-N | 355,939 |
TENNESSEE | None | None | None | None | None | None |
Bristol / Johnson City / Kingsport | TRI | TRI | KTRI | Tri-Cities Regional Airport (Tri-Cities Regional TN/VA) | P-N | 202,114 |
Chattanooga | CHA | CHA | KCHA | Chattanooga Metropolitan Airport (Lovell Field) | P-N | 292,830 |
Knoxville | TYS | TYS | KTYS | McGhee Tyson Airport | P-S | 804,917 |
Memphis | MEM | MEM | KMEM | Memphis International Airport | P-M | 4,930,935 |
Nashville | BNA | BNA | KBNA | Nashville International Airport (Berry Field) | P-M | 4,432,527 |
TEXAS | None | None | None | None | None | None |
Abilene | ABI | ABI | KABI | Abilene Regional Airport | P-N | 73,605 |
Amarillo | AMA | AMA | KAMA | Rick Husband Amarillo International Airport | P-S | 394,593 |
Austin | AUS | AUS | KAUS | Austin-Bergstrom International Airport | P-M | 4,201,136 |
Beaumont / Port Arthur | BPT | BPT | KBPT | Jack Brooks Regional Airport (was Southeast Texas Regional) | P-N | 17,394 |
Brownsville | BRO | BRO | KBRO | Brownsville/South Padre Island International Airport | P-N | 84,401 |
College Station | CLL | CLL | KCLL | Easterwood Airport (Easterwood Field) | P-N | 72,188 |
Corpus Christi / Kingsville | CRP | CRP | KCRP | Corpus Christi International Airport | P-S | 339,193 |
Dallas | DAL | DAL | KDAL | Dallas Love Field | P-M | 3,783,407 |
Dallas-Fort Worth | DFW | DFW | KDFW | Dallas/Fort Worth International Airport | P-L | 27,100,656 |
Del Rio | DRT | DRT | KDRT | Del Rio International Airport | P-N | 13,180 |
El Paso | ELP | ELP | KELP | El Paso International Airport | P-S | 1,509,093 |
Fort Hood / Killeen / Temple | GRK | GRK | KGRK | Killeen-Fort Hood Regional Airport / Robert Gray Army Airfield | P-N | 243,861 |
Harlingen | HRL | HRL | KHRL | Valley International Airport | P-S | 373,438 |
Houston | IAH | IAH | KIAH | George Bush Intercontinental Airport | P-L | 19,528,631 |
Houston | HOU | HOU | KHOU | William P. Hobby Airport | P-M | 4,357,835 |
Laredo | LRD | LRD | KLRD | Laredo International Airport | P-N | 112,520 |
Longview | GGG | GGG | KGGG | East Texas Regional Airport | P-N | 21,830 |
Lubbock | LBB | LBB | KLBB | Lubbock Preston Smith International Airport | P-S | 508,858 |
McAllen | MFE | MFE | KMFE | McAllen-Miller International Airport (McAllen Miller International) | P-S | 344,302 |
Midland | MAF | MAF | KMAF | Midland International Airport | P-S | 445,043 |
San Angelo | SJT | SJT | KSJT | San Angelo Regional Airport (Mathis Field) | P-N | 56,021 |
San Antonio | SAT | SAT | KSAT | San Antonio International Airport | P-M | 3,916,320 |
Tyler | TYR | TYR | KTYR | Tyler Pounds Regional Airport | P-N | 74,357 |
Waco | ACT | ACT | KACT | Waco Regional Airport | P-N | 61,401 |
Wichita Falls | SPS | SPS | KSPS | Wichita Falls Municipal Airport / Sheppard Air Force Base | P-N | 44,296 |
UTAH | None | None | None | None | None | None |
Provo | PVU | PVU | KPVU | Provo Municipal Airport (14,858 enplanements in 2011)[1] | P-N [nb 6] | 1,124 |
Salt Lake City | SLC | SLC | KSLC | Salt Lake City International Airport | P-L | 9,910,493 |
St. George / Beaver | SGU | SGU | KSGU | St. George Municipal Airport (opened 2011) | P-N [nb 7] | 37,596 |
Wendover | ENV | ENV | KENV | Wendover Airport (charter flights) | P-N [nb 8] | 50,734 |
VERMONT | None | None | None | None | None | None |
Burlington | BTV | BTV | KBTV | Burlington International Airport | P-S | 640,790 |
VIRGINIA | None | None | None | None | None | None |
Charlottesville | CHO | CHO | KCHO | Charlottesville–Albemarle Airport | P-N | 197,776 |
Lynchburg | LYH | LYH | KLYH | Lynchburg Regional Airport (Preston Glenn Field) | P-N | 93,772 |
Newport News | PHF | PHF | KPHF | Newport News/Williamsburg International Airport | P-S | 519,906 |
Norfolk | ORF | ORF | KORF | Norfolk International Airport | P-S | 1,663,294 |
Richmond | RIC | RIC | KRIC | Richmond International Airport (Byrd Field) | P-S | 1,651,131 |
Roanoke | ROA | ROA | KROA | Roanoke Regional Airport (Woodrum Field) | P-N | 316,478 |
Staunton / Waynesboro / Harrisonburg | SHD | SHD | KSHD | Shenandoah Valley Regional Airport | P-N [nb 9] | 10,408 |
Washington, D.C. / Arlington County | DCA | DCA | KDCA | Ronald Reagan Washington National Airport | P-L | 8,736,804 |
Washington, D.C. / Chantilly / Dulles | IAD | IAD | KIAD | Washington Dulles International Airport | P-L | 11,276,481 |
WASHINGTON | None | None | None | None | None | None |
Bellingham | BLI | BLI | KBLI | Bellingham International Airport | P-N | 398,368 |
Friday Harbor | FHR | FRD | KFHR | Friday Harbor Airport | P-N | 12,381 |
Pasco | PSC | PSC | KPSC | Tri-Cities Airport | P-N | 312,915 |
Port Angeles | CLM | CLM | KCLM | William R. Fairchild International Airport | P-N | 10,616 |
Pullman / Moscow, Idaho | PUW | PUW | KPUW | Pullman/Moscow Regional Airport | P-N | 35,248 |
Seattle | BFI | BFI | KBFI | King County International Airport (Boeing Field) | P-N | 33,656 |
Seattle / Tacoma (SeaTac) | SEA | SEA | KSEA | Seattle–Tacoma International Airport | P-L | 15,406,243 |
Spokane | GEG | GEG | KGEG | Spokane International Airport (Geiger Field) | P-S | 1,545,115 |
Walla Walla | ALW | ALW | KALW | Walla Walla Regional Airport | P-N | 29,064 |
Wenatchee | EAT | EAT | KEAT | Pangborn Memorial Airport | P-N | 46,837 |
Yakima | YKM | YKM | KYKM | Yakima Air Terminal (McAllister Field) | P-N | 53,832 |
WEST VIRGINIA | None | None | None | None | None | None |
Charleston | CRW | CRW | KCRW | Yeager Airport | P-N | 264,818 |
Clarksburg | CKB | CKB | KCKB | North Central West Virginia Airport (was Harrison-Marion Regional) | P-N | 10,694 |
Huntington | HTS | HTS | KHTS | Tri-State Airport (Milton J. Ferguson Field) | P-N | 115,263 |
Lewisburg | LWB | LWB | KLWB | Greenbrier Valley Airport | P-N [nb 10] | 12,293 |
Morgantown | MGW | MGW | KMGW | Morgantown Municipal Airport (Walter L. Bill Hart Field) | P-N | 11,249 |
WISCONSIN | None | None | None | None | None | None |
Appleton | ATW | ATW | KATW | Outagamie County Regional Airport | P-N | 259,340 |
Eau Claire | EAU | EAU | KEAU | Chippewa Valley Regional Airport | P-N | 18,762 |
Green Bay | GRB | GRB | KGRB | Austin Straubel International Airport | P-S | 410,348 |
La Crosse | LSE | LSE | KLSE | La Crosse Regional Airport | P-N | 111,462 |
Madison | MSN | MSN | KMSN | Dane County Regional Airport (Truax Field) | P-S | 728,075 |
Milwaukee | MKE | MKE | KMKE | General Mitchell International Airport | P-M | 3,861,333 |
Wausau | CWA | CWA | KCWA | Central Wisconsin Airport | P-N | 154,312 |
Rhinelander | RHI | RHI | KRHI | Rhinelander-Oneida County Airport | P-N | 26,193 |
WYOMING | None | None | None | None | None | None |
Casper | CPR | CPR | KCPR | Casper/Natrona County International Airport | P-N | 74,167 |
Cheyenne | CYS | CYS | KCYS | Cheyenne Regional Airport (Jerry Olson Field) | P-N | 16,697 |
Cody | COD | COD | KCOD | Yellowstone Regional Airport | P-N | 25,863 |
Gillette | GCC | GCC | KGCC | Gillette-Campbell County Airport | P-N | 28,232 |
Jackson | JAC | JAC | KJAC | Jackson Hole Airport | P-N | 305,566 |
Laramie | LAR | LAR | KLAR | Laramie Regional Airport | P-N | 10,371 |
Riverton | RIW | RIW | KRIW | Riverton Regional Airport | P-N | 17,035 |
Rock Springs | RKS | RKS | KRKS | Rock Springs – Sweetwater County Airport | P-N | 25,541 |
Sheridan | SHR | SHR | KSHR | Sheridan County Airport | P-N | 17,710 |
AMERICAN SAMOA | None | None | None | None | None | None |
Pago Pago, Tutuila | PPG | PPG | NSTU | Pago Pago International Airport | P-N | 49,479 |
GUAM | None | None | None | None | None | None |
Agana / Tamuning | GUM | GUM | PGUM | Antonio B. Won Pat International Airport | P-S | 1,488,187 |
NORTHERN MARIANAS | None | None | None | None | None | None |
Obyan, Saipan Island | GSN | SPN | PGSN | Saipan International Airport (Francisco C. Ada) | P-S | 448,177 |
Rota Island | GRO | ROP | PGRO | Rota International Airport | P-N | 10,092 |
PUERTO RICO | None | None | None | None | None | None |
Aguadilla | BQN | BQN | TJBQ | Rafael Hernández International Airport | P-N | 240,270 |
Ponce | PSE | PSE | TJPS | Mercedita International Airport | P-N | 110,159 |
San Juan / Carolina | SJU | SJU | TJSJ | Luis Muñoz Marín International Airport | P-M | 4,635,798 |
San Juan / Miramar | SIG | SIG | TJIG | Fernando Luis Ribas Dominicci Airport (Isla Grande Airport) | P-N [nb 11] | 13,837 |
Vieques | VQS | VQS | TJVQ | Antonio Rivera Rodríguez Airport | P-N | 21,517 |
U.S. VIRGIN ISLANDS | None | None | None | None | None | None |
Charlotte Amalie, St. Thomas | STT | STT | TIST | Cyril E. King Airport | P-S | 593,589 |
Christiansted, St. Croix | STX | STX | TISX | Henry E. Rohlsen Airport | P-N | 169,665 |