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.

N172TBBelli Paul · Philadelphia, TNBuilt 1970 · S/N 17259584N172TCMeweber Consulting Inc · Atlanta, MIBuilt 1976 · S/N 17266662N172TDSoule Clauson D · Cooperstown, NYBuilt 1970 · S/N 17258939N172THDairy Air Inc · Wyoming, PABuilt 1972 · S/N 17261033N172TKRhinelander Flying Service Inc · Rhinelander, WIBuilt 1978 · S/N 17270406N172TLRegistration Pending · Katy, TXRegistration pendingBuilt 1977 · S/N 17269706N172TRSkoglund David L · Jamul, CAS/N 17269899N172TSVero Technical Support Inc · Pensacola, FLBuilt 1974 · S/N 17264582N172TXD & L Innovations LLC · Hendersonville, TNS/N 17271027N172UCEndeavour Flight Training Inc · Opa Locka, FLBuilt 1978 · S/N 17271911N172UFR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273703N172UZMp Aviation LLC · Ogden, UTBuilt 1980 · S/N 17274011N172VFish Air Aviation LLC · San Diego, CABuilt 1985 · S/N 17276469N172VFVictor Foxtrot LLC · Scott City, KSBuilt 1975 · S/N 17265334N172VKKatula Gerard · Pawleys Island, SCBuilt 1968 · S/N 17257009N172VTFly Vermont LLC · Swanton, VTS/N 17263231N172WLaraux Arthur · Bethel, AKBuilt 1971 · S/N 17260099N172WAHandrop Ronald S · Bonita, CABuilt 1979 · S/N 17273507N172WBTumbleweed Leasing Company Inc · Salt Lake City, UTBuilt 1978 · S/N 17270907N172WEEl Aero Services LLC · Elko, NVBuilt 1975 · S/N 17265192N172WJBlue Skies Flight Training LLC · Gainesville, FLBuilt 1972 · S/N 17260906N172WLLeveille Wade P · Douglas, MABuilt 1975 · S/N 17265300N172WMChaves Roosevelt Jr · Fontana, CAS/N 17275539N172WPAviair LLC · Wilmington, NCBuilt 1973 · S/N 17262635N172WRWind River Aviation LLC · Lawton, OKBuilt 1981 · S/N 17275113N172WSWoodstock Air LLC · Cincinnati, OHBuilt 1973 · S/N 17261328N172WTTison William A Jr · Boynton Beach, FLS/N 17266400N172WWStraight And Level Seaplanes LLC · Grand Island, FLBuilt 1976 · S/N 17267445N172YNewton Michael R · Creston, WABuilt 1974 · S/N 17263360N172YACf Images LLC · Fairfield, NJBuilt 1981 · S/N 17275080N172YHWild River Flying Club · Saint Croix Falls, WIBuilt 1979 · S/N 17271130N172YYApr Aviation · Fresno, CABuilt 1974 · S/N 17263986N172ZMoss Mark A · El Dorado, CABuilt 1969 · S/N 17258726N1730PHolbrook Jonathan L · Morehead, KYS/N 22-2520N1731JRiverside Exteriors Inc · Post Falls, IDBuilt 1968 · S/N 28-24144N1731PLambert Wayne C · Canyon Lake, CABuilt 1954 · S/N 22-2521N17324Macair Aviation LLC · Xenia, OHBuilt 1979 · S/N 287916050N17325Hoover Frank W · Destin, FLBuilt 2000 · S/N 80019N1732JWyatt Roger G · Midlothian, VAS/N 28-24145N1732TGlasgow Construction Company Inc · Guin, ALBuilt 1971 · S/N 28-7125418N1732VElk & Ram Aviation Group LLC · San Antonio, TXBuilt 1974 · S/N 17263729N1733JProkop Gregory P · Cambridge, MNS/N 28-24147N1734HIndian Hills Community College · Ottumwa, IABuilt 1977 · S/N 28-7716048N1734TTaylor David V · Clinton, NCBuilt 1970 · S/N 28-7125050N1736PRegistered aircraftBuilt 1954 · S/N 22-2526N1736TN1736t LLC · Lake Point, UTBuilt 1970 · S/N 28-7125052N1737High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17265682N1737ARegistration Pending · Bulverde, TXRegistration pendingBuilt 1964 · S/N 28-1540N1737TN1737t LLC · West Palm Beach, FLBuilt 1970 · S/N 28-7125054N1737VWatson Patrick D · Kenyon, MNBuilt 1974 · S/N 17263732
Back to AD 79-10-03 R2