{"id":901,"date":"2026-06-02T14:47:47","date_gmt":"2026-06-02T04:47:47","guid":{"rendered":"http:\/\/www.constrainttec.com\/?p=901"},"modified":"2026-06-02T14:51:41","modified_gmt":"2026-06-02T04:51:41","slug":"making-operational-aviation-reporting-accessible-through-natural-language-ai","status":"publish","type":"post","link":"https:\/\/wwwprod2.contecint.com.au\/index.php\/2026\/06\/02\/making-operational-aviation-reporting-accessible-through-natural-language-ai\/","title":{"rendered":"Making Operational Aviation Reporting Accessible Through Natural Language AI"},"content":{"rendered":"<p>At CTI, we are continually exploring ways to simplify operational workflows and improve access to critical business data. One of our latest prototype developments within PegaSys is an AI-driven reporting tool designed to make aviation reporting more accessible through natural language interaction.<\/p>\n<p>Traditionally, operational reporting systems require users to have knowledge of SQL, database structures, and underlying schemas in order to retrieve meaningful data. This often means that ad hoc reporting requests need to be written or supported by technical teams, creating delays and limiting accessibility for non-technical users.<br \/>\nOur new <a href=\"http:\/\/www.constrainttec.com\/wp-content\/uploads\/2026\/06\/PegasysAIBrochure.pdf\">PegaSys AI<\/a> prototype aims to remove that barrier.<\/p>\n<p>Using a Large Language Model (LLM) combined with a dedicated SQL AI and a schema-aware Knowledge Bundle, users can simply ask questions in natural language, in virtually <strong>any language<\/strong>, and have those requests translated into SQL queries against the PegaSys database.<br \/>\nThe results can then be viewed directly within the interface or downloaded as CSV files for further analysis.<\/p>\n<p><a href=\"http:\/\/www.constrainttec.com\/wp-content\/uploads\/2026\/06\/PegasysAI-ReportingTool.png\" rel=\"attachment wp-att-904\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-904\" src=\"http:\/\/www.constrainttec.com\/wp-content\/uploads\/2026\/06\/PegasysAI-ReportingTool.png\" alt=\"PegasysAI-ReportingTool\" width=\"811\" height=\"672\" \/><\/a><\/p>\n<h3 class=\"western\" align=\"left\"><span style=\"font-size: medium;\">Making Reporting Accessible to Everyone<\/span><\/h3>\n<p>One of the most powerful aspects of this approach is that it enables users across the organisation to ask operational questions without needing to commission custom report development.<br \/>\nA CEO may ask a high-level financial or operational question, while an operations controller may ask something highly specific related to crew activity, allowances, or compliance deadlines.<\/p>\n<p>Potential users include:<\/p>\n<ul>\n<li>Operations teams<\/li>\n<li>Planning teams<\/li>\n<li>Analysts<\/li>\n<li>Management and executives<\/li>\n<\/ul>\n<p>This flexibility allows operational data to become far more accessible across the business.<\/p>\n<h3 class=\"western\" align=\"left\"><span style=\"font-size: medium;\">Example Questions the AI Reporting Tool Can Answer<\/span><\/h3>\n<p>The prototype is already capable of responding to a wide range of operational and analytical queries in virtually any language, making reporting more accessible to users across different regions and teams.<\/p>\n<p>Example questions include:<\/p>\n<ul>\n<li>\u201cGive me the top ten crew for taking sick leave in March 2026\u201d<\/li>\n<li>\u201cGive me the top allowance earners by month for the past year\u201d<\/li>\n<li>\u201cHow many captains have an SEP expiry in the next month?\u201d<\/li>\n<li>\u201cWhat is my allowance cost in April 2026?\u201d<\/li>\n<li>\u201cWhich crew and how long was each crew sick in March 2026?\u201d<\/li>\n<\/ul>\n<p>These are the types of questions that would traditionally require manual SQL development or predefined reports.<\/p>\n<p><a href=\"http:\/\/www.constrainttec.com\/wp-content\/uploads\/2026\/06\/PegasysAI-Chinese.png\" rel=\"attachment wp-att-905\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-905\" src=\"http:\/\/www.constrainttec.com\/wp-content\/uploads\/2026\/06\/PegasysAI-Chinese.png\" alt=\"PegasysAI-Chinese\" width=\"811\" height=\"795\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/www.constrainttec.com\/wp-content\/uploads\/2026\/06\/Tamil-Prompt.png\" rel=\"attachment wp-att-906\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-906\" src=\"http:\/\/www.constrainttec.com\/wp-content\/uploads\/2026\/06\/Tamil-Prompt.png\" alt=\"Tamil Prompt\" width=\"812\" height=\"728\" \/><\/a><\/p>\n<h3 class=\"western\" align=\"left\"><span style=\"font-size: medium;\">How the System Works<\/span><\/h3>\n<p>The reporting workflow combines multiple AI-assisted components:<\/p>\n<ul>\n<li>The user submits a question through a Question &amp; Answer interface.<\/li>\n<li>The LLM interprets the request and generates SQL.<\/li>\n<li>A dedicated Knowledge Bundle provides schema awareness, including table relationships and appropriate joins.<\/li>\n<li>The SQL is executed against the PegaSys database.<\/li>\n<li>If the query encounters syntax or execution errors, the system automatically attempts to correct and retry the SQL.<\/li>\n<li>The resulting dataset is returned to the user.<\/li>\n<\/ul>\n<p>The Knowledge Bundle plays a key role by helping guide the AI towards the correct schema relationships and query structures, reducing ambiguity and improving consistency.<\/p>\n<p><a href=\"http:\/\/www.constrainttec.com\/wp-content\/uploads\/2026\/06\/PegasysAI-Workflow.png\" rel=\"attachment wp-att-907\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-907\" src=\"http:\/\/www.constrainttec.com\/wp-content\/uploads\/2026\/06\/PegasysAI-Workflow.png\" alt=\"PegasysAI-Workflow\" width=\"811\" height=\"517\" \/><\/a><\/p>\n<h3 class=\"western\" align=\"left\"><span style=\"font-size: medium;\">Supporting Operational Investigations<\/span><\/h3>\n<p>While the prototype is already delivering promising results, AI-generated reporting should still be treated as an operational support tool rather than a fully autonomous decision-making system.<\/p>\n<p>AI can occasionally misunderstand context or generate incorrect assumptions, particularly with highly specialised operational data. For this reason, the tool is designed to help users focus and accelerate follow-up investigations rather than replace validation processes entirely.<\/p>\n<p>In many cases, the value comes from dramatically reducing the time required to explore operational questions and identify areas requiring deeper analysis.<\/p>\n<h3 class=\"western\" align=\"left\"><span style=\"font-size: medium;\">Looking Ahead<\/span><\/h3>\n<p>As development continues, we are extending the AI\u2019s understanding of operational terminology, schema relationships, and contextual reasoning to further improve the quality and relevance of generated queries.<\/p>\n<p>We are also exploring infrastructure approaches such as dedicated reporting database replicas to ensure AI-driven ad hoc querying does not impact production system performance.<br \/>\nThe long-term vision is to create a natural language reporting environment where operational users at every level of the organisation can interact with complex aviation data as easily as asking a question.<\/p>\n<p>At <strong><a href=\"https:\/\/www.constrainttec.com\/index.php\/contact-us\/\">CTI<\/a><\/strong>, we believe this represents an exciting step towards making operational intelligence more accessible, responsive, and scalable across the aviation industry.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>At CTI, we are continually exploring ways to simplify operational workflows and improve access to critical business data. One of our latest [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-901","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/posts\/901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/comments?post=901"}],"version-history":[{"count":6,"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/posts\/901\/revisions"}],"predecessor-version":[{"id":909,"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/posts\/901\/revisions\/909"}],"wp:attachment":[{"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/media?parent=901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/categories?post=901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wwwprod2.contecint.com.au\/index.php\/wp-json\/wp\/v2\/tags?post=901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}