AD 2017-19-05
Registered aircraft · 1,080
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:2017-19-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-19-05')
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:2017-19-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-19-05') 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.
N1604RDelta Air Lines Inc · Atlanta, GAN1605Delta Air Lines Inc · Atlanta, GAN16065Delta Air Lines Inc · Atlanta, GAN160FEFederal Express Corp · Memphis, TNN161FEFederal Express Corp · Memphis, TNN162FEFederal Express Corp · Memphis, TNN163FEFederal Express Corp · Memphis, TNN164FEFederal Express Corp · Memphis, TNN165FEFederal Express Corp · Memphis, TNN166FEFederal Express Corp · Memphis, TNN167FEFederal Express Corp · Memphis, TNN168FEFederal Express Corp · Memphis, TNN168SW8075 LLC · Wilmington, DEN169DZDelta Air Lines Inc · Atlanta, GAN169FEFederal Express Corp · Memphis, TNN1709AAndromeda Leasing I LLC · Purchase, NYN170FEFederal Express Corp · Memphis, TNN17156Bank Of Utah Trustee · Salt Lake City, UTN171DNDelta Air Lines Inc · Atlanta, GAN171DZDelta Air Lines Inc · Atlanta, GAN17217Wells Fargo Trust Co Na Trustee · Salt Lake City, UTN172DNDelta Air Lines Inc · Atlanta, GAN172DZDelta Air Lines Inc · Atlanta, GAN172FEFederal Express Corp · Memphis, TNN173DZDelta Air Lines Inc · Atlanta, GAN173FEFederal Express Corp · Memphis, TNN174DNDelta Air Lines Inc · Atlanta, GAN174DZDelta Air Lines Inc · Atlanta, GAN174FEFederal Express Corp · Memphis, TNN175DNDelta Air Lines Inc · Atlanta, GAN175DZDelta Air Lines Inc · Atlanta, GAN175FEFederal Express Corp · Memphis, TNN176DZDelta Air Lines Inc · Atlanta, GAN176FEFederal Express Corp · Memphis, TNN177DNDelta Air Lines Inc · Atlanta, GAN177DZDelta Air Lines Inc · Atlanta, GAN177FEFederal Express Corp · Memphis, TNN178DNDelta Air Lines Inc · Atlanta, GAN178DZDelta Air Lines Inc · Atlanta, GAN178FEFederal Express Corp · Memphis, TNN179DNDelta Air Lines Inc · Atlanta, GAN179FEFederal Express Corp · Memphis, TNN1800CGazillion Air LLC · Chapin, SCN180DNDelta Air Lines Inc · Atlanta, GAN180FEFederal Express Corp · Memphis, TNN181FEFederal Express Corp · Memphis, TNN182FEFederal Express Corp · Memphis, TNN183FEFederal Express Corp · Memphis, TNN184FEFederal Express Corp · Memphis, TNN185DNDelta Air Lines Inc · Atlanta, GA
Back to AD 2017-19-05