OpenAirDocs.org
AD 96-24-17 R1

Registered aircraft · 1,458

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:96-24-17-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:96-24-17-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.

N45664Powell James A · Zanesville, OHBuilt 1946 · S/N 2191N45666Sierens Stephen E · Deland, FLBuilt 1946 · S/N 2193N45668Brooks William L · Vienna, VABuilt 1946 · S/N 2195N45669Whetzel Herbert H · Clarkesville, GAS/N 2196N45671Macpherson Ursula A · Lagrangeville, NYBuilt 1946 · S/N 2198N45675Flory David M · Stillwater, MNBuilt 1946 · S/N 2202N45680Brown Thomas L · Hartford, WIBuilt 1946 · S/N 2207N45683Worm Gary L · Adona, ARBuilt 1946 · S/N 2210N45688Snead John S · Crescent City, FLBuilt 1946 · S/N 2215N45694Deal Clarence N · Jonesboro, GAS/N 2221N45701Hurlbert Vernon L · Anchorage, AKBuilt 1946 · S/N 2228N45707Oklahoma Warbird Aviation LLC · Oklahoma City, OKS/N 2234N45719Mustard Aviation LLC · Lovington, NMBuilt 1946 · S/N 2246N45721Registered aircraftAssigned, pending cancellationS/N 2248N45722Bergen Henry E · Fond Du Lac, WIBuilt 1946 · S/N 2249N45725Ude James K · Waterford, CABuilt 1946 · S/N 2252N45729Dietz Dale Gerard · Chesterfield, MOBuilt 1946 · S/N 2256N45730Greene Robert M · Limestone, TNS/N 2257N45732Registration Pending · Plains, MTRegistration pendingBuilt 1946 · S/N 2259N45736Ramin Reuben F · Tomball, TXBuilt 1946 · S/N 2263N45740Ducut Justin Joseph · Upland, CABuilt 1946 · S/N 2267N45749Henley Charles D · New London, NCS/N 2276N45750Carter Casey C · Sanger, TXBuilt 1946 · S/N 2277N45754Edmiston Brandon Lee · Murray, KYBuilt 1946 · S/N 2281N45755Davisson Paul V · Jupiter, FLBuilt 1946 · S/N 2282N45765Jhaco LLC · Lake Charles, LAS/N 2292N45766Gallette John B · Edgewood, NMBuilt 1946 · S/N 2293N45767Weber Loren B · Virginia Beach, VAS/N 2294N45768Wilkie David J · Nashua, NHBuilt 1946 · S/N 2288N45771Lindee Douglas L · Deer Park, WIBuilt 1946 · S/N 2298N45781Darden Jesse R · Nixa, MOBuilt 1946 · S/N 2308N45785Hoover Eli P · Chico, CABuilt 1946 · S/N 2312N45796Goldasich John · Lomita, CABuilt 1946 · S/N 2323N4580Ramin Fred R · Tomball, TXBuilt 1939 · S/N 1123N45803Lindberg David D · Everett, WABuilt 1946 · S/N 2330N45804Registered aircraftAssigned, pending cancellationS/N 2331N45805Prather Carl L · Gilroy, CABuilt 1946 · S/N 2332N45816Holley Donald W · Willis, TXBuilt 1946 · S/N 2343N45817Nelson Braxton A · Paducah, KYS/N 2344N4581MDaphna Inc · Middletown, DEBuilt 1945 · S/N 1936N45820Barnett David K · Brock, TXS/N 2347N45823Phillips Keaton K · Rigby, IDBuilt 1946 · S/N 2350N45839Stieber Joe · Brownwood, TXBuilt 1946 · S/N 2366N45841Michaud Paul K · Forest Lake, MNBuilt 1946 · S/N 2368N45842Feuge Philip R · Elgin, TXBuilt 1946 · S/N 2369N45847Southwest Aero Tech LLC · Punta Gorda, FLBuilt 1946 · S/N 2374N45851Guido Keith J · Saugerties, NYBuilt 1946 · S/N 2378N45853Camacho Hector · Andover, KSBuilt 1946 · S/N 2380N45872Smith Warren D · Oak Harbor, WABuilt 1946 · S/N 2399N45886Craig Richard L · Sonoma, CABuilt 1946 · S/N 2413
Back to AD 96-24-17 R1