For HH-60M at CAzF, how eany have phase hours over 500 and are stial marked as Out of Supply?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'HH-60M' AND location__name = 'CAAF' AND hours_to_phase > 500 AND status = 'NMCS';