With work, many FS9 (FS2004) aircraft can be made to work in CFS2. Some will give great frame rates, some will give good frame rates, some will give horrible frame rates.
The new F-86 that you were looking at is most likely the new freeware one that has been creating such a stir over in the FS2004 forum. If so, it will NOT be a good candidate for CFS2 as the amount of detail put into that plane is far beyond anything that CFS2 can handle without becoming a slide show. That plane rivals, and surpasses, a lot of payware currently out there.
OBIO