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.

N71116Chandler Robby L · New Hope, ALBuilt 1946 · S/N 2543N71127Dillahunty Chris D · Fresno, CAS/N 2554N71129Pustay John D · Inglis, FLBuilt 1946 · S/N 2556N71135Jebb Steven J · Clovis, CABuilt 1946 · S/N 2562N71139Whetzel Herbert H · Clarkesville, GABuilt 1946 · S/N 2566N71142Truesdale Thair W · Collinsville, OKBuilt 1946 · S/N 2569N71147Atkins Ricky K · Placerville, CABuilt 1946 · S/N 2574N71148Registered aircraftBuilt 1946 · S/N 2575N71152Allen Justin W · Lizton, INBuilt 1946 · S/N 2579N71155Step Too LLC · Wilmington, DEBuilt 1946 · S/N 2582N71156Rasch Kevin W · Denton, TXBuilt 1946 · S/N 2583N71157Bauer Lawrence L · Grand Rapids, MIS/N 2584N71161Miller Todd · Martinton, ILS/N 2588N71166Hatcher Michael C · Timberville, VABuilt 1946 · S/N 2593N71170Vandoynhoven John T · Glencoe, MNBuilt 1946 · S/N 2597N71172Bialozynski Gary · Menomonee Falls, WIBuilt 1946 · S/N 2599N71173Amigos 8a LLC · Breckenridge, TXBuilt 1946 · S/N 2600N71177Traweek Brian C · Battle Mountain, NVBuilt 1946 · S/N 2604N71179Spears Rickey L · Longmont, COBuilt 1946 · S/N 2606N71189Carlson Tom H · Miles City, MTBuilt 1946 · S/N 2616N71201Hatter Ronnie A · Newcastle, OKBuilt 1946 · S/N 2628N71212Smith Brian D · Sinclairville, NYBuilt 1946 · S/N 2639N71218Adkins Dwain L · Sycamore, ILBuilt 1946 · S/N 2645N71219Dakota Territory Air Museum · Minot, NDBuilt 1946 · S/N 2646N71226Watkins Stephen Randolph · Shady Shores, TXBuilt 1946 · S/N 2653N71230Hopper Jerry L · Winfield, KSBuilt 1946 · S/N 2657N71231Yeash Kevin M · Pemberton, NJBuilt 1946 · S/N 2678N71232Flying L Aircraft Inc · Fort Denaud, FLS/N 2659N71236Clark Michael L · Milford, CABuilt 1946 · S/N 2663N71239Sowder David M · Boonville, INBuilt 1946 · S/N 2666N71240Schlosser Charles M · Webster, MNBuilt 1946 · S/N 2667N71245Kussatz Michael · Olathe, KSBuilt 1946 · S/N 2672N71252Willis Theresa J · Greenfield, INBuilt 1946 · S/N 2679N71261Magnuson Lloyd W · Opelousas, LABuilt 1946 · S/N 2688N71264Wilson Richard · Morriston, FLBuilt 1946 · S/N 2691N71275Lee Robert E · Medford, WIBuilt 1946 · S/N 2702N71277Allen Robert K · Dallas, TXBuilt 1946 · S/N 2704N71281Keller William R · East Amherst, NYBuilt 1946 · S/N 2708N71283Week James A · Sun Prairie, WIBuilt 1946 · S/N 2710N71288Wilcox Ross L · Santa Rosa, CAS/N 2715N71291Williams Garner W · Naperville, ILBuilt 1946 · S/N 2718N71295Logback Michael R · Mcpherson, KSBuilt 1946 · S/N 2722N71297Eigsti Rodney E Trustee · Friend, NEBuilt 1946 · S/N 2724N71299Hurlbert Vernon L · Anchorage, AKBuilt 1946 · S/N 2726N71301Chambers Todd R · Brundidge, ALS/N 2728N71303Roetman Donald E · Flippin, ARS/N 2730N71306Braswell Charles A Jr · Taylorsville, NCS/N 2733N71307Wings Den LLC · Wilmington, DEBuilt 1946 · S/N 2734N71308Woodson Robert L III · Fort Mill, SCBuilt 1946 · S/N 2735N71311Lady Luscombe LLC · Seattle, WABuilt 1946 · S/N 2738
Back to AD 96-24-17 R1