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.

N5600ECompton Francis B Jr · Marfa, TXBuilt 1958 · S/N 17100N5600GChimera Air Inc · Maumee, OHBuilt 1969 · S/N 15071100N5600RBreland Gerald Monroe Sr · Bogalusa, LABuilt 1965 · S/N 17253207N5601AOsceola Aerosport LLC · Osceola, WIBuilt 1956 · S/N 28201N5601EMarshall Joseph · Uniontown, OHBuilt 1983 · S/N 18268333N5601JGoos Lynn A · Silver City, IABuilt 1974 · S/N 18263458N5602ALooney Hubert · Florissant, MOBuilt 1956 · S/N 28202N5602TBerg William J · Aberdeen, SDS/N 17251502N5603CBoulette Harris · School Craft, MIBuilt 1950 · S/N 15536N5603EMullins Esten R · El Paso, TXBuilt 1958 · S/N 17103N5603JMiller Duane A · Redlands, CABuilt 1974 · S/N 18263460N5603RRegistered aircraftBuilt 1965 · S/N 17253211N5604EHarris Stephanie L · Marion, MSBuilt 1958 · S/N 17104N5604JJohnson David A · Sunrise Beach, TXBuilt 1974 · S/N 18263461N5604RSkunda Robert J · Hebron, OHBuilt 1965 · S/N 17253213N5604TAndrews Jeremy R · Walker, MNBuilt 1964 · S/N 17251504N5605AKlase Robert · Greenville, TXS/N 28205N5605GMartinez Ivan A · Oro Valley, AZS/N 15071105N5605JMajor Air LLC · Charleston, SCS/N 17273819N5605RCostello John M · Wichita, KSBuilt 1965 · S/N 17253214N5606CCollins Florence D Miki · Lake Minchumina, AKFirst renewal noticeBuilt 1950 · S/N 15539N5606GPinho Michel A · Santa Barbara, CABuilt 1969 · S/N 15071106N5607AGilbirds William M · Kansas City, MOBuilt 1956 · S/N 28207N5608CGustafson Kurt E · Winchester, VABuilt 1950 · S/N 15541N5608EMyers Alex B · Oshkosh, WIBuilt 1958 · S/N 17108N5609BWinkelman Ronald A · Chugiak, AKBuilt 1956 · S/N 33609N5609TWestfall Gage T · Marietta, OKBuilt 1964 · S/N 17251509N560ABQuartermaster Growth LLC · Vashon, WABuilt 2007 · S/N 18281947N560FASteffel Farms LLC · Olivia, MNBuilt 2003 · S/N 172S9560N560MAKrauss Solutions LLC · Debary, FLBuilt 1966 · S/N 15065142N560SFAllen Adam W · Sutter Creek, CABuilt 1974 · S/N 15075865N560SPProtea Group Management Services LLC · Carrollton, TXS/N R1722359N560THLe Tourneau University · Longview, TXBuilt 2016 · S/N 172S11668N560ZHeslin Jon P · Sutton, MABuilt 1974 · S/N 17262889N5610ANielson Douglas W · East Troy, WIBuilt 1956 · S/N 28210N5610EBenelli Matthew T · Sandwich, MAS/N 17110N5610GInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15071110N5610JRael Pedro G · Los Lunas, NMBuilt 1974 · S/N 18263465N5611ALewis Christopher Michael · Troy, OHBuilt 1956 · S/N 28211N5611JJr'S Auto Care Center Inc · Gualala, CABuilt 1974 · S/N 18263466N5611RNordell Louis W · Watervliet, MIBuilt 1965 · S/N 17253222N5611TSale Reported · Lenexa, KSSale reportedBuilt 1964 · S/N 17251511N5612GNelson Daniel J · Ladd, ILBuilt 1969 · S/N 15071112N5612JNovember Aviation Corporation · Hobart, WABuilt 1974 · S/N 18263467N5612RLoerke James S · John Day, ORBuilt 1965 · S/N 17253224N5612TLord David A · Mackay, IDS/N 17251512N5613CHolliday Mark E · Lake Elmo, MNBuilt 1950 · S/N 15546N5613ESuter Laurance · Livermore, CABuilt 1958 · S/N 17113N5613JMorgan Edward A · Buchanan Dam, TXBuilt 1974 · S/N 18263468N5613TJones Curtis DBA · Jacksonville, NCBuilt 1964 · S/N 17251513
Back to AD 79-10-14 R1