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"