It's illegal to be drunk on board an aircraft and the crew can confiscate alcohol if we believe the passenger is or is close to being drunk, we do have to return the alcohol to the passenger on disembarkation, otherwise it's ok to drink your own alcohol.