AD 2025-06-13

Registered aircraft · 139

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
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:2025-06-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:2025-06-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.

N815AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 60305N820ALAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40639N821ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40640N822ANAmerican Airlines Inc · Fort Worth, TXS/N 40642N823ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40641N824ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40643N825AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40644N826ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40649N827ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40647N828AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40648N829ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40651N830ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40650N831AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40652N832AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40638N833AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40645N834AAAmerican Airlines Inc · Fort Worth, TXS/N 40653N835ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40655N836AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40654N837ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40658N838AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40659N839AAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40646N840ANAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 40656N841ANAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 40657N842AAWilmington Trust Company Trustee · Wilmington, DEBuilt 2025 · S/N 66007N843ANWilmington Trust Co Owner Trustee · Wilmington, DEBuilt 2025 · S/N 66008N844MCWilmington Trust Company Trustee · Wilmington, DEBuilt 2025 · S/N 66009N845MDWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 66010N846ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 66011N847MFAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66012N848ANAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66013N849ANAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66018N850ANAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66019N851MKAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66020N852MLAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 66021N853MMBoeing Co · Renton, WAS/N 66028N879CJBoeing Co · Renton, WAS/N 66408N879CMBoeing Co · Renton, WABuilt 2026 · S/N 66874N879PKBoeing Co · Renton, WABuilt 2026 · S/N 62177N91007United Airlines Inc · Chicago, ILBuilt 2017 · S/N 40929
Back to AD 2025-06-13