What are the names of all aircrafts that are associated with both London Heathrow and Gatwick airports?
CREATE TABLE aircraft (
    aircraft_id number,
    aircraft text,
    description text,
    max_gross_weight text,
    total_disk_area text,
    max_disk_loading text
)

CREATE TABLE pilot (
    pilot_id number,
    name text,
    age number
)

CREATE TABLE airport (
    airport_id number,
    airport_name text,
    total_passengers number,
    %_change_2007 text,
    international_passengers number,
    domestic_passengers number,
    transit_passengers number,
    aircraft_movements number,
    freight_metric_tonnes number
)

CREATE TABLE match (
    round number,
    location text,
    country text,
    date text,
    fastest_qualifying text,
    winning_pilot text,
    winning_aircraft text
)

CREATE TABLE airport_aircraft (
    id number,
    airport_id number,
    aircraft_id number
)
SELECT T1.aircraft FROM aircraft AS T1 JOIN airport_aircraft AS T2 ON T1.aircraft_id = T2.aircraft_id JOIN airport AS T3 ON T2.airport_id = T3.airport_id WHERE T3.airport_name = "London Heathrow" INTERSECT SELECT T1.aircraft FROM aircraft AS T1 JOIN airport_aircraft AS T2 ON T1.aircraft_id = T2.aircraft_id JOIN airport AS T3 ON T2.airport_id = T3.airport_id WHERE T3.airport_name = "London Gatwick"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the names of all aircrafts that are associated with both London Heathrow and Gatwick airports? ### Input: CREATE TABLE aircraft (
    aircraft_id number,
    aircraft text,
    description text,
    max_gross_weight text,
    total_disk_area text,
    max_disk_loading text
)

CREATE TABLE pilot (
    pilot_id number,
    name text,
    age number
)

CREATE TABLE airport (
    airport_id number,
    airport_name text,
    total_passengers number,
    %_change_2007 text,
    international_passengers number,
    domestic_passengers number,
    transit_passengers number,
    aircraft_movements number,
    freight_metric_tonnes number
)

CREATE TABLE match (
    round number,
    location text,
    country text,
    date text,
    fastest_qualifying text,
    winning_pilot text,
    winning_aircraft text
)

CREATE TABLE airport_aircraft (
    id number,
    airport_id number,
    aircraft_id number
) ### Response: SELECT T1.aircraft FROM aircraft AS T1 JOIN airport_aircraft AS T2 ON T1.aircraft_id = T2.aircraft_id JOIN airport AS T3 ON T2.airport_id = T3.airport_id WHERE T3.airport_name = "London Heathrow" INTERSECT SELECT T1.aircraft FROM aircraft AS T1 JOIN airport_aircraft AS T2 ON T1.aircraft_id = T2.aircraft_id JOIN airport AS T3 ON T2.airport_id = T3.airport_id WHERE T3.airport_name = "London Gatwick"