FAA NASR Airports

Introduction

The NASR (National Airspace System Resources) files in APT_CSV.zip provide comprehensive airport data, including information about airport facilities, runway details, frequencies, and services. These files are part of the FAA’s effort to provide accurate and up-to-date information for the aviation industry. The data is in CSV format, making it easy to integrate into various applications. Key files typically include information on airport identifiers, physical attributes, and operational data. These files are updated regularly to reflect changes in the national airspace system.

Data Source Characteristics

Data Target Characteristics

  • Database management system: PostgreSQL

  • Database name: io_xpa_db

  • Database tables:

    • io_apt_base

    • io_apt_rwy

    • io_apt_rwy_end

Data Processing

  • Repository: io-xpa-core

  • Script: run_io_xpa_core_aws

  • Tasks:

    • l_n (Load all files from FAA NASR)

    • l_n_a (Load APT csv files from FAA NASR)

Processing Steps:

  1. Download zip file from an url like https://nfdc.faa.gov/webContent/28DaySub/extra/dd_Mon_yyyy_APT_CSV.zip

  2. Unzip the file and store the data files in a temporary directory

  3. Update database table io_apt_base from data file APT_BASE.csv

  4. Create a S3 bucket JSON file with new, modified and deleted data: io_v_airport_delta_io_apt_base_<yyyy-mm-ddThh:mi:ss.mseZ>.json.gz

  5. Update database table io_apt_rwy from data file APT_RWY.csv

  6. Create a S3 bucket JSON file with new, modified and deleted data: io_v_airport_delta_io_apt_rwy_<yyyy-mm-ddThh:mi:ss.mseZ>.json.gz

  7. Update database table io_apt_rwy_end from data file APT_RWY_END.csv

  8. Create a S3 bucket JSON file with all data: io_v_airport_full_<yyyy-mm-ddThh:mi:ss.mseZ>.json.gz

  9. Create a S3 bucket JSON file with new, modified and deleted data: io_v_airport_delta_io_apt_rwy_end_<yyyy-mm-ddThh:mi:ss.mseZ>.json.gz

For detailed processing steps, refer to the external repository: io-xpa-core

Configuration Parameters:

faa_nasr_airport_aws_region = "us-east-2"
faa_nasr_airport_json_file = "io_v_airport"
faa_nasr_airport_s3_bucket = "n/a"
faa_nasr_apt_file_base = "APT_BASE.csv"
faa_nasr_apt_file_rwy = "APT_RWY.csv"
faa_nasr_apt_file_rwy_end = "APT_RWY_END.csv"
faa_nasr_apt_url = "https://nfdc.faa.gov/webContent/28DaySub/extra/dd_Mon_yyyy_APT_CSV.zip"
faa_nasr_subscription_date = "January 25, 2024"
faa_nasr_timeout = 10
faa_nasr_work_dir = "data/temp"

Contact Information