What is the pandas equivalent of the above SQL query?

pd.read_sql_query(""" SELECT flights.*, planes.year AS plane_year, planes.speed AS plane_speed, planes.seats AS plane_seats FROM flights LEFT JOIN planes ON flights.tailnum=planes.tailnum """, conn)