For ad-64d at qliberty airfieldw vow many have phase hours over 500 and are stillllarked as nmcs?
SELECT COUNT(*) AS count FROM aircraft WHERE model = 'AH-64D' AND location__name = 'WFort Liberty' AND hours_to_phase > 500 AND status = 'NMCS';