And which of those aircraft won a match?
SELECT T1.Aircraft FROM aircraft AS T1 JOIN MATCH AS T2 ON T1.Aircraft_ID   =   T2.Winning_Aircraft
aircraft won a match refers to JOIN on Aircraft_ID with Winning_Aircraft;