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.

N6482YSky West Aviation Inc Trustee · Albuquerque, NMS/N 21064400N64834Golden Mahalo LLC · Sheridan, WYBuilt 1982 · S/N 17275632N6483AKdrcjt Aviation LLC · Orange, MAS/N 33283N6483FRegistration Pending · Seattle, WARegistration pendingS/N 15063083N6483GPeterson Cassandra L · Poplar Grove, ILBuilt 1970 · S/N 15071983N6483SBlue Skies Aviation Of Wi Inc · Pulaski, WIBuilt 1967 · S/N 15067283N6483TFoothill Aviation LLC · Iliamna, AKS/N 17883N6484AState Of Illinois · Springfield, ILBuilt 1979 · S/N 21063535N6484FGrant Clinton A · Portage Des Sioux, MOS/N 15063084N6484XMeadows Robert H · Charleston, TNFirst renewal noticeBuilt 1961 · S/N 18050984N64859Leyva Maria · New Smyrna Beach, FLBuilt 1982 · S/N 17275636N6485EWitte Steven E · Egan, SDBuilt 1959 · S/N 46585N64866Universal Aviators Academy Inc · El Monte, CABuilt 1982 · S/N 17275639N6486AErickson Jon W · Union Grove, WIBuilt 1956 · S/N 33286N6486BDevine Aviation LLC · Atlanta, GABuilt 1956 · S/N 29686N6486GRomeo Aviation Inc · Cumberland, WIBuilt 1970 · S/N 15071986N6486JSpredemann Carl A · Emmett, IDBuilt 1980 · S/N 17273877N64875Air America Flight Center LLC · Daytona Beach, FLBuilt 1982 · S/N 17275642N6487ALucci Giancinto A · Nashville, MIS/N 33287N6487BOneal Gary · Springdale, ARBuilt 1957 · S/N 29687N6487DWayne County Airport Board · Monticello, KYBuilt 1979 · S/N 17272831N6487GRedell Donald J · Lake Geneva, WIBuilt 1970 · S/N 15071987N6487SSouth Louisiana Community College · Lafayette, LABuilt 1967 · S/N 15067287N64882Blue Sky Flyers Inc · Greeley, COBuilt 1982 · S/N 17275643N6488EDanielson Austin Mb · Kenai, AKBuilt 1959 · S/N 46588N6488FLee Michael R · Kelso, WABuilt 1966 · S/N 15063088N6488GKrog Steven L · Hartford, WIBuilt 1970 · S/N 15071988N6488VThree Mayhoods LLC · Bonita Springs, FLS/N 172RG0725N64892Montgomery Flying Club Inc · Montgomery, ALBuilt 1982 · S/N 17275644N6489EDupuis Normand G · Berlin, NHBuilt 1959 · S/N 46589N6489HMoon Flight Aviation LLC · Barto, PABuilt 1981 · S/N 18267891N6489XBargainnier Devin T · Carson City, NVBuilt 1961 · S/N 18050989N648BDHansen Robert C · Delavan, WIBuilt 1978 · S/N 18266461N648CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12624N648DWDewhipet LLC · Sibley, LABuilt 1966 · S/N P206-0252N648FRegistered aircraftS/N 18255185N648NHVenice Group LLC · Hopkinton, NHS/N P3370063N648SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1998 · S/N 172S8055N64901Gwaviation Consulting LLC · Woodstock, GABuilt 1974 · S/N 17262428N6490BPontoni Peter D · Athens, MIBuilt 1957 · S/N 29690N6490DCampbell James W · Joshua, TXBuilt 1979 · S/N 17272832N6490XHansen Mark A · Traverse City, MIBuilt 1961 · S/N 18050990N64915Northwoods Air LLC · Orono, MEBuilt 1982 · S/N 17275649N64918Loeser Harold · Boca Raton, FLBuilt 1982 · S/N 17275651N64919Hawk III Flyers Club · Republic, PABuilt 1973 · S/N 17262850N6491BTerrill Guy J · Dillon, MTBuilt 1978 · S/N 21062774N6491EToepfer Kendra · BielefeldBuilt 1959 · S/N 46591N6491HBlue Air 3 LLC · Miami, FLBuilt 1979 · S/N 20700543N6491KFisher Air LLC · Cardington, OHS/N 15077726N6491ZAndolina Richard F Jr · Hornell, NYBuilt 1981 · S/N U20606293
Back to AD 79-10-14 R1