AD 2003-11-23
Registered aircraft · 171
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:2003-11-23')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-11-23')
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:2003-11-23') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-11-23') 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.
N620NKBank Of Utah Trustee · Salt Lake City, UTN621NKWilmington Trust Co Trustee · Wilmington, DEN622NKWilmington Trust Co Trustee · Wilmington, DEN623NKWilmington Trust Co Trustee · Wilmington, DEN624NKWilmington Trust Co Trustee · Wilmington, DEN626NKBank Of Utah Trustee · Salt Lake City, UTN627NKBank Of Utah Trustee · Salt Lake City, UTN628NKBank Of Utah Trustee · Salt Lake City, UTN629NKUmb Bank Na Trustee · Salt Lake City, UTN630NKWells Fargo Trust Co Na Trustee · Columbia, MDN631NKUmb Bank Na - Trustee · Salt Lake City, UTN633NKBank Of Utah Trustee · Salt Lake City, UTN634NKUmb Bank Na Trustee · Salt Lake City, UTN635NKBank Of Utah Trustee · Salt Lake City, UTN636JBJetblue Airways Corp · Long Island City, NYN636NKUmb Bank Na - Trustee · Salt Lake City, UTN637JBJetblue Airways Corp · Long Island City, NYN637NKUmb Bank Na Trustee · Salt Lake City, UTN638JBJetblue Airways Corp · Long Island City, NYN638NKSpirit Airlines LLC · Dania Beach, FLN639JBJetblue Airways Corp · Long Island City, NYN639NKSpirit Airlines LLC · Dania Beach, FLN640JBJetblue Airways Corp · Long Island City, NYN640NKSpirit Airlines LLC · Dania Beach, FLN641JBJetblue Airways Corp · Long Island City, NYN641NKSpirit Airlines LLC · Dania Beach, FLN642NKSpirit Airlines LLC · Dania Beach, FLN643JBJetblue Airways Corp · Long Island City, NYN643NKBank Of Utah Trustee · Salt Lake City, UTN644JBJetblue Airways Corp · Long Island City, NYN644NKSpirit Airlines LLC · Dania Beach, FLN645JBJetblue Airways Corp · Long Island City, NYN645NKSpirit Airlines LLC · Dania Beach, FLN646JBJetblue Airways Corp · Long Island, NYN646NKSpirit Airlines LLC · Dania Beach, FLN647NKSpirit Airlines LLC · Dania Beach, FLN648JBJetblue Airways Corp · Long Island, NYN648NKSpirit Airlines LLC · Dania Beach, FLN649JBJetblue Airways Corp · Long Island City, NYN649NKSpirit Airlines LLC · Dania Beach, FLN650NKSpirit Airlines LLC · Dania Beach, FLN651JBJetblue Airways Corp · Long Island, NYN651NKSpirit Airlines LLC · Dania Beach, FLN652JBJetblue Airways Corp · Long Island City, NYN652NKSpirit Airlines LLC · Dania Beach, FLN653JBJetblue Airways Corp · Long Island City, NYN653NKSpirit Airlines LLC · Dania Beach, FLN654NKSpirit Airlines LLC · Dania Beach, FLN655JBJetblue Airways Corp · Long Island, NYN655NKSpirit Airlines LLC · Dania Beach, FL
Back to AD 2003-11-23