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.

N3053ECharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7990186 N3053NAnywhere Atp LLC · Mount Juliet, TNBuilt 1979 · S/N 28-7990288 N3054LNationwide Aviation LLC · Hudson Oaks, TXBuilt 1979 · S/N 28-7916250 N3054MRegistration Pending · Reseda, CARegistration pendingS/N 28-7890292 N3054TVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 28-7990325 N3055BSale Reported · Gainesville, FLSale reportedS/N 28-7990137 N30561Eisele William L · Laporte, INBuilt 1978 · S/N 28-7990096 N3056ZPopson LLC · Peachtree City, GABuilt 1979 · S/N 28-7990412 N3057FN3057f LLC · Branson, MOBuilt 1978 · S/N 28-7990226 N3057MAg Aero Inc · Lenzburg, ILBuilt 1977 · S/N 28-7890293 N3059BBay De Noc Flying Club Inc · Escanaba, MIBuilt 1978 · S/N 28-7990138 N305MDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020255 N305NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881616 N305UMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020051 N3060BPrestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7990139 N3060FEl Paso Aero Inc · El Paso, TXBuilt 1978 · S/N 28-7990227 N3060LLang Scott T · Waseca, MNBuilt 1979 · S/N 28-7916251 N3060YB&D Flight Club LLC · Portage, INBuilt 1979 · S/N 28-7916370 N3061YHott Steven A · Kokomo, INBuilt 1979 · S/N 28-7990388 N3062LMerino Rodrigo R · Chilton, WIBuilt 1979 · S/N 28-7916252 N3062YSwaringen Jeanne A · Lakeside, CABuilt 1979 · S/N 28-7990389 N30647Registration Pending · Diamondhead, MSRegistration pendingBuilt 1978 · S/N 28-7816545 N30650Elite Flight Training And Aircraft Management LLC · Kankakee, ILBuilt 1978 · S/N 28-7916089 N3065CVenture West LLC · Mesa, AZBuilt 1978 · S/N 28-7990152 N3066GAstro Aviation LLC · Cross Plains, TNBuilt 1978 · S/N 28-7990197 N3066HLarsen Mark S · Spencer, IABuilt 1978 · S/N 28-7916219 N3066YQuiett Aaron Trustee · Hillsboro, ORS/N 28-7990392 N3067DLawson Roger E · Elizabethtown, KYBuilt 1978 · S/N 28-7916159 N3069CBusboom Richard Jay · Berthoud, COBuilt 1978 · S/N 28-7990153 N3069LGrech George A Trustee · Concord, CABuilt 1979 · S/N 28-7990263 N306LJAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881496 N306MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010010 N3071DDaniella Levi & Associates Pc · Fresh Meadows, NYS/N 28-7916160 N3072DFly By Knight Inc · Hammond, LABuilt 1978 · S/N 28-7916161 N3072HPorter Paul S · Prestonsburg, KYBuilt 1978 · S/N 28-7990233 N3072LWright Steve R · Harrisburg, ILS/N 28-7990264 N30739Kent Stephen G · Spanaway, WABuilt 1978 · S/N 28-7990100 N3073UJla Aero LLC · State College, PABuilt 1979 · S/N 28-7916320 N30749Brantly Craig A · Lakeville, MNS/N 28-7990101 N3075KBaker James B · Roanoke, TXBuilt 1978 · S/N 28-7916239 N3075MRhodes Bradley E · Tualatin, ORBuilt 1977 · S/N 28-7816334 N3077MPremier Flight Center LLC · Hartford, CTBuilt 1977 · S/N 28-7816335 N3079MEagle Flight Academy LLC · Owensboro, KYBuilt 1977 · S/N 28-7816336 N3079USpicher Samuel C Jr · Harrisonburg, VABuilt 2004 · S/N 2843591 N307NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881617 N3081QInternational Air Services Inc Trustee · Carson City, NVS/N 28R-7737046 N30823Indian Hills Community College · Ottumwa, IAS/N 28-7816548 N30877Pompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1978 · S/N 28-7890457 N308FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020108 N308MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010011

Back to AD 2016-07-21