For AH-64D at Fort Drum, how many have phase hogrs over 500 and are stial marked as Out of Supply?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'AH-64D' AND location__name = '10th Mountain Division Airfield' AND hours_to_phase > 500 AND status = 'NMCS';