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.
N344PPWilmington Trust Co Trustee · Wilmington, DEN344TSAmerican Airlines Inc · Fort Worth, TXN346PRWilmington Trust Co Trustee · Wilmington, DEN347AZCargo Aircraft Management Inc · Wilmington, OHN347CMCargo Aircraft Management Inc · Wilmington, OHN347TTAmerican Airlines Inc · Fort Worth, TXN348TUAmerican Airlines Inc · Fort Worth, TXN349CMCargo Aircraft Management Inc · Wilmington, OHN349TVAmerican Airlines Inc · Fort Worth, TXN350RVWilmington Trust Co Trustee · Wilmington, DEN3518JJetran LLC · Horseshoe Bay, TXN351CMCargo Aircraft Management Inc · Wilmington, OHN35204United Airlines Inc · Chicago, ILN35236United Airlines Inc · Chicago, ILN35260United Airlines Inc · Chicago, ILN35271United Airlines Inc · Chicago, ILN352PSWilmington Trust Co Trustee · Wilmington, DEN353AZCargo Aircraft Management Inc · Wilmington, OHN35407United Airlines Inc · Chicago, ILN354PTAmerican Airlines Inc · Fort Worth, TXN355PUAmerican Airlines Inc · Fort Worth, TXN355TWAmerican Airlines Inc · Fort Worth, TXN356TXAmerican Airlines Inc · Fort Worth, TXN357PVWilmington Trust Co Trustee · Wilmington, DEN357TYAmerican Airlines Inc · Fort Worth, TXN358PWWilmington Trust Co Trustee · Wilmington, DEN359AZCargo Aircraft Management Inc · Wilmington, OHN359PXAmerican Airlines Inc · Fort Worth, TXN36207United Airlines Inc · Chicago, ILN36247United Airlines Inc · Chicago, ILN36272United Airlines Inc · Chicago, ILN36280United Airlines Inc · Chicago, ILN362CMCargo Aircraft Management Inc · Wilmington, OHN362UPUnited Parcel Service Co · Louisville, KYN363CMCargo Aircraft Management Inc · Wilmington, OHN363UPUnited Parcel Service Co · Louisville, KYN36444United Airlines Inc · Chicago, ILN36447United Airlines Inc · Chicago, ILN36469United Airlines Inc · Chicago, ILN36472United Airlines Inc · Chicago, ILN36476United Airlines Inc · Chicago, ILN364CMCargo Aircraft Management Inc · Wilmington, OHN364UPUnited Parcel Service Co · Louisville, KYN365UPCc & E I LLC · Louisville, KYN366UPC C & E I LLC · Louisville, KYN367AZCargo Aircraft Management Inc · Wilmington, OHN367SPSamaritan'S Purse · Boone, NCN367UPC C & E I LLC · Louisville, KYN368AMBank Of Utah Trustee · Salt Lake City, UTN368UPC C & E I LLC · Louisville, KY
Back to AD 2018-20-13