AD 2000-15-16
Registered aircraft · 1,709
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:2000-15-16')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-15-16')
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:2000-15-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-15-16') 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.
N180DNDelta Air Lines Inc · Atlanta, GAN180FEFederal Express Corp · Memphis, TNN18112United Airlines Inc · Chicago, ILN18119United Airlines Inc · Chicago, ILN181FEFederal Express Corp · Memphis, TNN18220United Airlines Inc · Chicago, ILN18223United Airlines Inc · Chicago, ILN18243United Airlines Inc · Chicago, ILN182ANAersale Inc · Coral Gables, FLN182FEFederal Express Corp · Memphis, TNN183FEFederal Express Corp · Memphis, TNN184FEFederal Express Corp · Memphis, TNN185DNDelta Air Lines Inc · Atlanta, GAN185FEFederal Express Corp · Memphis, TNN186DNDelta Air Lines Inc · Atlanta, GAN186FEFederal Express Corp · Memphis, TNN187DNDelta Air Lines Inc · Atlanta, GAN187FEFederal Express Corp · Memphis, TNN188DNDelta Air Lines Inc · Atlanta, GAN188FEFederal Express Corp · Memphis, TNN188JMKc Aviation Partners LLC · Wilmington, DEN189ANWyatt Aerospace LLC · Chandler, AZN189DNDelta Air Lines Inc · Atlanta, GAN189FEFederal Express Corp · Memphis, TNN1902STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN190AAWyatt Aerospace LLC · Chandler, AZN190DNDelta Air Lines Inc · Atlanta, GAN190FEFederal Express Corp · Memphis, TNN19117United Airlines Inc · Chicago, ILN19130United Airlines Inc · Chicago, ILN19136United Airlines Inc · Chicago, ILN19141United Airlines Inc · Chicago, ILN191ANWyatt Aerospace LLC · Chandler, AZN191DNDelta Air Lines Inc · Atlanta, GAN191FEFederal Express Corp · Memphis, TNN192DNDelta Air Lines Inc · Atlanta, GAN192FEFederal Express Corp · Memphis, TNN193ANWilmington Trust Company Trustee · Wilmington, DEN193DNDelta Air Lines Inc · Atlanta, GAN193FEFederal Express Corp · Memphis, TNN194DNDelta Air Lines Inc · Atlanta, GAN195DNDelta Air Lines Inc · Atlanta, GAN195FEFederal Express Corp · Memphis, TNN196AAWyatt Aerospace LLC · Chandler, AZN196DNDelta Air Lines Inc · Atlanta, GAN196FEFederal Express Corp · Memphis, TNN197DNDelta Air Lines Inc · Atlanta, GAN197FEFederal Express Corp · Memphis, TNN198DNDelta Air Lines Inc · Atlanta, GAN198FEFederal Express Corp · Memphis, TN
Back to AD 2000-15-16