OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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.

N17324Macair Aviation LLC · Xenia, OHBuilt 1979 · S/N 287916050N17325Hoover Frank W · Destin, FLBuilt 2000 · S/N 80019N1732JWyatt Roger G · Midlothian, VAS/N 28-24145N1732TGlasgow Construction Company Inc · Guin, ALBuilt 1971 · S/N 28-7125418N1732VElk & Ram Aviation Group LLC · San Antonio, TXBuilt 1974 · S/N 17263729N1733JProkop Gregory P · Cambridge, MNS/N 28-24147N1734HIndian Hills Community College · Ottumwa, IABuilt 1977 · S/N 28-7716048N1734TTaylor David V · Clinton, NCBuilt 1970 · S/N 28-7125050N1736PRegistered aircraftBuilt 1954 · S/N 22-2526N1736TN1736t LLC · Lake Point, UTBuilt 1970 · S/N 28-7125052N1737High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17265682N1737ARegistration Pending · Bulverde, TXRegistration pendingBuilt 1964 · S/N 28-1540N1737TN1737t LLC · West Palm Beach, FLBuilt 1970 · S/N 28-7125054N1737VWatson Patrick D · Kenyon, MNBuilt 1974 · S/N 17263732N1738JPiper 38j LLC · Buckeye, AZBuilt 1968 · S/N 28-24153N1738TClinton 83 Aviation LLC · La Place, LAS/N 28-7125055N1739JSahli Theodore E · Costa Mesa, CABuilt 1968 · S/N 28-24154N1739TWatkins Felton III · Meridian, MSBuilt 1970 · S/N 28-7125056N173BADunlap Jolene · Peoria, ILBuilt 1979 · S/N 17272370N173EFEliason James T · Prescott, AZBuilt 2002 · S/N 5298N173KADaigle Lawrence J · Cohasset, MNBuilt 1972 · S/N 17260939N173KMLd Enterprises Llp · Roswell, GABuilt 1968 · S/N 17257781N173PFRegistered aircraftBuilt 1997 · S/N 946N173PKTrc-4k Investments LLC · Southlake, TXBuilt 1968 · S/N 17257364N173PWSunspot Meadow LLC · Cloudcroft, NMBuilt 2004 · S/N 1362-2004N173VALegner Leasing LLC · Las Vegas, NVBuilt 1971 · S/N 172-60090N173YAHoekman Kenneth J · Sherwood, ARBuilt 1980 · S/N 17274191N1741JReynolds David Hays J · Ariton, ALS/N 28-24157N1741PWright Russell W · Ocala, FLBuilt 1954 · S/N 22-2531N1742VGalion Air Inc · Galion, OHBuilt 1974 · S/N 17263735N1743JRomualdi Giovanni · Torrance, CABuilt 1968 · S/N 28-24159N1743VRegistered aircraftBuilt 1974 · S/N 17263736N1745TStoffer Aviation LLC · Marion, INBuilt 1970 · S/N 28-7125063N1746THessing Dale C · Eagle, IDBuilt 1970 · S/N 28-7125064N1747JCromwell James A · Little Rock, ARBuilt 1968 · S/N 28-24165N1747TErickson Carrian Brooke · Overland Park, KSBuilt 1970 · S/N 28-7125065N1748JHaywood Aviation & Salvage LLC · Atlanta, TXBuilt 1968 · S/N 28-24167N1748PHarbison Robert L · Willow, AKBuilt 1954 · S/N 22-2539N1748TBallard George M · Mchenry, ILBuilt 1970 · S/N 28-7125066N1749TCollier Tony · Grayson, KYBuilt 1970 · S/N 28-7125067N1749VVance Nicholas D · Bluffton, OHS/N 17263737N174DCAire Services LLC · Barrigada, GUBuilt 1980 · S/N 28-8190085N174FVy Holdings LLC · Scottsbluff, NES/N 28-854N174HAKlin Trin Collectibles LLC · Downers Grove, ILS/N 17272235N174JRyan Aviation LLC · Forest Hills, NYBuilt 1974 · S/N 28-7405193N174JLHall Brent Dtrustee · Gilbert, AZBuilt 2005 · S/N 71103N174JPGeary Michael Fredrick · Seguin, TXBuilt 1971 · S/N 17259850N174PCMeyer Brian A · Milwaukie, ORBuilt 1973 · S/N 28-7425187N174RAWelke Gregory E · Chippewa Falls, WIBuilt 2005 · S/N 1390-2005N174RCCarsey Rick · Fowler, CAS/N 576-73
Back to AD 80-04-03 R2