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.

N9008UUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5786 N900UWAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7617 N9010RUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5789 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 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 N903AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7566 N903JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5783 N904AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7613 N905AUBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7700 N905JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5854 N906AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7651 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 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 N912UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6264 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 N915USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6387 N916USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6420 N917UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6427 N918USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6443 N919USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6479 N920USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6490 N921USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6523 N922USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6537 N923JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 5960 N923USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6543 N924USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6569 N925UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6613 N926UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6618 N927UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6625 N928AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7515

Back to AD 2017-18-21