About this Dataset

Aviation Facilities

The Aviation Facilities dataset is updated every 28 days from the Federal Aviation Administration (FAA) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Aviation Facilities dataset is a geographic point database of all official and 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. For more information about these data, please visit: https://www.faa.gov/air_traffic/flight_info/aeronav/Aero_Data/NASR_Subscription. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529011
Organization: Federal Geographic Data Committee
Last updated: 2025-06-30T16:04:45.637325
Tags: ngda-fgdc-gda-transportation

Tables

Table 1

@usgov.fgdc_gov_aviation_facilities_fcf79.table_1

2.44 MB
19952 rows
93 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "eff_date" TIMESTAMP,
  "site_no" DOUBLE,
  "site_type_code" VARCHAR,
  "state_code" VARCHAR,
  "arpt_id" VARCHAR,
  "city" VARCHAR,
  "country_code" VARCHAR,
  "region_code" VARCHAR,
  "ado_code" VARCHAR,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "county_assoc_state" VARCHAR,
  "arpt_name" VARCHAR,
  "ownership_type_code" VARCHAR,
  "facility_use_code" VARCHAR,
  "lat_deg" BIGINT,
  "lat_min" BIGINT,
  "lat_sec" DOUBLE,
  "lat_hemis" VARCHAR,
  "lat_decimal" DOUBLE,
  "long_deg" BIGINT,
  "long_min" BIGINT,
  "long_sec" DOUBLE,
  "long_hemis" VARCHAR,
  "long_decimal" DOUBLE,
  "survey_method_code" VARCHAR,
  "elev" DOUBLE,
  "elev_method_code" VARCHAR,
  "mag_varn" DOUBLE,
  "mag_hemis" VARCHAR,
  "mag_varn_year" DOUBLE,
  "tpa" DOUBLE,
  "chart_name" VARCHAR,
  "dist_city_to_airport" DOUBLE,
  "direction_code" VARCHAR,
  "acreage" DOUBLE,
  "resp_artcc_id" VARCHAR,
  "computer_id" VARCHAR,
  "artcc_name" VARCHAR,
  "fss_on_arpt_flag" VARCHAR,
  "fss_id" VARCHAR,
  "fss_name" VARCHAR,
  "phone_no" VARCHAR,
  "toll_free_no" VARCHAR,
  "alt_fss_id" VARCHAR,
  "alt_fss_name" VARCHAR,
  "alt_toll_free_no" VARCHAR,
  "notam_id" VARCHAR,
  "notam_flag" VARCHAR,
  "activation_date" TIMESTAMP,
  "arpt_status" VARCHAR,
  "far_139_type_code" VARCHAR,
  "far_139_carrier_ser_code" VARCHAR,
  "arff_cert_type_date" TIMESTAMP,
  "nasp_code" VARCHAR,
  "asp_anlys_dtrm_code" VARCHAR,
  "cust_flag" VARCHAR,
  "lndg_rights_flag" VARCHAR,
  "joint_use_flag" VARCHAR,
  "mil_lndg_flag" VARCHAR,
  "inspect_method_code" VARCHAR,
  "inspector_code" VARCHAR,
  "last_inspection" TIMESTAMP,
  "last_info_response" TIMESTAMP,
  "fuel_types" VARCHAR,
  "airframe_repair_ser_code" VARCHAR,
  "pwr_plant_repair_ser" VARCHAR,
  "bottled_oxy_type" VARCHAR,
  "bulk_oxy_type" VARCHAR,
  "lgt_sked" VARCHAR,
  "bcn_lgt_sked" VARCHAR,
  "twr_type_code" VARCHAR,
  "seg_circle_mkr_flag" VARCHAR,
  "bcn_lens_color" VARCHAR,
  "lndg_fee_flag" VARCHAR,
  "medical_use_flag" VARCHAR,
  "arpt_psn_source" VARCHAR,
  "position_src_date" VARCHAR,
  "arpt_elev_source" VARCHAR,
  "elevation_src_date" VARCHAR,
  "contr_fuel_avbl" VARCHAR,
  "trns_strg_buoy_flag" VARCHAR,
  "trns_strg_hgr_flag" VARCHAR,
  "trns_strg_tie_flag" VARCHAR,
  "other_services" VARCHAR,
  "wind_indcr_flag" VARCHAR,
  "icao_id" VARCHAR,
  "min_op_network" VARCHAR,
  "user_fee_flag" VARCHAR,
  "cta" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);