Data support during phase-out of final 5 fokker aircraft
Situation
During the redelivery of an aircraft back to the lessor, the airline is responsible for establishing the aircraft return delivery data binder. This contains all applicable airworthiness and maintenance data for the aircraft, including the various required regulatory certificates. During the phase-out of all Fokker aircraft from the KLM Cityhopper fleet, these data binders needed to be created for the last remaining five aircraft in order to be prepared for a sale to a new owner. Maintenance and Airworthiness data for these aircraft was logged into AMOS; however, regulatory certificates (dirty finger prints) were kept as digitally scanned PDF’s on a separate file storage. This resulted in a situation where maintenance history and compliance for these aircraft could not be matched with the regulatory document supporting the same.
Solution
An RPA-oriented process was established by EXSYN to automatically retrieve the required maintenance and airworthiness data from the MRO software (AMOS). Simultaneously, the RPA process collects the various scanned PDF dirty finger prints and runs these through OCR recognition software. Thereby enabling the processing of the content of each dirty finger print. Examples include the EASA Form-1 tracking number, the Tech-Log number, complaint descriptions, the workorder number, the aircraft registration, and the station.
Based on the retrieved meta data for each dirty-fingerprint document, a link was able to be made between the original PDF document and the associated maintenance status from the MRO software system. Thus saving the KLM Cityhopper team countless hours of manually reviewing the PDF documents and linking these to the maintenance status in the MRO software system.
The Project in Numbers
Tails
Aircraft Types
Source Systems
GB Processed
About KLM Cityhopper
Founded in April 1991 KLM Cityhopper is the regional airline subsidiary of KLM, headquartered in Haarlemmermeer, North Holland, Netherlands. It is based at nearby Amsterdam Airport Schiphol.The airline operates scheduled European feeder services on behalf of KLM to 69 destinations and has a fleet of 49 Embraer 175 and 190.