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.

N78523Sunderman Randy · Norfolk, NEBuilt 1968 · S/N 17257653N78525Aero II Inc · Spartanburg, SCBuilt 1969 · S/N 17257655N78526Miklus Michael III · Saint Georges, DEBuilt 1968 · S/N 17257656N7852UMartinson James C · Sioux Falls, SDBuilt 1964 · S/N 17251852N7852ZKvservices LLC · Buckley, WABuilt 1963 · S/N 15059952N78531Goodridge Flying Club Inc · Goodridge, MNBuilt 1968 · S/N 17257658N78538Drover Michael A · Winter, WIBuilt 1968 · S/N 17257660N7853ARegistered aircraftBuilt 1957 · S/N 32750N7853EFelton Marion L · Dickens, IARevoked, canceledBuilt 1959 · S/N 17653N7853FEdwards Michael J · Hazlehurst, GABuilt 1966 · S/N 15063953N7853TBailey Ned A · Friday Harbor, WABuilt 1960 · S/N 47453N78542Tolmachev Nikolay A · Anchorage, AKBuilt 1968 · S/N 17257661N78548Bakalar Flying Club Inc · Columbus, INBuilt 1968 · S/N 17257662N7854AMacglover Richard A · Ham Lake, MNBuilt 1957 · S/N 32751N7854GNeuschaefer George H · White Hills, AZBuilt 1970 · S/N 17259554N7854ZAdams Jerry W · Dallas, TXBuilt 1963 · S/N 15059954N78553Shop Branch Equipment Co Inc · Marble Falls, TXBuilt 1968 · S/N 17257666N78556B&T Venutres LLC · Duncan, OKBuilt 1973 · S/N 18261769N7855CSitz Walter L · Burns, ORBuilt 1959 · S/N 31440N7855FSmith Joshua B · Kenai, AKS/N 15063955N7855GAlpenglow Air 3 LLC · Anchorage, AKBuilt 1970 · S/N 17259555N7855XBensema Amber L · Winchester, CAS/N 17248355N7856FFitzgibbon Patrick D · Waterloo, WIBuilt 1966 · S/N 15063956N7856GMitchell Lindsey T · Chesnee, SCBuilt 1970 · S/N 17259556N7856XBrown Daniel F · Belgrade, MTBuilt 1961 · S/N 17248356N78579Hamilton George D · Bandera, TXBuilt 1968 · S/N 17257673N7857AEberhardt William J · Gig Harbor, WABuilt 1957 · S/N 32754N7857ELout James Mike · Jasper, TXBuilt 1959 · S/N 17657N7857GAmerican Patrols Inc · Midland, TXBuilt 1970 · S/N 17259557N7857TDiamondhead Aero Co-Owners LLC · Picayune, MSBuilt 1960 · S/N 47457N7857UMok Kuch · Delano, CABuilt 1964 · S/N 17251857N7858EWhite Larry K · Pittsburgh, PABuilt 1959 · S/N 17658N7858FShelley Tiffany · Chandler, AZFirst renewal noticeS/N 15063958N78590Obrien Connor J · Mulino, ORBuilt 1968 · S/N 17257676N78596Oshea Thomas F · Hamilton, NJBuilt 1968 · S/N 17257678N78598Schaefer Joseph P · Weyerhaeuser, WIS/N 17257680N7859GAviators LLC · Casco, WIBuilt 1970 · S/N 17259559N7859UDuncan Martin R · Newark, ARBuilt 1964 · S/N 17251859N7859XGraves David E · Astoria, ORS/N 17248359N785ASA S Flight Academy LLC · Lantana, FLBuilt 1974 · S/N 17262954N785BGVermont Flight Academy · South Burlington, VTBuilt 2006 · S/N 17281325N785BKPilot Peak Aviation LLC · Kalispell, MTBuilt 1977 · S/N 18265768N785ERTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13581N78603Beaufort Flight Training LLC · Beaufort, SCBuilt 1968 · S/N 17257682N78606Brook Trout Properties LLC DBA · Kalamazoo, MIBuilt 1968 · S/N 17257684N78607Jones John E Jr · Metter, GABuilt 1973 · S/N 18261774N7860EBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1959 · S/N 17660N7860FVahary David J · Portage, INBuilt 1966 · S/N 15063960N7860GRoberts Timothy J Jr · Taylor, TXBuilt 1970 · S/N 17259560N7860ZGideon Troy J III · Elba, ALS/N 15059960
Back to AD 79-10-14 R1