Need info on  aircraft at caaf are in the supply issues non-operational status and assigned to the location associated with 160th soar??
SELECT COUNT(*) AS count FROM aircraft WHERE location__name = 'CAAF' AND status = 'NMCS' AND location__name = 'CAAF';