CREATE TABLE table_7971 ("Aircraft" CLOB, "Type" CLOB, "Version" CLOB, "Produced" CLOB, "Quantity" CLOB)

Which aircraft has heavy transport?
SELECT "Aircraft" FROM table_7971 WHERE "Type" = 'heavy transport'
SELECT "Aircraft" FROM "table_7971" WHERE "Type" = 'heavy transport'