CREATE TABLE table_name_39 (aircraft VARCHAR, type VARCHAR)

Which aircraft has heavy transport?
SELECT aircraft FROM table_name_39 WHERE type = "heavy transport"
SELECT "aircraft" FROM "table_name_39" WHERE "heavy transport" = "type"