Aldehyde reductase that catalyzes the reduction of the aldehyde carbonyl groups on saturated and alpha,beta-unsaturated aldehydes with more than 5 carbons. Belongs to the short-chain dehydrogenases/reductases (SDR) family.