OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N1438FBermudez Santana Tacito O · Conyers, GAS/N 17254933N1438SAddamo Vincent R · Porterville, CABuilt 1976 · S/N 18264986N1438USale Reported · Greeley, COSale reportedBuilt 1976 · S/N 17267105N1438YDr Luis S Navarro Pllc · Edinburg, TXS/N 17249138N1439FHallock Lloyd E · Columbia, MOBuilt 1966 · S/N 17254934N1439UCass Aviation LLC · Henderson, NVBuilt 1976 · S/N 17267106N1439YGrace Aviation LLC · Fort Myers, FLBuilt 1962 · S/N 17249139N143AKLipinski Glen E · Chandler, AZS/N 15074168N143BBN62689 Inc · Middletown, DES/N 17249516N143CPPonzo Christopher A · North Reading, MABuilt 1980 · S/N 18267699N143DBBernard Daniel · GrillyBuilt 1965 · S/N 18256678N143DKReynolds Terry J · Phoenix, AZS/N 15073020N143DROroca Flying Club LLC · Weehawken, NJBuilt 1972 · S/N 17261119N143HJHurlburt Ward B IV · Anchorage, AKBuilt 1976 · S/N 18503032N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102N143KMBc Aircraft LLC · Edmonds, WABuilt 1977 · S/N 18265435N143MEGateway Of Sturgis LLC · Sturgis, MIBuilt 2000 · S/N 172S8427N143RMOft7 LLC · Ponca, ARBuilt 1975 · S/N 18263650N143TCHarris William D · Topeka, KSBuilt 1962 · S/N 205-0064N14407Hanson Rod D · Wasilla, AKBuilt 1964 · S/N 185-0676N1440ECreighton Mark · Port Aransas, TXBuilt 1982 · S/N 18268179N1440GSierra-Mike LLC · Springdale, ARS/N 15072955N1440QN1440q LLC · Maybee, MIS/N 15072740N1440SPolkowske Leroy A · La Jara, COBuilt 1976 · S/N 18264988N1441FMartin Michal R · Alva, OKBuilt 1966 · S/N 17254936N1441PN1441p LLC · Pompano Beach, FLBuilt 1973 · S/N 17260993N1441QSale Reported · Franklin, INSale reportedBuilt 1971 · S/N 15072741N1441SHustad Kenneth H · Spokane, WABuilt 1976 · S/N 18264989N1441VYegge David J · Hartland, MIBuilt 1974 · S/N 17263579N1442Viotto Stephen J · Anchorage, AKS/N 52072N1442CMakelbust Michael J · Ames, IABuilt 1977 · S/N 17702728N1442DBiggs James R · Piney Flats, TNBuilt 1973 · S/N 18262106N1442MLorenzo Blake D · Wynne, ARBuilt 1975 · S/N 18264332N1442QDelaware Aviation LLC · Sidney, NYFirst renewal noticeBuilt 1971 · S/N 15072742N1442STodd Philip A · Wendell, NCBuilt 1976 · S/N 18264990N1442UEastern Idaho Flying Club · Idaho Falls, IDBuilt 1976 · S/N 17267109N1443FNelson Harold G · Pendleton, ORBuilt 1966 · S/N 17254938N1443MBahnmiller Dennis D · Highwood, MTBuilt 1975 · S/N 18264333N1443VSchovanec David L · Stuart, FLBuilt 1974 · S/N 17263580N1444CFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9890N1444FStrope Byron P · Upland, CABuilt 1966 · S/N 17254939N1444QPelco Aviation Inc · Hampton Bays, NYBuilt 1971 · S/N 15072744N1444SEagle Forestry Services Inc · Monticello, ARBuilt 1976 · S/N 18264992N1444YHiggins Derrick G · Arbyrd, MOBuilt 1962 · S/N 17249144N14455Pinkerton Matthew L · Milton, FLS/N R-172-0143N14457Stone Kenneth R · Cedar Springs, MIBuilt 1966 · S/N R172-0120N1445ESouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 17271004N1445FMorris Loyd Albert · Alvarado, TXBuilt 1966 · S/N 17254940N1445SHagemann Karl B · Santa Clarita, CABuilt 1976 · S/N 18264993N1445YSwartz Steven L · Nashville, TNBuilt 1962 · S/N 17249145
Back to AD 79-10-14 R1