Aberdeen man in court after police stand-off