Skip to content

Registered aircraft · 40,471

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

N8967TKellys Flying Service LLC · Warrensburg, MOBuilt 1981 · S/N 28-8190209 N8968DCleary Katherine E · Mulberry, FLBuilt 1958 · S/N 22-6132 N8968JStevens Raymond W · Norfolk, VAS/N 28-2991 N8968VLittle Gordon D · Watertown, SDS/N 17264324 N8969CStrahl Guenter H · Jackson, NJBuilt 1976 · S/N 28-7690173 N896AKQuadcub Utah LLC · Salt Lake City, UTS/N 1 N896B49 Holdings LLC · Cheyenne, WYBuilt 2021 · S/N MB27 N896SCHansen Ernest F · Sequim, WABuilt 2020 · S/N 001 N8970JAll Tech Machine & Tool Inc · Greenwood, ARBuilt 1965 · S/N 28-2993 N8970VWinding Creek Aviation LLC · Snellville, GABuilt 1974 · S/N 17264326 N8971DThomas James W · Jay, FLBuilt 1958 · S/N 18-6408 N8971JSwearingen Louis S · Summerfield, FLBuilt 1965 · S/N 28-2994 N8971VGibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264327 N89721Propability One LLC · Daytona Beach, FLBuilt 1983 · S/N 17276010 N8972CBosn Richard O · Scottsbluff, NEBuilt 1976 · S/N 28-7690174 N8972DClarke Timothy B · Howard, SDBuilt 1958 · S/N 18-6411 N8972JPascua Jonathan J · Coventry, RIBuilt 1966 · S/N 28-2995 N8972VPearce Michael J · Phoenix, AZBuilt 1974 · S/N 17264328 N8973DSnider Scott E DBA · Turner, MTBuilt 1958 · S/N 18-6412 N8973JMuleshoe Flight Club LLC · Muleshoe, TXBuilt 1965 · S/N 28-2996 N8973VOcean Flyers LLC · Chatham, NJBuilt 1974 · S/N 17264329 N8975VMauser James E · Zionsville, PABuilt 1974 · S/N 17264331 N8976DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-4887 N8976JGreat Plains Aviation LLC · Lincoln, NEBuilt 1966 · S/N 28-2999 N8977DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-5083 N8977JJohnson Bradley F · West Babylon, NYBuilt 1966 · S/N 28-3000 N8977RCozine Mark R · Cherokee, IABuilt 1960 · S/N 7KC-1 N8978DShuman Cecil R Trustee · Chugiak, AKBuilt 1958 · S/N 18-6418 N8979DBurnett Kris W · Anchorage, AKBuilt 1975 · S/N 18-7509053 N8979RSeeley Lenard D · Osage, WYBuilt 1960 · S/N 13 N8979VAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17264335 N897DCRed Baron LLC · Middletown, DES/N 20012C N897JSMurray James P · Parrish, FLBuilt 2004 · S/N 90430 N897JWAmh Properties LLC · Auburn, ALFirst renewal noticeBuilt 2011 · S/N 2843698 N897MBJts Aircraft LLC · Rock Hill, SCBuilt 1966 · S/N 28-21978 N8980RHolmes Aviation Inc · Cannon Falls, MNBuilt 1960 · S/N 7GCB-14 N8980VSweitz-Air Inc · Stewartstown, PAS/N 17264336 N89811Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1983 · S/N 17276013 N8981RBlock Raymond J · Palmer, AKS/N 7GCB-10 N8982DNorth Sound Aviation Inc · Sedro Woolley, WABuilt 1958 · S/N 18-6377 N8982RBoo Steven R · Chisago City, MNBuilt 1960 · S/N 7GCB-15 N8982VHirsch John K Trustee · Gerald, MOBuilt 1974 · S/N 17264338 N8983JStensrud Maynard R · Waseca, MNBuilt 1966 · S/N 28-3006 N8983VMoon Reagan E · Bossier City, LABuilt 1974 · S/N 17264339 N8984JKlassen Wayne V · New Ulm, MNBuilt 1965 · S/N 28-3007 N8986JKleinberg Kenneth A · Saugerties, NYBuilt 1965 · S/N 28-3009 N8986RYarbanton John Robert · Muskegon, MIBuilt 1960 · S/N 7GCB-16 N8986VAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17264342 N89878Corwin Shawn M · Tucson, AZBuilt 1983 · S/N 17276015 N8987VPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1974 · S/N 17264343

Back to AD 80-04-03 R2