AD 79-08-06

Registered aircraft · 5,263

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-08-06')
    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-08-06')
  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.

N112CPBradley Aviation LLC · Columbus, INBuilt 2001 · S/N 18062CN112WSEdgeington Randall K · Riverton, WYBuilt 1961 · S/N 24-2765N113CJMarshall Joshua · Chuckey, TNBuilt 1979 · S/N R18201076N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226N11402Mcdowell Charles R II · South Charleston, WVBuilt 1973 · S/N 15075391N114CGUnited Aviation LLC · Whitehall, PABuilt 1995 · S/N 14628N114ERIhle Edward A · Elmendorf, TXS/N 0879N114WMMaule Flight LLC · Nashville, INBuilt 2001 · S/N 25058CN114XTaft Plumbing Co Inc · Taft, CABuilt 1961 · S/N 24-2698N11541Upskirt Aviation LLC · Fredericktown, MOS/N R18201914N1161XBarnett Donald R · Atoka, TNBuilt 1975 · S/N 32-7500040N116BKDacy Roy W · Rockport, TXS/N 32-782N1177XParrish View Farms · Kenbridge, VABuilt 1975 · S/N 28-7510086N1188NLll Aviation LLC · Durango, COBuilt 1978 · S/N R18200538N118SGWilt Jared · Gardners, PABuilt 1977 · S/N R18200115N11CVStoots Christa M · Tucson, AZS/N 24-4130N11LYBishop Jay K · Columbus, INBuilt 1964 · S/N 28-10535N11TDDuflo Spray Chemical Inc · Lowville, NYBuilt 1960 · S/N 27-271N120SGlenn Robert · Boulder, COBuilt 1958 · S/N 24-125N12134Everson Corey A · Madison, ALBuilt 1964 · S/N 24-3598N121DWFlight World Inc · San Juan, PRBuilt 1972 · S/N 312N121SClark William H IV · Thurmont, MDBuilt 1966 · S/N 32-835N1223Munning Joseph H Md · Jasper, INBuilt 1961 · S/N 24-2906N122CPFlorida Seaplanes LLC · Altamonte Springs, FLBuilt 2001 · S/N 18064CN122KYSeminole Flying & Soaring Inc · Clermont, FLBuilt 1968 · S/N 25-4576N122MWWalker Kyle E · Lawrence, KSBuilt 1979 · S/N R18201276N1239PPinellas Pilots Association Inc · Clearwater, FLS/N 28-7911207N123HMComanche Air LLC · Mokena, ILBuilt 1961 · S/N 24-2912N123MFAronhalt Daniel E · Columbus, INBuilt 1968 · S/N 32-1069N123TXGofly Corporation · Port Ewen, NYBuilt 1968 · S/N 28-11108N1246TRegistration Pending · Fort Mc Coy, FLRegistration pendingBuilt 1972 · S/N 32-7200034N124HKDavid A Desimone LLC · Newnan, GAS/N R18201621N124MARobison Ronald D · Idaho Falls, IDBuilt 1978 · S/N R18200627N1255SSmith David J · Broken Arrow, OKBuilt 1979 · S/N R18201279N125KCOtto Pilot Aviation LLC · Midland City, ALBuilt 1982 · S/N R18201805N125LARussell Aviation LLC · San Diego, CAS/N R18201012N125YDsr-Cherokee 180 LLC · Dallas, TXFirst renewal noticeBuilt 1963 · S/N 27-2366N126CMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 25094CN12828Fulwiler Air LLC · Green Bay, WIBuilt 1961 · S/N 3023N12BEElliott Russell R · Wasilla, AKS/N 7082CN12JLGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 27-404N12RDFlying Colors Airparts Inc · Leesburg, FLBuilt 1958 · S/N 24-368N130GHBose Tamal · Tucson, AZBuilt 1965 · S/N 32-124N1316NCox Kevin J · Harrison, IDBuilt 2013 · S/N 96-185/186-1077N131ABPlane And Simple Leasing LLC · Delano, MNBuilt 1965 · S/N 25-3693N131JLIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1970 · S/N 225N132HMMichels Agribusiness Inc · Plentywood, MTBuilt 1978 · S/N R18200844N1331LFirst Response Anesthesia Inc · Washington, UTBuilt 1979 · S/N 28-7911074N1333PJones Robert Conrad · Seeley Lake, MTBuilt 1979 · S/N R18200875N133JDSwick James N · Celina, TXBuilt 1970 · S/N S2
Back to AD 79-08-06