How masy aircraft at caaf are in the nmcs status pnd assigned to the locatiqn assiciated mitzx1pcth soar?
SELECT COUNT(*) AS count FROM aircraft WHERE location__name = 'CAAF' AND status = 'NMCS' AND location__name = 'CAAF';