Building a serial genealogy record instead of replacing every plant system
In September 2022 an engine customer asked us to identify every part we had made since 2016 from fourteen heat lots of titanium bar whose mill certificates were under investigation. It took twenty-three days and thirty-one people in four plants, working from three execution systems, scanned files and paper travellers. Our first answer listed 1,162 parts. Eleven days later we corrected it to 1,140, because 22 reworked parts had been counted twice. The material was eventually cleared, but the customer's supplier quality lead warned that a second slow answer would affect our standing on a new engine programme.
The obvious response was a group-wide execution system. Our chief operating officer, Yannick Desormeaux, had a C$48 million proposal ready, and it had real merits: one way of working on every shop floor. I argued instead for a genealogy layer above the existing systems, linking material certificate, heat lot, work order, operations, special-process runs, inspection and shipment for each serial number, at a budget of C$12.8 million. Mirabel's general manager opposed any new data-entry steps for his machinists. Our chief financial officer, Laurent Bégin, wanted the cheaper option but doubted my estimate. The board approved my proposal in February 2023, and the execution-system replacement was deferred indefinitely, with the inconsistent shop-floor practice that implies.
We started at Boucherville, because special-process records carried the most risk. We added validity rules at source, such as a heat-lot format check that blocks an operation from closing, and digitised 410,000 traveller pages from 2016 to 2019 for parts still on active programmes. Quarterly timed drills, reported to the audit and risk committee, test the result.
The record now covers 2.6 million serialised parts made since January 2020. Heat-lot completeness rose from 91.4% to 99.7%. In March 2026 a drill covering 3,800 parts in four plants took three hours and ten minutes, with no corrections afterwards. The programme cost C$14.2 million, above budget, and older parts still take days.
What I would do differently is the scanning. I hired a document contractor for the first batch, and its staff could not read handwritten amendments or inspector stamps. Experienced inspectors, paid overtime, did the work properly later. I should also have told the board about the pre-2016 gap when it approved the budget.