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.

N8973VOcean Flyers LLC · Chatham, NJBuilt 1974 · S/N 17264329N8974BWaller Steven M · Sterling, COBuilt 1958 · S/N 36674N8974GPike Vincent I · Bagdad, AZBuilt 1970 · S/N 18260514N8974SRegistration Pending · Bentonville, ARRegistration pendingS/N 15062274N8974XHarris Warren R · Mccleary, WABuilt 1960 · S/N 18253374N8975VMauser James E · Zionsville, PABuilt 1974 · S/N 17264331N8976GTeeray LLC · Mountain City, TNBuilt 1970 · S/N 18260516N8976SHattaway Laura C · Rossville, GABuilt 1965 · S/N 15062276N8976TKumm John J · Clarkston, WABuilt 1960 · S/N 52876N8977TAllsup Delmar D III · Oakhurst, CABuilt 1960 · S/N 52877N8979SFurtadobradley D · Lodi, CAS/N 15062279N8979TNardi Patty K · Missoula, MTFirst renewal noticeBuilt 1960 · S/N 52879N8979VAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17264335N897AFAmeriflyers Of Texas Inc · Addison, TXS/N 172S13543N897AHAerospace Asset Holdings LLC · Wilmington, DES/N 21064163N897CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282395N897EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12689N897LPMarcus Air LLC · Plano, TXBuilt 2001 · S/N 172S8897N897SMDomich Jeffrey E · Petaluma, CABuilt 2011 · S/N 18282309N8980TN8980t LLC · Dallas, TXS/N 52880N8980VSweitz-Air Inc · Stewartstown, PAS/N 17264336N89811Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1983 · S/N 17276013N8981TCharlie Tango LLC · Rapid City, SDBuilt 1960 · S/N 52881N8981XBales Philip J · Chandler, AZBuilt 1961 · S/N 18253381N8982TLarson Lynn R · Casselton, NDBuilt 1960 · S/N 52882N8982VHirsch John K Trustee · Gerald, MOBuilt 1974 · S/N 17264338N8983BMcguire Zach T · Jasper, MOBuilt 1958 · S/N 36683N8983VMoon Reagan E · Bossier City, LABuilt 1974 · S/N 17264339N8984BWhelchel Neil E · Joshua Tree, CABuilt 1958 · S/N 36684N8984XSkydive Florida Keys Inc · Summerland Key, FLBuilt 1961 · S/N 18253384N8985SOrganization Of Black Aerospace Professionals · Westchester, ILBuilt 1965 · S/N 15062285N8985TDonald V Johns Jr · Rush, COS/N 52885N8985XHill Jack · New Lenox, ILS/N 18253385N8986SSchneider Jackson L · Florissant, MOBuilt 1965 · S/N 15062286N8986UJmt Aviation LLC · Bel Air, MDBuilt 1976 · S/N 15078036N8986VAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17264342N89878Corwin Shawn M · Tucson, AZBuilt 1983 · S/N 17276015N8987BHoover Rowdy L · Owasso, OKBuilt 1958 · S/N 36687N8987TPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1960 · S/N 52887N8987VPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1974 · S/N 17264343N8988UQuestair LLC · Madison, MSBuilt 1976 · S/N 15078038N8988VWahle Daniel C · Missoula, MTBuilt 1974 · S/N 17264344N8989MSkymaster Mods & Parts LLC · Castalian Springs, TNS/N P3370101N898AHAerospace Asset Holdings LLC · Wilmington, DES/N 207-00123N898BPetropulos James J · Juneau, AKBuilt 1973 · S/N 18262080N898BHPompa Oliver · Tuscon, AZBuilt 1980 · S/N 21064108N898HCSmith Andy · Fitzgerald, GABuilt 1977 · S/N R1722628N898SWHealy Ronald L · Anchorage, AKBuilt 1955 · S/N 32112N898TMKingsley Kaland W · Miller, MOBuilt 1957 · S/N 34406N8990BSortomme Jeffrey P · Sacramento, CABuilt 1958 · S/N 36690
Back to AD 79-10-14 R1