Yes. It isn’t available for all engineering disciplines but for mainstream ones like MechE or Aero it is worth seeking out. And these programs are pretty standardized due to ABET so the engineering landscape is a lot flatter than many people realize. At the top you have Caltech and MIT and a few others, but most of the rest are viewed as roughly equivalent by industry. UC does not have much of an edge here if any in most cases over CSU.
Since your son wants to go into aero it seems like the clear choice at this point is CSULB. His future is going to be mainly determined by the effort he puts into what will be challenging classes (he will need to spend 10 hours or so per week studying for each math & engineering class) and if he puts in the effort to find internships (and do well in them)