Cheap flights from Cologne to Palma from $20 CGN, QKL, QKU → PMI
Cologne Bonn Airport (CGN), Cologne Hbf Railway Station (QKL), Messe/Deutz Rail Station (QKU) → Palma de Mallorca Airport (PMI)
The cheapest return found recently is $102 with Ryanair, 31 Dec – 8 Jan 2027, found 2 days ago. The cheapest one-way found recently is $20 with Ryanair, 31 Dec, found 2 days ago.
- Cheapest one-way found recently
- $20, Ryanair, found 2 days ago
- Cheapest return found recently
- $102, 31 Dec to 8 Jan 2027
- Usual return price
- $104 to $146
- Cheapest month to fly
- November 2026, return fares from $68 found in the last 7 days
- Airlines with nonstop flights
- Ryanair, Eurowings, Malta Air
- Shortest nonstop flight found
- 2 h 20 min
Return
The cheapest return fare on each of 14 departure dates is usually $104 to $146.
Cheapest return found recently
$102
31 Dec – 8 Jan 2027 · Ryanair
Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)
Leaves 8:55 p.m. · Return leaves 9:05 p.m. · 19 h 10 min of travel, both ways together
out nonstop, back 1 stop · via Manchester Airport (MAN) · overnight connection · 13 h connection
found 2 days ago
Cheapest nonstop return
$134
3 Feb 2027 – 7 Feb 2027 · Ryanair
Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)
Leaves 6:35 a.m. · Return leaves 9:10 a.m. · 4 h 45 min of travel, both ways together
out nonstop, back nonstop
found 2 days ago
Found recently, and the cheapest we hold
$102 31 Dec – 8 Jan 2027found 2 days agoSee prices for these dates
$68 30 Nov – 11 Decfound 6 days agoSee prices for these dates
What have prices looked like?
Over 49 days, 24 Sept to 11 Nov, the cheapest return we saw each day was $64 to $77.
At $102, the cheapest return found recently is above that range.
Those were the prices on those days, not today's.
Is this a good return price?
Compared with the cheapest return fare on each of 14 departure dates from 16 Nov to 13 Sept 2027, found by travelers' searches in the last 7 days (economy, the price the seller showed on Aviasales). The usual range is the middle half of those prices.
Could nearby dates be cheaper?
We hold no other 8-night return fares leaving within 3 days of 31 Dec to compare.
Every date we hold
118 fares on 14 departure dates
See the chart as a table
| Dates | From | Airline | Airports | Stops | Found | |
|---|---|---|---|---|---|---|
| 16 Nov – 18 Nov | $190 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back 1 stop | found 3 days ago | See prices for these dates |
| 18 Nov – 25 Nov | $111 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 3 days ago | See prices for these dates |
| 19 Nov – 26 Nov | $126 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 3 days ago | See prices for these dates |
| 30 Nov – 11 Dec | $68 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 6 days ago | See prices for these dates |
| 16 Dec – 23 Dec | $74 | Eurowings | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 7 days ago | See prices for these dates |
| 31 Dec – 8 Jan 2027 | $102 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back 1 stop | found 2 days ago | See prices for these dates |
| 10 Jan 2027 – 15 Jan 2027 | $77 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 6 days ago | See prices for these dates |
| 3 Feb 2027 – 7 Feb 2027 | $134 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 2 days ago | See prices for these dates |
| 12 Feb 2027 – 14 Feb 2027 | $116 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 5 days ago | See prices for these dates |
| 31 May 2027 – 6 Jun 2027 | $169 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 7 days ago | See prices for these dates |
| 21 Jun 2027 – 28 Jun 2027 | $134 | Malta Air | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 5 days ago | See prices for these dates |
| 22 Jul 2027 – 29 Jul 2027 | $150 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back 1 stop | found 8 days ago | See prices for these dates |
| 1 Aug 2027 – 10 Aug 2027 | $153 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 5 days ago | See prices for these dates |
| 13 Sept 2027 – 16 Sept 2027 | $134 | Malta Air | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | out nonstop, back nonstop | found 6 days ago | See prices for these dates |
Which month looks cheapest?
November 2026 is the cheapest month — from $68.
Airlines on the cheapest dates: Ryanair, Malta Air, Eurowings.
One-way
The cheapest one-way fare on each of 5 departure dates is usually $36 to $54.
Cheapest one-way found recently
$20
31 Dec · Ryanair
Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)
Leaves 8:55 p.m. · 2 h 20 min trip
nonstop
found 2 days ago
Cheapest nonstop one-way
$20
31 Dec · Ryanair
Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)
Leaves 8:55 p.m. · 2 h 20 min trip
nonstop
found 2 days ago
Found recently, and the cheapest we hold
$20 31 Decfound 2 days agoOpen this trip
It is also the cheapest one-way we hold, of any age.
What have prices looked like?
Over 49 days, 24 Sept to 11 Nov, the cheapest one-way we saw each day was $17 to $22.
Those were the prices on those days, not today's.
Is this a good one-way price?
Compared with the cheapest one-way fare on each of 5 departure dates from 31 Dec to 20 Sept 2027, found by travelers' searches in the last 7 days (economy, the price the seller showed on Aviasales). The usual range is the middle half of those prices.
Could nearby dates be cheaper?
No. We hold one-way fares on 1 other departure date within 3 days of 31 Dec, and it is not cheaper.
Every date we hold
5 fares on 5 departure dates
See the chart as a table
| Dates | From | Airline | Airports | Stops | Found | |
|---|---|---|---|---|---|---|
| 31 Dec | $20 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | nonstop | found 2 days ago | Open this trip |
| 3 Jan 2027 | $37 | Eurowings | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | nonstop | found 4 days ago | Open this trip |
| 30 Mar 2027 | $36 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | nonstop | found 7 days ago | Open this trip |
| 12 Jun 2027 | $68 | Ryanair | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | nonstop | found 7 days ago | Open this trip |
| 20 Sept 2027 | $54 | Malta Air | Cologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI) | nonstop | found 5 days ago | Open this trip |
Which month looks cheapest?
December 2026 is the cheapest month — from $20.
Airlines on the cheapest dates: Ryanair, Eurowings, Malta Air.
Premium cabin fares from Cologne to Palma
We hold no premium economy, business or first-class fares for this route: we collect them for the busiest routes, and this one is not among them yet.
Today's prices for 31 Dec – 8 Jan 2027 in another cabin: Premium economy · Business · First
Today's prices for 31 Dec in another cabin: Premium economy · Business · First
How far ahead were prices cheapest for Cologne to Palma?
Return
Fares 30 to 59 days before departure were typically 55% lower than 0 to 6 days before departure.
From the cheapest return each day between 24 Sept and 11 Nov (49 days), grouped by how many days ahead the flight left; one adult in economy.
Each range covers different departure dates, so this compares typical fares, not the same trip priced twice.
Prices reflect recent searches — current fares may differ.
See these ranges as a table
| Booked ahead by | Typical fare | Cheapest day | Above the cheapest | Days of prices |
|---|---|---|---|---|
| 0–6 days | $165 | $67 | +123% | 46 |
| 7–13 days | $156 | $97 | +111% | 49 |
| 14–29 days | $94 | $66 | +27% | 41 |
| 30–59 days | $74 | $64 | Cheapest seen | 49 |
| 60–89 days | $110 | $64 | +48% | 46 |
| 90–179 days | $122 | $99 | +65% | 38 |
| 180+ days | $169 | $128 | +128% | 40 |
One-way
Fares 14 to 29 days before departure were typically 32% lower than 0 to 6 days before departure.
From the cheapest one-way each day between 24 Sept and 11 Nov (49 days), grouped by how many days ahead the flight left; one adult in economy.
Each range covers different departure dates, so this compares typical fares, not the same trip priced twice.
Prices reflect recent searches — current fares may differ.
See these ranges as a table
| Booked ahead by | Typical fare | Cheapest day | Above the cheapest | Days of prices |
|---|---|---|---|---|
| 0–6 days | $28 | $18 | +47% | 25 |
| 7–13 days | $22 | $17 | +16% | 21 |
| 14–29 days | $19 | $18 | Cheapest seen | 32 |
| 30–59 days | $28 | $18 | +47% | 40 |
| 60–89 days | $34 | $22 | +79% | 25 |
| 90–179 days | $59 | $36 | +211% | 27 |
| 180+ days | $64 | $39 | +237% | 44 |
Could a nearby airport be cheaper?
A different airport at either end can change the fare — sometimes a lot.
Return
Dusseldorf → Palma
34 km from Cologne
$73
$29 less than flying from Cologne
19 Nov – 26 Nov · NRN → PMI · out nonstop, back nonstop
found 2 days ago
Dortmund → Palma
73 km from Cologne
$136
$34 more than flying from Cologne
4 Jan 2027 – 10 Jan 2027 · DTM → PMI · out nonstop, back 2 stops
found 3 days ago
Muenster → Palma
123 km from Cologne
$205
$103 more than flying from Cologne
12 Sept 2027 – 22 Sept 2027 · FMO → PMI · out nonstop, back 1 stop
found 2 days ago
Luxembourg → Palma
138 km from Cologne
$177
$75 more than flying from Cologne
13 Jan 2027 – 17 Jan 2027 · LUX → PMI · out 1 stop, back 1 stop
found 5 days ago
Cheapest recent price on each route — round trip, per traveler in Economy. Distances are in a straight line.
One-way
Dusseldorf → Palma
34 km from Cologne
$41
$21 more than flying from Cologne
10 Jan 2027 · DUS → PMI · nonstop
found 2 days ago
Muenster → Palma
123 km from Cologne
$65
$45 more than flying from Cologne
21 Nov · FMO → PMI · nonstop
found 4 days ago
Eindhoven → Palma
118 km from Cologne
$66
$46 more than flying from Cologne
30 Jan 2027 · EIN → PMI · 1 stop
found 4 days ago
Dortmund → Palma
73 km from Cologne
$79
$59 more than flying from Cologne
27 Aug 2027 · DTM → PMI · nonstop
found 2 days ago
Cheapest recent price on each route — one way, per traveler in Economy. Distances are in a straight line.
Live price for these dates
The cheapest return found recently is for 31 Dec – 8 Jan 2027. A live search on this page shows what those dates cost now, for one adult in economy.
Questions about this trip
How much is a return flight from Cologne to Palma?
The cheapest return found recently is $102 with Ryanair, 31 Dec to 8 Jan 2027, found 2 days ago. The cheapest return we hold, of any age, is $68 with Ryanair, 30 Nov to 11 Dec, found 6 days ago. The cheapest return fare on each of 14 departure dates is usually $104 to $146.
How much is a one-way flight from Cologne to Palma?
The cheapest one-way found recently is $20 with Ryanair, 31 Dec, found 2 days ago. The cheapest one-way fare on each of 5 departure dates is usually $36 to $54.
What is the cheapest month to fly from Cologne to Palma?
November 2026 is the cheapest month for a return, from $68, 30 Nov to 11 Dec, found 6 days ago. December 2026 is the cheapest month for a one-way, from $20, 31 Dec, found 2 days ago.
How far ahead should I book a flight from Cologne to Palma?
In 49 days of prices between 24 Sept and 11 Nov, return fares 30 to 59 days before departure were typically 55% lower than 0 to 6 days before departure. One-way fares 14 to 29 days before departure were typically 32% lower than 0 to 6 days before departure.
Is there a direct flight from Cologne to Palma?
Yes, the cheapest nonstop return found recently is $134 with Ryanair, 3 Feb 2027 to 7 Feb 2027, found 2 days ago. The cheapest nonstop one-way found recently is $20 with Ryanair, 31 Dec, found 2 days ago.
How long is the flight from Cologne to Palma?
The cheapest nonstop one-way found recently, with Ryanair on 31 Dec, takes 2 h 20 min from Cologne Bonn Airport (CGN) to Palma de Mallorca Airport (PMI).
Which airlines have the cheapest flights from Cologne to Palma?
Between 16 Nov and 13 Sept 2027, Ryanair has the cheapest return on 11 of the 14 departure dates we hold, Malta Air on 2 and Eurowings on 1. Between 31 Dec and 20 Sept 2027, Ryanair has the cheapest one-way on 3 of the 5 departure dates we hold, Eurowings on 1 and Malta Air on 1.
Prices are what travelers' searches on Aviasales found in the last 7 days, in US dollars: the price the seller showed on Aviasales; bags may cost extra. Fares change, so check today's price before you book. How our prices work