Skip to content

Registered aircraft · 5,443

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

N273NDPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 28-42073 N274DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010074 N274MAHot Wings Aviation LLC · Fishers, INBuilt 2024 · S/N 28020174 N274ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881613 N275AMAerodynamic LLC · Aurora, ORBuilt 2022 · S/N 2881518 N275CBCalifornia Baptist University · Riverside, CABuilt 2025 · S/N 2881916 N275DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010075 N275FAFly Gateway Aviation Institute · New Castle, DEBuilt 2022 · S/N 28020058 N275NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842097 N2765QHoney B LLC · Hillsboro, ORS/N 28-7716121 N2766MDahl Jerome M · Iron River, MIBuilt 1977 · S/N 28-7816309 N2767MNew Ulm Flight Services LLC · Marshall, MNBuilt 1977 · S/N 28-7890266 N276AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881811 N276DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010076 N276JAYale Companies LLC DBA · Fishers, INBuilt 2022 · S/N 28020076 N276MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2844180 N276NDPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2842075 N276USchleede Stephen C · Lanark, ILBuilt 1976 · S/N 28-7690384 N276ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881614 N2771MRegistered aircraftBuilt 1977 · S/N 28-7890267 N2771QBrunelle Eric P · Whitman, MABuilt 1977 · S/N 28-7790418 N277DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010077 N277LGAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881909 N278MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881019 N278NDRegistered aircraftBuilt 2002 · S/N 2844069 N279CGDelaware State University · Dover, DEBuilt 2000 · S/N 2843399 N279MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881020 N279NDSowela Technical Community College · Lake Charles, LABuilt 2000 · S/N 2844034 N279PWMauck Ryan S Trustee · Bend, ORBuilt 1985 · S/N 28-8590059 N27AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843768 N27GSMazzola Michael · Baton Rouge, LABuilt 1977 · S/N 28R-7737160 N28011Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881346 N28015Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881347 N28017Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881348 N28020Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881349 N28027Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881350 N28029Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881351 N2802MSkyone Aero Services LLC · Castro Valley, CABuilt 1977 · S/N 28-7816312 N28030Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881352 N28034Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881357 N28043Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881358 N28045Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881359 N2804MEhrenborg Robert J · Fisherville, KYBuilt 1977 · S/N 28-7890269 N28051Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881360 N28053Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881379 N28065Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881380 N28069Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881381 N2806MCondor Aero Club Inc · Zelienople, PABuilt 1977 · S/N 28-7890270 N28077Cae Aviation Academy Phoenix LLC · Mesa, AZS/N 2881382 N28086Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881392

Back to AD 2016-07-21