I am a native speaker, and I've heard "a riot" used to describe "a good time", but in isolation I'd definitely also picture the violent protest type of riot.

That said, this doesn't appear to to be a common usage in the US. Webster doesn't have this usage, Wiktionary describes it as obselete and pairs it more with excess than I would, (also they use fifteenth century examples), though Oxford has it.