Skip to content

Registered aircraft · 2,770

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-20-13') 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-20-13') 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-20-13')
    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-20-13')
  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-20-13')
  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-20-13')
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.

N260ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 33597 N260AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36349 N260FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67533 N261FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67532 N26208United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30580 N26210United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28770 N26215United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28775 N26226United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28935 N26232United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28942 N262FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67531 N263AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 62471 N263FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67530 N264AKAlaska Airlines Inc · Seatac, WABuilt 2016 · S/N 36360 N264FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66869 N265AKAlaska Airlines Inc · Seatac, WABuilt 2016 · S/N 62682 N265FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66868 N266AKAlaska Airlines Inc · Seatac, WABuilt 2016 · S/N 62683 N266FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66867 N267AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 60581 N267FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66866 N267JRKnight Sky II LLC · Miami, FLBuilt 1986 · S/N 23402 N268AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 36365 N268FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66865 N269CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 25586 N269FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66864 N270AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 44111 N270FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66249 N271CMCargo Aircraft Management Inc · Wilmington, OHS/N 22319 N271FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66250 N271LVSouthwest Airlines Co · Dallas, TXS/N 29090 N27205United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30577 N27213United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28773 N27239United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28951 N27246United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28956 N27251Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 43931 N27252Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 43932 N27253Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 43930 N27255Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 43440 N27256Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 64447 N27258Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 66593 N27260Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 43458 N27261Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 43464 N27263Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 66595 N27266Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 66597 N27267United Airlines Inc · Chicago, ILBuilt 2022 · S/N 67522 N27268United Airlines Inc · Chicago, ILBuilt 2022 · S/N 67523 N27269United Airlines Inc · Chicago, ILBuilt 2022 · S/N 67524 N27270United Airlines Inc · Chicago, ILBuilt 2022 · S/N 67525 N27271United Airlines Inc · Chicago, ILBuilt 2022 · S/N 67526 N27273United Airlines Inc · Chicago, ILBuilt 2022 · S/N 67528

Back to AD 2018-20-13