AD 2002-18-01
Registered aircraft · 972
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:2002-18-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-18-01')
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:2002-18-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-18-01') 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.
N755AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTN760JBJetblue Airways Corp · Long Island City, NYN763AVBank Of Utah Trustee · Salt Lake City, UTN763JBJetblue Airways Corp · Long Island, NYN766JBJetblue Airways Corp · Long Island City, NYN768JBJetblue Airways Corp · Long Island City, NYN775JBJetblue Airways Corp · Long Island City, NYN779JBJetblue Airways Corp · Long Island City, NYN784JBJetblue Airways Corp · Long Island City, NYN789JBJetblue Airways Corp · Long Island, NYN793JBJetblue Airways Corp · Long Island City, NYN794JBJetblue Airways Corp · Long Island City, NYN796JBJetblue Airways Corp · Long Island City, NYN804JBJetblue Airways Corp · Long Island City, NYN805JBJetblue Airways Corp · Long Island City, NYN806JBJetblue Airways Corp · Long Island City, NYN807JBJetblue Airways Corp · Long Island City, NYN809JBJetblue Airways Corp · Long Island City, NYN821AVAircol 22 · Wilmington, DEN821JBJetblue Airways Corp · Long Island City, NYN827JBJetblue Airways Corp · Long Island City, NYN827QDelaware Aircraft Trust LLC Trustee · New Castle, DEN828JBJetblue Airways Corp · Long Island City, NYN834JBJetblue Airways Corp · Long Island City, NYN837VABank Of Utah Trustee · Salt Lake City, UTN851ASUmb Bank Na Trustee · Salt Lake City, UTN862AVAircol 23 · Wilmington, DEN900UWAmerican Airlines Inc · Fort Worth, TXN901AAAmerican Airlines Inc · Fort Worth, TXN902AABank Of Utah Trustee · Salt Lake City, UTN903AAAmerican Airlines Inc · Fort Worth, TXN903JBJetblue Airways Corp · Long Island City, NYN904AABank Of Utah Trustee · Salt Lake City, UTN905AUBank Of Utah Trustee · Salt Lake City, UTN905JBJetblue Airways Corp · Long Island City, NYN906AABank Of Utah Trustee · Salt Lake City, UTN907AABank Of Utah Trustee · Salt Lake City, UTN907JBJetblue Airways Corp · Long Island City, NYN908AABank Of Utah Trustee · Salt Lake City, UTN909AMWilmington Trust Co Trustee · Wilmington, DEN910AUWilmington Trust Co Trustee · Wilmington, DEN912UYAmerican Airlines Inc · Fort Worth, TXN913JBJetblue Airways Corp · Long Island City, NYN913USAmerican Airlines Inc · Fort Worth, TXN914UYAmerican Airlines Inc · Fort Worth, TXN915USAmerican Airlines Inc · Fort Worth, TXN916USAmerican Airlines Inc · Fort Worth, TXN917UYAmerican Airlines Inc · Fort Worth, TXN918USAmerican Airlines Inc · Fort Worth, TXN919USAmerican Airlines Inc · Fort Worth, TX
Back to AD 2002-18-01