AD 2007-19-13
Registered aircraft · 2,446
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:2007-19-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:2007-19-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:2007-19-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:2007-19-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.
N715JBJetblue Airways Corp · Long Island City, NYN716FRWells Fargo Trust Co Na Trustee · Salt Lake City, UTN717FDFederal Express Corp · Memphis, TNN717FRBank Of Utah Trustee · Salt Lake City, UTN718FRUmb Bank Na Trustee · Salt Lake City, UTN719FDFederal Express Corp · Memphis, TNN719FRWells Fargo Trust Co Na Trustee · Columbia, MDN720FRWilmington Trust Co Trustee · Wilmington, DEN721FDFederal Express Corp · Memphis, TNN721FRBank Of Utah Trustee · Salt Lake City, UTN722FDFederal Express Corp · Memphis, TNN722FRAlc A321 8579 LLC · Camden, DEN723FDFederal Express Corp · Memphis, TNN723FRAlc A321 8640 LLC · Camden, DEN724AVBank Of Utah Trustee · Salt Lake City, UTN724FDFederal Express Corp · Memphis, TNN725FDFederal Express Corp · Memphis, TNN726FDFederal Express Corp · Memphis, TNN727FDFederal Express Corp · Memphis, TNN728AVBank Of Utah Trustee · Salt Lake City, UTN728FDFederal Express Corporation · Memphis, TNN729CAAc Spe 6 LLC · Orlando, FLN729FDFederal Express Corp · Memphis, TNN729JBJetblue Airways Corp · Long Island City, NYN730FDFederal Express Corp · Memphis, TNN731FDFederal Express Corp · Memphis, TNN73251United Airlines Inc · Chicago, ILN73256United Airlines Inc · Chicago, ILN73259United Airlines Inc · Chicago, ILN73270United Airlines Inc · Chicago, ILN73275United Airlines Inc · Chicago, ILN73276United Airlines Inc · Chicago, ILN73278United Airlines Inc · Chicago, ILN73283Umb Bank Na Trustee · Salt Lake City, UTN73291Umb Bank Na Trustee · Salt Lake City, UTN73299United Airlines Inc · Chicago, ILN732FDFederal Express Corporation · Memphis, TNN733FDFederal Express Corp · Memphis, TNN74007United Airlines Inc · Chicago, ILN740AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTN740AXCargo Aircraft Management Inc · Wilmington, OHN740FDFederal Express Corp · Memphis, TNN741FDFederal Express Corp · Memphis, TNN742AVUmb Bank Na Trustee · Salt Lake City, UTN742CKKalitta Air LLC · Ypsilanti, MIN742FDFederal Express Corp · Memphis, TNN743AVUmb Bank Na Trustee · Salt Lake City, UTN743CKKalitta Air LLC · Ypsilanti, MIN743FDFederal Express Corp · Memphis, TNN744AXCargo Aircraft Management Inc · Wilmington, OH
Back to AD 2007-19-13