OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N469DKKimbrough Duke III · Rhome, TXBuilt 1984 · S/N 249N469JHHolland John R · Jacksonville, FLBuilt 1975 · S/N 645N469JJTesmer Dean D · Rio, WIBuilt 1989 · S/N 1809030N469NETauber Samara R · La Jolla, CAFirst renewal noticeBuilt 1983 · S/N 17275952N469TWEmge Douglas W · Albertville, ALBuilt 1989 · S/N 507N46AArcher Jimmy R · Houston, TXBuilt 2000 · S/N 002WBN46APMorris Christopher J · Crockett, TXBuilt 1963 · S/N 28-1203N46ATBurcar Mark L · Gig Harbor, WAS/N 1N46BEvans James · Tuolumne, CABuilt 1991 · S/N 1498N46DAPotts Timothy W · Oscoda, MIBuilt 1993 · S/N 1556N46DHMusgrave John R · Morris, ILS/N 369N46ETNicholson Jim · Cody, WYBuilt 2012 · S/N 8-6894N46FCCopeland Forrest H · Brentwood, CABuilt 2003 · S/N 60075N46FTSerrino Sam K · Youngstown, OHBuilt 2022 · S/N 002N46HCCammack Howard D · Centennial, COBuilt 2001 · S/N 11236N46HSBlackburn Aviation Air LLC · Mesa, AZS/N 3430N46HYCelli Consulting LLC · Stockton, CABuilt 2004 · S/N 2264N46JLWeaver Aviation LLC · Yucaipa, CABuilt 1975 · S/N 20-1169N46JWWerner John D · Pownal, VTBuilt 1969 · S/N 17257942N46MPAnderson Howard E · Luray, VABuilt 1983 · S/N 172RG1144N46RERocks Aero LLC · Carbondale, COBuilt 2000 · S/N 22600N46RSHixson Steven D · Longview, WAS/N 6-7/8N46TJLile John G · Iowa Park, TXBuilt 1998 · S/N 23030N46VCAltitude & Anchor LLC · Kalispell, MTS/N 3206N46YHDouglas Hiram P · Godley, TXBuilt 2025 · S/N 21026N46YMAircraft Partner Holdings Inc Trustee · BerlinBuilt 1992 · S/N 10026N4701LTrainor Jonathan P · Bridgewater, NJS/N 28-4014N47023Morey John Jack · Port Orange, FLBuilt 1977 · S/N 28-7890049N4702FSouthern Aces LLC · Geneva, FLBuilt 1979 · S/N 17273074N4703AStromberg Gary J · Medicine Lake, MTS/N 18-4918N4703LMaust Luke A · Accident, MDBuilt 1967 · S/N 28-4017N4705DN4705d LLC · Oklahoma City, OKS/N 17272335N4705LHorton Kelly · Hollis, OKBuilt 1967 · S/N 28-4019N4706DKelly William W · Springfield, ORBuilt 1979 · S/N 17272336N4706LKings Heir Inc · Kent, WABuilt 1967 · S/N 28-4026N4707ASherman Aviation Inc · Redmond, ORBuilt 1956 · S/N 18-4924N4707CSmith James A · Lyle, WABuilt 1955 · S/N 22-3291N4708AFranz Stanley · Yakima, WABuilt 1956 · S/N 18-4926N4708LAlexander Nicholas R · Oak Hill, OHBuilt 1967 · S/N 28-4027N47093Skipper Consulting LLC · Athens, ALBuilt 1942 · S/N 2N4709LJohannsen Michael R · Allen, TXBuilt 1967 · S/N 28-4028N4709RG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0013N470CBoese Jon D · Holloway, MNBuilt 1997 · S/N 2448N470FLBaker Brian K · Dayton, OHBuilt 1971 · S/N 28-7125271N470FSCustom Air International LLC · Homestead, FLBuilt 1973 · S/N 17262011N470HPBloch Christopher P · Grand Rapids, MIBuilt 1998 · S/N 2004N470KCColeman Keith T · Mukilteo, WAS/N 1491N470MAKek Companies Inc · Portland, ORBuilt 2000 · S/N 2105N4710LStuhmer Samuel K · Central City, NEBuilt 1967 · S/N 28-4029N4711JDoucet Joshua A · Cabot, ARBuilt 1966 · S/N MB-169
Back to AD 79-10-03 R2