The artist now known as Sir Elton John made his U.S. debut with a big splash at The Troubadour club in Los Angeles with several rock stars in attendance