Show the names of pilots and fleet series of the aircrafts they have flied with in ascending order of the rank of the pilot.
SELECT T3.Pilot_name ,  T2.Fleet_Series FROM pilot_record AS T1 JOIN aircraft AS T2 ON T1.Aircraft_ID  =  T2.Aircraft_ID JOIN pilot AS T3 ON T1.Pilot_ID  =  T3.Pilot_ID ORDER BY T3.Rank
names of pilots and fleet series of the aircrafts they have flied with refers to Pilot_name and Fleet_Series from the tables pilot and aircraft respectively joined on a condition; in ascending order of the rank of the pilot refers to ORDER BY Rank ASC (default behavior for ORDER BY is ascending); joining tables based on related keys, Aircraft_ID and Pilot_ID, to link the data.