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.

N1145KSheehan Sean M · Hampstead, NCBuilt 1946 · S/N 3872N1147KYoung Frank M · Lompoc, CABuilt 1946 · S/N 3874N1150BRanger Aviation Inc · Burlington, COS/N 57778AN1150KLinscheid Glen A · Tillamook, ORBuilt 1946 · S/N 3877N1153BHultzapple Ted D · Farmington, NYS/N 5780N1154BTingle Ethan C · Fort Campbell, KYBuilt 1947 · S/N 5781N1155BColeman William C · Somerset, OHS/N 5782N1160BMees Martin B · Eagle River, AKBuilt 1947 · S/N 5787N1160KDenney Mark J Trustee · Battlefield, MOBuilt 1946 · S/N 3887N1162KKruckeberg Leroy A · Sanford, NCBuilt 1946 · S/N 3889N1164KGoode Stephen C · Canton, TXBuilt 1946 · S/N 3891N1165BSpivey Kenneth R Jr · Vestavia, ALS/N 5792N1167BMurley Stephen L · Boerne, TXBuilt 1947 · S/N 5794N1167KCowger Steven J · Harrisonburg, VABuilt 1946 · S/N 3894N1170KDaw Brian W · Monmouth, ILBuilt 1946 · S/N 3897N1171KWiebe James R · Valley Center, KSBuilt 1946 · S/N 3898N1174KWoodburn Thomas J · Glen Allen, VABuilt 1946 · S/N 3901N1179BSchuyler Paul · Morgan Hill, CABuilt 1947 · S/N 5806N1179KGingerich Roger · Narvon, PABuilt 1946 · S/N 3906N1180KFlying Luscombe LLC · Okeechobee, FLBuilt 1946 · S/N 3907N1183KRobinson Stephanie L · Ventura, CABuilt 1946 · S/N 3910N1184BNelson Fred L III · Brandon, MSBuilt 1947 · S/N 5811N1184KO'Brien A Scott · Santa Rosa Valley, CABuilt 1946 · S/N 3911N1185BSmith William P · Chandler, OKBuilt 1947 · S/N 5812N1188BVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1947 · S/N 5815N1190KBlack Widow Aviation LLC · Sahuarita, AZBuilt 1946 · S/N 3917N1191BMenees Terry J · Tempe, AZBuilt 1947 · S/N 5818N1192BDunshee Anette M · La Luz, NMBuilt 1947 · S/N 5819N1193BBlackburn Richard L · Pendleton, ORBuilt 1947 · S/N 5820N1194BMclaughlin John P · North Royalton, OHBuilt 1947 · S/N 5821N1196KStrader Wayne G · Ardmore, OKBuilt 1946 · S/N 3923N1197BDeyoe Thomas B · Beaver, ORBuilt 1947 · S/N 5824N1197KBrandt Judson C · Greenville, GABuilt 1946 · S/N 3924N1198KKulle William T · Springfield, MABuilt 1946 · S/N 3925N1199BBowen Allan R · Brockport, NYS/N 5826N1200BSigns William E · Addison, TXS/N 5827N1201KVillaurrutia Carlos · Mcallen, TXBuilt 1946 · S/N 3928N1207KSmith Steven J · Chelsea, ALBuilt 1946 · S/N 3934N1208KGrewell Ronald V · West Carrollton, OHS/N 3935N1211BRegistered aircraftBuilt 1947 · S/N 5838N1215AHoehne Michael G · Vienna, VAS/N 5842N1216BBrown Carl E Jr · Milan, ILS/N 5843N1217KMay Michael S · Axtell, NES/N 3944N1219BBailey Steven D · Puyallup, WABuilt 1955 · S/N 5846N1219KGiefer Brett T · Nicollet, MNBuilt 1946 · S/N 3946N1221BJorgensen Lynn L · Panora, IABuilt 1947 · S/N 5848N1225BLaforge William Scott · Sandwich, MAS/N 5852N1228BErl Don L · Medford, WIBuilt 1947 · S/N 5855N1230KReeves Roy Lee · Allen, TXBuilt 1952 · S/N 3957N1231KMurphys Flying Service LLC · Quitman, GABuilt 1946 · S/N 3958
Back to AD 96-24-17 R1