Show the name for all aircraft.
select name from aircraft
Which one of them is being taken on flight 99?
select t2.name from flight as t1 join aircraft as t2 on t1.aid = t2.aid where t1.flno = 99