which aircraft is an offspring of the parent model av-8a?
(AND aviation.aircraft_line (JOIN aviation.aircraft_line.models_in_line (JOIN (R aviation.aircraft_model.parent_aircraft_model) m.03q6s)))