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.
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
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.
N782HAAlaska Airlines Inc · Seattle, WAN783AMWilmington Trust Co Trustee · Wilmington, DEN783HAHawaiian Airlines Inc · Seattle, WAN784HAHawaiian Airlines Inc · Seattle, WAN800ANAmerican Airlines Inc · Fort Worth, TXN801ACAmerican Airlines Inc · Fort Worth, TXN802ANAmerican Airlines Inc · Fort Worth, TXN803ALAmerican Airlines Inc · Fort Worth, TXN804ANAmerican Airlines Inc · Fort Worth, TXN805ANAmerican Airlines Inc · Fort Worth, TXN807AAAmerican Airlines Inc · Fort Worth, TXN808ANAmerican Airlines Inc · Fort Worth, TXN809AAAmerican Airlines Inc · Fort Worth, TXN810ANAmerican Airlines Inc · Fort Worth, TXN811ABAmerican Airlines Inc · Fort Worth, TXN812AAAmerican Airlines Inc · Fort Worth, TXN813ANAmerican Airlines Inc · Fort Worth, TXN814AAAmerican Airlines Inc · Fort Worth, TXN815AAAmerican Airlines Inc · Fort Worth, TXN816AAAmerican Airlines Inc · Fort Worth, TXN817ANAmerican Airlines Inc · Fort Worth, TXN818ALAmerican Airlines Inc · Fort Worth, TXN819ANAmerican Airlines Inc · Fort Worth, TXN820ALAmerican Airlines Inc · Fort Worth, TXN821ANAmerican Airlines Inc · Fort Worth, TXN823ANAmerican Airlines Inc · Fort Worth, TXN824ANAmerican Airlines Inc · Fort Worth, TXN825AAAmerican Airlines Inc · Fort Worth, TXN826ANAmerican Airlines Inc · Fort Worth, TXN827ANAmerican Airlines Inc · Fort Worth, TXN828AAAmerican Airlines Inc · Fort Worth, TXN829ANAmerican Airlines Inc · Fort Worth, TXN830ANAmerican Airlines Inc · Fort Worth, TXN831AAAmerican Airlines Inc · Fort Worth, TXN832AAAmerican Airlines Inc · Fort Worth, TXN833AAAmerican Airlines Inc · Fort Worth, TXN835ANWilmington Trust Co Trustee · Wilmington, DEN836AAWilmington Trust Co Trustee · Wilmington, DEN837ANWilmington Trust Co Trustee · Wilmington, DEN838AAWilmington Trust Co Trustee · Wilmington, DEN839AAWilmington Trust Co Trustee · Wilmington, DEN840ANAmerican Airlines Inc · Fort Worth, TXN841ANAmerican Airlines Inc · Fort Worth, TXN842AAWilmington Trust Company Trustee · Wilmington, DEN843ANWilmington Trust Co Owner Trustee · Wilmington, DEN844MCWilmington Trust Company Trustee · Wilmington, DEN845MDWilmington Trust Co Trustee · Wilmington, DEN846ANWilmington Trust Co Trustee · Wilmington, DEN847MFAmerican Airlines Inc · Fort Worth, TXN848ANAmerican Airlines Inc · Fort Worth, TX
Back to AD 2017-26-01