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.

N71732Flemming Richard Eric · Kinsman, OHS/N 3159N71734Registration Pending · Lakemont, GARegistration pendingS/N 3173N71738Laroche John A · Ellington, CTBuilt 1946 · S/N 3165N71750Rushing Kevin W · Marks, MSS/N 3177N71760Schrage Jay T · Allison, IABuilt 1946 · S/N 3187N71765Stephen M Henley · Lexington, NCBuilt 1946 · S/N 3192N71771Mccartney Scott L · Plymouth, INBuilt 1946 · S/N 3198N71780Registration Pending · Lafayette, LARegistration pendingBuilt 1946 · S/N 3207N71781Smith William Lee · Langley, WAFirst renewal noticeBuilt 1946 · S/N 3208N71789Peterson Richard L · Crook, COBuilt 1946 · S/N 3216N71790Christy Ronald P · Covert, MIS/N 3217N71792Henley Charles D · New London, NCBuilt 1946 · S/N 3219N71793Shields Toby J · Cato, NYBuilt 1946 · S/N 3220N71800Miller Clyde D · Ionia, IABuilt 1946 · S/N 3227N71801Williams Christopher N · Redwood Valley, CAS/N 3228N71802Holbrook Joel P · Delta Junction, AKBuilt 1946 · S/N 3229N71804Adams Terry D · Boerne, TXS/N 3231N71806Cameron Thomas James · Stanchfield, MNBuilt 1946 · S/N 3233N71813Burdick Leon J · Cambridge Springs, PABuilt 1946 · S/N 3240N71814Collins Dennis M · Overgaard, AZBuilt 1946 · S/N 3241N71816Clark Nikita C · Ontario, ORBuilt 1946 · S/N 3243N71819Cuny John B · Carlsborg, WABuilt 1946 · S/N 3246N71824Forberg Robert E · Hudsonville, MIBuilt 1946 · S/N 3251N71825Tylenda John R · Bigelow, ARBuilt 1946 · S/N 3252N71826Bemidji Aviation Services Inc · Bemidji, MNBuilt 1946 · S/N 3253N71829Vaknin Michael · Pleasant Prairie, WIS/N 3256N71835Eads Timothy · West Linn, ORBuilt 1946 · S/N 3262N71836Taildragger Adventures Of Madison LLC · Madison, WIBuilt 1946 · S/N 3263N71845Kotranza Robert Roy · Houghton Lake, MIBuilt 1946 · S/N 3272N71854Wings N Nuts Inc · Canandaigua, NYBuilt 1946 · S/N 3281N71861Freudenberg Joseph B · Almira, WABuilt 1946 · S/N 3288N71862Seward Douglas L · Burlington, WABuilt 1946 · S/N 3289N71868Denly James E · Erie, COBuilt 1946 · S/N 3295N71872Barlow Charles E · Morganton, NCBuilt 1946 · S/N 3299N71875Laroche Susan L · Waukesha, WIBuilt 1946 · S/N 3302N71883Flight Department LLC · Santa Paula, CABuilt 1946 · S/N 3310N71887Wieland Jeffrey K · Elk Grove, CABuilt 1946 · S/N 3314N71891Emery Kyle Whitney · Mulberry, FLFirst renewal noticeBuilt 1946 · S/N 3318N71892Cleveland Chris · Denver, COBuilt 1946 · S/N 3319N71893Prough Ethan T · Godfrey, ILS/N 3320N71895Kell Thomas G · Anchorage, AKBuilt 1946 · S/N 3322N71901Langrell Sterling S · Woodburn, ORS/N 3328N71918Schepis Sally A · Perry, MIBuilt 1946 · S/N 3345N71919Professional Pilots Inc · Lowell, INBuilt 1946 · S/N 3346N71923Gann Nick · Conway, MOBuilt 1946 · S/N 3350N71928Singleton Bruce W · Grafton, OHBuilt 1946 · S/N 3355N71929Norsworthy Cletus C · Media, PABuilt 1946 · S/N 3356N71930Willis William P Trustee · New Palestine, INS/N 3357N71931Araldi Suzanne R · Lakeland, FLBuilt 1946 · S/N 3358N71932Swager Quentin D · Wrightwood, CAFirst renewal noticeBuilt 1946 · S/N 3359
Back to AD 96-24-17 R1