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.
N674DLDelta Air Lines Inc · Atlanta, GAN674UAUnited Airlines Inc · Chicago, ILN67501United Airlines Inc · Chicago, ILN675UAUnited Airlines Inc · Chicago, ILN67603Boeing Co · Renton, WAN676DLDelta Air Lines Inc · Atlanta, GAN676UAUnited Airlines Inc · Chicago, ILN677UAUnited Airlines Inc · Chicago, ILN67812United Airlines Inc · Chicago, ILN67815United Airlines Inc · Chicago, ILN67827United Airlines Inc · Chicago, ILN67845United Airlines Inc · Chicago, ILN67846United Airlines Inc · Chicago, ILN678DLDelta Air Lines Inc · Atlanta, GAN68061United Airlines Inc · Chicago, ILN68084Federal Express Corp · Memphis, TNN68085Federal Express Corp · Memphis, TNN68087Federal Express Corp · Memphis, TNN681AABank Of Utah Trustee · Salt Lake City, UTN682DADelta Air Lines Inc · Atlanta, GAFirst renewal noticeN683AZAmazon.Com Services LLC · Seattle, WAN683DADelta Air Lines Inc · Atlanta, GAN68452United Airlines Inc · Chicago, ILN68453United Airlines Inc · Chicago, ILN684DADelta Air Lines Inc · Atlanta, GAN685DADelta Air Lines Inc · Atlanta, GAN686AABank Of Utah Trustee · Salt Lake City, UTN686DADelta Air Lines Inc · Atlanta, GAN687DLDelta Air Lines Inc · Atlanta, GAN68801United Airlines Inc · Chicago, ILN68802United Airlines Inc · Chicago, ILN68805United Airlines Inc · Chicago, ILN68807United Airlines Inc · Chicago, ILN68811United Airlines Inc · Chicago, ILN68817United Airlines Inc · Chicago, ILN68821United Airlines Inc · Chicago, ILN68822United Airlines Inc · Chicago, ILN68823United Airlines Inc · Chicago, ILN68834United Airlines Inc · Chicago, ILN68836United Airlines Inc · Chicago, ILN68842United Airlines Inc · Chicago, ILN68843United Airlines Inc · Chicago, ILN68880United Airlines Inc · Chicago, ILN68891United Airlines Inc · Chicago, ILN688DLDelta Air Lines Inc · Atlanta, GAN688SLAero Micronesia Inc DBA · Barrigada, GUN689DLDelta Air Lines Inc · Atlanta, GAN69059United Airlines Inc · Chicago, ILN69063United Airlines Inc · Chicago, ILN690DLDelta Air Lines Inc · Atlanta, GA
Back to AD 2018-20-13