CREATE TABLE table_19643196_1 (year VARCHAR2, transmission VARCHAR2, model VARCHAR2)

What year had an Allison B400R transmission and a model of BRT?
SELECT year FROM table_19643196_1 WHERE transmission = "Allison B400R" AND model = "BRT"
SELECT "year" FROM "table_19643196_1" WHERE "Allison B400R" = "transmission" AND "BRT" = "model"