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.

N70022Linford Robert M · Spokane, WABuilt 1971 · S/N 18501897N70026Stephens Brandon J · North Pole, AKBuilt 1971 · S/N 18501901N7002AAustin James M · Fort Worth, TXBuilt 1956 · S/N 29102N7002EHickle William H · Inyokern, CABuilt 1960 · S/N 56502N7002FMcdonald Timothy M · Meredith, NHBuilt 1966 · S/N 15063602N7002MApte John W · Biddeford, MEBuilt 1958 · S/N 55302N70032Alpha Wings Inc · Willoughby, OHBuilt 1976 · S/N 17267180N70037Bancroft Contracting Corporation · South Paris, MEBuilt 1971 · S/N 18501905N7003AHuang Sophie M · Newcastle, WABuilt 1956 · S/N 29103N7003EIndy Air Sales LLC · Anderson, INBuilt 1960 · S/N 56503N7003KSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 18259923N70046Zane Newton F · Rllng Hls Est, CAS/N 17267183N70048Trident Resources LLC · Chino Valley, AZS/N 18501917N7004AMitchell Mark A · Pittsford, NYBuilt 1956 · S/N 29104N7004EBoughan Patrick W · Vail, COBuilt 1960 · S/N 56504N7004GMcgreen John R · Albany, NYBuilt 1969 · S/N 17258704N70052Hastings Heidi · Wasilla, AKBuilt 1976 · S/N 17267185N7005AStansell Clayton H · Los Lunas, NMBuilt 1956 · S/N 29105N7005FUS Flight Academy International Inc DBA · Post, TXBuilt 1966 · S/N 15063605N7005GHamilton Peter D · Bear, DEBuilt 1969 · S/N 17258705N7005QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260305N7005TSmith Roy B · Newland, NCBuilt 1959 · S/N 46605N70063Welch Thomas R DBA · Modesto, CABuilt 1974 · S/N 18801827TN7006AFletcher John G · Diamondhead, MSBuilt 1956 · S/N 29106N7006ELienke Kevin E · Beaver Dam, WIBuilt 1960 · S/N 56506N7006QToney Edward L · Hampton, GABuilt 1971 · S/N 17260306N7006SSpicer Greg · Portage, MIBuilt 1967 · S/N 15067706N7006TFraas Stephan H · Meriden, CTBuilt 1959 · S/N 46606N70070Bay Air Inc · Dillingham, AKBuilt 1971 · S/N 18501939N70071Bender Charles A Jr · Orrstown, PABuilt 1971 · S/N 18501940N7007MDouble 07 Mike Flyers Inc · Kalispell, MTBuilt 1958 · S/N 55307N7007SJw Air Ventures LLC · New Smyrna Beach, FLBuilt 1967 · S/N 15067707N70083Air Pacific LLC · Port Angeles, WABuilt 1971 · S/N 18501950N70084Bridges Pamela J · Calais, MES/N 18501951N70085Embley Kenneth · Anchorage, AKS/N 18501952N7008AMitchell Shawn J · Red Bluff, CAS/N 29108N7008SPoe John B · Port Orange, FLS/N 15067708N7008TDelaney Patrick James · Marion, TXS/N 46608N70091Franke Gordon D · Anchorage, AKBuilt 1972 · S/N 18501964N70095Eastern Kentucky University · Richmond, KYBuilt 1976 · S/N 17267192N70097Family Air Tours LLC · Ketchikan, AKBuilt 1972 · S/N 18501982N7009ESutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 56509N7009QJoiner Legacy Enterprises LLC · Joliet, MTS/N 17260309N7009TCrigler Christopher E · Warrenton, VABuilt 1959 · S/N 46609N700AGMash Kity J LLC · Grand Rapids, MIBuilt 1981 · S/N 172RG0670N700AMInternational Air Services Inc Trustee · Carson City, NVS/N 33701801N700CDCrahen William F · Merrimac, WIBuilt 1975 · S/N 177RG0788N700PDAero Survey LLC · Lake Havasu City, AZBuilt 1979 · S/N 18266974N700PJShort Stephen A · Lake Placid, NYBuilt 1977 · S/N 17702628N700PMRar LLC · Louisville, KYBuilt 1998 · S/N 172S8034
Back to AD 79-10-14 R1