Popular on the terraces, David captained Newcastle at the turn of the century and made one appearance for Scotland.