SKY Airline
fliteGAINS Demo Setup · ICAO: SKU
DEMO ENVIRONMENT · RESTRICTED ACCESS
fliteGAINS
1
Login
2
Upload Excel
3
Preview
4
Invoice OCR
5
Confirm
Demo Access
Sign in to configure the fliteGAINS 1-month data sample demo for SKY Airline. This session will import VUELOS JUNIO 2025 and set up the route cost audit environment.

★ Commercial Model

Each airline accesses their own isolated tenant via this same interface. Excel imports are CRUD operations into a partitioned PostgreSQL schema. An AI health-check agent monitors data quality and prompts operators when anomalies are detected. No data is shared between tenants. Pricing: per-flight processed or monthly flat rate.

Upload Operations Data
Upload your VUELOS SKY AIRLINE JUNIO 2025.xlsx file. fliteGAINS will parse the contour-export tab, validate all 26 columns, convert times to GMT/H24, and preview the data before import.
📂
Drop Excel file here
or click to browse · XLSX · XLS · CSV accepted
Expected: VUELOS SKY AIRLINE JUNIO 2025.xlsx · Tab: contour-export
📄 — —
Parsing… 0%
Data Preview
Showing first 5 rows from contour-export tab. Verify column mapping and GMT time conversion before confirming import.
✓ 26 columns detected · Times converted to GMT · -04:00 offset applied
flight_number status dep arr STD (local) STD (GMT) flight_min ICAO Route (Item 15)
H2 0102ATASCLARI07:00 -04:0011:00 UTC112N0450 F380 DONTI1J DONTI UQ802…
H2 0176ATACCPSCL12:10 -04:0016:10 UTC63N0454 F380 LODOS4M LODOS UQ808…
H2 0192ATAMHCSCL14:50 -04:0018:50 UTC80N0444 F380 KEVET2L KEVET UQ809…
H2 0242ATASCLCJC08:30 -04:0012:30 UTC86N0447 F360 DILOK1J DILOK UQ814…
H2 0288ATASCLANF09:45 -04:0013:45 UTC63N0445 F340 DONTI1J DONTI UQ802…
Total rows: loading… · Non-CNL: loading… · With route: loading… · Date range: Jun 2025
Invoice Audit Setup
Upload ANSP or Airport invoices (PDF or Excel) to enable the Expected vs Actual charge audit. fliteGAINS will OCR-parse invoices and match them line-by-line against PostGIS route calculations.
🗺
ANSP Invoice
En-route navigation charges from DGAC Chile, COCESNA, EANA or other ANSPs along the route FIRs.
✈
Airport Invoice
Landing fees, parking, passenger charges, ground handling from departure or arrival airport authorities.

Audit Logic · How it works

EXPECTED ← PostGIS parses ICAO Item 15 route → calculates charge per FIR / per airport using tariff tables
ACTUAL ← OCR reads uploaded invoice → extracts flight number, date, charge amount per line item
VARIANCE ← Expected − Actual per flight per FIR = audit finding · surfaced in Cesium FIR drill-down modal
Confirm Import
Review the import summary below. This will write to the PostgreSQL database on your Digital Ocean managed cluster. This action cannot be undone without a restore.

Flight Data

FileVUELOS JUNIO 2025.xlsx
Tabcontour-export
AirlineSKY · H2 · SKU
PeriodJune 2025
Columns26 mapped
Rows~300+ flights

Database Target

Hostflite4d-db-do-…
Port25060
Schemasky_airline
Tableflights_jun2025
ModeINSERT (UPSERT on flight_number+date)
PostGISRoute parse on import
⚠ Demo mode: data is scoped to tenant sky_demo and will not affect production tables. The PostGIS route parsing script in /root/ICAO-CANSO/ will be triggered automatically after insert.
Importing… 0%