AD 96-10-01 R1

Registered aircraft · 8,138

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-10-01-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-10-01-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.

N32258Wing Rentals LLC · Phoenix, AZBuilt 1974 · S/N 28-7505043N32265Norsesian Brandon · Valrico, FLBuilt 1974 · S/N 28-7525040N32271Tylka Edward · Lockport, ILBuilt 1974 · S/N 28-7505044N32274Simaan Daniel · Fontana, CABuilt 1974 · S/N 28-7525042N32293Stone James B · Springfield, VABuilt 1974 · S/N 28-7505046N32296Fly South Aviation LLC · Charlotte, NCBuilt 1974 · S/N 28-7525046N32314Fort Dodge Flight Support Inc · Fort Dodge, IABuilt 1974 · S/N 28-7525048N3231QCollins Gregory J · Appleton, WIBuilt 1977 · S/N 28-7725220N32326Blair James J Jr · Brick, NJBuilt 1974 · S/N 28-7525050N32336Simmer Nicholas Lee · Rock Falls, ILBuilt 1974 · S/N 28-7525052N32355Finlayson Duncan Robert · Estacada, ORBuilt 1974 · S/N 28-7505053N32361Odom Eric J · Johnson City, TNBuilt 1974 · S/N 28-7525055N32369Avia Flight Academy LLC · Stratford, CTBuilt 1974 · S/N 28-7505054N32378Sanders David D · Alvin, TXBuilt 1974 · S/N 28-7505055N32386Rice Craig W · Walnut Creek, CABuilt 1974 · S/N 28-7525058N32387Mclelland Brenda M · Springfield, MOBuilt 1974 · S/N 28-7525059N32392Devrnja Aero LLC · Knoxville, TNBuilt 1974 · S/N 28-7505056N32397Tanya Austin L · Newburgh, NYBuilt 1974 · S/N 28-7525062N323BETracy Brian R · Georgetown, OHBuilt 1963 · S/N 28-1086N323JMDubbert Roger D · Mexico, MOBuilt 1970 · S/N 28-7125096N32405Hop-Hi Aviation LLC · St Louisville, OHS/N 28-7505057N32413Peterson Paul · Maryville, TNS/N 28-7505058N32419Registered aircraftBuilt 1974 · S/N 28-7525064N32426Fly Aviation LLC · Sabetha, KSBuilt 1974 · S/N 28-7505059N32435Nickos Ryan L · Kenosha, WIS/N 28-7525066N32436Townsend Ricky E · Rogers, ARS/N 28-7525067N32441Registration Pending · Kalispell, MTRegistration pendingS/N 28-7505060N32466Oh Heung Taeg · Olney, MDBuilt 1974 · S/N 28-7505062N32475Eikenberry Don A · Palouse, WABuilt 1974 · S/N 28-7525072N32480Alphakiloecho LLC · Somerville, MABuilt 1974 · S/N 28-7505063N32500Fairfield Flying Service Inc · Fairfield, IAS/N 28-7525076N32505N83at LLC · Dover, DEBuilt 1974 · S/N 28-7505065N32506Schuhler Louis A · Plainfield, ILBuilt 1974 · S/N 28-7505066N32514Summit Flight Academy LLC · Peculiar, MOS/N 28-7525075N32525Willaford Gina T · Cape Coral, FLBuilt 1974 · S/N 28-7525078N32526Cannon Adam H · Purcell, OKS/N 28-7525079N32534Bh534 LLC · West Hartford, CTBuilt 1974 · S/N 28-7505069N32539Orosz Ryan · Santa Clara, CABuilt 1974 · S/N 28-7505050N32540Registration Pending · Mocksville, NCRegistration pendingBuilt 1975 · S/N 28-7525081N32544Swaz Aviation LLC · Mesa, AZBuilt 1974 · S/N 28-7505071N32551Gcbc LLC · Norman, OKBuilt 1974 · S/N 28-7505072N32556Mcguire Richard L · Valparaiso, INBuilt 1974 · S/N 28-7525083N325925niner2 Aviation LLC · Washington, DCBuilt 1974 · S/N 28-7505075N32627Joyner Hudson Ellis · Memphis, TNS/N 28-7525091N3263PSalazar Ralph T Jr · Leesville, LABuilt 1965 · S/N 28-2338N32646Russell Thomas Carl · Beverly Hills, FLBuilt 1974 · S/N 28-7525094N32653Emerald Flyers LLC · Everett, WABuilt 1974 · S/N 28-7505079N32684Registration Pending · Brooks, GARegistration pendingBuilt 1974 · S/N 28-7525097N32692Holland Walter E Trustee · Casa Grande, AZBuilt 1974 · S/N 28-7505083N326MMHarrington James G · Westport, MABuilt 1973 · S/N 28-7325347
Back to AD 96-10-01 R1