Category Archives: Free

Aeriaa Airport Dashboard. Creating the BHS (I)

In the previous article we started to develop the basic airport’s systems four our Airport Dashboard’s Project, the AODB mock-up, in this article we are going to build another airport’s system mock-up that has a relationship with the AODB, the Baggage Handling System (BHS), not the physical system but the Sort Allocation Computer (SAC). Please see this article for a introduction of the AODB & BHS relationship. To sum up, the BHS has the following main features.

  • Transport, classify and deliver each baggage to its destination carrousel (departure and arrival flights).
  • Process the baggages in the integrated security subsystem. As X-Ray machines that look for hazardous substances, material, drugs, explosives, etc.
  • Store the baggages for early check-in flights.

What data do we want from BHS to our Dashboard?

  • General process status and metrics. Bags per hour, first bag delivery time, luggage events per flight, bad reading tag ratio, system status, percentage of manual sorting in comparison to automatic sorting, percentage of bags that are wrongly sorted by the system (sent to a wrong carrousel), average time and standard deviation regarding the time to be sorted by the BHS, etc. Thanks Pablo Roux for some KPI’s suggestions.

What data does the BHS (SAC) need from the AODB?

  • The flights scheduled for a time period (day, week, etc.). Where are they planned to be parked.
  • Any flight’s relevant updating in real time, any new estimated time of arrival or departure (ETA, ETD), cancellation, stand reassignment, etc.

Are there other systems closely related to BHS?

  • Yes, the Airlines Departure Control Systems from the BHS will be notified about the baggage checked, through SITA. (see the article mentioned before)


Baggage Handling System Blueprint

Baggage Handling System Blueprint

Aeriaa Airport Dashboard. Creating the AODB (I)


Following the aeriaA Airport Dashboard Project series, in this post we will build a little Airport Operational DataBase (AODB) system for our Dashboard’s architecture. This post is mixed oriented, it is a  little introduction of an AODB and a little introduction of the technologies used for building it.

The AODB is one of the central part of the whole project. We simplified a lot the AODB’s features, it is not the intention to build a real one, these are the main features:

  • Manage the Departures Flights of our Aeriaa International Airport.  We can create, update and delete departures flights (We will develop the arrivals flight later).
  • The frontend is a website application. We’ll try in the the future a smartphone app (step by step).
  • The flight’s attributes at the first data model are (alphabetically ordered):
    • AOBT. Actual Off-Blocks Time. It is the time when the fight is ready, doors closed, jetway decoupled, and the towbear available for the push-back.
    • ASAT. Actual Start-Up Approval Time. It is the real time when the flight has the approval for start the engines.
    • Aircraft. The aircraft model.
    • Company. The airline company.
    • Counter. The designated counters for the flight.
    • Destination.
    • ETD. Estimated Time for Departure.
    • Flight. It is the fight’s code.
    • Gate. The gate assigned for the flight.
    • ICAO. Company’s ICAO code.
    • STD. Scheduled Time for Departure.
    • TOBT. Target Off-Block Time. It is the target time for the Off-Blocks Time (see AOBT)
    • TSAT. Target Start Up ApprovalTime. See ASAT.
  • We included some time’s milestones (TOBT, TSAT, AOBT, ASAT) related to A-CDM philosophy in order to approach the AODB to this new work collaboration paradigm. There just a few of the huge times complexity of A-CDM. You can find a big list of time milestones here
  • Billing the services provided by the airport or ground handler that the airline must pay. The services could be the push-back service, the jetways, follow me car, baggage handling, counters, etc.


Building our AODB System mock-up. Image Credit: Pedro Garcia

aeriaA’s Airport Dashboard Project

Project Name: The aeriaA Airport Operation Dashboard.

Project status: Ongoing


License: Creative Commons

Author/s: Pedro García

Contact: LinkedIn Profile


The purpose of this demo is technology self learning and for sharing with you some airports concepts.
Imagine that there is a big-size airport called Aeriaa International Airport, with a fake IATA code, AEI (some day I’ll post why the airports code are composed) with about 20 million passengers per year and with one huge terminal building.
In this Terminal, called “Papepe Terminal” we have this services, systems and facilities:
- One automatic baggage handling system.
- 150 checkin counters and 25 self service checkin kiosks (IRONIC MODE=ON “I love them” IRONIC MODE=OFF).
- 50 boarding gates, distributed in A, B, and C areas.
- 20 Passenger Boarding Bridges/Airbridges/Jetties for boarding.
- 2 security passenger filters.
- A parking lot with 10.000 parking spaces.
- Terminal building SCADA systems, HVAC, lighting, water, electric power…
- Airport Operational Systems to manage the flights. I will more precise on these systems later. (in this or in next posts).
- Cameras, cameras, and more cameras, security systems at every corner and access control to all the security areas. (As operational systems, you will see later more about this).
So we have a terminal, facilities, systems….lets have a look on the airport’s users:
- Passengers, people that take or leave a flight at departures or arrivals. Do not forget the people that see off his friends and families and those ones that welcomes them back. There are two “emotional” places at every airport. The happy one, at arrivals and the sadest one, at departures, if one day you need optimism, please enjoy a few hours at an airport’s arrivals lounge.
- Airlines, can you put in a list all the airlines you know?
- Handling agents, specialized companies that manage the specific processes of carrying baggages to/from planes, or carrying passengers to remote positions in buses, moves the planes to the taxi areas, check and board the passengers…
- Shops! Yes, the airports are malls where the people take planes.
- Workers, thousand of workers that maintain the airport alive and functional.



Demo Airport Dashboard. Credit: Pedro Garcia



Airport’s world of events


Basic Architecture