Skip to content

Registered aircraft · 193

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:2021-23-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:2021-23-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:2021-23-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:2021-23-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:2021-23-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:2021-23-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.

N836AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40654 N837ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40658 N838AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40659 N839AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40646 N840ANAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 40656 N841ANAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 40657 N842AAWilmington Trust Company Trustee · Wilmington, DEBuilt 2025 · S/N 66007 N843ANWilmington Trust Co Owner Trustee · Wilmington, DEBuilt 2025 · S/N 66008 N844MCWilmington Trust Company Trustee · Wilmington, DEBuilt 2025 · S/N 66009 N845MDWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 66010 N846ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 66011 N847MFAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66012 N848ANAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66013 N849ANAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66018 N850ANAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66019 N851MKAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66020 N852MLAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66021 N853MMBoeing Co · Renton, WAS/N 66028 N870AXWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 65990 N871AYWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 65991 N872ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 65992 N873BBWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 65993 N874ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 65994 N875BDWimington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 65995 N876ALWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 65996 N877BFWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 65997 N878BGWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 65998 N879BHWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 65999 N879CJBoeing Co · Renton, WAS/N 66408 N879CMBoeing Co · Renton, WABuilt 2026 · S/N 66874 N879PKBoeing Co · Renton, WABuilt 2026 · S/N 62177 N880BJWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 66000 N881BKWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 66001 N882BLWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 66002 N883BMWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 66003 N884AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 66004 N885BPWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 66005 N886BRWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 66006 N947BABank Of Utah Trustee · Salt Lake City, UTS/N 35507 N964AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 35307 N965AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 35308 N966AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 35311 N967AMWilmington Trust Co Trustee · Wilmington, DEFirst renewal noticeBuilt 2014 · S/N 35312

Back to AD 2021-23-21