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.

N9465CPottenger Matthew J · Richland, MIBuilt 1955 · S/N 31863N9465DMehrer Fritz J · Oceanside, CAS/N 172RG1176N9465GOsprey Air LLC · Anchorage, AKS/N U20601665N9465YWof Investments LLC · Dover, DES/N 21064515N94660Tweed Bradley Steven · Greeneville, TNBuilt 1978 · S/N 18266480N94669Harvanek Brian R · Sarver, PABuilt 1978 · S/N 18266484N9466AThomas Lynnet M · Stevensville, MTBuilt 1949 · S/N 15287N9466BStoots David A · Fairbanks, AKBuilt 1958 · S/N 55484N9466CTappan Zachariah · Fritz Creek, AKBuilt 1955 · S/N 31864N9466EGood Flight Aviation LLC · Stockton, CABuilt 1979 · S/N 17272272N9466XFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11233N94671Sky Jaunts LLC · Kalispell, MTBuilt 1978 · S/N 18266485N94672Cls Contracting LLC · Eureka, MTFirst renewal noticeBuilt 1978 · S/N 18266486N94673Glaze Roy J · Smyrna, TNBuilt 1978 · S/N 18266487N9467AKourtis Vintage Aviation LLC · Owasso, OKBuilt 1950 · S/N 15469N9467MSideropoulos Lester G · Knoxville, TNBuilt 1968 · S/N 18258909N9467UPowell Travis R · Clinton, MOS/N 15078415N94682Flight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11234N9468BHayward David E · Middlesboro, KYBuilt 1958 · S/N 55268N9468CClarkson Darren E · Phoenix, AZS/N 31866N9468DKelly Henry Searles · Ossining, NYBuilt 1984 · S/N 172RG1177N9468HShouse Andrew · Flagstaff, AZBuilt 1975 · S/N 17266169N9468TBas Part Sales LLC · Greeley, COS/N 57268N9468XBg Family Lp · Edinburg, TXS/N 21057768N94691Brentco Aerial Patrol Inc · Canton, OHBuilt 1978 · S/N 18266491N94698Corsa Exotics Inc · South El Monte, CABuilt 1978 · S/N 18266492N9469ABohl Howard M · Temecula, CABuilt 1949 · S/N 15290N9469EParker Duane E · Louisville, KYBuilt 1979 · S/N 17272273N9469GGolf Tango Air Racing LLC · Ephrata, WABuilt 1971 · S/N U20601669N9469HAirplanes And Attitude LLC · Mckinney, TXBuilt 1975 · S/N 17266170N9469UBrennecke Matthew L · Tulsa, OKBuilt 1976 · S/N 15078417N9469XMurdoch Nathan B · Nehawka, NEBuilt 1961 · S/N 21057769N9469ZEly John E · Prosser, WAS/N 33940N946ASA2g International LLC · San Juan Capo, CAS/N 33701851N946CHCritchfield Flying Service LLC · Rupert, IDBuilt 1977 · S/N 17269021N946CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282408N946PKPrado Mike · Sugar Land, TXBuilt 1980 · S/N R1723339N946SMEntrekin David C · Ridgeland, MSBuilt 1982 · S/N 17275870N946THWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 172S13146N94709South Georgia Technical College · Americus, GABuilt 1978 · S/N 18266496N9470CLauer William A · Mercer, WIBuilt 1955 · S/N 31686N9470GDrean Gary T · Rancho Santa Fe, CABuilt 1971 · S/N U20601670N9470MJanes Dwayne O · Edmond, OKBuilt 1970 · S/N 21059370N9470XPerry Edward Glen · Brigham City, UTS/N 21057770N94713Thompson Robert M · Nevada, MOBuilt 1978 · S/N 18266497N9471ABlock Elliot M · Encinitas, CAS/N 15292N9471NBas Part Sales LLC · Greeley, COBuilt 1981 · S/N 18504362N9471XVincent Equipment LLC · Grand Junction, COBuilt 1961 · S/N 21057771N9472BGrundy James W · West Greenwich, RIS/N 55272N9472ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268417
Back to AD 79-10-14 R1