Data Doughnut
Data catalog › Community health & safety

FAA and Bureau of Transportation Statistics

Airports & air traffic

Every public and private airport and runway, passengers boarding and cargo by airport, and airline flights and passengers between airports by month.

Published by FAA and Bureau of Transportation Statistics Finest detail facility Tables 6
Airport list Sample of 25 rows out of about 19,837 · 34 columns
idairport_seq_idairport_idairportdisplay_airport_namedisplay_airport_city_name_fullairport_wac_seq_id2airport_wacairport_country_nameairport_country_code_isoairport_state_nameairport_state_codeairport_state_fipscity_market_seq_idcity_market_iddisplay_city_market_name_fullcity_market_wac_seq_id2city_market_waclat_degreeslat_hemispherelat_minuteslat_secondslatitudelon_degreeslon_hemispherelon_minuteslon_secondslongitudeutc_local_time_variationairport_start_dateairport_thru_dateairport_is_closedairport_is_latestcounty_fips
110001011000101AAfognak Lake AirportAfognak Lake, AK1011United StatesUSAlaskaAK02300010130001Afognak Lake, AK101158N63458.10944444152W5424-152.90666667No data7/1/2007 12:00:00 AMNo data0102150
210003011000303ABear Creek Mining StripGranite Mountain, AK1011United StatesUSAlaskaAK02300030130003Granite Mountain, AK101165N325365.54805556161W418-161.07166667No data7/1/2007 12:00:00 AMNo data0102188
310004011000404ALik Mining CampLik, AK1011United StatesUSAlaskaAK02300040130004Lik, AK101168N5068.08333333163W100-163.16666667No data7/1/2007 12:00:00 AMNo data0102188
410005011000505ALittle Squaw AirportLittle Squaw, AK1011United StatesUSAlaskaAK02300050130005Little Squaw, AK101167N341267.57148W112-148.18388889No data8/1/2007 12:00:00 AMNo data0102290
510006011000606AKizhuyak BayKizhuyak, AK1011United StatesUSAlaskaAK02300060130006Kizhuyak, AK101157N444357.74527778152W5258-152.88277778No data10/1/2007 12:00:00 AMNo data01No data
610007011000707AKlawock Seaplane BaseKlawock, AK1011United StatesUSAlaskaAK02300070130007Klawock, AK101155N331755.55472222133W66-133.10166667No data4/1/2008 12:00:00 AMNo data0102198
710008011000808AElizabeth Island AirportElizabeth Island, AK1011United StatesUSAlaskaAK02300080130008Elizabeth Island, AK101159N92559.15694444151W4945-151.82916667No data6/1/2008 12:00:00 AMNo data0102122
810009011000909AAugustin IslandHomer, AK1011United StatesUSAlaskaAK02300090130009Homer, AK101159N214659.36277778153W2550-153.43055556No data6/1/2008 12:00:00 AMNo data0102122
91001001100101B1Columbia CountyHudson, NY220122United StatesUSNew YorkNY36300100130010Hudson, NY22012242N172042.2888888973W4237-73.71027778-05004/1/2009 12:00:00 AM6/30/2011 12:00:00 AM0036021
101001002100101B1Columbia CountyHudson, NY220122United StatesUSNew YorkNY36300100130010Hudson, NY22012242N172942.2913888973W4237-73.71027778-05007/1/2011 12:00:00 AMNo data0136021
111001101100111G4Grand Canyon WestPeach Springs, AZ810181United StatesUSArizonaAZ04300110130011Peach Springs, AZ81018135N592535.99027778113W4859-113.81638889-07007/1/2008 12:00:00 AM9/30/2011 12:00:00 AM0004015
121001102100111G4Grand Canyon WestPeach Springs, AZ810181United StatesUSArizonaAZ04300110130011Peach Springs, AZ81018135N591035.98611111113W491-113.81694444-070010/1/2011 12:00:00 AM10/31/2017 12:00:00 AM0004015
131001103100111G4Grand Canyon WestPeach Springs, AZ810181United StatesUSArizonaAZ04300110130011Peach Springs, AZ81018135N592535.99027778113W4859-113.81638889-070011/1/2017 12:00:00 AM11/30/2017 12:00:00 AM0004015
141001104100111G4Grand Canyon WestPeach Springs, AZ810181United StatesUSArizonaAZ04300110130011Peach Springs, AZ81018135N591035.98611111113W491-113.81694444-070012/1/2017 12:00:00 AMNo data0104015
151001201100121N7Blairstown AirportBlairstown, NJ210121United StatesUSNew JerseyNJ34300120130012Blairstown, NJ21012140N581640.9711111174W5951-74.9975-05007/1/2008 12:00:00 AMNo data0134041
161001301100138F3Crosbyton MunicipalCrosbyton, TX740174United StatesUSTexasTX48300130130013Crosbyton, TX74017433N372633.62388889101W1427-101.24083333No data1/1/2009 12:00:00 AMNo data0148107
17100140110014A01Blair LakeFairbanks/Ft. Wainwright, AK1011United StatesUSAlaskaAK02315170131517Fairbanks, AK101164N215164.36416667147W2141-147.36138889No data10/1/2002 12:00:00 AM6/30/2011 12:00:00 AM0002090
18100140210014A01Blair LakeFairbanks/Ft. Wainwright, AK1011United StatesUSAlaskaAK02315170131517Fairbanks, AK101164N214964.36361111147W2150-147.36388889No data7/1/2011 12:00:00 AM6/30/2025 12:00:00 AM0002090
19100140310014A01Blair LakeFairbanks/Ft. Wainwright, AK1011United StatesUSAlaskaAK02315170131517Fairbanks, AK101164N214964.36361111147W2155-147.36527778No data7/1/2025 12:00:00 AMNo data0102090
20100150110015A02Deadmans Bay AirportDeadmans Bay, AK1011United StatesUSAlaskaAK02300150130015Deadmans Bay, AK101157N4057.06666667153W5616-153.93777778No data6/1/2002 12:00:00 AMNo data01No data
21100160110016A03Hallo Bay AirportHallo Bay, AK1011United StatesUSAlaskaAK02300160130016Hallo Bay, AK101158N272758.4575154W124-154.02333333No data4/1/2002 12:00:00 AMNo data01No data
22100170110017A04Red Lake AirportRed Lake, AK1011United StatesUSAlaskaAK02300170130017Red Lake, AK101157N163857.27722222154W2032-154.34222222No data9/1/2002 12:00:00 AMNo data0102150
23100180110018A05Shell Lake AirportShell Lake, AK1011United StatesUSAlaskaAK02300180130018Shell Lake, AK101161N575061.96388889151W3321-151.55583333No data11/1/2002 12:00:00 AMNo data0102170
24100190110019A06Navigator AirstripKougarok, AK1011United StatesUSAlaskaAK02300190130019Kougarok, AK101165N392065.65555556165W2123-165.35638889No data6/1/2002 12:00:00 AMNo data0102180
25100200110020A07Roland Norton Memorial AirstripSelawik, AK1011United StatesUSAlaskaAK02300200130020Selawik, AK101166N455766.76583333160W99-160.1525No data12/1/2002 12:00:00 AM6/30/2011 12:00:00 AM0002188

Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.

See pricing

Source data published by FAA and Bureau of Transportation Statistics. Data Doughnut shows it as published; US states + DC. · Support · Terms · Privacy Policy · What is Data Doughnut?