OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N949MDUnruh Leasing LLC · Blossom, TXBuilt 1973 · S/N 21059889N949RVVan Wagenen Stanley Keith Trustee · Las Vegas, NVBuilt 2003 · S/N 90369N949SMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 172RG0713N949TEBarron Wesley Thomas · Port Orange, FLBuilt 2003 · S/N 10228N949WParrish Shawn J · Great Falls, MTBuilt 2010 · S/N 90467N949WCCampbell Weldon W · Great Bend, KSBuilt 1997 · S/N 23469N94ABMiller Paul · El Dorado Springs, MOBuilt 1994 · S/N 21923N94BSMcdonnell John T · Yardley, PABuilt 1989 · S/N 2N94CPAhlhorn Travis Wayne · New Braunfels, TXBuilt 1979 · S/N 17273150N94DBFox Joseph L · Ocean City, NJBuilt 1983 · S/N 362N94DGGreen Daryl K · Grove City, OHBuilt 2005 · S/N 21507N94DLWhiskey November Aviation LLC · Minneapolis, MNBuilt 1973 · S/N 28-7415076N94ERHill Andrew T · Smithville, TXBuilt 1983 · S/N 17276053N94FDBeaver Jonathan D · Greensboro, NCBuilt 2002 · S/N 81243N94GCCook Gregory L · Carl Junction, MOBuilt 1994 · S/N 20020CN94HFDefenbaugh Matthew J · Biggsville, ILBuilt 1979 · S/N 1153-79N94HJGable Taylor Lee · Nicholson, GABuilt 1975 · S/N 17265633N94HUTronstad John L · Baker, MTBuilt 1994 · S/N 1260N94HWLach John F · Warren, OHBuilt 2002 · S/N 90045N94HYWest Metro Aviation LLC · Buffalo, MNBuilt 2005 · S/N 2297N94KBBaker Bryn M · Clinton, UTBuilt 2000 · S/N 23929N94KDSprik Robert J · Hamilton, MIBuilt 1995 · S/N KD-03N94KWHine Garrett Christopher · Panama City Beach, FLBuilt 1994 · S/N 19026CN94LBWhetzel Russell R · Milford, NJBuilt 1994 · S/N 19029CN94LESky Path N94le LLC · Carmel, INBuilt 1993 · S/N 20776N94LJFrostenson Bobi J · Fairfield, IDBuilt 1986 · S/N 218N94SBBernatz Gerald F · Highland, ILBuilt 1994 · S/N 22194N94SJMoe Alan D · North Bend, ORBuilt 1988 · S/N 01N94TSPetersen Andrew John · Saint Paul, MNS/N 17259814N94VFPenhorwood Joshua M · Shubuta, MSBuilt 1994 · S/N 809N94WDRegistration Pending · Sugar Grove, ILRegistration pendingS/N 1849N94WGAltruda Thomas Joseph · Las Vegas, NVBuilt 2005 · S/N 4273N94XTaylor Samuel R · Kenai, AKBuilt 1962 · S/N 18-7858N95008Ottaway Brent E · Derby, KSBuilt 1969 · S/N 28-25775N9500DFlight Club LLC · Anchorage, AKBuilt 1958 · S/N 22-6415N9500JMidwest Air Freight LLC · Sioux City, IABuilt 1966 · S/N 28-3620N9500LAtlantic Aero Club Inc · Newark, DEBuilt 1972 · S/N AA5-0100N9500WRachel Calvin · Kimberly, ALS/N 28-22921N9501DBelof Joshua · Franklin, NCBuilt 1958 · S/N 22-6416N9501JKnutson Donald W · Litchfield, MNBuilt 1966 · S/N 28-3621N9502BGraceffa Salvatore · Atascadero, CABuilt 1981 · S/N 172RG0839N9502HYoung Roger A II · Wasilla, AKFirst renewal noticeBuilt 1975 · S/N 17266182N9502WHellevang Ryan K · Duvall, WAS/N 28-22924N9503DHardison Allan · Castle Rock, COS/N 22-6418N9503WLoya Armando · Whittier, CAS/N 28-22925N95044Mach Point Two Aviation LLC · Conroe, TXBuilt 1969 · S/N 28-25783N9504DWilliams Jimmy Z · Sherman, TXBuilt 1958 · S/N 22-6419N9504HPatterson Clifford Wayne · Murphy, TXBuilt 1975 · S/N 17266184N9504WS&J Aviation LLC · Burlington, WABuilt 1967 · S/N 28-22926N95053Jamesweathers Robi J · Blaine, MNBuilt 1969 · S/N 28-25788
Back to AD 79-10-03 R2