Skip to content

Registered aircraft · 1,370

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:2017-18-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:2017-18-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:2017-18-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:2017-18-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:2017-18-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:2017-18-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.

N966ADBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1966 N966ASUmb Bank Na Trustee · Salt Lake City, UTS/N 1241 N966JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7230 N967JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7257 N968JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7305 N969JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7353 N970JBJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7415 N970UYAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3924 N971JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7390 N971UYAmerican Airlines Inc · Fort Worth, TXS/N 6249 N972JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7455 N972UYAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4123 N973JTJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8581 N973UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4893 N974JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7448 N974UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4898 N975JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7520 N975UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4935 N976JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7529 N976UYUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5235 N977JEJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8641 N977UYAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5409 N978JBJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7584 N978UYAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5422 N979JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7627 N979UYAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5763 N980AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3980 N980JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7631 N980UYAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5795 N981JTJetblue Airways Corporation · Long Island City, NYBuilt 2017 · S/N 7692 N981UYAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5800 N982JBJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7815 N982VJAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5374 N983JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7739 N984CMCargo Aircraft Management Inc · Wilmington, OHS/N 03274 N984JBJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7874 N985CMCargo Aircraft Management Inc · Wilmington, OHS/N 1928 N985JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7798 N986ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7046 N986JBJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7907 N987AMAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7079 N987JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7855 N988ALAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7154 N988JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7956 N989AUAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7307 N989CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 1807 N989JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7924 N990AUAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7336 N990CMCargo Aircraft Management Inc · Wilmington, OHS/N 1848 N990JLJetblue Airways Corporation · Long Island City, NYBuilt 2017 · S/N 7993

Back to AD 2017-18-21