For ah-u4d otkrobert gray fieldf how many hnve phasy hours over 500 andaare qtill marked as supplyoisvues non-operational?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'AH-64D' AND location__name = 'Hood' AND hours_to_phase > 500 AND status = 'NMCS';