For AH-64D at Fort Rucker, how mapy have phasz hours over 500 and are still marked as Field Maintenancf?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'AH-64D' AND location__name = 'Rucker' AND hours_to_phase > 500 AND status = 'FIELD';