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.

N8334PCanta Alain Ongkeko · Northridge, CABuilt 1981 · S/N 28-8116149 N8334WGhenciu Petre I · Homer Glen, ILBuilt 1981 · S/N 28-8116150 N8334YOncore Aviation LLC · Rochester, NYBuilt 1981 · S/N 28-8116151 N8334ZUfly Vi LLC · St Thomas, VIBuilt 1981 · S/N 28-8116152 N83364Rhoads Eric S · Costa Mesa, CABuilt 1982 · S/N 28-8390035 N8336GGolden Age N8336g LLC · Norwalk, IABuilt 1981 · S/N 28-8190167 N8336HNeel Aviation LLC · Lakeland, FLBuilt 1981 · S/N 28-8190168 N8338DPlant Galen M · Crown Point, INBuilt 1981 · S/N 28-8116156 N8339DLd Flight LLC · Houston, TXBuilt 1982 · S/N 28-8316030 N833NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881292 N833TBEuro 2000 Inc · Merritt Island, FLBuilt 2002 · S/N 2842149 N83416Offutt Air Force Base Aero Club · Offutt Afb, NEBuilt 1981 · S/N 28-8116160 N8341ADavidson Air LLC · Hemet, CAS/N 28-8390021 N8342HBartolf Michael Joseph · Williamston, SCBuilt 1981 · S/N 28-8116162 N8342NHansen Derek J · Lehi, UTBuilt 1981 · S/N 28-8190171 N8342YThompson Kevan R · Penn Yan, NYBuilt 1981 · S/N 28-8190179 N8344VStandley Joseph · Lake In The Hills, ILBuilt 1982 · S/N 28-8316035 N8345ZTrident Aircraft Inc · Easton, MDBuilt 1981 · S/N 28-8116167 N8346CBroyles Richard M · Wildwood, MOBuilt 1976 · S/N 28-7690120 N8346HAir Jay West LLC · Winnetka, CABuilt 1981 · S/N 28-8190180 N8346NFleetcraft Transportation LLC · Naperville, ILBuilt 1981 · S/N 28-8190181 N8346STravel Express Aviation LLC · West Chicago, ILBuilt 1981 · S/N 28-8190182 N8346TMoradi Mark M · Orlando, FLBuilt 1981 · S/N 28-8190183 N8347CTriple R D2 Jmw Corp · Saint Cloud, MNBuilt 1976 · S/N 28-7690121 N834NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881304 N834TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881707 N8351WQuality Aero LLC · East Aurora, NYBuilt 1981 · S/N 28-8116176 N8352DScarlet Wings LLC · Brunswick, OHBuilt 1981 · S/N 28-8116179 N8352TFlight Inc · Lakewood, COBuilt 1981 · S/N 28-8190187 N8353DKauffman Land & Development LLC · Fort Lupton, COBuilt 1981 · S/N 28-8190189 N83540Red Tail Scholarship Foundation · Tuskegee, ALBuilt 1981 · S/N 28-8190190 N8354CTayab Farooq · Allen, TXBuilt 1976 · S/N 28-7690122 N8358ZMinella Frank A · Old Forge, PABuilt 1981 · S/N 28-8190192 N8360YOtto Aviation LLC · Gilbertsville, PABuilt 1981 · S/N 28-8190195 N8363EEllefson Aircraft LLC · Tyler, MNS/N 28-8116187 N8363HFox John · Asheboro, NCBuilt 1981 · S/N 28-8116188 N8363PLove Richard S · Indianapolis, INBuilt 1981 · S/N 28-8116191 N8363ZGobel Mario · Belleville, WIFirst renewal noticeBuilt 1981 · S/N 28-8190202 N8364GMcintosh Warren K · Cookeville, TNBuilt 1981 · S/N 28-8190203 N8365ZScorse Jeffrey A · Lunenburg, MABuilt 1981 · S/N 28-8116196 N8366NLakes Region Flying Club Inc · Gilford, NHBuilt 1981 · S/N 28-8190205 N8366ZApm Leasing LLC · Casper, WYBuilt 1981 · S/N 28-8190206 N83670Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1981 · S/N 28-8190210 N8367SBaer Donald J · Groton, CTBuilt 1981 · S/N 28-8190207 N8369ANorthern Ventures II LLC · Carl Junction, MOS/N 28-8116198 N8369XTemesvary Peter · Katy, TXBuilt 1981 · S/N 28-8190211 N8369YLand Sea Air LLC · West Tisbury, MAS/N 28-8190212 N8369ZB & J 58 Inc · Fredericksburg, VABuilt 1981 · S/N 28-8190213 N836FSSmart01 LLC · Kissimmee, FLBuilt 1981 · S/N 28-8116200 N8372CMarino Robert · Little Neck, NYBuilt 1976 · S/N 28-7690125

Back to AD 2016-07-21