Skip to content

Registered aircraft · 878

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2020-07-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-07-21') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2020-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-07-21')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2020-07-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-07-21')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N269NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000774 N269SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000727 N270NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000775 N270SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000728 N271NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000776 N271SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000729 N272NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000777 N272SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000734 N273JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 19000073 N273NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000778 N273SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000735 N274NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000779 N274SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000736 N275NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000780 N275SYSkywest Airlines Inc · Saint George, UTBuilt 2018 · S/N 17000737 N276NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000781 N276SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000740 N277NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000783 N277SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000741 N278NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000784 N278SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000742 N279JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000090 N279MQAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000788 N279SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000743 N280NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000800 N280SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000745 N281JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000103 N281NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000801 N281SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000746 N282NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000810 N282SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000747 N283JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000125 N283NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000818 N283SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000748 N284JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 19000144 N284JNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000822 N284SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000750 N285NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000823 N285SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000751 N286NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000827 N286SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000752 N287NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000828 N287SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000753 N288NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000829 N288SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000754 N289MWAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 17000840 N289SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000756 N290NNAmerican Airlines Inc · Fort Worth, TXBuilt 2020 · S/N 17000841 N290SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000758 N291NNAmerican Airlines Inc · Fort Worth, TXBuilt 2020 · S/N 17000842

Back to AD 2020-07-21