OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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
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.

N47LHPompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1979 · S/N 28-7990480N47MLWitt Jerry D III · Houston, TXBuilt 1956 · S/N 22-3865N47PGRandall Skye Sanjay · Lansdowne, PABuilt 1977 · S/N AA5A0340N47RGGossard Philip G · Stonington, MEBuilt 1994 · S/N 3290N47STFuhs Nicholas J · Advance, NCS/N 2739N47TDBeene Donald · Westfield, INBuilt 1999 · S/N 60023N47TSStewart Terry · Anchorage, AKBuilt 1977 · S/N 18-7709120N47WCFly Girls Aviation LLC · Saint Amant, LABuilt 1959 · S/N TD-241N47WLSchettler Patrick J · Garnett, KSBuilt 2001 · S/N MM001N48007White Andrew Kyle · San Diego, CABuilt 2003 · S/N 5497-01N4800LFlying Aces LLC · Scappoose, ORBuilt 1967 · S/N 28-4139N4800VRegistered aircraftBuilt 1980 · S/N 172RG0382N4801GFrederick Aero Development Inc · Murrieta, CAS/N 17273349N4801LWilliams Fire Apparatus Inc · Ashland, ALBuilt 1967 · S/N 28-4140N4802LKrishna Vijay · Appleton, WIBuilt 1967 · S/N 28-4141N4802ZHoffman James R · Bethel, AKBuilt 1962 · S/N 18-7800N4803Molek Jon · Warren, OHS/N 1126N4803FNorman Howard A · Freeport, ILBuilt 1976 · S/N 28-7715067N4803GAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1979 · S/N 17273351N4803LJc And Co Menswear Inc · Tulsa, OKS/N 28-4142N4804AMakely Abraham M · Culpeper, VABuilt 1956 · S/N 22-3956N4804EPrestar Inc · Davis, CABuilt 1978 · S/N 17271665N4805GTidewater Flying Club Inc · Newport News, VABuilt 1979 · S/N 17273353N4805LPrunty Gregory A · Saint Peter, MNBuilt 1967 · S/N 28-4144N4805VBudulas Peter Panagiotis · Laurel, MDBuilt 1980 · S/N 172RG0384N4806AButler David B · Ipswich, MABuilt 1956 · S/N 22-3958N4806FSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496095N4806GStone Howard L · Pine Mountain, GABuilt 1979 · S/N 17273354N4806TGardner Robert · Dixon, CABuilt 1972 · S/N 28-7225207N4807DRussell Matthew D · Chattaroy, WAS/N 17272363N4807JNew England Aviation LLC · Plainville, CTBuilt 1979 · S/N 17273680N4807TAdams Kent C · Hubbard, ORBuilt 1972 · S/N 28-7225209N4807YMayes Noelle C · Williams, CAS/N 25-4555N4808DLmnb LLC · Centreville, VABuilt 1979 · S/N 17272364N4808FYankee Flying Club Inc · Maple Grove, MNBuilt 1979 · S/N 17273084N4808LGifford Jerald O · Idaho Falls, IDS/N 28-4147N4809LLuxl Frank S · Wilmington, DEBuilt 1967 · S/N 28-4148N4810ADecker Richard A · Onalaska, WABuilt 1956 · S/N 22-3962N4810GAndrecheck Cynthia R · Bethel, AKBuilt 1979 · S/N 17273358N4810LLove James Matthew Maynard · Brighton, MIBuilt 1967 · S/N 28-4149N4810UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842227N4811AJacobs Eric R · Bozeman, MTBuilt 1956 · S/N 22-3963N4811GPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1979 · S/N 17273359N4811JSeals Kenneth P · Munford, ALBuilt 1979 · S/N 17273681N4812LPalmer Xavier · Moreno Valley, CABuilt 1967 · S/N 28-4151N4812TBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 28-7225211N48130Estes Johnny C · Senoia, GABuilt 1976 · S/N 76N4813AVon Etten Robert P · Ravena, NYBuilt 1956 · S/N 22-3965N4813CCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276505N4813GBasso Michele · Millbrook, ALBuilt 1979 · S/N 17273361
Back to AD 80-04-03 R2