Skip to content

Instantly share code, notes, and snippets.

@steve-kasica
Last active August 13, 2018 22:52
Show Gist options
  • Save steve-kasica/e8e9254dd01794fbc978b882a322bca7 to your computer and use it in GitHub Desktop.
Save steve-kasica/e8e9254dd01794fbc978b882a322bca7 to your computer and use it in GitHub Desktop.
airport_code close_amount_sum claim_count total_passengers airport_name coordinates
ABE 130 1 297096 Lehigh Valley International Airport -75.44080352783203, 40.652099609375
ABI 499 3 93756 Abilene Regional Airport -99.68190002440001, 32.4113006592
ABQ 139.1 2 2354087 Albuquerque International Sunport Airport -106.609001, 35.040199
ACY 839.61 4 585709 Atlantic City International Airport -74.57720184326172, 39.45759963989258
ALB 209.75 5 1210621 Albany International Airport -73.80169677734375, 42.74829864501953
AMA 0 1 362280 Ama Airport 141.67, -4.10111111111
AMA 0 1 362280 La Amalia -62.01656, -35.10042
AMA 0 1 362280 Rick Husband Amarillo International Airport -101.706001, 35.219398
AMA 0 1 362280 Amatlan de Jora Airport -104.128434, 21.393753
AMA 0 1 362280 La Amalia Airport -74.145833, 10.860833
ANC 0 4 2341143 Ted Stevens Anchorage International Airport -149.99600219726562, 61.174400329589844
ATL 11338.87 79 45966966 Hartsfield Jackson Atlanta International Airport -84.4281005859375, 33.63669967651367
ATW 223.71 1 249585 Appleton International Airport -88.5190963745, 44.258098602299995
AUS 625.27 16 5171421 Austin Bergstrom International Airport -97.6698989868164, 30.194499969482422
AVL 99.99 1 382484 Presidente Avellaneda Airport -59.6569, -29.1061
AVL 99.99 1 382484 Asheville Regional Airport -82.54180145263672, 35.43619918823242
AVP 0 1 214581 Wilkes Barre Scranton International Airport -75.72339630130001, 41.338500976599995
BDL 2223.08 8 2891522 Bradley International Airport -72.68319702149999, 41.9388999939
BFL 0 1 139994 Meadows Field -119.0569992, 35.43360138
BGM 0 1 82603 Greater Binghamton/Edwin A Link field -75.97979736, 42.20869827
BGM 0 1 82603 Las Bugambilias Airport -104.8325, 21.607
BHM 79.98 4 1298117 Birmingham-Shuttlesworth International Airport -86.75350189, 33.56290054
BLI 13 2 539002 Bellingham International Airport -122.53800201416016, 48.79280090332031
BLI 13 2 539002 Balimo Airport 142.932998657, -8.05000019073
BMI 0 2 204445 Central Illinois Regional Airport at Bloomington-Normal -88.91590118, 40.47710037
BNA 2756.66 17 5367508 Nashville International Airport -86.6781997680664, 36.1245002746582
BNA 2756.66 17 5367508 Baina Airstrip 143.6818, -6.8918
BOI 477 4 1378328 Boise Air Terminal/Gowen field -116.2229996, 43.56439972
BOS 7176.35 55 13709432 Lobos Airport -59.1367, -35.2108
BOS 7176.35 55 13709432 General Edward Lawrence Logan International Airport -71.00520325, 42.36429977
BQN 0 3 212239 Rafael Hernandez Airport -67.12940216064453, 18.49489974975586
BRD 205 1 17141 Brainerd Lakes Regional Airport -94.13809967, 46.39830017
BTR 136.86 3 380023 Batri Airstrip 143.9441, -6.5522
BTR 136.86 3 380023 Baton Rouge Metropolitan, Ryan Field -91.14959717, 30.53319931
BTV 0 3 601504 Burlington International Airport -73.15329742429999, 44.471900939899996
BUF 250 4 2377529 Buffalo Niagara International Airport -78.73220062, 42.94049835
BUR 479 8 1928533 Bob Hope Airport -118.35900115966797, 34.20069885253906
BWI 2001.74 34 10923142 Blimbingsari Airport 114.3401, -8.31015
BWI 2001.74 34 10923142 Baltimore/Washington International Thurgood Marshall Airport -76.66829681, 39.17539978
BZN 0 1 482548 Gallatin Field -111.1529999, 45.77750015
CAE 92.4 3 498003 Columbia Metropolitan Airport -81.11949920654297, 33.93880081176758
CAK 0 3 770627 Akron Canton Regional Airport -81.44219970703125, 40.916099548339844
CHA 249 1 356066 Charata Airport -61.2103, -27.2164
CHA 249 1 356066 Lovell Field -85.20379638671875, 35.035301208496094
CHA 249 1 356066 Chicoral - Estra Airport -74.969722, 4.202222
CHS 250 3 1539052 Charleston Air Force Base-International Airport -80.04049683, 32.89860153
CHS 250 3 1539052 China Strait Airstrip 150.690694444, -10.5627777778
CID 881.61 3 570285 The Eastern Iowa Airport -91.71080017089844, 41.884700775146484
CLE 1007.31 23 3656914 Lomas del Espinillo Airport -64.16972, -32.08806
CLE 1007.31 23 3656914 Cleveland Hopkins International Airport -81.8498001099, 41.4117012024
CLT 2082.69 24 21437068 Charlotte Douglas International Airport -80.94309997558594, 35.2140007019043
CLT 2082.69 24 21437068 Colonia Catriel Airport -67.8349990845, -37.9101982117
CMH 2149.08 8 3090116 John Glenn Columbus International Airport -82.891899, 39.998001
COD 0 1 32301 Yellowstone Regional Airport -109.024002075, 44.520198822
COS 0 2 624233 City of Colorado Springs Municipal Airport -104.70099639893, 38.805801391602
CPR 0 1 103374 Casper-Natrona County International Airport -106.4639969, 42.90800095
CPR 0 1 103374 Los Capires Airport -101.986662, 18.354552
CPR 0 1 103374 Cape Rodney Airport 148.379030228, -10.179823004
CVG 1086.86 6 2851377 Cape Vogel Airport 150.019722222, -9.67
CVG 1086.86 6 2851377 Cincinnati Northern Kentucky International Airport -84.6678009033, 39.0488014221
DAL 1974.32 10 4520852 Dallas Love Field -96.851799, 32.847099
DAY 15.94 1 1120159 James M Cox Dayton International Airport -84.21939849853516, 39.902400970458984
DCA 4922.17 35 9998163 Ronald Reagan Washington National Airport -77.037697, 38.8521
DEN 4014 45 25686181 Denver International Airport -104.672996521, 39.861698150635
DFW 7108.26 51 30196926 Dallas Fort Worth International Airport -97.03800201416016, 32.89680099487305
DLH 0 1 153416 Duluth International Airport -92.19360351559999, 46.8420982361
DSM 198.98 4 1141048 Des Moines International Airport -93.66310119628906, 41.534000396728516
DTW 690.26 18 15587638 Detroit Metropolitan Wayne County Airport -83.35340118408203, 42.212398529052734
ELP 85 3 1395296 El Pampero Airport -64.1866989136, -36.5928001404
ELP 85 3 1395296 Eliptamin Airport 141.6779, -5.0412
ELP 85 3 1395296 El Paso International Airport -106.3779984, 31.80719948
ERI 0 1 97012 Eri Airstrip 138.1094, -2.6308
ERI 0 1 97012 Erie International Tom Ridge Field -80.1738667488, 42.0831270134
EUG 168.95 2 440167 Mahlon Sweet Field -123.21199798583984, 44.12459945678711
EWR 5009.34 78 15927867 Newark Liberty International Airport -74.168701171875, 40.692501068115234
F 0 10
FAI 35 1 455124 Fairbanks International Airport -147.8560028, 64.81510162
FAR 272.84 1 454974 Hector International Airport -96.81580352783203, 46.92070007324219
FAT 0 1 640039 Fresno Yosemite International Airport -119.71800231933594, 36.77619934082031
FLL 5803.5 65 11108847 Fort Lauderdale Hollywood International Airport -80.15270233154297, 26.072599411010742
FLO 100 1 59314 Florence Regional Airport -79.7238998413086, 34.18539810180664
FLO 100 1 59314 Las Flores Airport -106.467681, 24.798599
FLO 100 1 59314 Las Flores Airport -59.1042, -36.0672
FNT 0 1 421120 Bishop International Airport -83.74359893798828, 42.96540069580078
FWA 25483.44 2 323232 Fort Wayne International Airport -85.19509888, 40.97850037
GEG 552.8 6 1445550 Spokane International Airport -117.53399658203125, 47.61989974975586
GJT 0 2 214247 Grand Junction Regional Airport -108.527000427, 39.1223983765
GLH 0 1 1618 General Las Heras -58.9164, -34.9206
GLH 0 1 1618 Mid Delta Regional Airport -90.98560333251953, 33.4828987121582
GRB 79.99 2 302293 Austin Straubel International Airport -88.12960052490234, 44.48509979248047
GRR 686.69 4 1174535 Gerald R. Ford International Airport -85.52279663, 42.88079834
GSO 0 1 850080 Piedmont Triad International Airport -79.93730163574219, 36.097801208496094
GSP 0 1 945419 Gusap Airport 145.959047, -6.053196
GSP 0 1 945419 Greenville Spartanburg International Airport -82.2189025879, 34.8956985474
GUM 126 2 1012841 Antonio B. Won Pat International Airport 144.796005249, 13.4834003448
HNL 2551.29 39 7997508 Daniel K Inouye International Airport -157.924228, 21.32062
HOU 764.39 15 5797745 William P Hobby Airport -95.27890015, 29.64539909
HPN 0 1 752705 P.N.A. Of. Ppal. Ballestra Heliport -58.3838, -34.5772
HPN 0 1 752705 Westchester County Airport -73.70760345458984, 41.06700134277344
HPN 0 1 752705 Nestle Heliport -99.188492, 19.438293
HRL 0 2 293294 Valley International Airport -97.65440368652344, 26.228500366210938
HSV 75 3 523230 Huntsville International Carl T Jones Field -86.775100708008, 34.637199401855
HSV 75 3 523230 Alsavision Heliport -99.201368, 19.436581
IAD 2452.67 31 8470983 Washington Dulles International Airport -77.45580292, 38.94449997
IAH 3950.57 31 18578719 George Bush Intercontinental Houston Airport -95.34140014648438, 29.984399795532227
ICT 0 2 757592 Wichita Mid Continent Airport -97.43309783935547, 37.649898529052734
ILG 522 1 104462 Ilugwa/Antara Airport 138.9219, -3.8357
ILG 522 1 104462 New Castle Airport -75.60649872, 39.67869949
IND 1472.3 12 3585914 Indianapolis International Airport -86.294403, 39.7173
IND 1472.3 12 3585914 Paso De Los Indios Airport -69.05000305179999, -43.8666992188
ISP 200 2 646134 Long Island Mac Arthur Airport -73.10019684, 40.79520035
ITO 92.01 1 626950 Hilo International Airport -155.04800415039062, 19.721399307250977
ITO 92.01 1 626950 Chilecito Airport -67.4389038086, -29.2238998413
IWA 135 5 Phoenix-Mesa-Gateway Airport -111.6549988, 33.30780029
JAC 0 1 308280 Jackson Hole Airport -110.73799896240234, 43.6072998046875
JAC 0 1 308280 Jachal Airport -68.740196228, -30.249500274699997
JAN 215.42 2 537764 Jackson-Medgar Wiley Evers International Airport -90.0758972168, 32.3111991882
JAX 1061.45 7 2589117 Jacksonville International Airport -81.68789672851562, 30.49410057067871
JFK 11340.05 144 17640692 John F Kennedy International Airport -73.77890015, 40.63980103
JNU 634.39 2 311378 Juneau International Airport -134.5760040283203, 58.35499954223633
KOA 1199.53 6 1373082 Ellison Onizuka Kona International At Keahole Airport -156.045603, 19.738783
LAS 2938.39 30 18789608 McCarran International Airport -115.1520004, 36.08010101
LAS 2938.39 30 18789608 Lasguabin Airport -71.549444, 4.710833
LAX 17457.11 112 27397762 Los Angeles International Airport -118.4079971, 33.94250107
LBB 173.14 2 451120 Lubbock Preston Smith International Airport -101.822998, 33.663601
LBB 173.14 2 451120 Los Bravos De Bonfil Airport -91.68843, 17.98953
LCH 0 1 69110 Lake Charles Regional Airport -93.22329711914062, 30.126100540161133
LEX 189.99 5 594681 Blue Grass Airport -84.60590362548828, 38.0364990234375
LFT 0 1 246828 Lafayette Regional Airport -91.98760223, 30.20529938
LFT 0 1 246828 La Floresta Airport -75.576111, 2.629722
LGA 3458.87 43 12886290 La Guardia Airport -73.87259674, 40.77719879
LGA 3458.87 43 12886290 La Gloria de Coahuila Airport -100.491992, 28.057181
LGA 3458.87 43 12886290 Las Garzas Airport -75.9475, 3.751111
LGB 27 8 1368778 Long Beach /Daugherty Field/ Airport -118.1520004, 33.81769943
LIH 707.7 4 1289789 Lismore Helibase 153.288242, -28.801211
LIH 707.7 4 1289789 Lihue Airport -159.33900451660156, 21.97599983215332
LIT 250.14 1 1005146 Bill & Hillary Clinton National Airport/Adams Field -92.2242965698, 34.729400634799994
LYH 0 1 78874 Lynchburg Regional Preston Glenn Field -79.20040130615234, 37.326698303222656
MCO 10345.42 92 15468409 Los Menucos Airport -68.074699, -40.817699
MCO 10345.42 92 15468409 Orlando International Airport -81.30899810791016, 28.429399490356445
MDT 268.67 3 638005 Harrisburg International Airport -76.7633972168, 40.1935005188
MDW 594.71 19 10137485 Chicago Midway International Airport -87.75240325927734, 41.7859992980957
MEM 754.48 10 1799329 Memphis International Airport -89.97669982910156, 35.04240036010742
MFE 130.5 2 378165 Mc Allen Miller International Airport -98.23860168, 26.17580032
MFR 128.88 4 323534 Rogue Valley International Medford Airport -122.87300109863281, 42.37419891357422
MHT 0 3 1032940 Manchester Airport -71.43569946289062, 42.93259811401367
MIA 1413.55 52 15476730 Miami International Airport -80.29060363769531, 25.79319953918457
MKE 154.99 7 3212520 General Mitchell International Airport -87.89659881591797, 42.947200775146484
MLU 179.4 1 120589 Monroe Regional Airport -92.0376968383789, 32.51089859008789
MLU 179.4 1 120589 Malalaua Airport 146.155472222, -8.07138888889
MMH 0 1 25910 Mammoth Yosemite Airport -118.8379974, 37.62409973
MOB 220.76 2 288280 Mobile Regional Airport -88.242797851562, 30.691200256348
MOT 0 1 219842 Minot International Airport -101.27999877929688, 48.2593994140625
MRY 25 3 186717 Monterey Peninsula Airport -121.84300231933594, 36.58700180053711
MSP 7272.47 26 16887858 Marcos Paz -58.8969, -34.7975
MSP 7272.47 26 16887858 Minneapolis-St Paul International/Wold-Chamberlain Airport -93.22180175780001, 44.881999969499994
MSP 7272.47 26 16887858 San Luis De Paca Airport -70.346389, 0.874444
MSY 1547.05 18 4846835 Mirsey Airstrip 142.6609, -4.0621
MSY 1547.05 18 4846835 Louis Armstrong New Orleans International Airport -90.25800323486328, 29.99340057373047
MYR 134.99 2 849161 Myrtle Beach International Airport -78.9282989502, 33.6796989441
OAK 1130.77 22 4973012 Metropolitan Oakland International Airport -122.221001, 37.721298
OGG 1171.84 11 2866426 Kahului Airport -156.429993, 20.8986
OKC 39.95 4 1861184 Will Rogers World Airport -97.60070037841797, 35.39310073852539
OMA 0 2 2019892 Eppley Airfield -95.89409637451172, 41.303199768066406
OMA 0 2 2019892 Loma La Lata Airport -68.737297, -38.413799
ONT 2236.01 7 1995701 Ontario International Airport -117.60099792480469, 34.055999755859375
ORD 15640.94 78 31222233 Chicago O'Hare International Airport -87.90480042, 41.97859955
ORF 117.8 4 1485865 Norfolk International Airport -76.20120239257812, 36.89459991455078
PBI 2605.9 17 2873022 Palm Beach International Airport -80.09559631347656, 26.68320083618164
PDX 1256.05 15 7812618 Portland International Airport -122.5979996, 45.58869934
PHL 6450.55 47 14501100 Philadelphia International Airport -75.24109649658203, 39.87189865112305
PHX 1395.56 43 19937297 Phoenix Sky Harbor International Airport -112.01200103759766, 33.43429946899414
PIA 0 2 319754 General Wayne A. Downing Peoria International Airport -89.6932983398, 40.664199829100006
PIE 329.32 3 655678 St Petersburg Clearwater International Airport -82.68740082, 27.91020012
PIE 329.32 3 655678 Waterloo Airport -75.035556, 4.442222
PIT 808.04 6 3802399 Pittsburgh International Airport -80.23290253, 40.49150085
PIT 808.04 6 3802399 La Pinta Airport -98.473083, 25.447861
PNS 0 2 758582 Pensacola Regional Airport -87.186599731445, 30.473400115967
PSC 197.43 2 329081 Tri Cities Airport -119.11900329589844, 46.26470184326172
PSE 0 1 97271 Mercedita Airport -66.56300354003906, 18.00830078125
PSP 79.99 4 809934 Termal Airport -60.492222, -26.753611
PSP 79.99 4 809934 Palm Springs International Airport -116.50700378417969, 33.8297004699707
PVD 278.4 4 1764366 Theodore Francis Green State Airport -71.42040252685547, 41.732601165771484
RDU 2607.13 12 4638957 Raleigh Durham International Airport -78.7874984741211, 35.877601623535156
RHI 70 1 20751 Rhinelander Oneida County Airport -89.46749877929688, 45.63119888305664
RIC 731.38 5 1667158 Richmond International Airport -77.3197021484375, 37.50519943237305
RNO 349 3 1611179 Reno Tahoe International Airport -119.76799774169922, 39.49909973144531
ROA 0 1 304966 Roanoke–Blacksburg Regional Airport -79.975403, 37.3255
RSW 2064.99 29 3794269 Southwest Florida International Airport -81.75520324707031, 26.53619956970215
SAN 3915.57 26 9096035 San Diego International Airport -117.190002441, 32.7336006165
SAN 3915.57 26 9096035 Antoine De St Exupery Airport -65.0343, -40.7512
SAN 3915.57 26 9096035 San Fernandof Airport -71.683889, 5.666667
SAT 4624.61 16 3877468 San Antonio International Airport -98.46980285644531, 29.533700942993164
SAT 4624.61 16 3877468 Santa Clara Airport -72.773889, 4.415833
SAV 249 4 932288 Savissivik Heliport -65.1176834106, 76.01861346460001
SAV 249 4 932288 Savannah Hilton Head International Airport -81.20210266, 32.12760162
SAV 249 4 932288 Santa Ana Maloapan Airport -97.0872, 20.0623
SBA 213.73 1 334591 Santa Barbara Municipal Airport -119.8399963, 34.42620087
SBN 46.99 2 310909 South Bend Regional Airport -86.31729888916016, 41.70869827270508
SBN 46.99 2 310909 Santa Bárbara Airport -77.981753, 2.445825
SDF 263.94 2 1634630 Louisville International Standiford Field -85.736, 38.1744
SEA 4513.47 48 17119184 Seattle Tacoma International Airport -122.30899810791016, 47.44900131225586
SFB 222.97 3 919356 Orlando Sanford International Airport -81.23750305175781, 28.777599334716797
SFO 0 6 19695768 San Francisco International Airport -122.375, 37.61899948120117
SGF 0 1 419932 Springfield Branson National Airport -93.38860321, 37.24570084
SGU 0 1 59286 St George Municipal Airport -113.510306, 37.036389
SHV 0 4 307435 Shreveport Regional Airport -93.82559967041016, 32.44660186767578
SJC 0 6 4524016 Norman Y. Mineta San Jose International Airport -121.929001, 37.362598
SJT 152.99 1 65954 San Justo Airport -60.5653, -30.7642
SJT 152.99 1 65954 San Angelo Regional Mathis Field -100.49600219726562, 31.35770034790039
SJT 152.99 1 65954 San Javier Airport -75.035556, 4.401389
SJU 1232.83 22 4033008 Capitan D Daniel Vazquez Airport -67.8026, -49.3068
SJU 1232.83 22 4033008 Luis Munoz Marin International Airport -66.0018005371, 18.4393997192
SLC 2245.15 26 10138800 Salt Lake City International Airport -111.97799682617188, 40.78839874267578
SLC 2245.15 26 10138800 Sabanalarga Airport -73.033333, 4.816667
SMF 7503.83 11 4324558 Finca La Frontera Airport -63.29055, -22.12351
SMF 7503.83 11 4324558 Sacramento International Airport -121.59100341796875, 38.69540023803711
SNA 801.79 15 4526216 John Wayne Airport-Orange County Airport -117.8679962, 33.67570114
SPS 0 1 46890 Sopise Airstrip 144.1593, -6.7887
SPS 0 1 46890 Sheppard Air Force Base-Wichita Falls Municipal Airport -98.491898, 33.9888
SRQ 0 3 581510 Sarasota Bradenton International Airport -82.55439758300781, 27.39539909362793
STL 962.06 11 6087757 St Louis Lambert International Airport -90.370003, 38.748697
STT 630 5 687132 Santo Tomas Airport -92.205, 14.6448
STT 630 5 687132 Cyril E. King Airport -64.97339630126953, 18.337299346923828
STX 90 1 184164 Santa Elena Airstrip -101.8959, 29.6391
STX 90 1 184164 Henry E Rohlsen Airport -64.79859924316406, 17.701900482177734
SUX 0 1 31655 Sioux Gateway Col. Bud Day Field -96.38439941, 42.40259933
SYR 272.5 4 981786 Syracuse Hancock International Airport -76.1063003540039, 43.11119842529297
TOL 22.5 1 98933 Toledo Express Airport -83.80780029, 41.58679962
TOL 22.5 1 98933 Tol Airport 152.009994507, -4.98083019257
TOL 22.5 1 98933 Tolwin Observatory Airport -67.1989974976, -54.521900177
TOL 22.5 1 98933 Tolemaida Air Base -74.649901, 4.2448
TPA 1949.02 25 8286452 Tampa International Airport -82.533203125, 27.975500106811523
TUL 0 2 1371465 Tulsa International Airport -95.88809967041016, 36.19839859008789
TUS 28 3 1596929 Tucson International Airport -110.94100189208984, 32.1161003112793
TYS 705.45 4 845566 McGhee Tyson Airport -83.9940033, 35.81100082
XNA 130 1 619137 Northwest Arkansas Regional Airport -94.306801, 36.281898
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment