AD 79-10-14 R1

Registered aircraft · 56,582

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-14-R1')
    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-14-R1')
  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.

N7669GWingsleasing LLC · Wichita, KSBuilt 1970 · S/N 17259369N7669M95 Contracting LLC · Leander, TXBuilt 1959 · S/N 55969N766CPCity Of Cleveland · Cleveland, OHBuilt 1975 · S/N 172-66326N766EETomaszewski John E · Oceanside, CABuilt 1970 · S/N 18260217N766MHoddenbach Jim · Woods Cross, UTS/N 18501795N766PDTexas State Technical College · Waco, TXBuilt 2000 · S/N 172S8419N766SPMaxxum Financial Group Inc · Destrehan, LABuilt 2001 · S/N 172S8699N766TWBarr Air Patrol LLC · Mesquite, TXBuilt 1980 · S/N 17274134N766VNCagle Jonathan D · Mobile, ALBuilt 1957 · S/N 34561N7670GPremier Aviation LLC · Philadelphia, MSBuilt 1970 · S/N 17259370N7670UMatthews Christopher T · Gardnerville, NVS/N 15077796N7670XLohrke James W · Converse, TXBuilt 1960 · S/N 17248170N7671MWarren Robert Scott · Harrisburg, NCBuilt 1959 · S/N 55971N7671XBernsen Timothy Stephen · Devine, TXS/N 17248171N7672ATram Enterprises LLC · White, GAS/N 32569N7672XFlying Couch LLC · Orleans, MABuilt 1961 · S/N 17248172N7673GSchaack Lawrence A · Woods Cross, UTBuilt 1970 · S/N 17259373N7673TDunning Steve G · Assaria, KSBuilt 1960 · S/N 47273N7673XDunham Randy C DBA · Lawton, OKBuilt 1960 · S/N 17248173N7674KToms Robert G · Holly, MIS/N 18052698N7674MMezzell James H · Cullman, ALBuilt 1959 · S/N 55974N7674TDugger Robert F · Ashville, ALBuilt 1960 · S/N 47274N7674UBischoff Daniel C · Camano Island, WAS/N 15077800N7675GHalopoff Guy · Oroville, CABuilt 1973 · S/N 15074713N7675TClegg Peter M · Grace, IDS/N 47275N7675UWaite Trevor K · South Ogden, UTBuilt 1976 · S/N 15077801N7675XEstes Jerry L · Lewisville, ARBuilt 1960 · S/N 17248175N7676GPalmer Michael C · Emmett, IDBuilt 1970 · S/N 17259376N7676MWhite Hawk Leasing LLC · Chapel Hill, NCS/N 55976N7676TNickerson David W · East New Market, MDBuilt 1960 · S/N 47276N7676URhine Steven L · Vancouver, WABuilt 1976 · S/N 15077802N7677UOrser Shana J · Kissimmee, FLBuilt 1976 · S/N 15077803N7678AHenderson William H Trustee · Eagle River, AKBuilt 1956 · S/N 32575N7678GTanner Michael J · Hooksett, NHS/N 17259378N7678XSandstone Point Cattle Co LLC · Seguin, TXBuilt 1960 · S/N 17248178N7679GShipp-Hove Kylan · Mesa, AZBuilt 1970 · S/N 17259379N7679MRothgeb Michael A · Burns, ORBuilt 1959 · S/N 55979N7679UDebenedetto John · Northwood, NHBuilt 1976 · S/N 15077805N767CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282120N767CDTyler Flyers Inc · Tyler, TXBuilt 1979 · S/N 17273607N767CGMindy Limited LLC · Muscatine, IAS/N 17269309N767CLMls Aviation LLC · Yorba Linda, CABuilt 2005 · S/N 172S9987N767CRAtp Aircraft 2 LLC · Wilmington, DEBuilt 2005 · S/N 172S10021N767GEGreystoke Leasing Inc · Flagstaff, AZBuilt 2009 · S/N 20608317N767HRDg Upshaw LLC · Wilmington, DEBuilt 1998 · S/N 18280349N767KTStitch And Purl LLC · Sparks, NVBuilt 1998 · S/N 18280197N767LRegistered aircraftBuilt 2002 · S/N 18281122N767MTDouglas Machinery LLC · Saint Francis, SDBuilt 2000 · S/N 18280755N767RAClear Prop Aero Inc · Webster, MNBuilt 1959 · S/N 47078N767RSRegistered aircraftBuilt 1958 · S/N 51140
Back to AD 79-10-14 R1