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.
N77592Umb Bank Na Trustee · Salt Lake City, UTN77598Umb Bank Na Trustee · Salt Lake City, UTN775FDFederal Express Corp · Memphis, TNN776FDFederal Express Corp · Memphis, TNN777FDFederal Express Corp · Memphis, TNN778FDFederal Express Corp · Memphis, TNN778MAUmb Bank Na Trustee · Salt Lake City, UTN779FDFederal Express Corp · Memphis, TNN78060United Airlines Inc · Chicago, ILN780FDFederal Express Corp · Memphis, TNN781FDFederal Express Corp · Memphis, TNN78285Umb Bank N A Trustee · Salt Lake City, UTN782FDFederal Express Corp · Memphis, TNN7835ASouthwest Airlines Co · Dallas, TXN783AXCargo Aircraft Management Inc · Wilmington, OHN783BABoeing Aircraft Holding Company · Renton, WAN783CKKalitta Air LLC · Ypsilanti, MIN783FDFederal Express Corp · Memphis, TNN783SPKalitta Charters II LLC · Ypsilanti, MIN78438United Airlines Inc · Chicago, ILN7843ABank Of Utah Trustee · Salt Lake City, UTN78448United Airlines Inc · Chicago, ILN7844ABank Of Utah Trustee · Salt Lake City, UTN7847AUmb Bank Na Trustee · Salt Lake City, UTN7848AUmb Bank Na Trustee · Salt Lake City, UTN784FDFederal Express Corp · Memphis, TNN784XASale Reported · CuauhtemocSale reportedN78501United Airlines Inc · Chicago, ILN78506United Airlines Inc · Chicago, ILN78509United Airlines Inc · Chicago, ILN78511United Airlines Inc · Chicago, ILN78524United Airlines Inc · Chicago, ILN78540United Airlines Inc · Chicago, ILN785FDFederal Express Corp · Memphis, TNN786FDFederal Express Corp · Memphis, TNN787CKKalitta Air LLC · Ypsilanti, MIN787FDFederal Express Corp · Memphis, TNN7886ABank Of Utah Trustee · Salt Lake City, UTN7887ABank Of Utah Trustee · Salt Lake City, UTN7888ABank Of Utah Trustee · Salt Lake City, UTN788FDFederal Express Corp · Memphis, TNN788XABank Of Utah Trustee · Salt Lake City, UTN789FDFederal Express Corp · Memphis, TNN790FDFederal Express Corp · Memphis, TNN791FDFederal Express Corp · Memphis, TNN79279United Airlines Inc · Chicago, ILN792FDFederal Express Corp · Memphis, TNN793ACUmb Bank Na Trustee · Salt Lake City, UTN793AXAeroacq Partners LLC · Laud By Sea, FLN793FDFederal Express Corp · Memphis, TN
Back to AD 2018-20-13