Table schema:
CREATE TABLE table_name_28 (flight VARCHAR, aircraft VARCHAR)

Question: Which flight had the aircraft avro rj-100?
SQL: SELECT flight FROM table_name_28 WHERE aircraft = "avro rj-100"