Aviation fuel marketers, joint hydrant storage depots, and into-plane refueling operators at Jomo Kenyatta International Airport (JKIA), Wilson Airport, Moi International Airport (Mombasa), Kisumu, Eldoret, Entebbe, and Julius Nyerere (Dar es Salaam) operate under the most stringent zero-contamination safety regime in global logistics: the Joint Inspection Group (JIG 1, JIG 2 & JIG 3) and EI/JIG 1530 standards. Managing KPC pipeline receipts, floating-suction storage tanks, hydrant dispenser trucks, micro-filter differential pressure logs, and wing-tip fuel tickets on paper clipboards leads to audit non-conformances during IATA Fuel Quality Pool (IFQP) inspections, unrecorded thermal volume shrinkage between ambient 28°C apron dispensing and 15°C standard liters, delayed airline uplift invoicing, and credit-limit exposure on ad-hoc charter flights.
At devManue, we engineer custom Aviation Fuel (Jet A-1 & Avgas 100LL) Depot, Hydrant & Into-Plane Refueling ERP platforms. Our architecture integrates batch refinery/import Certificate of Quality (CoQ) genealogy, automated JIG tank-sump and filter-water separator interlocks, intrinsically safe ATEX apron tablets linked to dispenser bulk meters, ASTM Table 53B/54B temperature-compensated mass/volume reconciliation, and instant IATA XML fuel ticket settlement.
1. Batch Refinery CoQ Intake, Settling Quarantine & JIG Daily Sump Water-Detector Interlocks
Every batch of Jet A-1 arriving via the Kenya Pipeline Company (KPC) line or bridged by dedicated stainless-steel/epoxy-lined road tankers must maintain an unbroken chain of custody from refinery hydro-treater to aircraft wing tank:
- Refinery CoQ & Recertification Certificate (RC) Quarantine: Logs DEF STAN 91-091 / ASTM D1655 parameters—flash point (
≥38.0°C), freezing point (≤-47.0°C), electrical conductivity (50–600 pS/mwith Stadis 450 static dissipator additive), MSEP water separation rating, and JFTOT thermal stability. Receiving tanks automatically lock out hydrant discharge valves until the mandatory settling period (1 hour per meter of tank depthor post-microfiltration recertification) is completed and signed off. - Daily Low-Point Sump Drain, Visual Appearance & Chemical Water Detector (CWD) Logs: Requires operators to scan QR/NFC tags at tank sumps, filter-water separators (
FWS), and refueler vehicle sumps at the start of every shift, recording Clear and Bright visual vortex checks and Shell Water Detector / Velcon Hydrokit capsule tests (blocking dispatch if free water exceeds15 ppm). - Filter-Water Separator Differential Pressure (ΔP) & Millipore Colorimetric Membrane Gate: Captures flow-corrected differential pressure across coalescer/separator elements at maximum achievable flow rate; if
ΔPexceeds1.0 bar (15 psi)or drops suddenly (indicating element rupture), the dispenser truck is immediately quarantined in the dispatch console.
2. Into-Plane ASTM Table 54B Volume Correction, Kilogram Uplift & JIG Filter Interlock Engine
Flight deck crews calculate aircraft center-of-gravity and payload range in kilograms (kg) of fuel, whereas airport dispenser meters measure ambient liters at apron temperature, and customs/petroleum depots account for stock in standard liters at 15°C and metric tons. Our into-plane engine validates filter safety interlocks and computes exact temperature-compensated uplift quantities on the apron:
from decimal import Decimal, ROUND_HALF_UP
class AviationIntoPlaneRefuelingEngine:
"""
Evaluates JIG 1/2 filter-water separator differential pressure and free-water interlocks,
converts ambient metered Jet A-1 liters to standard 15°C liters and kilograms (ASTM Table 54B),
and verifies flight deck density/uplift discrepancy tolerance.
"""
@staticmethod
def compute_uplift_and_jig_safety_gate(
ambient_metered_liters: Decimal,
apron_fuel_temp_c: Decimal,
density_at_15c_kg_per_l: Decimal, # Typically 0.7750 to 0.8400 kg/L for Jet A-1
filter_delta_p_psi: Decimal,
cwd_free_water_ppm: int,
aircraft_gauged_uplift_kg: Decimal,
) -> dict:
# JIG safety interlocks: max 15 psi (1.0 bar) filter Delta-P and < 15 ppm free water
jig_safety_ok = (filter_delta_p_psi <= Decimal("15.0")) and (cwd_free_water_ppm < 15)
# ASTM D1250 / Table 54B thermal expansion approximation for jet kerosene
alpha_per_deg_c = Decimal("0.00093")
delta_t = apron_fuel_temp_c - Decimal("15.0")
vcf_to_15c = (
Decimal("1.0") - (alpha_per_deg_c * delta_t)
).quantize(Decimal("0.0001"), rounding=ROUND_HALF_UP)
standard_liters_15c = (
ambient_metered_liters * vcf_to_15c
).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
delivered_mass_kg = (
standard_liters_15c * density_at_15c_kg_per_l
).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
us_gallons_ambient = (
ambient_metered_liters / Decimal("3.78541178")
).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
# Check discrepancy between dispenser meter kg and aircraft cockpit totalizer kg
cockpit_discrepancy_pct = (
((delivered_mass_kg - aircraft_gauged_uplift_kg) / delivered_mass_kg) * Decimal("100.0")
if delivered_mass_kg > Decimal("0")
else Decimal("0.0")
).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
return {
"jig_interlock_passed": jig_safety_ok,
"volume_correction_factor_vcf": vcf_to_15c,
"standard_liters_at_15c": standard_liters_15c,
"delivered_mass_kg": delivered_mass_kg,
"delivered_us_gallons": us_gallons_ambient,
"cockpit_gauge_discrepancy_pct": cockpit_discrepancy_pct,
"fdr_status": "ISSUE_E_FDR_AND_POST_IATA_INVOICE" if (jig_safety_ok and abs(cockpit_discrepancy_pct) <= Decimal("1.50")) else "HOLD_FOR_JIG_OR_METER_AUDIT",
}3. Apron Flight-Schedule Dispatch, Electronic Fuel Delivery Receipts (e-FDR) & Bonded Export Accounting
To eliminate turnaround delays on international wide-body and regional turboprop flights, our platform digitizes apron operations from stand arrival to customs acquittal:
- Live Flight-Schedule & Bay Allocation Board: Integrates live AODB / flight schedule feeds showing aircraft registration (e.g.,
5Y-KZA), aircraft type (B787-8,A350,Dash 8-Q400), parking bay/hydrant pit number, estimated on-blocks time, and required total fuel on board. - Pre-Uplift Credit Gating, Fuel Carnet & Multi-Currency Platts Differential Pricing: Validates contract airlines against Platts Arab Gulf / Mediterranean Mean of Platts (
MOPS) plus into-plane differential formulas, and requires pre-authorized USD/KES deposit or valid aviation fuel carnet for non-contract ad-hoc charters before the refueler PTO valve unlocks. - Pilot Glass-Signature e-FDR, IATA XML Invoicing & KRA iCMS Bonded Export Acquittal: Captures the Captain or Flight Engineer’s signature on the intrinsically safe apron tablet, transmits the IATA Fuel Invoice XML / PDF immediately to airline operations, and compiles KRA Customs bonded export returns for duty-free international uplifts.
| Aviation Fuel Depot & Into-Plane Refueling ERP Metric | Legacy Spreadsheets & Manual Tallying | devManue Custom Enterprise ERP |
|---|---|---|
| JIG 1/2/3 Sump, CWD & Filter Delta-P Logs | Paper clipboards filled out retrospectively before IFQP audits | Timestamped NFC sump/filter scans with hard dispenser lockout on >15 ppm water or high Delta-P |
| Ambient Liters vs. 15°C Liters & Kilograms | Manual density/temperature lookup tables causing depot stock variances | Automated ASTM Table 54B 15°C volume & kilogram conversion directly from meter temperature probes |
| Paper Fuel Delivery Receipts (FDR) to Invoice | 3–7 days collecting paper pink slips from apron drivers for billing | Instant pilot glass-signature e-FDR transmitting IATA XML invoices within 30 seconds of chocks-off |
| Ad-Hoc Charter Credit & Bonded KRA Returns | Unsecured credit uplifts & manual spreadsheets for KRA export acquittal | Real-time charter wallet pre-authorization and automated KRA iCMS bonded uplift schedules |
Related Enterprise ERP & Engineering Guides
- Commercial Aviation MRO, Charter Airline & Flight Operations ERP — Managing aircraft tech-logs, KCAA airworthiness directives, and flight dispatch.
- Bulk Petroleum/LPG Terminal & Custody-Transfer Metering ERP — Managing Coriolis mass-flow custody transfer, bonded tank farms, and gantry automation.
- Carbon Credit dMRV & Sustainable Aviation / Clean Energy ERP — Tracking verifiable emissions reductions and environmental compliance telemetry.
- Midstream Pipeline Pigging, Inline Inspection (ILI) Smart Pig Anomaly & Cathodic Protection (ICCP) ERP — How to architect a Midstream Pipeline Pigging, Inline Inspection (ILI) Smart Pig & Impressed-Current Cathodic Protection (ICCP).
- Custom Aviation Fuel Depot & Into-Plane Refueling ERP — Architect your JIG-compliant airport fuel depot and apron dispatch platform with devManue.