Registered aircraft · 165

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

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:2008-14-02-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-14-02-R1') ORDER BY n_number

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:2008-14-02-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-14-02-R1')
  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:2008-14-02-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-14-02-R1')
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.

N911FRMiami Dade Fire Rescue Department · Miami, FLBuilt 2020 · S/N 41569 N911LKMonroe County Florida · Key West, FLBuilt 2025 · S/N 41605 N911RAMiami Dade Fire Dept · Miami, FLBuilt 2020 · S/N 41570 N911RRMonroe County Florida · Key West, FLBuilt 2025 · S/N 41601 N925VHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 31282 N926EPAgustawestland Philadelphia Corp · Philadelphia, PABuilt 2026 · S/N 41626 N939BGBristow LLC · Lake Charles, LABuilt 2010 · S/N 41234 N939ZIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2006 · S/N 31061 N965LATrey Aviation LLC · North Oaks, MNBuilt 2023 · S/N 41584 N977RTIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 31977 N978RTIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 31978 N98DQDuquesne Aviation Inc · New York, NYBuilt 2009 · S/N 41219 N996LFVariety Childrens Hospital DBA · Miami, FLBuilt 2026 · S/N 41616 N99DQDuquesne Aviation Inc · New York, NYBuilt 2024 · S/N 32087 N9NJState Of New Jersey · Trenton, NJS/N 41243

Back to AD 2008-14-02 R1