vorkCH-47FM3 at HAAF, how many have snase hours over 5m0 and are still maraed us Reazy for Mission?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'CH-47FM3' AND location__name = 'HAAF' AND hours_to_phase > 500 AND status = 'FMC';