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.

N71312Frasca Air Museum · Urbana, ILBuilt 1946 · S/N 2739N71313Albers Edward R · St Charles, ILBuilt 1946 · S/N 2740N71315Shewalter Nicholas · Frankfort, MIBuilt 1946 · S/N 2742N71318Allen Benjamin S · Flowery Branch, GABuilt 1946 · S/N 2745N71328Egbert Charles A · Mogadore, OHBuilt 1946 · S/N 2755N71329Eigsti Rodney E Trustee · Friend, NES/N 2756N71342Oliva Samuel A · Lebanon, TNBuilt 1946 · S/N 2769N71345Zawalski Mark G · Webster Groves, MOBuilt 1946 · S/N 2772N71346Osmndson Thomas J · Kent, WABuilt 1946 · S/N 2773N71352Hare Hayden H · Roanoke, ALBuilt 1946 · S/N 2779N71353Sides Jerry Webster · Medina, TXBuilt 1946 · S/N 2780N71356Glenn Larry W · Bunn, NCS/N 2783N71363Registered aircraftBuilt 1946 · S/N 2790N71364Collins Camden B · Millersport, OHBuilt 1946 · S/N 2791N71365Atwell Christopher Allen · Leesburg, FLBuilt 1946 · S/N 2792N71366Monteleone Gene R · Mount Vernon, TXBuilt 1946 · S/N 2793N71372Lee Johnathan C · New Braunfels, TXBuilt 1946 · S/N 2799N71373Wilson Mikel W · Picayune, MSBuilt 1946 · S/N 2800N71379Lowry Wilson R · Leonardtown, MDBuilt 1946 · S/N 2806N71381Windsock Capital LLC · Bertram, TXS/N 2808N71385Scott Steve W · Antioch, CABuilt 1946 · S/N 2812N71389Jacobs William O Jr · Holly Hill, FLS/N 2816N71402Dierks Herman D Jr · Round Rock, TXBuilt 1946 · S/N 2829N71406Tomlin Rayburn H · Burleson, TXBuilt 1946 · S/N 2833N71407Kreikemeier Terry L · Garfield, WABuilt 1946 · S/N 2834N71413Thompson Eric J · Tempe, AZBuilt 1946 · S/N 2840N71416Smith Mark E · Mount Morris, NYBuilt 1946 · S/N 2843N71425Harris Jeremy B · Boring, ORBuilt 1946 · S/N 2852N71428Walker Ray A · Sanger, TXBuilt 1946 · S/N 2855N71434Goudeau Todd J · Broussard, LABuilt 1946 · S/N 2861N71441Oconnell Marcia S Trustee · Coeur D Alene, IDBuilt 1946 · S/N 2868N71442Grueninger Mark J · Benton, ILBuilt 1946 · S/N 2869N71448Registered aircraftBuilt 1946 · S/N 2875N71455Slomer James A · Cheswick, PAS/N 2882N71461Gumley Jamison J · Wasilla, AKBuilt 1946 · S/N 2888N71465Baxter Thomas L · Stockbridge, GABuilt 1946 · S/N 2892N71467Dombrowski Gregory · Mangum, OKBuilt 1946 · S/N 2894N71470Murphys Flying Service LLC · Thomasville, GAS/N 2897N71472Bedford Dennis L · Auke Bay, AKBuilt 1946 · S/N 2899N71476Cruz Jesse · Simi Valley, CABuilt 1946 · S/N 2903N71479Sale Reported · Elizabeth, COSale reportedBuilt 1946 · S/N 2906N71480Clark Trevor D · Sheridan, WYS/N 2907N71486Wasson Tina A · Lakeport, CABuilt 1946 · S/N 2913N71488Booker Louis E · Pinetop, AZBuilt 1946 · S/N 2915N71492Adkins Dwain L · Sycamore, ILFirst renewal noticeBuilt 1946 · S/N 2919N71496Doyle Robin C · Denham Springs, LABuilt 1946 · S/N 2923N71498Eaton Mark E · Houston, TXBuilt 1946 · S/N 2925N71499Monahan Robert J · Bulverde, TXBuilt 1946 · S/N 2926N71500Colomello Charles P · Tillson, NYBuilt 1946 · S/N 2927N71504Loonam Christopher J · Morgan Hill, CABuilt 1946 · S/N 2931
Back to AD 96-24-17 R1