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.

N8274GMorris Robert B · Star Valley, AZBuilt 1971 · S/N 177RG0174N8274QBravo Delta II LLC · Steamboat Springs, COBuilt 1976 · S/N U20603135N8274TTraylor Robert B · Millersview, TXS/N 17556974N8275BVixie James G · Milton Freewater, ORBuilt 1957 · S/N 36075N8275FStanford Michael · Victoria, TXBuilt 1966 · S/N 15064375N8275MValiair Limited Company Trustee · Casper, WYBuilt 1970 · S/N 21059275N8275QAbel Derek R · Rio Vista, CABuilt 1976 · S/N U20603136N8275XEvans C David II · Elkhart, INBuilt 1961 · S/N 17248775N8276BHermens Stanley G · Wallowa, ORS/N 36076N8276ESkyview Aviation LLC · Tracy, CABuilt 1979 · S/N 17272163N8276LFly Time Aviation LLC · San Tan Valley, AZBuilt 1967 · S/N 17256476N8276TCooper Craig S · Pasco, WABuilt 1961 · S/N 17556976N8276UNurge Richard J · Gilroy, CAS/N 15077910N8276YVrem Kevin · Anchorage, AKBuilt 1977 · S/N 18052778N8277BRyder Clifford J · Massapequa, NYBuilt 1957 · S/N 36077N8277GCountry Aero LLC · Darwin, MNBuilt 1973 · S/N 18801281TN8277LSillers Kim O · Sault Sainte Marie, MIBuilt 1967 · S/N 17256477N8277MBlalock Paul T · Longview, TXBuilt 1970 · S/N 21059277N8277UEdgewood Farms LLC · Groveland, NYBuilt 1964 · S/N 17252177N8278EEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1979 · S/N 17272165N8278FIvey Joseph M · Poland, OHS/N 15064378N8278UMattison Alan B · Petaluma, CABuilt 1964 · S/N 17252178N8278XDepew Gerald R · Oak Ridge, TNBuilt 1961 · S/N 17248778N8279AHadley Harold C · Parma, IDBuilt 1952 · S/N 25131N8279EHull Farms Inc · Blythe, CABuilt 1979 · S/N 17272166N8279TGaddis James W · Steelville, MOS/N 17556979N8279ZVines Forrest Mackenzie · Bonney Lake, WABuilt 1963 · S/N 205-0279N827BWWhitby Aviation Inc · Athol, IDS/N 172S9841N827CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281271N827DFBrown Edward M · Cabot, ARBuilt 1970 · S/N 15071994N827DGAfrica Inland Mission International Inc · Peachtree City, GABuilt 1981 · S/N U206-06286N827EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2022 · S/N 172S12832N827ESAtp Aircraft 1 LLC · Wilmington, DEBuilt 2013 · S/N 172S11280N827KSPlanelease LLC · Venice, CABuilt 1999 · S/N 17280793N827MAPs N827ma LLC · Green Bay, WIBuilt 2001 · S/N 17281015N827PAJa Flight Services LLC · Sugar Grove, ILBuilt 2006 · S/N 172S10155N827TWGardner Thomas W · Lincoln, MEBuilt 1973 · S/N 21059836N827VPClik Services LLC · Forestdale, MABuilt 1959 · S/N 55840N8280BSea Coast Aviation LLC · Conway, SCBuilt 1957 · S/N 36080N8280ETrivedi Jay S · Skokie, ILBuilt 1984 · S/N 18268389N8280TSwift Raptor Aviation LLC · Herndon, VAS/N 17556980N8280XRegistration Pending · Archer Lodge, NCRegistration pendingBuilt 1961 · S/N 17248780N8281EAir Plains Services Corp · Wellington, KSBuilt 1979 · S/N 17272168N8281GWidtfeldt John R · Auburn, PABuilt 1971 · S/N 177RG0181N8281LSliwinski Kellyn E · Anchorage, AKBuilt 1967 · S/N 17256481N8281Q9 North LLC · Parker, COBuilt 1976 · S/N U20603142N8281UHersch Richard E · Arlington, WAS/N 17252181N8281XStull Carl · Phoenix, AZBuilt 1961 · S/N 17248781N8281ZSpearfish Aviation Inc · Summerset, SDS/N U20604116N8282ACole Brian S · Friday Harbor, WABuilt 1952 · S/N 25134
Back to AD 79-10-14 R1