The National Company Law Appellate Tribunal (NCLAT) on Wednesday restored former Tata group Chairman Cyrus Mistry as executive chairman of Tata Group.