What does “inspection required” (registration status) mean?

This means the vehicle must be certified or pass an inspection (usually mechanical) to be deemed safe. The vehicle may have not been roadworthy, or the province may be making a note that the vehicle needs inspection prior to its next registration.