After records migration
Tracing a migrated weight and balance file back to its sources for acquisition teams
When an acquisition target's records arrive digitized or re-indexed, the weight and balance statement may read cleanly while its sources sit misfiled or missing. This reconciliation walks the statement back through every amendment to the weighing reports that anchor it, inside the migrated archive the buyer actually received. Records specialists run it for the acquisition team once the data set is delivered and before valuation assumptions harden. The team gets a source map for each figure, a list of entries that no longer resolve to a document, and recovery actions ranked by effect on the deal.
When this review is needed
- The seller delivered a scanned or system-exported records set and the diligence team has to decide how far to trust it.
- Records were migrated between platforms during the hold period and index fields were mapped automatically.
- The weight and balance statement in the data room is a fresh export with no visible link to underlying documents.
- An earlier review sampled the file; the deal now needs the weight and balance chapter checked line by line.
The problem
Migration tools preserve totals and lose provenance. A statement exported from the seller's system shows current figures, but the weighing report behind them may have been scanned into the wrong aircraft folder, split across batches, or dropped at OCR. The acquisition team cannot tell a clean file from a hollow one by reading the statement alone, and the seller's records staff who knew where things lived are often gone by diligence.
What gets reviewed
- The delivered weight and balance statement and every revision the archive contains
- Weighing reports located anywhere in the migrated set, including misindexed folders
- Amendment entries, equipment change forms, and the calculations behind each revision
- Loading documents and program references the statement depends on
- Index metadata against document content for the weight and balance section
- Gaps between the seller's stated records inventory and what was actually delivered
Scope this review
Tell us the asset, the event, and the evidence in scope, and we will outline a focused first engagement.
Send a representative, redacted record set and we will scope the review.
What gets validated
- Each figure on the statement resolves to a legible source document in the delivered archive, not merely to an index entry
- The most recent weighing report exists in the set and its date matches the statement's stated basis
- Amendments between the last weighing and the current statement are complete, in sequence, and arithmetically consistent
- Scanned documents attributed to this serial number actually belong to it
- Nothing in the amendment chain references a document the delivery inventory does not include
Evidence normally required
- The migrated records set exactly as delivered, with its index or manifest
- The seller's records inventory or data room listing
- The current weight and balance statement and revision log
- Any pre-migration records listing available from the seller or prior CAMO
Common discrepancies
- Weighing reports filed under a sister aircraft's registration after a batch scan
- An amendment chain that skips a revision the statement's numbering says should exist
- Index entries pointing to blank, partial, or illegible scans
- Statement figures that predate the migration and were never re-anchored to delivered documents
What is at stake
If the gap is found after signing, the buyer owns a statement it cannot substantiate and inherits the cost of reconstruction, which can mean paying for a reweigh that proper filing would have avoided. Found during diligence, the same gap is a price point or a seller obligation instead.
Move from findings to resolution
Move from findings to a documented resolution path.
How the work runs
Fix the delivered set
Freeze the archive as received and record its manifest so findings reference a stable baseline.
Trace the statement
Walk each figure back through amendments to a located weighing report.
Chase strays
Search the whole archive, including other aircraft folders, for misfiled weight and balance documents.
Grade and report
Classify each unresolved item by recovery path and deal impact, then brief the diligence lead.
What the buyer receives
- A source map connecting every statement figure to its document location in the archive
- An unresolved-items list with a recovery path and owner for each
- A diligence memo stating how far the weight and balance file supports the figures the deal assumes
Who uses the output
- Technical due diligence leads deciding what the records support
- Investment teams pricing recovery cost or negotiating seller cure obligations
- The buyer's records team that will inherit the file at closing
How the work fits into the transaction or program
This reconciliation is a chapter of records diligence run in parallel with AD, LLP, and configuration checks. Its unresolved-items list feeds the master discrepancy register, and after closing the same source map becomes the starting index for the new owner's baseline.
Jurisdiction-specific considerations
Retention obligations differ by regime: 14 CFR 91.417 keeps current weight and balance data with the aircraft's records, while EASA continuing-airworthiness rules under Regulation 1321/2014 tie the data to the operator's approved program. A migrated file assembled under one regime and read under the other can be complete by its own rules and still short of what the receiving registry expects.
Regulatory limits
The work assesses document traceability only. It does not certify the accuracy of weights, direct a reweigh, approve any amendment, or make an airworthiness determination. Decisions about corrective action rest with the operator, its CAMO, and the certifying personnel involved.
What this review does not cover
- Reweighing the aircraft or checking physical configuration
- Rebuilding the seller's records system or repairing its indexes
- Legal review of purchase agreement records clauses
Specific to this review
- OCR-driven auto-indexing routinely misfiles weighing reports because their layouts vary by shop and the registration often appears in handwriting.
- A statement can pass a sampling review and still fail line-by-line reconciliation; weight and balance chains are short enough that full tracing is practical.
- The cheapest recovery window is while the seller still holds pre-migration backups; that leverage disappears at closing.
- Cross-registry deals often trip on amendment format: an entry acceptable in the exporting file may not read as a valid record to the importing authority's inspectors.
Sources
U.S. Government (eCFR). Maintenance recordkeeping content and approval-for-return-to-service requirements, including 43.9, 43.11, and Appendix B.
U.S. Government (eCFR). Records an owner or operator must keep, including total time in service, current status of life-limited parts, and AD compliance.
European Union / EASA. Continuing airworthiness, maintenance records, CAMO responsibilities, and the airworthiness review process in the EASA system.
Frequently asked questions
The data room includes a signed statement. Why is that not enough?
A signature attests to the statement at the time it was made. Diligence relies on the delivered archive, and if the documents behind the signature did not survive migration, the buyer inherits an assertion without evidence. The reconciliation establishes which figures still have their sources.
Relevant glossary terms
Related pages
Where this fits
Talk to an engineer who has done this work
We will walk through your current state, the records or evidence involved, and a scoped first engagement.
Talk through the aircraft, records, evidence, deadline, and next useful step.