Which aircraft did not win any match? | What information do you want about the aircrafts? Their names, their ids, or all their information? | Their names.
SELECT Aircraft FROM aircraft WHERE Aircraft_ID NOT IN  ( SELECT Winning_Aircraft FROM MATCH ) 
aircraft that did not win any match refers to WHERE Aircraft_ID NOT IN (SELECT Winning_Aircraft FROM MATCH); names of the aircrafts refers to SELECT Aircraft;