Airplane Mode — Frappe Custom App | DevOps & Frappe Technical Specs

The Problem

Standard ERP platforms aren't built for aviation. Flight routes, seat assignments, ticketing logic — none of it fits natively into off-the-shelf systems.

Qualitative Outcome

Flight and ticketing workflows moved entirely inside the ERP — eliminating third-party API latency and data inconsistencies.

What changed for the business

Passenger flights and ticketing flows now live inside the company's core ERP — no third-party sync required.

How it was built

A standalone Frappe app with custom DocTypes, Python server scripts, REST API hooks, and optimized MariaDB queries for real-time seat and baggage logic.

Architecture Snapshot

Aviation UICustom Passenger DocType

→

Python ValidationHooks, Server & Capacity Checks

→

MariaDB ACIDOptimized Passenger Records

What I Built

Defined custom DocTypes for flights, passenger manifests, seat grids, and ticket transactions.
Wrote Python server scripts and Frappe hooks for automated baggage calculations and seat locking.
Built REST API endpoints to sync operational data with external ticketing platforms.
Optimized MariaDB query logic for high-speed inventory updates under concurrent ticket lock conditions.

How It Works

Standard ERP wasn’t designed for airline logistics. It doesn’t know about seat grids, baggage calculations, or passenger manifests. Building this custom Frappe application taught me how far the framework can be pushed — and how elegantly it can model a completely custom business domain.

What Was Built

The app extends Frappe at three levels:

DocTypes — Custom schemas (Airline Flight, Airplane Ticket, Airport) that model the aviation domain natively inside ERPNext.
Server Scripts — Python validation logic that prevents oversold seats, automates baggage fee calculations, and runs pre-commit checks.
Hooks — Event-driven automation on validate, on_submit, and background Redis queue triggers — keeping every data change tracked and auditable.

Building something similar?

I'd love to hear about what you're working on.

Start a conversation →