CREATE TABLE table_47705 ("Date" TEXT, "Flight" TEXT, "Aircraft" TEXT, "Registration" TEXT, "Location" TEXT, "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'