AD 2017-26-01

Registered aircraft · 124

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:2017-26-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-26-01')
  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.

N782HAAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 66430N783AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 37167N783HAHawaiian Airlines Inc · Seattle, WABuilt 2025 · S/N 66431N784HAHawaiian Airlines Inc · Seattle, WABuilt 2025 · S/N 66432N800ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40618N801ACAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40619N802ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40620N803ALAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40621N804ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40622N805ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40623N807AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40625N808ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40626N809AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40627N810ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40628N811ABAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40629N812AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40630N813ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40631N814AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40632N815AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40633N816AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40634N817ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40635N818ALAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40636N819ANAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40637N820ALAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40639N821ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40640N823ANAmerican 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 40645N835ANWilmington 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 66013
Back to AD 2017-26-01