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.
N567AVBank Of Utah Trustee · Salt Lake City, UTN567UWAmerican Airlines Inc · Fort Worth, TXN568JBJetblue Airways Corp · Long Island City, NYN568UWAmerican Airlines Inc · Fort Worth, TXN569JBJetblue Airways Corp · Long Island City, NYN570JBJetblue Airways Corp · Long Island City, NYN570TABank Of Utah Trustee · Salt Lake City, UTN571JBJetblue Airways Corp · Long Island City, NYN572UWAmerican Airlines Inc · Fort Worth, TXN573UWAmerican Airlines Inc · Fort Worth, TXN575UWAmerican Airlines Inc · Fort Worth, TXN576UWAmerican Airlines Inc · Fort Worth, TXN578UWAmerican Airlines Inc · Fort Worth, TXN579JBBank Of Utah Trustee · Salt Lake City, UTN579UWAmerican Airlines Inc · Fort Worth, TXN580JBBank Of Utah Trustee · Salt Lake City, UTN580UWAmerican Airlines Inc · Fort Worth, TXN581UWAmerican Airlines Inc · Fort Worth, TXN582UWAmerican Airlines Inc · Fort Worth, TXN583JBJetblue Airways Corp · Long Island City, NYN583UWAmerican Airlines Inc · Fort Worth, TXN584JBJetblue Airways Corp · Long Island City, NYN584UWAmerican Airlines Inc · Fort Worth, TXN585JBJetblue Airways Corp · Long Island City, NYN585UWAmerican Airlines Inc · Fort Worth, TXN586JBJetblue Airways Corp · Long Island City, NYN586UWAmerican Airlines Inc · Fort Worth, TXN587JBJetblue Airways Corp · Long Island City, NYN587UWAmerican Airlines Inc · Fort Worth, TXN588JBJetblue Airways Corp · Long Island City, NYN589JBJetblue Airways Corp · Long Island City, NYN590JBJetblue Airways Corp · Long Island City, NYN591JBJetblue Airways Corporation · Long Island City, NYN592JBJetblue Airways Corporation · Long Island City, NYN593JBJetblue Airways Corp · Long Island City, NYN594JBJetblue Airways Corp · Long Island City, NYN595JBJetblue Airways Corp · Long Island City, NYN597JBJetblue Airways Corp · Long Island City, NYN598JBJetblue Airways Corp · Long Island City, NYN599AVWells Fargo Trust Co Na Trustee · Columbia, MDN599JBJetblue Airways Corp · Long Island City, NYN601AWAmerican Airlines Inc · Fort Worth, TXN601NKBank Of Utah Trustee · Sale Lake City, UTN602NKBank Of Utah Trustee · Salt Lake City, UTN603JBJetblue Airways Corp · Long Island City, NYN603NKBank Of Utah Trustee · Salt Lake City, UTN604AWUmb Bank Na Trustee · Salt Lake City, UTN604NKBank Of Utah Trustee · Salt Lake City, UTN605JBJetblue Airways Corp · Long Island City, NYN605NKWells Fargo Trust Co Na Trustee · Columbia, MD
Back to AD 2002-18-01