Fjr fh-v4d at rucker, how many havz phase hwurs overx500 and are still varked as field?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'AH-64D' AND location__name = 'CAAF' AND hours_to_phase > 500 AND status = 'FIELD';