 His career in the New Brunswick Legislative Assembly ended when he lost his seat in 2006 to Liberal MLA, Rick Miles.In May 2008, he was appointed a Judge of the Court of Queen's Bench for the judicial district of Saint John.Green was named to the Court of Appeal of New Brunswick in Fredericton on September 1, 2009.