Exploring the ANAC Aircraft Database With Tableau

There is plenty of online resources to download and get data. As an analytic person with a passion for data analysis, I am always looking for relevant, publicly available data and explore it for interesting information. One reliable (and official) source of aviation data is Civil Aviation Authorities.

(A warning: I chose aviation data because it is something I can understand and get inferences. Data professionals can manipulate any kind of data, but not automatically understand what’s behind it or make useful insights from it).

According to ANAC website, the RAB:

Through the RAB Inquiry page, it is possible to consult the status of each aircraft by their registration marks, Type Rating and other characteristics. Check for yourself:

But instead of checking individual points, what if we could dive in the whole dataset and gather some insights of Brazilian aviation?

The JSON file of the RAB dataset can be found at:

and the RAB data dictionary can be found at:

Also, the database in Microsoft Office Excel format downloaded through the link below:

One of the first questions we may ask is: what is the most popular aircraft manufacturer in Brazil? You can check by yourself in the figure below. Right after the figure lies the link to the dashboard.

In the RAB dataset, there are many aircraft categories, including experimental and ultralight aircraft. It is possible to see that the most popular manufacturer is “Null”, since many experimental and ultralight aircraft do not have a manufacturer declared — and they are very popular in Brazil (according to the dataset). After the “Null” category follows the actual names of the manufacturers.

You can check the popularity of the aircraft categories on the figure below and in the linked dashboard right after:

Since this variable is so relevant, let’s check how many aircraft are there in each category. Only data related to airworthy aircraft was filtered. You can change the filters yourself in the dashboard.

One last question about the interdiction code: what is the average fabrication year of each category? It is expected that some categories (especially the ones with expired airworthiness certificates) were fabricated earlier (and contain older aircraft, in average). Let’s check it out.

It is possible to see that the average manufacturing year of the ultralight category is the earliest and categories with airworthiness issues (register expired and airworthiness certificates suspended / expired / cancelled) were, in average, manufactured a longer time ago.

In this article we have explored the Brazilian Aircraft Registry data looking for insights and validating hypothesis using the Tableau app. Try downloading the data, exploring it in your tool of choice and finding your own insights. Have fun!

Related posts:

Facebook groups are dead. 2021 is the year of Telegram and WhatsApp groups, especially when you live and travel through Mexico. They are not only practical to meet the right people, but also creating…

A look at how using free android and iPhone voice journal apps compares to bullet journaling. Both great easy ways to keep a journal and diary today.