Aviation Fuel (Jet A-1) Depot, Hydrant Pipeline & Into-Plane Refueling ERP: JIG-1/2/3 Filter-Water Separator Differential Pressure, Millipore Colorimetric QC, Temperature-Compensated Litres & IATA Fuel Ticket Settlement

How to architect an Aviation Fuel (Jet A-1 & Avgas 100LL) Airport Depot, Hydrant Pipeline & Into-Plane Refueling ERP in Kenya and East Africa: Joint Inspection Group (JIG 1/2/3) daily tank sump water-detector checks, filter-water separator differential pressure (Delta-P) interlocks, ASTM D1250 density/temperature volume correction to 15°C, KCAA/EPRA batch recertification, and electronic Fuel Delivery Receipt (e-FDR) IATA settlement.

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/m with 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 depth or 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 exceeds 15 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 ΔP exceeds 1.0 bar (15 psi) or drops suddenly (indicating element rupture), the dispenser truck is immediately quarantined in the dispatch console.
Stage 01→
Pipeline / Bridger Intake
DEF STAN 91-091 CoQ, Conductivity Check & Mandatory Tank Settling Lock
Stage 02→
JIG Sump & Filter QC
Daily Low-Point Sump CWD (<15 ppm), Millipore Colorimetric & FWS Delta-P
Stage 03→
Apron Flight Dispatch
Flight Schedule Feed, Stand Assignment & Airline Credit/Carnet Pre-Auth
Stage 04→
Into-Plane Metering
ATEX Tablet Bulk-Meter Link, Deadman Timer & ASTM 54B 15°C Conversion
Stage 05✓
e-FDR & IATA Billing
Pilot Glass-Sign e-FDR, KRA Bonded Export Entry & IATA XML Invoicing

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 MetricLegacy Spreadsheets & Manual TallyingdevManue Custom Enterprise ERP
JIG 1/2/3 Sump, CWD & Filter Delta-P LogsPaper clipboards filled out retrospectively before IFQP auditsTimestamped NFC sump/filter scans with hard dispenser lockout on >15 ppm water or high Delta-P
Ambient Liters vs. 15°C Liters & KilogramsManual density/temperature lookup tables causing depot stock variancesAutomated ASTM Table 54B 15°C volume & kilogram conversion directly from meter temperature probes
Paper Fuel Delivery Receipts (FDR) to Invoice3–7 days collecting paper pink slips from apron drivers for billingInstant pilot glass-signature e-FDR transmitting IATA XML invoices within 30 seconds of chocks-off
Ad-Hoc Charter Credit & Bonded KRA ReturnsUnsecured credit uplifts & manual spreadsheets for KRA export acquittalReal-time charter wallet pre-authorization and automated KRA iCMS bonded uplift schedules
// High-Throughput Engineering • Systems Architecture Consulting

Scaling Python & Django APIs or Resolving Concurrency Bottlenecks?

We partner with engineering founders and tech leads to architect resilient distributed systems, optimize async worker pools, design scalable databases, and eliminate production latency spikes.

All Insights
Chat on WhatsApp