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.

N2708KSwanson Gavin S · Jamestown, NYS/N 5435N2710KWhite Brian R · Concrete, WABuilt 1947 · S/N 5437N2719KNorsworthy Cletus C · Media, PABuilt 1947 · S/N 5446N2721KTibbitts Constance B · Marble Canyon, AZBuilt 1947 · S/N 5448N2722KN2722k LLC · Austin, TXBuilt 1947 · S/N 5449N2746KMiller Rondo T · Coon Rapids, MNBuilt 1947 · S/N 5473N2750KLeithead Bruce O · Stone Mountain, GABuilt 1947 · S/N 5477N2757KClassic Air 46 LLC · Cleveland, GABuilt 1947 · S/N 5484N2759KOtt Edward C · Walnut Creek, CAS/N 5486N2764KQueen Gregory A · Pickerington, OHBuilt 1947 · S/N 5491N2765KVance Scott R · Calverton, NYBuilt 1947 · S/N 5492N2767KRegistered aircraftBuilt 1947 · S/N 5494N276YHolliday Mark E · Lake Elmo, MNS/N 2723N2775KSanders Brian L · Tehachapi, CABuilt 1947 · S/N 5502N2778KDeloach Albert D · Del Valle, TXBuilt 1947 · S/N 5505N2781KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1947 · S/N 5508N2789KColvin Clu D DBA · Big Cabin, OKBuilt 1947 · S/N 5516N2790KThomson James W · Narragansett, RIBuilt 1947 · S/N 5517N2794KWallitner Raymond · Renton, WABuilt 1947 · S/N 5521N2795KIvy James III · Seligman, AZBuilt 1947 · S/N 5522N2796KWilson Roy M III · Cibolo, TXBuilt 1947 · S/N 5523N2797KWalton T Michael · Hudson Falls, NYS/N 5524N27RDWengerd Lavern W · Heron, MTBuilt 1946 · S/N 3969N2826KFallbrook Air Service Inc · Fallbrook, CABuilt 1947 · S/N 5553N2832KBalogh Andrew · Wellington, FLBuilt 1947 · S/N 5559N2833KCook Norman E · Davie, FLS/N 5560N2836KKent Stephen G · Danvers, MAS/N 5563N28404Bongiovanni Joseph T · Ocala, FLBuilt 1940 · S/N 1271N28412Poppy The Plane LLC · Hernando, FLBuilt 1940 · S/N 1279N28418Beetz Jerry C · Pearland, TXBuilt 1940 · S/N 1285N28419Shirlted LLC · Rome City, INBuilt 1940 · S/N 1286N28424Hooten William T Jr · Greenbrier, ARBuilt 1940 · S/N 1291N28428Johengen James M · Eau Claire, WIBuilt 1940 · S/N 1295N2842KMiller Steven L · Naperville, ILBuilt 1947 · S/N 5569N28430Lamb James M · Farmersville, OHBuilt 1940 · S/N 1297N28436Madaras William W · Eureka, CAS/N 1303N2843KMorrison John L · Oklahoma City, OKBuilt 1947 · S/N 5570N28441Mccormick Edward J Jr · Kenton, OHBuilt 1940 · S/N 1412N28442Jeffers Kyle A · New Carlisle, OHBuilt 1940 · S/N 1309N28443Hoecher Robert T · Anchorage, AKBuilt 1940 · S/N 1310N28444Plourde James D · Flint, MIBuilt 1940 · S/N 1311N28450Hataway Gregory L · Kinston, ALS/N 1317N28460Studenroth Arthur C · Hobart, INBuilt 1940 · S/N 1327N28461Smutny John · Auburn, WABuilt 1940 · S/N 1328N28465Davis Christopher Vance · Green Forest, ARS/N 1332N28468Perkins Dale J · Union, ORBuilt 1940 · S/N 1335N28473Uvanni Bruce A · Shelburne, VTBuilt 1940 · S/N 1340N28480Wigley Jan L · Centralia, WABuilt 1948 · S/N 1347N28485Lewis Timothy W · Thousand Palms, CAS/N 1352N28486Reed Michael D · Parsons, KSBuilt 1940 · S/N 1353
Back to AD 96-24-17 R1