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.

N74968Niesen Isaac W · Nikiski, AKBuilt 1976 · S/N 18-7709045N7496DLeggett Brandon · Eola, TXBuilt 1957 · S/N 18-5837N7496PS & S Air Inc · Wilmington, DEBuilt 1961 · S/N 24-2691N74979Johnson Warren E · Kenai, AKBuilt 1975 · S/N 18-7509109N7497PLift Aircraft LLC · Carmel, INBuilt 1961 · S/N 24-2692N74990Berry Stanley W · Reddick, FLBuilt 1975 · S/N 18-7509111N74996Seward Air Taxi LLC · Seward, AKBuilt 1975 · S/N 18-7509112N74998White Jacob E · Delta Junction, AKBuilt 1975 · S/N 18-7509106N7499PTri-C Farms · Tompkinsville, KYBuilt 1961 · S/N 24-2696N7499RCart Caleb L · Eunice, LAS/N 28-22054N7499WWoodward Adam B · Fort Collins, COBuilt 1963 · S/N 28-1412N749DWAntler Aviation And Wildlife Service LLC · Wasilla, AKBuilt 1946 · S/N 12-1403N749MCWilliams Rodger Gale · Broseley, MOBuilt 1974 · S/N AA5 0626N749SKOcean Aerial Ads Inc · Berlin, MDBuilt 1974 · S/N 127-75N749VWGenet David S · Saint Augustine, FLBuilt 1971 · S/N 15N74ABAerial Digital Images LLC · Huntington Beach, CABuilt 1959 · S/N 23-1656N74ALDavis Tessie · Buckeye, AZBuilt 1974 · S/N 15075510N74BFSellers Jim M · Watkinsville, GABuilt 1995 · S/N 2274N74CPersonal Aviation Inc · Poway, CABuilt 1978 · S/N 17270368N74CNBuckley Scott · Orcutt, CABuilt 1984 · S/N 201N74DBSanderson Bryan D · Eagle, IDBuilt 1981 · S/N 100N74DJWood Shawn A · Cassville, WIBuilt 2002 · S/N 90181N74DMT C Rian Association LLC · Grove, OKBuilt 1973 · S/N 17262699N74DNMooney Daniel P · Edmond, OKBuilt 1998 · S/N 20211N74ERSimplifly LLC · Mesa, AZBuilt 1977 · S/N 17269502N74FAMangelsdorf David M · Raton, NMBuilt 1992 · S/N 513N74HPRoberts Joseph F · Bell Buckle, TNBuilt 2003 · S/N NF0003N74HYRegistration Pending · Roundup, MTRegistration pendingBuilt 2000 · S/N 2070N74JJWard Ralph G · Parrish, FLBuilt 1974 · S/N 1071-GT-1N74JPGulf Coast Helicopters Inc · Pearland, TXBuilt 1974 · S/N 17263356N74KLMccoy Mark C · Ocoee, FLBuilt 1990 · S/N 201N74LPMendota Flyers LLC · Middleton, WIBuilt 1968 · S/N 28-25196N74MHRichmond Wheeler LLC · Marshfield, WIBuilt 1974 · S/N 28-7415465N74MRRubbert Jan Dale · Upham, NDBuilt 1974 · S/N 18-7409145N74PESkycrafters Incorporated · Johnson City, TNBuilt 1973 · S/N 17262191N74PPBunnell Randy D · Blakesburg, IABuilt 1968 · S/N 17700928N74SRGodwin David P · Bryan, TXS/N 280N74STRybczynski Douglas R · Chandler, AZBuilt 1994 · S/N 1506N74THDe Gracia Jack P · Orlando, FLBuilt 1966 · S/N 28-22308N74TLLombardi Thomas C · Camp Verde, AZBuilt 2016 · S/N 73082N74TXPhillips John R · Tucson, AZBuilt 1994 · S/N B9N74WBJefferies Eric · Weatherford, TXBuilt 1975 · S/N AA5A-0025N74WFWeber Stephen J · Hastings, MNBuilt 1965 · S/N 18-8302N74WRPrecision Millwright & Machine Inc · Villa Park, ILBuilt 1974 · S/N 28-7415458N74XRundell Lanny · Winnsboro, LABuilt 1980 · S/N MII-622N75005Spiesman William J · Austin, TXBuilt 1976 · S/N 28-7690279N7500DRiggin Flight Service Inc · Madison, SDBuilt 1957 · S/N 22-5227N7500RSzymanski Tadeusz C · Fort Myers, FLBuilt 1966 · S/N 28-22055N7500WGajewski Richard G · Naples, FLBuilt 1963 · S/N 28-1413N7501FStafford Tech Inc · Rehoboth, MABuilt 1969 · S/N 204
Back to AD 79-10-03 R2