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.

N710LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 172S11420N710MHK Bay Air LLC · Homer, AKBuilt 1974 · S/N U20602383N710RRMulcahy Michael T · Perris, CABuilt 2000 · S/N 20608106N710SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13577N710SPElite Approach LLC · Chesterfield, MOBuilt 1999 · S/N 172S8106N710TDDuke Ray J · Oak Point, TXBuilt 1976 · S/N 21061424N710TRSln Aviation LLC · Salina, KSBuilt 1977 · S/N R1722768N710WGAger Brandon Reno · Craig, COBuilt 1975 · S/N 18263570N71107Jrf Enterprises LLC · Salem, ORS/N 18259497N7110QLawson Virgil · Sylvar Grove, KSS/N 17260410N7110TWright Donald E · Greensboro, NCS/N 46710N71114Aeropaws Aviation LLC · Front Royal, VABuilt 1968 · S/N 18259499N71118Taf Aerial Services LLC · Beeville, TXS/N 18259501N7111ABurgess Fred P · Titusville, FLBuilt 1956 · S/N 29211N7111MPlatt Aaron Eugene · Heppner, ORBuilt 1958 · S/N 55411N7111NAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1977 · S/N 17269101N7111SDemaio John · Dillwyn, VABuilt 1976 · S/N 18265063N7111TMesseder Thomas Alan Jr · Fredericksburg, VABuilt 1959 · S/N 46711N7111WBetter Living Aviation Inc · Wilmington, DEBuilt 1999 · S/N 18280550N7111XGoodwin Joseph N · Grass Valley, CABuilt 1961 · S/N 15059211N71121Karmy Jeffrey R · Medford, ORBuilt 1968 · S/N 18259502N71123Debusk Eric M · Columbus, INBuilt 1968 · S/N 18259503N71124N71124 LLC · Waunakee, WIBuilt 1968 · S/N 18259504N71126Overturf Andrew · Franklin, WIBuilt 1968 · S/N 18259505N7112EAircraft Structural Repair Inc · Hamilton, MTBuilt 1959 · S/N 52112N7112FHurst Richard H · Lometa, TXBuilt 1966 · S/N 15063712N7112GHooper Walter E III · Spring City, TNBuilt 1969 · S/N 17258812N7112SBridges Robert S · Friendswood, TXBuilt 1967 · S/N 15067812N7112XKoplitz Wesley D · Oshkosh, WIBuilt 1961 · S/N 15059212N7113Rotter Shane F · Olympia, WABuilt 1956 · S/N 33754N71132Neale Bruce G · Joppa, ALBuilt 1968 · S/N 18259507N711333 F Aviation LLC · Norwood, LABuilt 1968 · S/N 18259508N71136Jones Harper L II · Pendleton, ORBuilt 1968 · S/N 18259509N7113ATrail Richard L · Mccook, NEBuilt 1956 · S/N 29213N7113MOgle Tyler E · Eufaula, OKFirst renewal noticeBuilt 1958 · S/N 55413N7113QMiles Michael G · Hillsborough, NCBuilt 1972 · S/N 17260413N71149Skydive Harbor Springs Inc · Charlevoix, MIBuilt 1968 · S/N 18259511N7114ETlm Properties LLC · Gladewater, TXBuilt 1959 · S/N 52114N7114FWernecke Thomas C · Southfield, MIBuilt 1966 · S/N 15063714N7114MJohnson Mark A · Bellevue, IDBuilt 1958 · S/N 55414N7114QSass Kenneth · Charlotte, NCBuilt 1972 · S/N 17260414N7114SMuinos Jose M · York, PABuilt 1976 · S/N 18265064N7114TMeyer Andrew J · Carter, SDBuilt 1959 · S/N 46714N7114XKnutson Wayne R · Tioga, NDBuilt 1961 · S/N 15059214N7115ARothenbusch Michael G · Tampa, FLBuilt 1956 · S/N 29215N7115MSatanta Flying Service Inc · Satanta, KSBuilt 1958 · S/N 55415N7115QMaggart Kenneth R · Lutz, FLBuilt 1972 · S/N 17260415N7115T172 Club LLC · Olalla, WABuilt 1959 · S/N 46715N71164Core Jerry M · Bishop, CABuilt 1968 · S/N 18259516N71165Aggie Aero Enterprises LLC · Cleveland, TXBuilt 1968 · S/N 18259517
Back to AD 79-10-14 R1