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.

N418FLKinney Richard · West Des Moines, IABuilt 1971 · S/N 28-7125197N418RLChant Andrew P · San Francisco, CABuilt 2004 · S/N RG002N418SRegistered aircraftBuilt 2001 · S/N 60121N418SLLagergren Steven R · Litchfield, MNFirst renewal noticeBuilt 2011 · S/N 70419N418TJFive Star Family Aviation LLC · Yorkville, ILBuilt 1977 · S/N 28-7890086N418WKMenger Charles C Jr · Wills Point, TXBuilt 2002 · S/N 20735N41901Specht Gilbert E · Downs, KSBuilt 1974 · S/N 28-7405148N41904Gjertsen John W · Quincy, CABuilt 1974 · S/N 28-7425294N41905Rodgers Phillip L · Williford, ARBuilt 1974 · S/N 28-7415353N4190ZWinn Derek H · Joseph, ORBuilt 1966 · S/N 18-8374N4191JVillalba Raymond · Katy, TXBuilt 1966 · S/N 28-22531N4191PBerry Michael C · Stanfield, AZBuilt 1959 · S/N 23-1679N41927Budziejko David C · Williamsville, NYBuilt 1974 · S/N 28-7415360N4192XYoblinski Robert J · Boone, NCS/N 5192N4192YDragon Grass LLC · Nashua, NHS/N 966-77N4192ZSwanson Amos W · Palmer, AKBuilt 1966 · S/N 18-8379N41937Calumet Aero LLC · Crown Point, INBuilt 1974 · S/N 28-7415365N41940Moughty Matthew · New Haven, VTS/N 28R-7435228N41949Ferg Robert B · New London, WIBuilt 1974 · S/N 28-7425301N41954Up And Up Aviation LLC · Magnolia, TXBuilt 1974 · S/N 28-7415368N41963Schafer Gary L · Greenwood, DEBuilt 1974 · S/N 28-7425302N41966Wray Jimmy Don · White House, TNBuilt 1974 · S/N 28-7425303N41967Krog Steven L · Hartford, WIBuilt 1974 · S/N 28-7415370N41969Lazy 8 Aviation LLC · Arden, NCBuilt 1974 · S/N 28-7415371N4196PHarmon Aviation LLC · Exeter, NHBuilt 1959 · S/N 23-1684N41973Legacy Aviation LLC · Murfreesboro, TNS/N 28-7405155N41977Augusti Group Enterprises Inc · Clayton, NCBuilt 1974 · S/N 28-7415375N41978Henderson Jason E · Corona, CABuilt 1974 · S/N 28-7415376N4197ZBurns Barry D · Amarillo, TXS/N 18-8389N41980Warren Donald E · Pine Bluff, ARBuilt 1974 · S/N 28-7415377N41983Brotherman LLC · Hereford, TXBuilt 1974 · S/N 28-7415379N41985Aerospace Systems And Training LLC · Orange City, FLBuilt 1974 · S/N 28-7405157N4198BAero Flight Flying Club · Minneapolis, MNBuilt 1959 · S/N 23-1687N4198FRal Aviation LLC · Trumbull, CTBuilt 1976 · S/N 28-7790006N4198ZMcfarlane Bradley J · Port Alsworth, AKBuilt 1966 · S/N 18-8391N41992Stein Anthony J · Locust Grove, GABuilt 1974 · S/N 28-7415380N41995Columbus State Community College · Columbus, OHFirst renewal noticeBuilt 1974 · S/N 28-7415382N4199JHallenbeck Jesse · Bellingham, WAS/N 28-22543N4199ZSymanowski Kevin · Reeder, NDBuilt 1966 · S/N 18-8392N419DTurner Spencer A · Modesto, CABuilt 1995 · S/N 20419N419DMNote Clayton R · Eagle Point, ORBuilt 2003 · S/N 442-2003N419FKlenoski Brian D · Fulton, MIBuilt 2000 · S/N 22690N419LKSluka Christopher · San Diego, CABuilt 1978 · S/N 17271787N419SGilpin Nathan L · Cornelia, GAS/N 419-SN419SFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17262659N419TEEp Enterprises Inc · San Juan, PRS/N 20-0039N419WAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1995 · S/N 2843001N41AMStephens Calvin · Adrian, GABuilt 1974 · S/N 17262980N41APRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268890N41AWWalker James A · Birmingham, ALBuilt 1966 · S/N 28-21385
Back to AD 79-10-03 R2