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.
N828MHDelta Air Lines Inc · Atlanta, GAN829DNDelta Air Lines Inc · Atlanta, GAN829MHDelta Air Lines Inc · Atlanta, GAN829NNAmerican Airlines Inc · Fort Worth, TXN830DNDelta Air Lines Inc · Atlanta, GAN830MHDelta Air Lines Inc · Atlanta, GAN830NNAmerican Airlines Inc · Fort Worth, TXN831DNDelta Air Lines Inc · Atlanta, GAN831MHDelta Air Lines Inc · Atlanta, GAN831NNAmerican Airlines Inc · Fort Worth, TXN832DNDelta Air Lines Inc · Atlanta, GAN832MHDelta Air Lines Inc · Atlanta, GAN832NNAmerican Airlines Inc · Fort Worth, TXN833DNDelta Air Lines Inc · Atlanta, GAN833MHDelta Air Lines Inc · Atlanta, GAN833NNAmerican Airlines Inc · Fort Worth, TXN834ASAersale Inc · Coral Gables, FLN834DNDelta Air Lines Inc · Atlanta, GAN834MHDelta Air Lines Inc · Atlanta, GAN834NNAmerican Airlines Inc · Fort Worth, TXN835DNDelta Air Lines Inc · Atlanta, GAN835MHDelta Air Lines Inc · Atlanta, GAN835NNBank Of Utah Trustee · Salt Lake City, UTN836DNDelta Air Lines Inc · Atlanta, GAN836MHDelta Air Lines Inc · Atlanta, GAN836NNWilmington Trust Co Trustee · Wilmington, DEN837AMAlc B379 65190 LLC · Los Angeles, CAN837DNDelta Air Lines Inc · Atlanta, GAN837MHDelta Air Lines Inc · Atlanta, GAN837NNWilmington Trust Co Trustee · Wilmington, DEN838AKAlaska Airlines Inc · Seatac, WAN838AMAlc B379 43392 LLC · Los Angeles, CAN838DNDelta Air Lines Inc · Atlanta, GAN838MHDelta Air Lines Inc · Atlanta, GAN838NNWilmington Trust Co Trustee · Wilmington, DEN839AKAlaska Airlines Inc · Seattle, WAN839DNDelta Air Lines Inc · Atlanta, GAN839MHDelta Air Lines Inc · Atlanta, GAN839NNWilmington Trust Co Trustee · Wilmington, DEN839SYBank Of Utah Trustee · Salt Lake City, UTN840DNDelta Air Lines Inc · Atlanta, GAN840MHDelta Air Lines Inc · Atlanta, GAN840NNWilmington Trust Co Trustee · Wilmington, DEN840SYBank Of Utah Trustee · Salt Lake City, UTN841DNDelta Air Lines Inc · Atlanta, GAN841MHDelta Air Lines Inc · Atlanta, GAN841NNWilmington Trust Co Trustee · Wilmington, DEN842AKAlaska Airlines Inc · Seattle, WAN842DNDelta Air Lines Inc · Atlanta, GAN842MHDelta Air Lines Inc · Atlanta, GA
Back to AD 2018-20-13