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.
N899NNBank Of Utah Owner Trustee · Salt Lake City, UTN900UWAmerican Airlines Inc · Fort Worth, TXN901AAAmerican Airlines Inc · Fort Worth, TXN901ANAmerican Airlines Inc · Fort Worth, TXN901NNWilmington Trust Co Trustee · Wilmington, DEN902AABank Of Utah Trustee · Salt Lake City, UTN902ANAmerican Airlines Inc · Fort Worth, TXN902NNBank Of Utah Trustee · Salt Lake City, UTN903AAAmerican Airlines Inc · Fort Worth, TXN903ANAmerican Airlines Inc · Fort Worth, TXN903ARUmb Bank Na Trustee · Salt Lake City, UTN903JBJetblue Airways Corp · Long Island City, NYN903NNWilmington Trust Co Trustee · Wilmington, DEN904AABank Of Utah Trustee · Salt Lake City, UTN904ANAmerican Airlines Inc · Fort Worth, TXN904ARUmb Bank Na Trustee · Salt Lake City, UTN904NNWilmington Trust Co Trustee · Wilmington, DEN905ANAmerican Airlines Inc · Fort Worth, TXN905AUBank Of Utah Trustee · Salt Lake City, UTN905JBJetblue Airways Corp · Long Island City, NYN905NNBank Of Utah Trustee · Salt Lake City, UTN906AABank Of Utah Trustee · Salt Lake City, UTN906ANAmerican Airlines Inc · Fort Worth, TXN906NNWilmington Trust Co Trustee · Wilmington, DEN90705Qualitair LLC Trustee · MichelstadtN907AABank Of Utah Trustee · Salt Lake City, UTN907ANAmerican Airlines Inc · Fort Worth, TXN907JBJetblue Airways Corp · Long Island City, NYN907NNWilmington Trust Co Trustee · Wilmington, DEN908AABank Of Utah Trustee · Salt Lake City, UTN908ANAmerican Airlines Inc · Fort Worth, TXN908NNBank Of Utah Trustee · Salt Lake City, UTN909AMWilmington Trust Co Trustee · Wilmington, DEN909ANAmerican Airlines Inc · Fort Worth, TXN909NNBank Of Utah Trustee · Salt Lake City, UTN910ANAmerican Airlines Inc · Fort Worth, TXN910AUWilmington Trust Co Trustee · Wilmington, DEN910NNUmb Bank Na Trustee · Salt Lake City, UTN912ANAmerican Airlines Inc · Fort Worth, TXN912NNBank Of Utah Trustee · Salt Lake City, UTN912UYAmerican Airlines Inc · Fort Worth, TXN913ANAmerican Airlines Inc · Fort Worth, TXN913JBJetblue Airways Corp · Long Island City, NYN913NNBank Of Utah Trustee · Salt Lake City, UTN913USAmerican Airlines Inc · Fort Worth, TXN914ANAmerican Airlines Inc · Fort Worth, TXN914NNUmb Bank Na Trustee · Salt Lake City, UTN914UYAmerican Airlines Inc · Fort Worth, TXN915ANAmerican Airlines Inc · Fort Worth, TXN915NNBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2007-19-13