to deal with drunk passengers (during flight) there is ONLY one way...GIVE HIM/HER MORE ALCOHOL...till he/she becomes immobilized....all other ways you play with fire
Somewhat contrary to the RSA (Responssible Service of Alcohol) principals, which might see the crew in more trouble than the offender in some jurisdictions.