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.
N534UWAmerican Airlines Inc · Fort Worth, TXN535ASAlaska Airlines Inc · Seattle, WAN535JBJetblue Airways Corp · Long Island City, NYN535UWAmerican Airlines Inc · Fort Worth, TXN536ASAlaska Airlines Inc · Seattle, WAN536AVWells Fargo Trust Co Na Trustee · Columbia, MDN536JBJetblue Airways Corp · Long Island City, NYN536UWAmerican Airlines Inc · Fort Worth, TXN537ASAlaska Airlines Inc · Seatac, WAN537CAAc Spe 10 LLC · Orlando, FLN537JTJetblue Airways Corp · Long Island City, NYN537UWAmerican Airlines Inc · Fort Worth, TXN538ASAlaska Airlines Inc · Seattle, WAN538AVWilmington Trust Co Trustee · Wilmington, DEN538LAQuetro Aircraft Leasing Trust · Wilmington, DEN538UWAmerican Airlines Inc · Fort Worth, TXN539UWAmerican Airlines Inc · Fort Worth, TXN540LACaiquen Leasing LLC · Wilmington, DEN540UWAmerican Airlines Inc · Fort Worth, TXN54241United Airlines Inc · Chicago, ILN542LAQuetro Aircraft Leasing Trust · Wilmington, DEN542UWAmerican Airlines Inc · Fort Worth, TXN543UWAmerican Airlines Inc · Fort Worth, TXN544UWAmerican Airlines Inc · Fort Worth, TXN545UWAmerican Airlines Inc · Fort Worth, TXN546ASAlaska Airlines Inc · Seattle, WAN546UWAmerican Airlines Inc · Fort Worth, TXN547JBBank Of Utah Trustee · Salt Lake City, UTN548ASAlaska Airlines Inc · Seattle, WAN549UWAmerican Airlines Inc · Fort Worth, TXN551ASAlaska Airlines Inc · Seattle, WAN551UWUmb Bank N A Trustee · Salt Lake City, UTN552ASAlaska Airlines Inc · Seattle, WAN552JBBank Of Utah Trustee · Salt Lake City, UTN552UWUmb Bank Na Trustee · Salt Lake City, UTN553ASAlaska Airlines Inc · Seattle, WAN553UWUmb Bank Na Trustee · Salt Lake City, UTN554JBBank Of Utah Trustee · Salt Lake City, UTN554UWUmb Bank Na Trustee · Salt Lake City, UTN556ASAlaska Airlines Inc · Seattle, WAN556JBJetblue Airways Corp · Long Island City, NYN556UWAmerican Airlines Inc · Fort Worth, TXN557ASAlaska Airlines Inc · Seattle, WAN557UWAmerican Airlines Inc · Fort Worth, TXN558ASAlaska Airlines Inc · Seattle, WAN558JBBank Of Utah Trustee · Salt Lake City, UTN558UWUmb Bank Na Trustee · Salt Lake City, UTN559ASAlaska Airlines Inc · Seattle, WAN559JBJetblue Airways Corp · Long Island City, NYN559UWAmerican Airlines Inc · Fort Worth, TX
Back to AD 2007-19-13