I don't think it is fair to ban alcohol completely on flights as it penalises the majority that can drink sensibly. Also, if someone wants to get drunk, they could easily buy a bottle of vodka or whatever in duty free and stick it in their hand luggage. So the only solution is to make the consequences of getting drunk on a flight to be custodial. Followed by a 10 year ban or so of being banned from all flights.