Regulation · Systems · Aviation

Aviation Regulation, Systems, and Insight.

From the ICAO framework and the 19 Annexes to aviation system-development tutorials, in-depth articles, and the news that moves the field — clear, well-sourced reading for the modern aviation professional.

Read Articles Read Tutorials

Select your way in

Pick where you want to start.

Episodes

A structured video series on ICAO, the 19 Annexes, and how civil aviation actually works behind the scenes.

Articles

Field notes, opinion, and analysis from working pilots, controllers, investigators, and regulators.

Technology

Tutorials on building the systems that run aviation — APEX, Oracle, ORDS, integrations, regulatory data models.

Latest episodes

Episode 01 9 min May 2026

What is ICAO?

The Chicago Convention. The agency it created. Why it still governs every international flight.

Recent Articles

Safety Management 9 min

Annex 19: How Safety Management Became Its Own Discipline

Annex 19 is how safety management became its own discipline -- the first new Annex in decades, effective 2013. The State Safety Programme, the four-component SMS, continuous hazard identification, protected safety data and just culture, and measuring safety performance, with ASIAS and EPAS as examples. (3rd Edition applicable November 2026 -- verify.)

Safety Management 8 min

Annex 18: Carrying Dangerous Goods by Air, Safely

Annex 18 governs carrying dangerous goods by air safely, with the detail in the Technical Instructions (Doc 9284). The nine hazard classes, packing, labelling and the shipper's declaration, operator duties and training, the UN Model Regulations and IATA DGR -- and the lithium battery problem, from cabin-versus-cargo rules to the accidents that tightened them.

Aviation Security 9 min

Annex 17 and the National Civil Aviation Security Programme

Annex 17 is aviation security -- safeguarding civil aviation against acts of unlawful interference through each state's National Civil Aviation Security Programme. Layered prevention, the insider threat, response and quality control via ICAO's USAP, the new cyber frontier, and the balance with Annex 9 facilitation. A public, educational overview -- no operationally sensitive detail.

All articles →

Recent Tutorials

Aviation Technology 6 min

Creating APEX_PDB and Installing APEX 26.1

Create a dedicated APEX_PDB pluggable database with four tablespaces, then install the APEX 26.1 engine into it as schema APEX_260100 and stage its static images for Apache.

Aviation Technology 7 min

Preparing AlmaLinux 9 and Oracle 26ai for APEX

Tune AlmaLinux 9 and Oracle 26ai for a stable APEX host: kernel parameters, user limits, disabling Transparent Huge Pages, and the database memory, process, and redo-log settings sized for an 8 GB server.

Aviation Technology 6 min

The Complete Oracle APEX 26.1 Server Stack

A map of the complete Oracle APEX 26.1 server stack: how the database, application, and web tiers fit together, what is exposed to the internet and what is not, how mail leaves the box, and what each tutorial in the series builds.

All tutorials →

About Aviation Affair

Founded by Ahmed Saeed — over thirty years across Saudi Airlines, the General Authority of Civil Aviation, the Aviation Investigation Bureau, and Saudi Aviation IT Co. Today a senior consultant at one of the largest business solutions companies in Saudi Arabia, and a certified Oracle APEX developer.