86 Aircraft. Thousands of Configurations. One Source of Truth.

Configuration Management Data Visualization DocSurfer AI Global air cargo and charter airline operator
  • {{ s.stat }}

    {{ s.label }}

The Situation

A global air cargo and charter airline operator flies 86 wide-body Boeing aircraft: 767s, 747s, and 777s. The fleet runs a mix of cargo, passenger charter, VIP operations, and military airlift. Many of the aircraft are passenger-to-freighter conversions, which means supplemental type certificates, modified illustrated parts catalogs, and configuration rules that differ from the original OEM baseline.

For the engineering team, maintaining accurate configuration across that fleet consumed weeks of manual effort every time Boeing issued a parts catalog revision. Engineers had to cross-reference each revision against the maintenance ERP system, validate part numbers across multiple fleet types and configurations, identify obsoleted or superseded parts, and update the system accordingly. The same rotable components appear across fleet types, voice recorders and flight data recorders among them, but each carries different effectivity rules depending on the modification status of the tail number.

Two problems compounded each other. First, the sheer volume of data made manual validation impractical. Second, discrepancies between what the OEM documentation listed as allowable and what the maintenance ERP system showed as installed triggered an internal corrective action program under the airline's CASS (Continuing Analysis and Surveillance System). Parts were being installed without confirmed authorization for that specific tail number and position.

They needed to validate the allowable configuration for every tail number in the fleet, audit certification documentation for in-scope components, and do it inside a 30-day window before each aircraft's heavy maintenance visit.

The Approach

After an initial visit to the operator's maintenance and engineering headquarters, Tsunami assembled two teams to work the problem from both sides at once.

Configuration Assessment Team

Aviation SMEs who understood illustrated parts catalogs, a chief data scientist who could parse Boeing's PDF and JSON-formatted data into structured flat files, and ERP specialists who knew how the data was organized in the maintenance system.

The team built a master data set for each aircraft model by merging three sources: Boeing OEM documentation, the airline's engineering data, and direct extracts from the maintenance ERP system. Then they built a comparison methodology to identify every instance where the ERP showed a part assignment the OEM data said wasn't allowable for that tail number and position.

Initial reporting used Excel. It wasn't effective. Common parts spanning fleet types made filtering and prioritization difficult in flat spreadsheets.

From Spreadsheets to Real-Time Visibility

Tsunami's chief data scientist built interactive Tableau dashboards, deployed to the cloud on the airline's single sign-on infrastructure. Engineers could filter by tail number, fleet type, part number, or discrepancy type. Color-coded indicators showed whether a mismatch was a Boeing documentation error, requiring an IPC revision request, or an ERP configuration error, requiring internal corrective action. Research tasks that took hours in spreadsheets took minutes.

Tsunami-built tools: simplify configuration validation

Configuration control requires not only validating with OEM documentation but added functionality above what is typically provided in the source data.

Source Data

Extraction

  • AIPC
  • Supplemental IPC
  • Emergency Equipment List
  • Layout of Passenger Accommodations
→

Merge

  • Master Source Part
  • Effectivity to Tail Number conversion
  • Master Source Part List

ERP Data

Extraction

  • Master Part List
  • Interchangeability
  • One-Way
  • Effectivity
  • Aircraft Master
  • Positional Data
  • Controlled Parts List
  • As Maintained List
→

Merge

  • Part Number
  • Part Number Position
  • Controlled Parts

Compare

  • Allowable
→

Filter

  • Actuals

Visualizations

IPC Revision Review
Allowable Review
Actuals Review
Allowable vs. as-maintained configuration, filterable by tail, fleet type, part number, or discrepancy type.

Records Audit Team

Tsunami records specialists with deep experience in airworthiness certification documentation. Working alongside the operator's records team, they audited each aircraft's component certification documents: pulling records from the airline's system, running them through DocSurfer for automated identification and extraction, and validating that every in-scope part had current, correct certification.

DocSurfer processed batches of aviation PDFs, automatically identified FAA 8130-3 forms and other certification documents, extracted every data field, and produced structured reports showing exactly which page in which file contained each certification. The tool audited 80–120 components per batch in hours rather than the days it would take manually. Accuracy exceeded 98%.

The audit runs 30 days before each aircraft enters heavy maintenance. If a part lacks proper certification or isn't authorized for that position, it can be replaced during the maintenance visit without grounding the aircraft.

The Results

If you're an engineering director watching your team spend weeks on IPC revisions instead of engineering work, or a configuration manager manually cross-referencing parts catalogs across a mixed fleet, these are the numbers that matter:

{{ g.title }}

  • {{ it }}

What Evolved

What started as a one-time assessment became a cloud-based SaaS platform running on the airline's own infrastructure. The Tableau dashboards, DocSurfer integration, and comparison methodology now operate as a standing capability the team uses daily.

Facing a Similar Challenge? Talk to Our Aviation Team →

Services Demonstrated

  • {{ s }}

Why This Matters

The comparison methodology works because the people who built it understand how illustrated parts catalogs map to maintenance ERP configuration. A generic consulting firm could build dashboards. They wouldn't know what to compare, or why a discrepancy matters.

DocSurfer wasn't built for one particular client. It was built by practitioners who've spent decades working with aviation certification documents. This engagement is one application of a tool that exists because Tsunami's team works with these documents every day.

A one-time configuration assessment became an ongoing records audit program and a cloud-hosted SaaS platform. That's what happens when the partner understands the operation well enough to see adjacent opportunities before the client articulates them.

Talk to an Aviation Expert

{{ shotLabel }}