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.
N514VLWells Fargo Trust Co Na Trustee · Columbia, MDN515VLBank Of Utah Trustee · Salt Lake City, UTN516ASWilmington Trust Co Trustee · Wilmington, DEN516JBJetblue Airways Corp · Long Island City, NYN517ASAlaska Airlines Inc · Seatac, WAN517JBJetblue Airways Corp · Long Island City, NYN518ASAlaska Airlines Inc · Seattle, WAN518VLBank Of Utah Trustee · Salt Lake City, UTN519ASAlaska Airlines Inc · Seatac, WAN519BCAlta 777 LLC · Salt Lake City, UTN519JBJetblue Airways Corp · Long Island City, NYN519UWAmerican Airlines Inc · Fort Worth, TXN519VLBank Of Utah Trustee · Salt Lake City, UTN520ASAlaska Airlines Inc · Seattle, WAN520JBJetblue Airways Corp · Long Island City, NYN520VLBank Of Utah Trustee · Salt Lake City, UTN521JBJetblue Airways Corp · Long Island City, NYN521SHGlobal Crossing Airlines Inc · Miami, FLN521UWAmerican Airlines Inc · Fort Worth, TXN521VLUmb Bank Na Trustee · Salt Lake City, UTN522VLBank Of Utah Owner Trustee · Salt Lake City, UTN523ASWilmington Trust Co Trustee · Wilmington, DEN523JBJetblue Airways Corp · Long Island City, NYN523UWAmerican Airlines Inc · Fort Worth, TXN523VLUmb Bank Na Trustee · Salt Lake City, UTN524ASAlaska Airlines Inc · Seatac, WAN524JBJetbule Airways Corporation · Long Island City, NYN524UWBank Of Utah Trustee · Salt Lake City, UTN524VLBank Of Utah Trustee · Salt Lake City, UTN525ASAlaska Airlines Inc · Seatac, WAN525VLUmb Bank Na Trustee · Salt Lake City, UTN526ASAlaska Airlines Inc · Seatac, WAN526JLJetblue Airways Corp · Long Island City, NYN526VLWells Fargo Trust Co Na Trustee · Columbia, MDN527ASAlaska Airlines Inc · Seatac, WAN527JLJetblue Airways Corp · Long Island, NYN527VLWilmington Trust Na Trustee · Wilmington, DEN528ASAlaska Airlines Inc · Seattle, WAN529ASAlaska Airlines Inc · Seatac, WAN529CGCargo Aircraft Management Inc · Wilmington, OHN529JBJetblue Airways Corporation · Long Island City, NYN530ASAlaska Airlines Inc · Seattle, WAN530FLBank Of Utah Trustee · Salt Lake City, UTN530XTBank Of Utah Trustee · Salt Lake City, UTN531ASAlaska Airlines Inc · Seattle, WAN531JLJetblue Airways Corp · Long Island City, NYN532ASAlaska Airlines Inc · Seatac, WAN533ASAlaska Airlines Inc · Seatac, WAN534ASAlaska Airlines Inc · Seatac, WAN534JBJetblue Airways Corp · Long Island City, NY
Back to AD 2007-19-13