The Airports dataset includes all official and operational aerodromes as of July 16, 2020 and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Airports database is a geographic point database of official operational aerodromes in the United States and U.S. Territories. Attribute data is provided on the physical and operational characteristics of the aerodrome, current usage including enplanements and aircraft operations, congestion levels and usage categories. This geospatial data is derived from the FAA's National Airspace System Resource Aeronautical Data Product.
This dataset has the following 107 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| the_geom | the_geom | point | {"coordinates":[-77.86055555622181,34.35888888910647],"type":"Point"} {"coordinates":[-96.98501000017477,27.944457499686532],"type":"Point"} {"coordinates":[-86.24582249957729,39.779210000329364],"type":"Point"} {"coordinates":[-106.31641666667711,39.21947222200775],"type":"Point"} {"coordinates":[-106.30946999997492,42.92441000016282],"type":"Point"} view top 100 |
| OBJECTID | objectid | text | 12471 7457 12671 11270 16692 view top 100 |
| Rec_Type | rec_type | text | APT view top 100 |
| Site_Num | site_num | text | 50092.*A 08581.01*A 11727.5*H 17403.6*A 24459.*A view top 100 |
| Fac_Type | fac_type | text | AIRPORT HELIPORT SEAPLANE BASE ULTRALIGHT GLIDERPORT view top 100 |
| Loc_Id | loc_id | text | 0.00E+00 XS33 53XS MU13 K38 view top 100 |
| Eff_Date | eff_date | text | 7/16/2020 view top 100 |
| Region_Cod | region_cod | text | AGL ASW ASO AEA ANM view top 100 |
| Field_Offi | field_offi | text | NONE TEX CHI HAR DET view top 100 |
| State_Post | state_post | text | TX FL CA AK PA view top 100 |
| State_Name | state_name | text | TEXAS FLORIDA CALIFORNIA ALASKA PENNSYLVANIA view top 100 |
| County | county | text | WASHINGTON JEFFERSON MATANUSKA-SUSITNA LOS ANGELES FRANKLIN view top 100 |
| County_Pos | county_pos | text | TX FL CA AK PA view top 100 |
| City | city | text | HOUSTON WASILLA LOS ANGELES COLUMBUS GREENVILLE view top 100 |
| Fac_Name | fac_name | text | MEMORIAL HOSPITAL HILLTOP MILLER SMITH FIELD WILSON view top 100 |
| Owner_Type | owner_type | text | PR PU MR MA MN view top 100 |
| Fac_Use | fac_use | text | PR PU view top 100 |
| Owner_Name | owner_name | text | ALASKA DOT&PF NORTHERN REGION ALASKA DOT&PF CENTRAL REGION ALASKA DOT&PF SOUTHCOAST REGION CENTURYLINK USAF view top 100 |
| Owner_Addr | owner_addr | text | PO BOX 196900 CITY HALL 2301 PEGER RD 9666 METRO AIRPORT AVE 2301 PEGER ROAD view top 100 |
| Owner_City | owner_city | text | FAIRBANKS, AK 99709 ANCHORAGE, AK 99519-6900 FT BELVOIR, VA 22060 BROOMFIELD, CO 80012 WASHINGTON, DC 20373 view top 100 |
| Owner_Phon | owner_phon | text | 907-451-2200 (303) 643-4972 208-334-8775 503-378-4880 (907) 451-5280 view top 100 |
| Manager_Na | manager_na | text | DARREN ALMSKOG COMMANDING OFFICER DAVE GUERRERO C/O SCE AIR OPS SCOTT RANDBY DIV ADMIN view top 100 |
| Manager_Ad | manager_ad | text | 9666 METRO AIRPORT AVE 2301 PEGER RD 7702 TERMINAL STREET SW 3040 25TH ST SE BOX 505 view top 100 |
| Manager_Ci | manager_ci | text | BROOMFIELD, CO 80012 FAIRBANKS, AK 99709 BOISE, ID 83707-1129 WASILLA, AK 99654 BETHEL, AK 99559 view top 100 |
| Manager_Ph | manager_ph | text | (303) 304-9960 208-334-8775 503-378-4880 909-974-4641 (907) 543-2498 view top 100 |
| Ref_Point_ | ref_point_ | text | 40-46-30.0000N 42-35-51.0000N 33-19-18.0000N 38-39-09.0000N 41-42-05.0000N view top 100 |
| Ref_Poin_1 | ref_poin_1 | text | 146790.0000N 119958.0000N 149749.7000N 148958.7000N 122967.7000N view top 100 |
| Ref_Poin_2 | ref_poin_2 | text | 086-56-27.0000W 077-03-27.0000W 088-07-38.9000W 117-51-12.0000W 116-40-04.5000W view top 100 |
| Ref_Poin_3 | ref_poin_3 | text | 424272.0000W 280033.9750W 300219.0000W 269968.6060W 323847.0000W view top 100 |
| Ref_Poin_4 | ref_poin_4 | text | E view top 100 |
| Elevation | elevation | number | 0.0 10.0 800.0 20.0 1000 view top 100 |
| Elevation_ | elevation_ | text | E S view top 100 |
| Mag_Var | mag_var | text | 06E 02W 07E 03W 05E view top 100 |
| Mag_Var_Ye | mag_var_ye | text | 1985 1995 1990 2000 2010 view top 100 |
| Pattern_Al | pattern_al | text | 800 600 1000 700 1200 view top 100 |
| Sectional_ | sectional_ | text | NEW YORK CHICAGO DETROIT DALLAS-FT WORTH WASHINGTON view top 100 |
| Dist_City_ | dist_city_ | text | 3 1 2 0 4 view top 100 |
| Dir_City_T | dir_city_t | text | N NE SW NW SE view top 100 |
| Land_Area_ | land_area_ | text | 1 10 5 20 40 view top 100 |
| Boundary_A | boundary_a | text | ZMP ZHU ZFW ZKC ZAU view top 100 |
| Boundary_1 | boundary_1 | text | ZCP ZCH ZCF ZCK ZCG view top 100 |
| Boundary_2 | boundary_2 | text | MINNEAPOLIS HOUSTON FORT WORTH KANSAS CITY CHICAGO view top 100 |
| Responsibl | responsibl | text | ZMP ZHU ZFW ZAU ZKC view top 100 |
| Responsi_1 | responsi_1 | text | ZCP ZCH ZCF ZCG ZCK view top 100 |
| Responsi_2 | responsi_2 | text | MINNEAPOLIS HOUSTON FORT WORTH CHICAGO KANSAS CITY view top 100 |
| Fss_On_Fac | fss_on_fac | text | N Y view top 100 |
| Fss_Id | fss_id | text | FTW DCA SJT GRB SEA view top 100 |
| Fss_Name | fss_name | text | FORT WORTH LEESBURG SAN ANGELO GREEN BAY SEATTLE view top 100 |
| Local_Phon | local_phon | text | 907-283-7211 703-724-4288 907-474-0788 907-586-7380 LC 443-2291 view top 100 |
| Toll_Free_ | toll_free_ | text | 1-800-WX-BRIEF 1-866-864-1737 1-866-248-6516 1-866-297-2236 1-800-478-8400 view top 100 |
| Alt_Fss_Id | alt_fss_id | text | FAI ENA JNU OTZ view top 100 |
| Alt_Fss_Na | alt_fss_na | text | FAIRBANKS KENAI JUNEAU KOTZEBUE view top 100 |
| Toll_Fre_1 | toll_fre_1 | text | 1-866-248-6516 1-866-864-1737 1-866-297-2236 1-800-478-7460 view top 100 |
| Notam_Wx_F | notam_wx_f | text | FDC LAN FTW ENA BOI view top 100 |
| Notam_DSer | notam_dser | text | N Y view top 100 |
| Activation | activation | text | Apr-40 Feb-87 May-06 Apr-93 Mar-05 view top 100 |
| Status_Cod | status_cod | text | O CI CP view top 100 |
| Arff_Cert_ | arff_cert_ | text | I B S 05/1973 I C S 05/1973 I A S 05/1973 I E S 05/1973 I D S 05/1973 view top 100 |
| Npias_Fed_ | npias_fed_ | text | NGY N NGY3 NGPY NY1 view top 100 |
| Airspace_A | airspace_a | text | CONDITIONAL NO OBJECTION NOT ANALYZED OBJECTIONABLE view top 100 |
| Intl_Custo | intl_custo | text | N Y view top 100 |
| Intl_Cus_1 | intl_cus_1 | text | N Y view top 100 |
| Mil_Joint_ | mil_joint_ | text | N Y view top 100 |
| Mil_Landin | mil_landin | text | Y N view top 100 |
| Inspection | inspection | text | 2 S F C 1 view top 100 |
| Agency_Ins | agency_ins | text | N S C F view top 100 |
| Last_Inspe | last_inspe | text | 6272019 6182019 6192019 6252019 8062019 view top 100 |
| Last_Info_ | last_info_ | text | 1312018 3142019 9072019 5182019 2282018 view top 100 |
| Fuel_Types | fuel_types | text | 100LLA 100LL 100LLA+ A 100LLA1+ view top 100 |
| Repair_Ser | repair_ser | text | NONE MAJOR MINOR view top 100 |
| Power_Plan | power_plan | text | NONE MAJOR MINOR view top 100 |
| Bottled_Ox | bottled_ox | text | NONE HIGH/LOW HIGH LOW view top 100 |
| Bulk_Oxyge | bulk_oxyge | text | NONE HIGH/LOW HIGH LOW view top 100 |
| Lighting_S | lighting_s | text | SEE RMK SS-SR view top 100 |
| Beacon_Lig | beacon_lig | text | SS-SR SEE RMK view top 100 |
| Atc_Tower | atc_tower | text | N Y view top 100 |
| Unicom | unicom | text | 122.8 122.95 122.7 123 123.05 view top 100 |
| Ctaf | ctaf | text | 122.9 122.8 122.7 123 123.05 view top 100 |
| Seg_Circle | seg_circle | text | N Y Y-L view top 100 |
| Beacon_Col | beacon_col | text | CG CGY SCG C CY view top 100 |
| Landing_Fe | landing_fe | text | N Y view top 100 |
| Medical_Fa | medical_fa | text | Y view top 100 |
| Based_Sing | based_sing | text | 1 2 3 0 4 view top 100 |
| Based_Mult | based_mult | text | 0 1 2 3 4 view top 100 |
| Based_Jet_ | based_jet_ | text | 0 1 2 3 4 view top 100 |
| Based_Heli | based_heli | text | 0 1 2 3 4 view top 100 |
| Based_Glid | based_glid | text | 0 1 2 3 4 view top 100 |
| Based_Mili | based_mili | text | 0 1 2 10 8 view top 100 |
| Based_Ultr | based_ultr | text | 0 1 2 3 4 view top 100 |
| Commercial | commercial | text | 0 1 10 4 1460 view top 100 |
| Commuter_O | commuter_o | text | view top 100 |
| Air_Taxi_O | air_taxi_o | text | 0 100 500 200 50 view top 100 |
| Ga_Local_O | ga_local_o | text | 500 1000 100 5000 2000 view top 100 |
| Ga_Itinera | ga_itinera | text | 100 1000 500 200 2000 view top 100 |
| Mitary_Ops | mitary_ops | text | 100 50 10 0 200 view top 100 |
| Annual_Ops | annual_ops | text | 12/31/2018 12/31/2017 12/31/2016 12/31/2019 4/30/2019 view top 100 |
| Position_S | position_s | text | OWNER FAA-EST IMAGERY 3RD PARTY SURVEY FAA-EST FAA view top 100 |
| Position_1 | position_1 | text | 7/9/2007 3/4/2016 2/2/2016 4/25/2007 4/30/2015 view top 100 |
| Elevatio_1 | elevatio_1 | text | OWNER 3RD PARTY SURVEY NGS NACO STATE view top 100 |
| Elevatio_2 | elevatio_2 | text | 10/22/2015 2/9/2012 7/28/2005 3/10/2011 5/17/2002 view top 100 |
| Contract_F | contract_f | text | N Y view top 100 |
| Transient_ | transient_ | text | TIE HGR,TIE HGR BUOY BUOY,TIE view top 100 |
| Other_Serv | other_serv | text | AGRI INSTR,RNTL CARGO INSTR AGRI,INSTR view top 100 |
| Wind_Indic | wind_indic | text | Y Y-L N view top 100 |
| Icao_Ident | icao_ident | text | CYAM CYAZ CYBD CYBL CYCD view top 100 |
| Min_Op_Net | min_op_net | text | N Y view top 100 |
| Filler | filler | text | view top 100 |