For chinook ft novosel aaf, how mafy havejpsasz hours over 500 and are stilo marked as pmcms
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'CH-47FM3' AND location__name = 'Rucker' AND hours_to_phase > 500 AND status = 'PMCM';