OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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:79-10-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:79-10-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.

N1738JPiper 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-73N1750JBlackwood Aldon · Baltimore, MDBuilt 1968 · S/N 28-24169N1750PWeinreis Gene · Golva, NDBuilt 1954 · S/N 18-4069N1750TVan Strand Investments LLC · Fruita, COBuilt 1970 · S/N 28-7125068N1751JColvin Vernon H II · Warren, ARS/N 28-24170N1751TLasko C Peter · North Ft Myers, FLBuilt 1970 · S/N 28-7125069N1752PPurdy Ranch LLC · Buffalo, WYBuilt 1954 · S/N 18-4072N1754PLorring Eric H · Kodiak, AKS/N 18-4074N1754VAviation Specialist Inc · Apison, TNBuilt 1974 · S/N 17263739N1755PBryan Edgar A II · North Pole, AKS/N 18-4075N1756JLitzenberger Troy A · Wrightwood, CABuilt 1968 · S/N 28-24175N1757MAdventurous LLC · Hayden, IDBuilt 1957 · S/N 18-6009N1757PJolin Mitchell S · Eagle River, AKBuilt 1954 · S/N 18-4077N1758TRikhy Sudeep Singh · Los Gatos, CABuilt 1970 · S/N 28-7125076N1758VKrickhahn Kermit O · Marion, TXBuilt 1974 · S/N 17263740
Back to AD 79-10-03 R2