Analytics of the age of the air fleet of Russian airlines

Today we bring to your attention a study (analytics) of the age of the air fleet of Russian airlines represented on the Russian market for commercial transportation. The full list can be found here .

Motivation, planning, sampling

 From time to time we hear more than once that some plane is delayed, then returns to the airport, then makes an emergency landing, in most cases this is due to technical malfunctions. In this study, we do not want to link the age of the civil aviation fleet with their trouble-free operation and understand perfectly well that the main thing is professional maintenance of machinery and equipment, but at the same time we cannot deny that each technique has its own resource. 

To begin with, I would like to indicate what we mean by Russian airlines those that are on the official list . - «», «», «», «»(Azimuth), «»(AzurAir), «», «»(NordStar), «»(NordWind), «»(PegasFly), «»( ), «»(RedWings), «»(Rossiya), «» (RoyalFlight), «S7»( «»), «»(SmartAvia), « »(UralAirlines), «»(Utair), «»(Yakutia), «»(Yamal). ≈ 85% . «» , - , , , .

flightradar24 , . , :) 

- python   numpy, pandas , plotly , ableau , google sheets brain. 

, 7 () 834 . .

.

. (mean) = 10.61 , (median) = 9.0 .

dataframe, .

ages = data.groupby(by='airlines').age.describe()
ages.sort_values(by='count', ascending=False)
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
    

, -5 :

:

«» (Azimuth) - (mean) 2,9 , ()  3 ;

«» - (mean) 3,5 , () 3 ;

 «» - (mean) 5,1 , () 5 ;

 «S7» - (mean) 9,5 , () 9 ,

«» , , :

«» (AzurAir) - (mean) 20,3 , () 20 , - 13 , 30 . 

-10 .

data.type.value_counts().to_frame('count').head(10)
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
    

«» :

Airbus A320

Sukhoi Superjet 100

Boeing 737

Airbus A321

-3 :

Boeing 737 MAX, . «S7», «NordStar», «UralAirlines», «Utair»,

Boeing 737 MAX

Airbus A350-941 VQ-BFY  «» :)

Airbus A350-941

, flightradar24 - () - :)

  , , «» :)  , , 50 :

Airbus Helicopter H135 - 5 ;

Airbus Helicopter H155 - 1 unit;

Dassault Falcon 900 - 6 units;

Dassault Falcon 7X - 5 units;

Dassault Falcon 8X - 2 units;

and this interesting model Let L410UVP-E20 Turbolet

In conclusion, I would like to remind you that all the information provided is based on the data received from the flightradar24 service, therefore, perhaps part of the air fleet did not fall into the sample, and part was entered by the service with errors, everything is possible, but I think I have received a general idea of ​​the age of the Russian airlines' fleet ;)

 And of course, for dessert, there is a beautiful dashboard on Tableau, which can be viewed here .

All the best, your konstatic.