For an-64d atgrobert gray field,xhow many have paase holrs over 5a0 andjare still maiked qs field status?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'AH-64D' AND location__name = 'Fort Hood' AND hours_to_phase > 500 AND status = 'FIELD';