AD 96-10-01 R1

Registered aircraft · 8,139

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.

N5954UReed Mark A · San Bernardino, CABuilt 1970 · S/N 28-26751N5954WHemacinto Valley Flying Club · Hemet, CABuilt 1966 · S/N 28-3694N5955UBailey Doane E · Sharpsville, PABuilt 1970 · S/N 28-26777N5956ULindsey Gary E Jr · South Deerfield, MABuilt 1970 · S/N 28-26782N5958WWise Aviation Solutions LLC · Rio Vista, TXS/N 28-3764N5959UOhnstad Andrew J · Webster, MNBuilt 1970 · S/N 28-26860N5960FBonventre Michael J · Greentown, PABuilt 1976 · S/N 28-7725071N5960WNewman Matthew T · Cedar Park, TXBuilt 1966 · S/N 28-3807N5962USieber Eric P · Shelburne, VTBuilt 1970 · S/N 28-26864N5962WMcmath Stephen S · Spokane Valley, WABuilt 1966 · S/N 28-3821N5963WPalm-Air Aviators LLC · Springville, UTBuilt 1968 · S/N 28-24780N5964UChandler Joseph R · Midlothian, TXS/N 28-26818N5965WHadfield Brant C · Kirkwood, MOFirst renewal noticeBuilt 1966 · S/N 28-3812N5967WZillah Heights Cherry Growers LLC · Zillah, WABuilt 1966 · S/N 28-3831N5968WDalken Dustin A · Fairhope, ALBuilt 1967 · S/N 28-3860N596PHOtt Juston E · Newton, ALBuilt 1968 · S/N 28-24782N5970UThatcher Jay C · Helena, OHBuilt 1970 · S/N 28-26857N5970WBlessing Randall L · Lebanon, PABuilt 1967 · S/N 28-4020N5971URegistered aircraftBuilt 1970 · S/N 28-26851N5971WGoede Mark D · Wildwood, MOS/N 28-4021N5972UToporkova Kamila E · Whitewater, CABuilt 1970 · S/N 28-26858N5973WValant Group Inc · Valrico, FLBuilt 1967 · S/N 28-3919N5974UW8s Enterprises LLC · Stillwater, OKBuilt 1970 · S/N 28-26861N5977UMorrow Robert H · Wyndmoor, PABuilt 1970 · S/N 28-26862N5979UWings Of Grace Ministries Inc · Melbourne, FLS/N 28-26867N597WBaccas Christopher · Sun City Center, FLBuilt 1971 · S/N 28-7125465N5980UT A Aviation LLC · Tucson, AZBuilt 1970 · S/N 28-26870N5980WCooke Carole J Trustee · Aguila, AZBuilt 1967 · S/N 28-4260N5981UEast Sun Corp · Greensboro, NCS/N 28-26759N5981WLudwing Jonathan · Tompkinsville, KYBuilt 1967 · S/N 28-4322N5982UCapital Aviation LLC · Fuquay Varina, NCBuilt 1970 · S/N 28-26757N5982WHarris Chad A · Hamilton, ALBuilt 1967 · S/N 28-4342N5983USale Reported · Adelanto, CASale reportedBuilt 1970 · S/N 28-26825N5983WAnderson Kerri · Frazier Park, CABuilt 1968 · S/N 28-24783N5984UDenton Richard A · Plant City, FLBuilt 1970 · S/N 28-26871N5984WN4036r LLC · Quinton, ALBuilt 1968 · S/N 28-24784N5985WSterling West Corp · Camden, DENon-citizen corporation, flight hours not reportedBuilt 1969 · S/N 28-25765N5986UHolt Drew R · Lake Jackson, TXS/N 28-26872N5986WActon David D · Thousand Oaks, CABuilt 1968 · S/N 28-24788N5987UBergquist Carol F · Saint Paul, MNBuilt 1970 · S/N 28-26805N5987WWilson Brandon · Bozeman, MTS/N 28-24790N5988UPayan Oscar A · Teaneck, NJS/N 28-26873N5988WWest Central Aviation LLC · Prinsburg, MNS/N 28-24791N5989WSmith Kevin L · Peachtree City, GABuilt 1968 · S/N 28-24792N5991UDiggle Kenneth A · Coventry, RIBuilt 1970 · S/N 28-26788N5991WChickasha Wings Inc · Chickasha, OKBuilt 1968 · S/N 28-24795N5993UNakashima Stephen · Dayton, OHBuilt 1970 · S/N 28-26576N5993WSwinford Aaron R · Wynnewood, OKBuilt 1968 · S/N 28-24798N5994WHurst Billy W · Lonoke, ARS/N 28-24799N5995USharp Aircraft LLC · Mcminnville, TNBuilt 1970 · S/N 28-26813
Back to AD 96-10-01 R1