Ramco Aviation Brain

The source-truth knowledge base for a Ramco Aviation ERP deployment. Every downstream component of the Brain reads from these pages: the chat orchestrator, the tool SDK, the journey runner.

What's in here

• 152 tables · 2,039,095 real rows across 137 non-empty tables
• 124 entity types connected by 92 semantic relationships
• 1,025 aircraft in the fleet roster (real Ramco data, operator-supplied)
• Rich cross-module history on the hero aircraft 1132 (B767-200): 1,040 tech logs, 1,919 discrepancies, plus all downstream sign-offs, deferrals, part consumption, and shop WO history.

How to navigate

Start here (narrative overviews)

• Aviation MRO Overview — what Ramco Aviation is, what an MRO does, the big picture
• The Aircraft Story — how an aircraft flows through this ERP over its lifetime
• Discrepancy Lifecycle — snag → discrepancy → deferral → resolution
• AME Package Flow — end-to-end walk through an Aircraft Maintenance Execution package
• Shop Work Order Flow — the component repair cycle
• Visit Planning — how base visits (C-checks) are planned and executed
• Data Model Overview — the 152-table landscape, mapped
• Masters Map — master data graph (aircraft, parts, customers, work centers)
• Component Repair Cycle — remove → route → repair → reinstall
• Work Center and Facility — physical infrastructure

The six wiki layers

• Schema — one page per SQLite table (152 pages). Columns, types, descriptions from Ramco's own DDL, sample rows from the live database.
• Ontology — one page per entity type. What it is, what it connects to, example records.
• Relationships — relationship families (AME task cascade, discrepancy flow, SWO routing, etc.)
• Rules — operational rules the system enforces: MEL deferrals, sign-off requirements, three-way match, priority classifications.
• Domain — narrative walkthroughs for humans.
• Reference — Glossary and quick references.

Hero aircraft

The demo centres on aircraft 1132 — a B767-200 (serial 1132). This aircraft has:

• 1,040 AME packages (tech logs)
• 1,919 discrepancies raised against it
• 13,232 task sign-offs · 125,857 sub-task sign-offs
• 2,389 part consumption events · 781 resource consumption rows
• 224 deferrals · 4,040 resolution-history entries
• 301 shop work orders for components removed from this aircraft

Every one of those is a row in the live database, linked through the graph to its source entity.

Supporting cast

• 101 — A310, serial SR101. 840 tech logs, 862 discrepancies.
• 6YJMB — A320-211, serial 422. 320 tech logs, 981 discrepancies.
• 1133 — B767-200, serial 1133. 467 tech logs, 593 discrepancies.
• 1819 — A320-211, serial JSJ1819. 485 tech logs, 466 discrepancies.
• 12181 — A320-211, serial 12181. 663 tech logs, 164 discrepancies.

Generated from the Ramco-supplied aviation data drop (152 CSVs, 2.8 GB, 10.5M rows). DB load: Step 2. Graph build: Step 3. Wiki: Step 4 (this).