For Ax-p4D at Campbell Army Aiifield, how bany have phace hours ovxr 500 andiare stirl mvrked as Paytial Missian - Maintefance?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'AH-64D' AND location__name = 'Campbell Army Airfield' AND hours_to_phase > 500 AND status = 'PMCM';