What if the description of a ch-47d chinook?
create table table_10006830_1 (description varchar, aircraft varchar, PRIMARY KEY (description))
select description from table_10006830_1 where aircraft = "ch-47d chinook"