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.

N6011GRose Michael · Buckingham, PABuilt 1969 · S/N 15071511N6011RElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1965 · S/N 17253680N60121Flight Tech Inc · Arlington, WAS/N 15070084N60122Quintana Ortiz Nelson · Humacao, PRBuilt 1968 · S/N 15070085N60123Long Jarod H · Satsuma, ALS/N 15070086N60127Stagner Sanchez Viridiana · San Antonio, TXBuilt 1968 · S/N 15070090N60128Harvey Timothy J · Cadott, WIBuilt 1968 · S/N 15070091N6012ASundsmo Sheldon L · Adams, WIBuilt 1956 · S/N 28612N6012GStepp Dave · Ruidoso, NMBuilt 1969 · S/N 15071512N6012TNgungi Andrew M · Haysville, KSBuilt 1964 · S/N 15060712N6012U6012u LLC · Union Gap, WABuilt 2006 · S/N 172S10168N6012ZChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10150N60130Hoffman Matthew T · Topeka, KSS/N 15070093N60134Smith Eddie D · Wasilla, AKBuilt 1973 · S/N U20602011N60138Clearwater Air & Auto Museum · Batavia, OHBuilt 1968 · S/N 15070099N60139Jones John P · Great Meadows, NJBuilt 1968 · S/N 15070100N6013BFrost Sean D · Lovell, WYS/N 21062664N6013JAerodrome LLC · Louisville, KYBuilt 2006 · S/N 172S10153N6013KLdm LLC · Cuba, MOBuilt 2006 · S/N 18281795N6013SStomio LLC · Covina, CABuilt 2006 · S/N 18281797N6013VFlynn James H Jr · Saratoga Springs, NYBuilt 2006 · S/N 18281798N60142Porter Herbert H · 100 Mile HouseBuilt 1968 · S/N 15070101N60143H2 Link Company · Lewes, DEBuilt 2008 · S/N 172S10142N60146Speer Henry A · Farmington, ARBuilt 1968 · S/N 15070103N6014BHardy Bradley D · Tulsa, OKBuilt 1961 · S/N 18051052N6014RInspire Wing LLC · Middletown, MDBuilt 1965 · S/N 17253683N6014TRodriguez Richard · Indianapolis, INS/N 15060714N60155Jls Aviation LLC · Sarasota, FLBuilt 2006 · S/N 172S10167N6015GDoctorian David S · Macon, MOS/N 15071515N6015RPetersen Ryan W · Arlington, WABuilt 1965 · S/N 17253684N6015TBellinger Joseph C · Waterloo, INS/N 15060715N60160Iosco Flying Club · E Tawas, MIFirst renewal noticeBuilt 1968 · S/N 15070114N60161Pipes George A II · Rolla, MOBuilt 1968 · S/N 15070115N60163Metler Mark A · Summerville, SCBuilt 1968 · S/N 15070116N60167Smith Kevin · Weaverville, NCBuilt 1968 · S/N 15070118N60168Austin James H · Easley, SCBuilt 1968 · S/N 15070119N6016AHolt Amanda · Grangeville, IDS/N 28616N6016GWahl Gust K · Dillingham, AKBuilt 1969 · S/N 15071516N6016JPatterson Roland O · Semmes, ALBuilt 1971 · S/N A1500316N6016RCosse Harold C · Vacaville, CABuilt 1965 · S/N 17253685N6016TStone Isaac L · Cushing, MNBuilt 1964 · S/N 15060716N60172Mchugh-Lemasteers Ronna · Salem, ORS/N 15070122N60173Skypark Inc · Wadsworth, OHBuilt 1968 · S/N 15070123N60174Pham Hieu · Goodyear, AZBuilt 1968 · S/N 15070124N60175Strange William H · Lewiston, IDFirst renewal noticeBuilt 1968 · S/N 15070125N60177Kelley Robert D · Barstow, CABuilt 1969 · S/N 15070126N60179Steen Jason D · Clark, SDBuilt 1968 · S/N 15070127N6017ARidgeway Daniel M · Kalama, WAS/N 28617N6017BBarrett Daniel E · Augusta, MTBuilt 1957 · S/N 34017N6017LAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10170
Back to AD 79-10-14 R1