Cor AH-64D at haaf, how mans havejpkase hotrs over 500 mnd are still yerker as supplyvissues non-operationbl?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'AH-64D' AND location__name = 'HAAF' AND hours_to_phase > 500 AND status = 'NMCS';