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.

N1235KWheeler Brian K · Landenberg, PABuilt 1946 · S/N 3962N1237BOmlid Robert L · Watford City, NDBuilt 1957 · S/N 5760N1237KKush John J Jr · Oil City, PABuilt 1946 · S/N 3964N1264KWarnock Edward R Trustee · Garden Valley, CABuilt 1946 · S/N 3991N1268BLill Stephen P · Lafayette, LABuilt 1947 · S/N 5895N1268KDanielson Bradley K · Sunburg, MNBuilt 1946 · S/N 3995N1273BDorazio Rp · Winooski, VTS/N 5900N1273KWhitlock Paul H · Kent, WAS/N 4000N1275KHarris Kenneth B · El Dorado, ARBuilt 1946 · S/N 4002N1277BBennett Robert M · Felton, DEBuilt 1947 · S/N 5904N1278KHanson Toby J · Webster, MNBuilt 1946 · S/N 4005N1279BCrane Ryan S · Poplar Grove, ILBuilt 1947 · S/N 5906N1279KPellenz Edward J · Brandon, FLBuilt 1946 · S/N 4006N127DBPrice Gregory L · Kyle, TXBuilt 1947 · S/N 5874N1280BTailwheel Aviators Llp · Kokomo, INBuilt 1947 · S/N 5907N1282BSchrage John R · Urbandale, IABuilt 1947 · S/N 5909N1286BIngraham Jim E · Woodland, CAS/N 5913N1291BKegin Kevin M · Salem, ILBuilt 1947 · S/N 5918N1293BHamilton Terry D · Adams, MNBuilt 1947 · S/N 5920N1294MPosey Brothers Inc · Pipersville, PABuilt 1946 · S/N 4021N1297KMills Robert D · Newport, MIBuilt 1946 · S/N 4024N1298BJury Steven T · Fresno, CABuilt 1947 · S/N 5925N1302BSns Flyers LLC · Salinas, CABuilt 1948 · S/N 5929N1303KMiller James A · Granada Hills, CABuilt 1946 · S/N 4030N1304KMurphy Glen T · Campbell, TXBuilt 1946 · S/N 4031N130RHHendry Rickey William · Apple Springs, TXS/N 5935N1313KWestrum Durl T · Norwalk, IABuilt 1946 · S/N 4040N1314BHildebrant Steven C · Newborn, GABuilt 1948 · S/N 5941N1315KBrumby William R · Dunnellon, FLS/N 4042N1318KPratt James M III · Hoffman Estates, ILBuilt 1947 · S/N 4045N1319KJames Dennis K · La Crosse, VABuilt 1946 · S/N 4046N1321BReck Robert Cody · Cameron, MTBuilt 1948 · S/N 5948N1323BMoyer Alan L · Perkasie, PABuilt 1948 · S/N 5950N1325BRemax Flying Club · West Plains, MOBuilt 1948 · S/N 5952N1325KGilpin Nathan L · Cornelia, GABuilt 1946 · S/N 4052N1327Anderson Mark A · Bates City, MOS/N 801N1329KCarson Ronald G · San Antonio, TXBuilt 1946 · S/N 4056N1330BKazamias Evangelios · Niles, ILBuilt 1948 · S/N 5957N1331KCarlson Carl A · Geneva, NYS/N 4058N1333KSenkair LLC · Sylvester, GABuilt 1946 · S/N 4060N1336BDeckett William H · East Tawas, MIBuilt 1948 · S/N 5963N1337BLerille Mark J · Lafayette, LAS/N 5964N1343BSchneider David W · Richfield, MNS/N 5970N1343KVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1946 · S/N 4070N1345KCollins Camden B · Millersport, OHBuilt 1946 · S/N 4072N1346BFugate David W · Hamilton, OHBuilt 1948 · S/N 5973N1347BCorley Charles P · Wesley Chapel, FLBuilt 1948 · S/N 5974N1350BHeiderscheidt Sam T · Hector, MNBuilt 1948 · S/N 5977N1350KLewis John E · Claytonon, NJBuilt 1946 · S/N 4077N1353BShaw James J · Loranger, LABuilt 1948 · S/N 5980
Back to AD 96-24-17 R1