Table schema:
CREATE TABLE table_name_39 (aircraft VARCHAR, type VARCHAR)

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