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.

N793AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 37511 N794AVWells Fargo Trust Co Na Trustee · Columbia, MDFirst renewal noticeBuilt 2017 · S/N 39406 N795AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 39407 N796AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 65315 N798AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 34795 N799AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 34796 N800ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40618 N800AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 36526 N801ACAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40619 N802ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40620 N803ALAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40621 N804ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40622 N805ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40623 N806AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40624 N807AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40625 N808ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40626 N809AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40627 N810ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40628 N81105United Airlines Inc · Chicago, ILBuilt 2026 · S/N 68651 N81107United Airlines Inc · Chicago, ILBuilt 2026 · S/N 68653 N81110United Airlines Inc · Chicago, ILBuilt 2026 · S/N 68656 N81113United Airlines Inc · Chicago, ILBuilt 2026 · S/N 68658 N81116United Airlines Inc · Chicago, ILS/N 68660 N81119Boeing Co · Renton, WAS/N 68678 N811ABAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40629 N812AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40630 N813ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40631 N814AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40632 N815AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40633 N815AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 60305 N816AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40634 N817ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40635 N818ALAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40636 N819ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40637 N820ALAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40639 N821ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40640 N822ANAmerican Airlines Inc · Fort Worth, TXS/N 40642 N823ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40641 N824ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40643 N825AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40644 N826ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40649 N827ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40647 N828AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40648 N829ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40651 N830ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40650 N831AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40652 N832AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40638 N833AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40645 N834AAAmerican Airlines Inc · Fort Worth, TXS/N 40653 N835ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40655

Back to AD 2021-23-21