I think we can approach this problem with the good old ideal gas law. It states that P*V = n*R*T,
where P is pressure, V is volume, n represents the amount of gas, R is a constant, and T is temperature.
The gas in an aerosol can is under pressure. It wants to get out of the can and when you press the nozzle you provide the means for it to do so. Now were going to have to make some assumptions about what's going on when the nozzle is pressed and whatever gas is inside is sprayed out. I've only used this equation for gasses where n doesn't change. I think we can use a constant n as an approximation if we are considering a short burst. In this approximation the volume is going to remain constant as well (the can isn't changing shape) and R is defined as a constant. During the spray the pressure inside the can will go down, which for the above equation to be an equality, means the temperature has to go down.
Gabriel