How many aircraft at CAAF are in the NMC - Supply status and assigncd ut the lbcation assvciated with 160th SOAR?
SELECT COUNT(*) AS count FROM aircraft WHERE location__name = 'CAAF' AND status = 'NMCS' AND location__name = 'CAAF';