OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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-03-R2')
    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-03-R2')
  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.

N269YADavenport Ross K · Raleigh, NCBuilt 1994 · S/N RV-6-21606N26ADTango Aviation LLC · Valrico, FLS/N 20264N26AJByford Christopher H · Mc Gregor, TXBuilt 2005 · S/N 90444N26AKLousberg Daniel A · Wasilla, AKBuilt 1974 · S/N 18-7409079N26CLPuckett Lewis R · Ellijay, GABuilt 1973 · S/N CL72N26CMLaurel Highlands Aeronautical Academy · Latrobe, PABuilt 1958 · S/N TD-119N26CWBarzelatto Brett · Thornton, COS/N 17272496N26DASimons Thomas A · Howes, SDS/N 001N26EAThweatt Andrew C · Riverside, CABuilt 2005 · S/N 716EN26EVN26ev LLC · Pine, COBuilt 1977 · S/N AA5A0405N26FBBluhm Raymond M · Waxhaw, NCBuilt 2001 · S/N 3810N26FPTate Zachary W · Cypress, TXBuilt 1978 · S/N 17271318N26GBLunt Christopher J · Marco Island, FLBuilt 1982 · S/N 18-8209004N26HVHotel Victor LLC · Bend, ORS/N 1410N26HYFocus Air LLC · Wilmington, DEBuilt 2000 · S/N 2053N26JSWarrick Douglas R · Corvallis, ORBuilt 1981 · S/N 29N26KAOliver Brian · North Attleboro, MABuilt 1964 · S/N 28-20380N26KSMrd Aero LLC · Manheim, PAS/N 24658N26LMClassic Aviation Inc · Pella, IABuilt 1979 · S/N ME-177N26MF2nd Amendment Consulting And Design LLC · Red Bluff, CAS/N 17701425N26MHZorrilla Peter · Charles Town, WVS/N 20422N26MLDay Brittney L · Inola, OKBuilt 1990 · S/N 2093N26RDPacific North Air LLC · Portland, ORS/N 34-7350167N26SROrtega Daniel H · Mccall, IDBuilt 1995 · S/N 92628N26TDTamaco2 LLC · Jackson, MOBuilt 1969 · S/N M-1228N26TFTop Flight Aviation Inc · Corona, CABuilt 1972 · S/N 17261318N26TPGlobal Aerials Inc · Pembroke Pines, FLFirst renewal noticeBuilt 1967 · S/N 17700144N26VHWise Joe · Kilgore, TXBuilt 2004 · S/N 3677N26ZWeber Mark S · Wildwood, MOBuilt 1969 · S/N 17258153N2700CMckeever Jesse · Indio, CABuilt 1954 · S/N 26244N2702DFerguson James L · Junction City, KSBuilt 1954 · S/N T1-16SN2702WMedic Choppers LLC · Springdale, ARS/N 3329N27036Pace William Todd · Palmer, AKS/N 18-3516N2703DBowser William · Burns, KSBuilt 1956 · S/N T1-20SDN2704PBriggs Ralph H · Des Moines, IABuilt 1955 · S/N 22-3010N2706PFraser William G · Berkley, MABuilt 1955 · S/N 22-3012N2707WLund Tyler David · San Diego, CABuilt 1966 · S/N 3331N2708LRafter Jm Enterprises LLC · Swink, OKBuilt 1967 · S/N 17255908N2709PRuble Marsha L · Aurora, ORBuilt 1955 · S/N 22-3015N270AMCode 1 Flight Training LLC · Wills Point, TXBuilt 1973 · S/N 17262722N270CCEuro 2000 Inc · Merritt Island, FLBuilt 2000 · S/N 28-42070N270RBaxter Thomas L · Stockbridge, GABuilt 1958 · S/N 23-1456N270SASundance Airport Fbo LLC · Yukon, OKBuilt 1966 · S/N 28-21576N270WCState Of Alaska Dept Of Fish And Game · Palmer, AKBuilt 1954 · S/N 18-3920N270ZMcgee Andy R · Town Creek, ALBuilt 1982 · S/N 2-270N2710SMarshall Loraine · Cincinnati, OHS/N 28-7415519N2710YPink Ibis Air LLC · Vero Beach, FLS/N TD-45N2711TLucero Nicholas T · North Hollywood, CABuilt 1966 · S/N 28-21917N2712GGrady'S Auction & Realty Inc · Newport, ARBuilt 1967 · S/N 14N2712MCardinal Adventures LLC · Green Bay, WIBuilt 1946 · S/N 12-1127
Back to AD 79-10-03 R2