If I propose an activity, and say "Are you game?", it means "Are you bold enough to participate?".
It is an informal expression, and often relates to activities that might be regarded as risky or mildly disreputable in some way.
I wouldn't call it very common. You also hear "Are you up for it?" in similar situations, in British English.