Is it possible to unlock a weapon in Battlefield 2 singleplayer?

Yes, you need to install a mod like ffolkes unlocks.