GGG & The Airman Directory – a making-of

Tools, methodology and data used to produce the article ‘GenderGapGrader: Airline Pilots‘:

We’re disclosing the data used in the study. We’ve opened GendRE API which extracts gender from names. To make it usable by everyone, we’ve built an extension for RapidMiner, a leading open source data mining and predictive analytics software.

So you can run your own gender gap analysis, where and when it matters to you!

Data Files:

• Original Data File from the FAA : “The Airman Directory” (July 2014) CS072014.ZIP Mirror: CS072014.ZIP
• Genderized Data File : ALL_PILOT_OPENDATA.ZIP

Data Mining Tools:

• RapidMiner v6
• RapidMiner Onomastics Extension (Extract Gender Operator) v0.0.3
  • Get it from RapidMiner Market Place, OR
  • Get it from GitHub
  • Documentation
• GenderAPI v0.0.15/v0.0.16

Data Scope:

• Commercial/Airline Pilots :

SELECT ALL_PILOTS_GENDERIZED_LICENCED.COUNTRY, ALL_PILOTS_GENDERIZED_LICENCED.TYPE, ALL_PILOTS_GENDERIZED_LICENCED.LEVEL, ALL_PILOTS_GENDERIZED_LICENCED.gender, Sum(ALL_PILOTS_GENDERIZED_LICENCED.gender_scale) AS SumOfgender_scale, Count(ALL_PILOTS_GENDERIZED_LICENCED.[UNIQUE ID]) AS [CountOfUNIQUE ID] FROM ALL_PILOTS_GENDERIZED_LICENCED WHERE (COUNTRY=’USA’ And TYPE=’P’ And (LEVEL=’C’ Or LEVEL=’A’)) Or (COUNTRY<>’USA’ And TYPE=’Y’ And LEVEL=’Y’) GROUP BY ALL_PILOTS_GENDERIZED_LICENCED.COUNTRY, ALL_PILOTS_GENDERIZED_LICENCED.TYPE, ALL_PILOTS_GENDERIZED_LICENCED.LEVEL, ALL_PILOTS_GENDERIZED_LICENCED.gender;

Raw Estimates:

In bold, the estimates cited in the article or the infographics.

All pilots gender gap, overall statistics:

All commercial pilots gender gap, overall statistics:

Commercial/airline pilots gender gap, by country:

NB/ this table was uploaded on Wikipedia to facilitate sharing of alternative statistics, actual gender gap disclosures by major national airlines.

Student pilots gender gap, by country: