CREATE TABLE table_47705 ("Date" CLOB, "Flight" CLOB, "Aircraft" CLOB, "Registration" CLOB, "Location" CLOB, "Fatalities" FLOAT)

Which flight had the aircraft avro rj-100?
SELECT "Flight" FROM table_47705 WHERE "Aircraft" = 'avro rj-100'
SELECT "Flight" FROM "table_47705" WHERE "Aircraft" = 'avro rj-100'