FAA Aircraft Registration¶

Introduction¶

Releasable Aircraft Database Download.

Data Source Characteristics¶

Data files: ReleasableAircraft.zip
Format: zip
Size: about 60 MB
Update frequency: Daily at 11:30 pm central time.
URL: Download the Aircraft Registration Database (60MB))
Website hint: see Aircraft Registration

Data Target Characteristics¶

Database management system: PostgreSQL
Database name: io_xpa_db
Database tables:
- io_aircraft_reference
- io_aircraft_registration
- io_engine_reference

Data Processing¶

Repository: io-xpa-core
Script: run_io_xpa_core_aws
Task: l_a_r (Load aircraft registration data)

Processing Steps:¶

Download zip file from Download the Aircraft Registration Database (60MB))
Unzip the file and store the data files in a temporary directory
Update database table io_aircraft_reference from data file ACFTREF.txt
Update database table io_engine_reference from data file ENGINE.csv
Update database table io_aircraft_registration from data file MASTER.txt

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

Configuration Parameters:¶

faa_aircraft_registration_aircraft_reference = "ACFTREF.txt"
faa_aircraft_registration_aircraft_registration = "MASTER.txt"
faa_aircraft_registration_engine_reference = "ENGINE.txt"
faa_aircraft_registration_timeout = 10
faa_aircraft_registration_url = "https://registry.faa.gov/database/ReleasableAircraft.zip"
faa_aircraft_registration_work_dir = "data/temp"

Contact Information¶

Email: 9-AMC-AFS705-WebAdmin@faa.gov