Skip to content

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

See prices for these datesCheck today's price

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

See prices for these datesCheck today's price

FareTell may earn a commission when you book through a partner.

Found recently, and the cheapest we hold

Cheapest found recently $102 31 Dec – 8 Jan 2027found 2 days agoSee prices for these dates

Cheapest we hold, of any age $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

16 Nov – 18 Nov: $190, found 3 days ago18 Nov – 25 Nov: $111, found 3 days ago19 Nov – 26 Nov: $126, found 3 days ago30 Nov – 11 Dec: $68, found 6 days ago16 Dec – 23 Dec: $74, found 7 days ago31 Dec – 8 Jan 2027: $102, found 2 days ago10 Jan 2027 – 15 Jan 2027: $77, found 6 days ago3 Feb 2027 – 7 Feb 2027: $134, found 2 days ago12 Feb 2027 – 14 Feb 2027: $116, found 5 days ago31 May 2027 – 6 Jun 2027: $169, found 7 days ago21 Jun 2027 – 28 Jun 2027: $134, found 5 days ago22 Jul 2027 – 29 Jul 2027: $150, found 8 days ago1 Aug 2027 – 10 Aug 2027: $153, found 5 days ago13 Sept 2027 – 16 Sept 2027: $134, found 6 days agoNovDecJanFebMayJunJulAugSep
See the chart as a table
The cheapest price seen for each departure date — per traveler in Economy.
DatesFromAirlineAirportsStopsFound
16 Nov – 18 Nov$190RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back 1 stopfound 3 days agoSee prices for these dates
18 Nov – 25 Nov$111RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 3 days agoSee prices for these dates
19 Nov – 26 Nov$126RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 3 days agoSee prices for these dates
30 Nov – 11 Dec$68RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 6 days agoSee prices for these dates
16 Dec – 23 Dec$74EurowingsCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 7 days agoSee prices for these dates
31 Dec – 8 Jan 2027$102RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back 1 stopfound 2 days agoSee prices for these dates
10 Jan 2027 – 15 Jan 2027$77RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 6 days agoSee prices for these dates
3 Feb 2027 – 7 Feb 2027$134RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 2 days agoSee prices for these dates
12 Feb 2027 – 14 Feb 2027$116RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 5 days agoSee prices for these dates
31 May 2027 – 6 Jun 2027$169RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 7 days agoSee prices for these dates
21 Jun 2027 – 28 Jun 2027$134Malta AirCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 5 days agoSee prices for these dates
22 Jul 2027 – 29 Jul 2027$150RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back 1 stopfound 8 days agoSee prices for these dates
1 Aug 2027 – 10 Aug 2027$153RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 5 days agoSee prices for these dates
13 Sept 2027 – 16 Sept 2027$134Malta AirCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)out nonstop, back nonstopfound 6 days agoSee prices for these dates

Which month looks cheapest?

November 2026 is the cheapest month — from $68.

November 2026From $68Cheapest seen4 departure dates30 Nov – 11 Dec · found 6 days agoSee prices for these dates
December 2026From $742 departure dates16 Dec – 23 Dec · found 7 days agoSee prices for these dates
January 2027From $771 departure date10 Jan 2027 – 15 Jan 2027 · found 6 days agoSee prices for these dates
February 2027From $1162 departure dates12 Feb 2027 – 14 Feb 2027 · found 5 days agoSee prices for these dates
May 2027From $1691 departure date31 May 2027 – 6 Jun 2027 · found 7 days agoSee prices for these dates
June 2027From $1341 departure date21 Jun 2027 – 28 Jun 2027 · found 5 days agoSee prices for these dates
July 2027From $1501 departure date22 Jul 2027 – 29 Jul 2027 · found 8 days agoSee prices for these dates
August 2027From $1531 departure date1 Aug 2027 – 10 Aug 2027 · found 5 days agoSee prices for these dates
September 2027From $1341 departure date13 Sept 2027 – 16 Sept 2027 · found 6 days agoSee prices for these dates

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

Open this tripCheck today's price

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

Open this tripCheck today's price

FareTell may earn a commission when you book through a partner.

Found recently, and the cheapest we hold

Cheapest found recently $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.

$20, the cheapest one-way found recently, sits here in that range of $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

31 Dec: $20, found 2 days ago3 Jan 2027: $37, found 4 days ago30 Mar 2027: $36, found 7 days ago12 Jun 2027: $68, found 7 days ago20 Sept 2027: $54, found 5 days agoDecJanMarJunSep
See the chart as a table
The cheapest price seen for each departure date — per traveler in Economy.
DatesFromAirlineAirportsStopsFound
31 Dec$20RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)nonstopfound 2 days agoOpen this trip
3 Jan 2027$37EurowingsCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)nonstopfound 4 days agoOpen this trip
30 Mar 2027$36RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)nonstopfound 7 days agoOpen this trip
12 Jun 2027$68RyanairCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)nonstopfound 7 days agoOpen this trip
20 Sept 2027$54Malta AirCologne Bonn Airport (CGN) → Palma de Mallorca Airport (PMI)nonstopfound 5 days agoOpen this trip

Which month looks cheapest?

December 2026 is the cheapest month — from $20.

December 2026From $20Cheapest seen1 departure date31 Dec · found 2 days agoOpen this trip
January 2027From $371 departure date3 Jan 2027 · found 4 days agoOpen this trip
March 2027From $361 departure date30 Mar 2027 · found 7 days agoOpen this trip
June 2027From $681 departure date12 Jun 2027 · found 7 days agoOpen this trip
September 2027From $541 departure date20 Sept 2027 · found 5 days agoOpen this trip

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.

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
Typical price in each booking range — round trip, per traveler in Economy.
Booked ahead byTypical fareCheapest dayAbove the cheapestDays 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$64Cheapest seen49
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
Typical price in each booking range — one way, per traveler in Economy.
Booked ahead byTypical fareCheapest dayAbove the cheapestDays of prices
0–6 days$28$18+47%25
7–13 days$22$17+16%21
14–29 days$19$18Cheapest seen32
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

See this route

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

See this route

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

See this route

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

Check today's price

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

See this route

Muenster → Palma

123 km from Cologne

$65

$45 more than flying from Cologne

21 Nov · FMO → PMI · nonstop

found 4 days ago

See this route

Eindhoven → Palma

118 km from Cologne

$66

$46 more than flying from Cologne

30 Jan 2027 · EIN → PMI · 1 stop

found 4 days ago

Check today's price

Dortmund → Palma

73 km from Cologne

$79

$59 more than flying from Cologne

27 Aug 2027 · DTM → PMI · nonstop

found 2 days ago

See this route

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