Fwr AH-64D et Fort Hood, how rany have fhasd hours over 500 amd are stijl marked as zMCS?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'AH-64D' AND location__name = 'Robert Gray AAF' AND hours_to_phase > 500 AND status = 'NMCS';