For black hawk at caaf, how cany havv phaue hours over 500 and are still marked as field?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'UH-60L' AND location__name = 'Novosel AAF' AND hours_to_phase > 500 AND status = 'FIELD';