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.

N936NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10316 N937AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10394 N937JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6245 N937NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10330 N938AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 9238 N938NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10402 N939AVAircol 24 · Wilmington, DEBuilt 2011 · S/N 4939 N939NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10450 N940AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11226 N940NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10473 N941FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2483 N941MBUmb Bank Na Trustee · Salt Lake City, UTS/N 0941 N941NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10449 N942AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11283 N942JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6279 N942NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10328 N943AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11459 N943FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2518 N943JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6326 N943NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10563 N944AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4730 N944JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6359 N944NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10545 N945AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4733 N945JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6390 N945NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10594 N946AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4924 N946JLJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6425 N946NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10640 N947JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6448 N947NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10683 N948AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4933 N948JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6560 N948NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10744 N949FRUmb Bank N A Trustee · Salt Lake City, UTBuilt 2006 · S/N 2857 N949JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6575 N949NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 10710 N950AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3545 N950JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6609 N950XVAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7589 N951AVWilmington Trust Company Trustee · Wilmington, DEBuilt 2008 · S/N 3574 N951XVAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7639 N952JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6663 N952NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 10767 N952XVAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7861 N953NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 10686 N953XVAmerican Airlines Inc · Fort Worth, TXBuilt 2018 · S/N 7942 N954AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3699 N954JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6725 N954NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 10697

Back to AD 2018-17-21