FAA NASR Frequency Data

Introduction

The NASR files in FRQ_CSV.zip contain information on radio frequencies used across various facilities in the National Airspace System. This includes frequencies for control towers, ground control, approach/departure control, and other aviation communication services. The data is provided in CSV format for easy parsing and integration. These files are essential for ensuring proper communication between pilots and air traffic control. They are updated regularly to reflect the current frequency assignments and changes.

Data Source Characteristics

Data Target Characteristics

  • Database management system: PostgreSQL

  • Database name: io_xpa_db

  • Database table: io_frq

Data Processing

  • Repository: io-xpa-core

  • Script: run_io_xpa_core_aws

  • Tasks:

    • l_n (Load all files from FAA NASR)

    • l_n_f (Load FRQ 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_FRQ_CSV.zip

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

  3. Update database table io_frq from data file FRQ.csv

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

  5. Create a S3 bucket JSON file with new, modified and deleted data: io_v_airport_delta_io_frq_<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_frq_file = "FRQ.csv"
faa_nasr_frq_url = "https://nfdc.faa.gov/webContent/28DaySub/extra/dd_Mon_yyyy_FRQ_CSV.zip"
faa_nasr_subscription_date = "January 25, 2024"
faa_nasr_timeout = 10
faa_nasr_work_dir = "data/temp"

Contact Information