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.
N915USAmerican Airlines Inc · Fort Worth, TXN916ANAmerican Airlines Inc · Fort Worth, TXN916NNBank Of Utah Trustee · Salt Lake City, UTN916USAmerican Airlines Inc · Fort Worth, TXN917ANAmerican Airlines Inc · Fort Worth, TXN917NNBank Of Utah Trustee · Salt Lake City, UTN917UYAmerican Airlines Inc · Fort Worth, TXN918ANAmerican Airlines Inc · Fort Worth, TXN918NNUmb Bank Na Trustee · Salt Lake City, UTN918USAmerican Airlines Inc · Fort Worth, TXN919ANAmerican Airlines Inc · Fort Worth, TXN919CAAc Spe 2 LLC · Orlando, FLN919NNBank Of Utah Owner Trustee · Salt Lake City, UTN919RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN919USAmerican Airlines Inc · Fort Worth, TXN920ANAmerican Airlines Inc · Fort Worth, TXN920NNUmb Bank Na Trustee · Salt Lake City, UTN920USAmerican Airlines Inc · Fort Worth, TXN921ANAmerican Airlines Inc · Fort Worth, TXN921NNBank Of Utah Trustee · Salt Lake City, UTN921USAmerican Airlines Inc · Fort Worth, TXN922ANAmerican Airlines Inc · Forth Worth, TXN922NNBank Of Utah Trustee · Salt Lake City, UTN922USAmerican Airlines Inc · Fort Worth, TXN923ANAmerican Airlines Inc · Fort Worth, TXN923JBJetblue Airways Corp · Long Island City, NYN923NNBank Of Utah Trustee · Salt Lake City, UTN923USAmerican Airlines Inc · Fort Worth, TXN924ANWilmington Trust Co Trustee · Wilmington, DEN924NNBank Of Utah Trustee · Salt Lake City, UTN924USAmerican Airlines Inc · Fort Worth, TXN925ANWilmington Trust Co Trustee · Wilmington, DEN925NNWilmington Trust Co Trustee · Wilmington, DEN925UYAmerican Airlines Inc · Fort Worth, TXN926ANAmerican Airlines Inc · Fort Worth, TXN926NNBank Of Utah Trustee · Salt Lake City, UTN926UWAmerican Airlines Inc · Fort Worth, TXN927ANAmerican Airlines Inc · Fort Worth, TXN927NNWilmington Trust Co Trustee · Wilmington, DEN927UWAmerican Airlines Inc · Fort Worth, TXN928AMAmerican Airlines Inc · Fort Worth, TXN928ANAmerican Airlines Inc · Fort Worth, TXN928NNBank Of Utah Trustee · Salt Lake City, UTN929AAAmerican Airlines Inc · Fort Worth, TXN929ANAmerican Airlines Inc · Fort Worth, TXN929JBJetblue Airways Corp · Long Island City, NYN929NNBank Of Utah Trustee · Salt Lake City, UTN930ANAmerican Airlines Inc · Ft. Worth, TXN930AUAmerican Airlines Inc · Fort Worth, TXN930NNBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2007-19-13