AD 2022-11-13
Registered aircraft · 1,119
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:2022-11-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:2022-11-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:2022-11-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:2022-11-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.
N372DADelta Air Lines Inc · Atlanta, GAN3730BDelta Air Lines Inc · Atlanta, GAN3731TDelta Air Lines Inc · Atlanta, GAN3732JDelta Air Lines Inc · Atlanta, GAN3733ZDelta Air Lines Inc · Atlanta, GAN3734BDelta Air Lines Inc · Atlanta, GAN3735DDelta Air Lines Inc · Atlanta, GAN3736CDelta Air Lines Inc · Atlanta, GAN3737CDelta Air Lines Inc · Atlanta, GAN3738BDelta Air Lines Inc · Atlanta, GAN3739PDelta Air Lines Inc · Atlanta, GAN373DADelta Air Lines Inc · Atlanta, GAN3740CDelta Air Lines Inc · Atlanta, GAN37413United Airlines Inc · Chicago, ILN37419United Airlines Inc · Chicago, ILN3741SDelta Air Lines Inc · Atlanta, GAN37420United Airlines Inc · Chicago, ILN37422United Airlines Inc · Chicago, ILN37427United Airlines Inc · Chicago, ILN3742CDelta Air Lines Inc · Atlanta, GAN37434United Airlines Inc · Chicago, ILN37437United Airlines Inc · Chicago, ILN3743HDelta Air Lines Inc · Atlanta, GAN3744FDelta Air Lines Inc · Atlanta, GAN37456United Airlines Inc · Chicago, ILN3745BDelta Air Lines Inc · Atlanta, GAN37462United Airlines Inc · Chicago, ILN37464United Airlines Inc · Chicago, ILN37465United Airlines Inc · Chicago, ILN37466United Airlines Inc · Chicago, ILN37468United Airlines Inc · Chicago, ILN3746HDelta Air Lines Inc · Atlanta, GAN37470United Airlines Inc · Chicago, ILN37471United Airlines Inc · Chicago, ILN37474United Airlines Inc · Chicago, ILN3747DDelta Air Lines Inc · Atlanta, GAN3748YDelta Air Lines Inc · Atlanta, GAN3749DDelta Air Lines Inc · Atlanta, GAN374DADelta Air Lines Inc · Atlanta, GAN3750DDelta Air Lines Inc · Atlanta, GAN3751BDelta Air Lines Inc · Atlanta, GAN3752Delta Air Lines Inc · Atlanta, GAN3753Delta Air Lines Inc · Atlanta, GAN3754ADelta Air Lines Inc · Atlanta, GAN3755DDelta Air Lines Inc · Atlanta, GAN3756Delta Air Lines Inc · Atlanta, GAN3757DDelta Air Lines Inc · Atlanta, GAN3758YDelta Air Lines Inc · Atlanta, GAN3759Delta Air Lines Inc · Atlanta, GAN375DADelta Air Lines Inc · Atlanta, GA
Back to AD 2022-11-13