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.

N9303GBenson Steve J · Keenesburg, COBuilt 1971 · S/N 18260843N9303NWings Over Texas Holdings LLC · Denton, TXBuilt 2011 · S/N 172S11118N9303RCanoe Bay Outfitters LLC · Chugiak, AKBuilt 1984 · S/N U20606829N9303TBaxter Patrick L · Frisco, COS/N 50803N9303UWestover Scott A · Anchorage, AKBuilt 1976 · S/N 15078253N9303XHawaiian Airlift Company Llp · Kihei, HIS/N 18268479N9304HWischmeyer Matthew R · Hopewell Junction, NYBuilt 1975 · S/N 17266078N9304RShah Zahid · Santa Paula, CAS/N U20606830N93050Wilson Thomas Henry III · Anchorage, AKBuilt 1976 · S/N 18503172N93052Pfm 2025 LLC · Lake Forest, ILBuilt 1974 · S/N 21060244N93055Moore Joshua M · North Pole, AKBuilt 1977 · S/N 18503173N9305BStar Aero LLC · Santa Teresa, NMBuilt 1958 · S/N 55105N9305CLinn Michael A · Nisswa, MNBuilt 1955 · S/N 31703N9305NRancho Av Leasing LLC · Temecula, CABuilt 2011 · S/N 172S11132N9306CKoehrer Ernie · Palmer, AKBuilt 1955 · S/N 31704N9306GPaiva Rafael R · College Station, TXBuilt 1971 · S/N 18260846N9306HAnycomm Corp · Gold River, CABuilt 1975 · S/N 17266079N9307CJrs Buena Vida LLC · College Station, TXBuilt 1955 · S/N 31705N9307DAviatzone LLC · Fort Lauderdale, FLBuilt 1982 · S/N 172RG1114N9307GSchwaderer Delbert L · Stevensville, MTBuilt 1971 · S/N 18260847N9307HMoss Jon · Gridley, CABuilt 1981 · S/N 182-67929N9307YRader Drew · Avon, COBuilt 1981 · S/N 21064467N9308BKorn Antony · Chehalis, WABuilt 1958 · S/N 55108N9308CCameron Thomas J · Stanchfield, MNBuilt 1955 · S/N 31706N9308GBoilermaker-Warrior Express LLC · Grosse Pointe, MIBuilt 1971 · S/N 18260848N9308X5p&P LLC · Glenwood Springs, COBuilt 1961 · S/N 18253708N93098Faeo John D · Wasilla, AKBuilt 1976 · S/N 18503179N9309CVan Bortel Aircraft Inc · Arlington, TXBuilt 2011 · S/N 18282306N9309GHagle Terry A · Niceville, FLBuilt 1971 · S/N 18260849N9309XRigsby R W · Salisbury, NCBuilt 1961 · S/N 18253709N9309YYecny Alan K · San Luis Obispo, CABuilt 1981 · S/N 21064469N930ASA2g International LLC · San Juan Capo, CABuilt 1976 · S/N 33701854N930CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282398N930GGelazin Paul J · Palm Harbor, FLBuilt 1977 · S/N 21061866N930JSDolphin Air LLC · Fairbanks, AKBuilt 1975 · S/N 15076752N930LFWanner Robin L · Lufkin, TXBuilt 1966 · S/N 21058766N9310BThrom Donald R · Parachute, COBuilt 1958 · S/N 55110N9310DRegistered aircraftBuilt 1982 · S/N 172RG1116N9310GBaldwin James C · Fruita, COBuilt 1971 · S/N 18260850N9310HLilienthal Donald W · Cyrus, MNBuilt 1975 · S/N 17266080N93112Strack Air LLC · Yorba Linda, CABuilt 1974 · S/N 21060267N9311GSooter Craig · Blue Ridge, TXBuilt 1971 · S/N 18260851N9311TCrouse John A · Sterling, AKBuilt 1960 · S/N 50811N9311XLink Lance L · Concordia, KSBuilt 1961 · S/N 18253711N93128High Plains Aero Consulting Inc · Pampa, TXBuilt 1974 · S/N 21060273N93129Klca Inc · Warsaw, INS/N 21060274N9312GYoung Robert S IV · Abilene, TXBuilt 1971 · S/N 18260852N9312XLewan William F · Naperville, ILBuilt 1962 · S/N 18253712N93135Shannon Frances W · Clarksdale, MSBuilt 1974 · S/N 21060278N9313BAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 172RG0788
Back to AD 79-10-14 R1