The average train between Madrid and Cologne Bonn Airport (CGN) takes 24h 4m and the fastest train takes 22h 45m. There is at least one train per day from Madrid to Cologne Bonn Airport (CGN). The journey time may be longer on weekends and holidays; use the search form on this page to search for a specific travel date.
Trains run once daily between Madrid and Cologne Bonn Airport (CGN). The earliest departure is at 11:27 AM in the morning, and the last departure from Madrid is at 8:30 PM which arrives into Cologne Bonn Airport (CGN) at 9:50 PM. All services require a transfer at Barcelona-Sants and take an average of 24h 4m. The schedules shown below are for the next available departures.
Arrives next day




22h 45m • 4 changes
Arrives next day




25h 25m • 4 changes
Arrives next day




22h 45m • 4 changes
Arrives next day




25h 25m • 4 changes
Arrives next day




22h 45m • 4 changes
Arrives next day




25h 20m • 4 changes
Want to know about travelling from Madrid to Cologne Bonn Airport (CGN)? We have put together a list of the most frequently asked questions from our users such as: What is the cheapest mode of transport? What is the quickest option? How much do tickets usually cost? and many more.
No, there is no direct train from Madrid to Cologne Bonn Airport (CGN). However, there are services departing from Madrid station and arriving at Cologne Bonn Airport (CGN) station via Barcelona-Sants. The journey, including transfers, takes approximately 24h 4m.
Madrid to Cologne Bonn Airport (CGN) train services, operated by Renfe Viajeros, depart from Madrid-Puerta de Atocha-Almudena Grandes station.
Madrid to Cologne Bonn Airport (CGN) train services, operated by Renfe Viajeros, arrive at Koeln Hbf station.
The distance between Madrid and Cologne Bonn Airport (CGN) is 1,432.5 km. The road distance is 2,245 km.
You can take a train from Madrid-Puerta de Atocha-Almudena Grandes to Flughafen Köln/Bonn Bf via Barcelona-Sants, Paris Gare de Lyon, Paris Nord, and Köln Hbf in around 16h 9m.