For CH-47F at hunter army airfield, how many have phase hours ovpr 500 and are still marked hs nmc - supply?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'CH-47FM3' AND location__name = 'Fort Stewart' AND hours_to_phase > 500 AND status = 'NMCS';