Skip to content

Registered aircraft · 1,631

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:2018-17-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:2018-17-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:2018-17-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:2018-17-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:2018-17-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:2018-17-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.

N9011PWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5798 N9012American Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5810 N9013AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5827 N9015DUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5327 N9016Umb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6040 N9017PUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6085 N9018EUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6150 N9019FUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6154 N901AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7636 N901AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 11912 N901NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 6833 N9021HUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6277 N9022GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6310 N9023NUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6349 N9025BUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6393 N9026CAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6429 N9029FAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6491 N902AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7519 N902AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 12169 N902NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 6907 N903AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7566 N903AVBank Of Utah Trustee · Salt Lake City, UTS/N 12173 N903JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5783 N903NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7011 N904AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7613 N904AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 12289 N904NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7094 N905AUBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7700 N905AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 12100 N905JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5854 N905NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7334 N906AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7651 N906AVUmb Bank Na Owner Trustee · Salt Lake City, UTBuilt 2025 · S/N 12840 N906NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 7788 N907AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7732 N907JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5865 N908AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7775 N908NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8658 N909AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7756 N910AUWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7876 N910FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 1781 N910NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8668 N912NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 8038 N912UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6264 N913AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 13193 N913JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5909 N913USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6255 N914UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6337 N915NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 7851 N915USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6387

Back to AD 2018-17-21