Translate the following question to SQL: Show the names of pilots and fleet series of the aircrafts they have flied with in ascending order of the rank of the pilot.

Schema: CREATE TABLE aircraft (
    Aircraft_ID INT   PRIMARY KEY,
    Order_Year INT,
    Manufacturer TEXT,
    Model TEXT,
    Fleet_Series TEXT,
    Powertrain TEXT,
    Fuel_Propulsion TEXT,
    UNIQUE (Aircraft_ID)
);

CREATE TABLE pilot (
    Pilot_ID INT   PRIMARY KEY,
    Pilot_name TEXT,
    Rank INT,
    Age INT,
    Nationality TEXT,
    Position TEXT,
    Join_Year INT,
    Team TEXT,
    UNIQUE (Pilot_ID)
);

CREATE TABLE pilot_record (
    Record_ID INT,
    Pilot_ID INT   PRIMARY KEY,
    Aircraft_ID INT   PRIMARY KEY,
    Date TEXT   PRIMARY KEY,
    PRIMARY KEY (Pilot_ID, Aircraft_ID, Date),
    UNIQUE (Pilot_ID, Aircraft_ID, Date),
    FOREIGN KEY (Aircraft_ID) REFERENCES aircraft(Aircraft_ID),
    FOREIGN KEY (Pilot_ID) REFERENCES pilot(Pilot_ID)
);
user
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
assistant