regional airports in Brazil

Ladies and gentlemen, sit back and enjoy the view!

ironhack

Ironhack Data Analytics Bootcamp



. . .

CAPSTONE PROJECT

. . .

Felipe Altermann

December 2021

brazilian airports with comercial flights in the last 20 years (2002-2021)


226
airports

. . .

28%
can only operate during day light and clear weather

number of airports over time

what is a regional airport?

how to classify an airport as regional?

flights within the same state,
excluding those with departure from a capital city or other major airport hubs

flights from one state to another,
excluding capital cities and other major airport hubs

non-regional,
flights from capital cities and other major airport hubs

195 airports
31 airports

regional airports win the growth battle

passengers – regional vs non-regional

regional airports percentage difference

comparing
2005 to 2020
500% growth on regional airports
420% growth on routes
585% growth on flights
95% growth on passengers

applying machine learning

with cluster analysis

to discover natural grouping in data

metrics

Available Seat
Kilometres (ASK)

A measure of an airline’s carrying capacity to generate revenue, taken from multiplying the available seats on an aircraft by the number of kilometres flown on a given flight.

Revenue Passenger
Kilometres (RPK)

A way of calculating the number of kilometres travelled by paying customers, by multiplying the number of paying passengers by the distance travelled.

hello clusters

1

2

3

4

5

6

7

8

key numbers

origins
destinations
carriers
aircraft types
routes
mean aircraft
capacity

GRU Airport – São Paulo International AirportGuarulhos, SP

RIOgaleão – Antonio Carlos Jobim International AirportRio de Janeiro, RJ

Santos Dumont AirportRio de Janeiro, RJ

Foz do Iguaçu – Cataratas International AirportFoz do Iguaçu, PR

Porto Seguro AirportPorto Seguro, BA

Uberlândia – César Bombonato AirportUberlândia, MG

Hugo Cantergiani Regional AirportCaxias do Sul, RS

Júlio Belém AirportParintins, AM

monthly fligths and passengers by airport

Flights per
month
and origin
Passengers per
month
and origin

regional and non-regional airports

clusters vs. airports over time

click 'play' button for animation

carriers flights percentage by cluster

findings

regional airports experienced a huge growth in a 15 year span – about 500%

one carrier player lead this growth – 'Azul'

several small carriers play a big role to deliver passengers to non-regional airports

next steps

air fares analysis

carriers market share concerning:

routes

flights

seats