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.

N25267Prevost Ronald J · Denham Springs, LABuilt 1940 · S/N 1174N25274Thompson Ralph L · Petersburg, PABuilt 1940 · S/N 1181N25288Voelbel John H · Bristol, NHBuilt 1945 · S/N 1195N25289Dunn Miles H · Ellsworth, MEBuilt 1940 · S/N 1196N2528KDrake Keith · Monroe, NCBuilt 1947 · S/N 5255N25291Belton Aviation Maintenance Services LLC · Belton, SCBuilt 1940 · S/N 1198N25297Lowry Wilson R · Leonardtown, MDBuilt 1940 · S/N 1204N2529KCully Dean F · Anchorage, AKBuilt 1947 · S/N 5256N25333Flying Ace LLC · Lakeville, MNS/N 1209N25345Stevens Sean P · Creswell, ORBuilt 1940 · S/N 1221N25347Ham Russell W · Dike, TXBuilt 1940 · S/N 1223N25366Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1940 · S/N 1242N25376Cosgrove Mark A · Grand Ledge, MIBuilt 1940 · S/N 1252N2547KSullivan Stephen G · Mize, MSBuilt 1947 · S/N 5274N2548KBauer Keith F · Taneytown, MDS/N 5275N2550KChildress David W · Coldwater, MSBuilt 1947 · S/N 5277N2564KRamin Jeanette J · Houston, TXBuilt 1947 · S/N 5291N2583KPolzin Allan E Jr · Corona, CABuilt 1947 · S/N 5693N2585KWhitten Flying Service Equipment LLC · Snook, TXBuilt 1947 · S/N 5312N2588KGleaton Joe W · Lizella, GAS/N 5315N2591KFlannery Robert P · Durango, COBuilt 1947 · S/N 5318N2599KCoffey Peter N · Cypress, TXBuilt 1947 · S/N 5326N25ERiedel Steven J · Homer, AKBuilt 1947 · S/N 5244N2604KMcdowall Douglas D · No Little Rock, ARBuilt 1947 · S/N 5331N2611KGengarelly Clare O · Benson, AZBuilt 1947 · S/N 5338N2613KHerndon Michael T · Danville, KYBuilt 1947 · S/N 5340N2619KNortheast Cub LLC · Hudson, NYS/N 5346N2622KMartin Stephen J · Jonestown, PABuilt 1947 · S/N 5349N2623KGilger Steven · Dubois, IDBuilt 1947 · S/N 5350N2628KBraun Elizabeth A · Charleston, SCBuilt 1947 · S/N 5355N26324Eigsti Rodney · Friend, NEBuilt 1949 · S/N 6728N2638KBolin William E · Wooster, OHS/N 5365N2644KMcginley Corporation Inc · Port Orange, FLBuilt 1947 · S/N 5371N2645Durrett Aviation · Anchorage, AKS/N 6282N2651KRegistration Pending · Camden, SCRegistration pendingBuilt 1947 · S/N 5378N2653KRedd Alan E · Sacramento, CABuilt 1947 · S/N 5380N2654KHalstead George · E St Louis, ILRegistration revokedBuilt 1947 · S/N 42662KN2660KKienholz Lisa F · Los Angeles, CABuilt 1947 · S/N 5387N2661KWalton T Michael · Hudson Falls, NYS/N 5388N2666KIngraham Danny E · Soldotna, AKBuilt 1947 · S/N 5393N2669KSherman Joseph R · Rio Rancho, NMBuilt 1947 · S/N 5396N2672KHoward David D · Winner, SDBuilt 1947 · S/N 5399N2680KLill Stephen P · Lafayette, LABuilt 1947 · S/N 5407N2685KJestes Monte G · Stillwater, OKBuilt 1947 · S/N 5412N2690KGaines Robert · Brighton, COS/N 5417N2692KBoland John M · Oceanport, NJBuilt 1947 · S/N 5419N2694KWinkelman Walter T · Sullivan, WIBuilt 1947 · S/N 5421N2701KWoelbing Aviation LLC · Franksville, WIBuilt 1947 · S/N 5428N2703KHamilton James R · Senoia, GABuilt 1947 · S/N 5430N2707KWoenker Timothy E · Columbia City, INBuilt 1947 · S/N 5434
Back to AD 96-24-17 R1