Data Quality in Aviation

How To Greatly Improve Data Quality in Aviation

In the airline industry, one of the most critical measurements is AOG or Aircraft On Ground.

Our aviation clients use exMon to monitor a wide range of operational risk issues to ensure that their fleet is maximizing uptime.

These issues range from validating customer data, detecting fraudulent bookings to monitoring loyalty club transactions and aircraft maintenance schedules.

Read how Air Atlanta ensures aircraft utilization in the Air Atlanta case study.

data quality in aviation

Examples of controls our Aviation customers are using:

Operations:

  • Monitor delays of more than 180 minutes. Possible penalty flights
  • Check if the explanation for delay times fits the discrepancy between actual and scheduled departure (secure registration of delays)
  • Missing fuel data or logbook data
  • Monitor if there is an available aircraft for lease or use (aircraft on the ground for more than 24 hrs.)
  • Check if an airplane was exchanged for another with less seat capacity than initially booked
  • Check if lack of information about the airport at registration (new airport)
  

Service codes:

  • Monitor canceled meals, but traveler still active
  • Monitor grown-ups that have ordered children’s meals
  • Monitor flights with an unusually high registration of unaccompanied minors
  • Monitor flights with a change to travel date or time and customer contacts are missing
  • Monitor discrepancies between catering suppliers and cooked meals
 

Bookings:

  • Overbooked flights
  • Monitor extensive group bookings
  • Monitor flights with unnaturally low booking X days before departure
  • Informational reports
  • All catering orders to suppliers 72h, 24h, 12h
  • Daily flight schedule next three days pr. airport (sent to every airport)
  • Monthly flight schedules next 30 days pr. airport (sent to every airport)
  
Crew:
  • Registered shifts versus payments to crew
  • Pilot and maintenance certifications
  
Fraud:
  • Bookings close to departure
  • Blacklist of names/emails
  • Unusual travel plan
  
Maintenance:
  • Orders older than X days
  • Spare parts not returning to inventory
  • Inventory compared to forecasts 
exmon aviation data quality

Air Atlanta's Success Story

Air Atlanta is one of the largest ACMI (aircraft, crew, maintenance, and insurance) service providers globally, with almost 20 planes and 1400 employees.

They offer tailor-made solutions to other carriers, both in the passenger and cargo industry.

The Challenge

Like others in this industry, Air Atlanta needs to make sure all aircraft are fully utilized, as every extra hour of AOG (aircraft on the ground) is expensive.

Sigrún Inga Kristinsdóttir, the administrator of Trax MRO (maintenance, repair, and overhaul) system, explains:

“When we remove parts from an aircraft and send them for repair, they would too often be registered incorrectly in our systems.

When we needed the parts again, we couldn’t always tell if they were back from the repair or not.

The data issues caused unnecessary delays and costs, and we realized we needed to improve data quality.

After searching for a suitable solution, we decided to implement exMon.”

The Solution

When we started implementing exMon, our primary goal was to decrease costs resulting from insufficient data in our Trax maintenance system.

We set up quality checks looking for overdue repair orders and overdue purchases.

We also added controls to make sure rotatable parts are processed correctly.

These checks had an instant reward as quality got better, with better usage of our parts and a lot less rework for our employees.

Next up was our scheduling process.

We use exMon to monitor our minimum guarantee hours (MGH) contracts to ensure we effectively use our aircraft, which has reduced our costs.

We can now ensure that an aircraft is not scheduled to land at airports, which are forbidden for us to use for legal or contractual reasons.

The Benefits

Sigrun says: “These efforts have saved us a considerable amount of rework and has made sure our aircraft are fully utilized.

We regularly get feedback from our vendors and customers on how good our data is.

We are continuously adding new data quality checks to improve our processes even more.

Furthermore, our internal users have been very positive with these changes, and we keep getting requests for new checks.”

Learn How Our Customers Are Using eXmon

See how exMon Data Quality can help you fix and maintain quality financial data.

Manage all your budgeting and forecasting processes. Find issues and missed submissions before its too late.

Our customers in retail use exMon to monitor cash registers and back-office systems. Monitor supply chain processes, inventory levels, and unusually high discounts

Know more about how pharmaceutical companies use exMon to make sure project data is being maintained correctly.

Learn more about how Vodafone is continuously monitoring their data and services with an emphasis on customer happiness, revenue leakage, and fraud monitoring

See how Atlanta Air is detecting fraudulent bookings,monitoring loyalty club transactions, and keeping eye on aircraft maintenance schedules.

Detect irregularities in access to key systems and platforms.

Detect fraud and misuse leaving footprints in your.

Find out how you can better govern your Master Data with the exMon

How Can I start Improving My Data?

Schedule a demo

Request a live demo to see how the exmon Data Governance Suite can help your company improve business and master data.

Sign up for a pOC Using your data

We can use your data to demonstrate how our tools can help you improve data quality. 

We set everything up for your environment

We configure the system to your needs and show you how to administer the system yourself.

You start improving your data

Once the system is installed in your environment you can start setting up processes to improve your data.