Observed Redshifts in the Solar Transition Region above Active and Quiet Regions