AD 2018-20-13
Registered aircraft · 2,770
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:2018-20-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:2018-20-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.
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:2018-20-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:2018-20-13') 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.
N8744BUmb Bank Na Trustee · Salt Lake City, UTN8745KUmb Bank Na Trustee · Salt Lake City, UTN8746QUmb Bank Na Trustee · Salt Lake City, UTN8747QUmb Bank Na Trustee · Salt Lake City, UTN8748QUmb Bank Na Trustee · Salt Lake City, UTN8749QUmb Bank Na Trustee · Salt Lake City, UTN874DNDelta Air Lines Inc · Atlanta, GAN874NNBank Of Utah Trustee · Salt Lake City, UTN874TWUnited States Government · Washington, DCN87507United Airlines Inc · Chicago, ILN8750QUmb Bank Na Trustee · Salt Lake City, UTN87512United Airlines Inc · Chicago, ILN87513United Airlines Inc · Chicago, ILN8751RUmb Bank Na Trustee · Salt Lake City, UTN87527United Airlines Inc · Chicago, ILN8752QSouthwest Airlines Co · Dallas, TXN87531United Airlines Inc · Chicago, ILN8753QSouthwest Airlines Co · Dallas, TXN8754SSouthwest Airlines Co · Dallas, TXN8755LSouthwest Airlines Co · Dallas, TXN8756SSouthwest Airlines Co · Dallas, TXN8757LSouthwest Airlines Co · Dallas, TXN8758LSouthwest Airlines Co · Dallas, TXN8759QSouthwest Airlines Co · Dallas, TXN875AMWells Fargo Trust Co Na Trustee · Columbia, MDN875DNDelta Air Lines Inc · Atlanta, GAN875NNWilmington Trust Co Trustee · Wilmington, DEN8760LSouthwest Airlines Co · Dallas, TXN8761LSouthwest Airlines Co · Dallas, TXN8762QSouthwest Airlines Co · Dallas, TXN8763LSouthwest Airlines Co · Dallas, TXN8764QSouthwest Airlines Co · Dallas, TXN8765QSouthwest Airlines Co · Dallas, TXN8766TSouthwest Airlines Co · Dallas, TXN8767MSouthwest Airlines Co · Dallas, TXN8768QSouthwest Airlines Co · Dallas, TXN8769QSouthwest Airlines Co · Dallas, TXN876DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeN876NNWilmington Trust Co Trustee · Wilmington, DEN8770QSouthwest Airlines Co · Dallas, TXN8771DSouthwest Airlines Co · Dallas, TXN8772MSouthwest Airlines Co · Dallas, TXN8773QSouthwest Airlines Co · Dallas, TXN8774QSouthwest Airlines Co · Dallas, TXN8775QSouthwest Airlines Co · Dallas, TXN8776LSouthwest Airlines Co · Dallas, TXN8777QSouthwest Airlines Co · Dallas, TXN8778QSouthwest Airlines Co · Dallas, TXN8779QSouthwest Airlines Co · Dallas, TXN877DNDelta Air Lines Inc · Atlanta, GAFirst renewal notice
Back to AD 2018-20-13