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.

N9471CHitpas Henry R II · Beaufort, SCBuilt 1978 · S/N 28R-7837200 N9480CDave Gross Inc · Midland, TXBuilt 1978 · S/N 28-7816480 N9482CSchuetz Ray · Davie, FLBuilt 1978 · S/N 28-7816481 N9483CCnczilla Co · Royersford, PABuilt 1978 · S/N 28-7816482 N9486CRhodes Ryan · Dallas, TXBuilt 1978 · S/N 28-7890415 N9487KInverted Air LLC · Mesa, AZBuilt 1976 · S/N 28-7690254 N949GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881225 N94NARegistration Pending · Northampton, MARegistration pendingS/N 2844003 N94WAVidal Aviation LLC · Gaithersburg, MDS/N 2843118 N950DSSchmitt Douglas F · Bloomsbury, NJBuilt 1978 · S/N 28R-7837167 N950TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881950 N9512CDe Aviation Inc · La Porte, TXBuilt 1978 · S/N 28-7816487 N9513CAgri Business Aviation Inc · Sparta, ILBuilt 1978 · S/N 28-7890418 N951NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881925 N951TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881951 N9526KReyn/Craft Wildside Aviation LLC · Athens, ILS/N 28-7690257 N952AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843804 N952NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881370 N952TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881952 N9537CArcher II LLC · Kenosha, WIBuilt 1978 · S/N 28-7890420 N9538CCobb Janet · Saint Joseph, MOBuilt 1978 · S/N 28-7890421 N9539CNafziger Aviation Leasing LLC · Wittman, MDBuilt 1978 · S/N 28R-7837206 N953GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881081 N953TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881953 N9542DSandberg Joseph A · Mount Laurel, NJS/N 28-7690180 N954GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881082 N9552KWing Flying Club Inc · Lees Summit, MOBuilt 1976 · S/N 28-7690258 N9555CVimana LLC · Chandler, AZBuilt 1978 · S/N 28-7816491 N9556KN R I Flying Club Inc · Walnut Creek, CAS/N 28-7690259 N9557KCook Walter T · Centerville, TNBuilt 1976 · S/N 28-7690260 N955SEmge Douglas W · Albertville, ALBuilt 1979 · S/N 287990385 N955SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881875 N9561CRak Flight Squad LLC · Bronx, NYBuilt 1978 · S/N 28-7816493 N9564CPowell David K · Edwardsville, ILBuilt 1978 · S/N 28-7890422 N9568CMitchell Stephen D · Wichita, KSBuilt 1978 · S/N 28-7890423 N9576CMercer Paul A · Salida, CABuilt 1978 · S/N 28-7816497 N9579CVan Winkle Steven Russell · East Berlin, PABuilt 1978 · S/N 28-7890425 N9594CPassino Nicholas J · Latham, NYBuilt 1978 · S/N 28R-7837209 N959GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881473 N95TSSkywest Leasing Inc · St George, UTBuilt 1997 · S/N 2843103 N9600UUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7816505 N9605CA O G Aircraft Services LLC · Aberdeen, NJBuilt 1978 · S/N 28-7816502 N9607CLmc Aviation LLC · Goleta, CABuilt 1978 · S/N 28-7890429 N960ACNaples Air Center Inc · Naples, FLBuilt 1990 · S/N 2841325 N960WCStardust Aviation LLC · Farmingdale, NYBuilt 2000 · S/N 2843368 N961ABPiper Aircraft Inc · Vero Beach, FLS/N 28010089 N961DACondair Flyers Inc · Latham, NYBuilt 1996 · S/N 2843034 N961GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881226 N961TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881961 N961WGChandler Air Service Inc · Chandler, AZBuilt 2000 · S/N 2843376

Back to AD 2016-07-21