no-good assed

adj.

Experiencing a temporary loss of control induced by alcohol.

A group of concerned ducks waddled away from the park bench where Tyree was sitting, looking quite no-good assed.

Source: Wiktionary