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.

N7806LRegistered aircraftBuilt 1976 · S/N 18264966N7806SAeroquest LLC · Plano, TXBuilt 1978 · S/N U20604168N7806ZRobinson Jordan P · Lexington, NCBuilt 1963 · S/N 15059906N78076Clinton Aeroclub · Clinton, IABuilt 1968 · S/N 17257472N78078International Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17257473N7807ERegistered aircraftAssigned, pending cancellationS/N 17607N7807FFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeBuilt 1966 · S/N 15063907N7807GLake Of The Woods Aviation LLC · Baudette, MNS/N 17259507N7807KSutton Aircraft Salvage LLC · Palmer, AKS/N 18052741N7807XFarwell Joseph W · Holmen, WIBuilt 1961 · S/N 17248307N7807ZSmokovitz Joseph M · Tecumseh, MIBuilt 1963 · S/N 15059907N78086Drake Ronald N · Helena, MTBuilt 1968 · S/N 17257475N7808ESauls Billy J · Hollow Rock, TNBuilt 1959 · S/N 17608N7808KRegistration Pending · Fort Collins, CORegistration pendingBuilt 1976 · S/N 18052742N7808TMckay H Samuel · Barnwell, SCBuilt 1960 · S/N 47408N78091Stumberg Richard Kirk · Pottsboro, TXBuilt 1973 · S/N 18261747N78092Sale Reported · Prescott Valley, AZSale reported, pending cancellationBuilt 1973 · S/N 18261748N78095Leuer James A · Encinitas, CABuilt 1968 · S/N 17257480N78098Fahrenkamp Russell E · Parker, AZS/N 18261749N7809EHavelka Justin R · Mcgregor, TXBuilt 1959 · S/N 17609N7809GHodge Aviation LLC · Monroe, LABuilt 1970 · S/N 17259509N7809KAdamson Bradley R · Cody, NEBuilt 1976 · S/N 18052743N7809UHigh Planes Aviation LLC · Waseca, MNFirst renewal noticeBuilt 1964 · S/N 17251809N780ALas Margaritas Aviation LLC · Qulin, MOBuilt 1978 · S/N U20604463N780BGMaw Enterprises USA LLC · Hudson, FLBuilt 1980 · S/N 17274382N780BWBridgewater State University · North Dartmouth, MABuilt 2000 · S/N 172S8600N780CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281780N780EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13569N780ESFlying Pineapple LLC · Naples, FLS/N U20604272N780HN780h LLC · Angola, INBuilt 1965 · S/N 18256595N780JAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10476N7810Danger Zone Aviation LLC · Ham Lake, MNBuilt 1971 · S/N 18260671N78102Sonoma County Land Company Inc · Santa Rosa, CABuilt 1973 · S/N 18261751N7810ABlack Diamond Soaring Inc · Oley, PABuilt 1957 · S/N 32707N7810KBecker Michael A · La Grande, ORBuilt 1976 · S/N 18052744N7810URasch Hellmut G · Tomball, TXS/N 17251810N7810XCoats Benjamin F II · Ducktown, TNBuilt 1960 · S/N 17248310N78112Botnick Eric L · Luling, LABuilt 1968 · S/N 17257486N78115Cm3 LLC · North Las Vegas, NVBuilt 1973 · S/N 18261753N7811EWinkler William R III · Boone, NCBuilt 1959 · S/N 17611N7811THoke Cylus G · Culver, ORBuilt 1960 · S/N 47411N7811XMach 3 LLC · Enid, OKBuilt 1961 · S/N 17248311N7811ZTeske Robert E · Kalamazoo, MIBuilt 1963 · S/N 15059911N78123Rrr3 LLC · Midway, FLS/N 17257490N78124Barrow James L · Elizabethtown, KYBuilt 1968 · S/N 17257491N78126Orme Jason R · Red Oak, IABuilt 1968 · S/N 17257492N7812TCurzon John R · Brookings, ORS/N 47412N7812UPs Aviation Inc · Granada, MNS/N 17251812N7812ZAbbe Thomas E · Wasilla, AKBuilt 1963 · S/N 15059912N78130Garoutte Kirk E · Anchorage, AKBuilt 1968 · S/N 17257493
Back to AD 79-10-14 R1