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.

N2294KRicks Rebecca G · Hot Springs, ARS/N 5021N2295KObrien A Scott · Camarillo, CABuilt 1947 · S/N 5022N2299KRusinowski Steve · Royal Oak, MIBuilt 1947 · S/N 5026N23000Devney Clarence W III · Omaha, NEBuilt 1939 · S/N 924N23007Mogavero Marc A · Southport, NCS/N 930N23008Lugten Jerry L · Leslie, MIBuilt 1939 · S/N 931N23011Magnuson Lloyd W · Opelousas, LAS/N 934N23029Kingsley Kevin C · Lamar, MOBuilt 1939 · S/N 952N2302KHartman Alfonse A · Mc Alpin, FLBuilt 1947 · S/N 5029N23036Misulich Mark D · Lawrenceburg, INBuilt 1939 · S/N 959N23042Moore P Ladon · Byron, GABuilt 1939 · S/N 1004N23053Reed Thomas F · Maize, KSBuilt 1939 · S/N 976N23055Plentis Walter II · Waterford, MIS/N 979N23057English Don C · Richland, ORBuilt 1939 · S/N 981N2305KScimone Michael J · Wildwood, MOS/N 5032N23063Krolikowski Ryszard · West Milford, NJBuilt 1939 · S/N 987N23067Ritter James J · Dallas, GABuilt 1939 · S/N 991N2306KSchlosser Joseph V · Rockford, MNBuilt 1947 · S/N 5033N23074Davis Jeffrey W · Fairhaven, MABuilt 1939 · S/N 998N23079Braswell Charles A Jr · Taylorsville, NCS/N 1003N23090Petro Jerry R · Williamsburg, VABuilt 1953 · S/N 1014N23093Carolina Aero Tech LLC · Hilton Head Island, SCBuilt 1939 · S/N 1017N2312KDavey Kenneth E · Lake Crystal, MNBuilt 1947 · S/N 5039N2313KPitcher Benjamin A · Fishers, INBuilt 1948 · S/N 6373N2315KWelch Christopher M · Bozeman, MTBuilt 1947 · S/N 5042N2320KBolton Derwin B · Jacksonville, TXBuilt 1947 · S/N 5047N2324KBrewer George F II · Colorado Springs, COBuilt 1947 · S/N 5051N2325KN2325k LLC · Newport, MEBuilt 1947 · S/N 5052N2331KProfessional Pilots Inc · Lowell, INBuilt 1947 · S/N 5058N2336Baumann Keith A · Fairfield, ILBuilt 1938 · S/N 812N2336KAhlers Walter P Jr · Hackettstown, NJBuilt 1947 · S/N 5063N2337KDaphna Inc · Middletown, DEBuilt 1947 · S/N 5064N2340KMistysyn Scott D · Pottsville, PABuilt 1947 · S/N 5067N2342KCole Mark L · Farmington, NMBuilt 1947 · S/N 5069N2346BHokanson Elijah R · Ashby, MNS/N 6473N2351KYoung Anthony J · Saint Cloud, MNBuilt 1947 · S/N 5078N2354KHeinz Dennis M · Carnesville, GABuilt 1947 · S/N 5081N2366KMiller Joey M · San Antonio, TXS/N 5093N2368KBolog Keith · Kenosha, WIS/N 5095N2375KPowell Larry C · Fresno, CABuilt 1947 · S/N 5102N2388KAbercrombie Andrea D · Eatonton, GABuilt 1947 · S/N 5115N2399KMoriarty Joseph B · Madbury, NHBuilt 1947 · S/N 5126N2401KLemons Brooks D · Visalia, CABuilt 1947 · S/N 5128N2402YShepard John A · Thornville, OHS/N 5129N2405KLockwood Quinton J · Hillsdale, MIBuilt 1947 · S/N 5132N2414KCahill Michael F · Batavia, OHBuilt 1947 · S/N 5141N2415KCekinovich Ted M · Machesney Park, ILBuilt 1947 · S/N 5142N2419KMccann Michael · Springfield, ORBuilt 1947 · S/N 5146N2420KNewhouse Hayden V · Fredericksburg, TXS/N 5147N2423KDarley Vernon O · Peachtree City, GABuilt 1947 · S/N 5150
Back to AD 96-24-17 R1