How We Built a DGCA Random Selection Software for an Aviation Client

An aviation client came to us with a problem that sounds simple but isn't: they needed to randomly pick employees for a test, and prove that the pick was actually random.

Not a raffle. Not a "pick a name out of a hat" kind of random. Under DGCA (Directorate General of Civil Aviation) requirements, aviation operators must periodically select safety-sensitive employees for psychoactive substance (drug and alcohol) testing using a method that is fair, unbiased, and defensible if an inspector ever asks "how did you choose this person?"

That's how RandPicker — our custom aviation software for random employee selection — came to be. Here's the story of the problem, and how we built the solution.

Why Random Selection Matters in Aviation

If you work outside aviation, this requirement might sound unusual. But in a safety-critical industry, it makes complete sense: pilots, crew and other safety-sensitive staff need to be tested for psychoactive substances on a recurring basis, and the selection has to be genuinely random — not influenced, even unintentionally, by who a manager likes, dislikes, or simply remembers to include.

That means an aviation operator needs to show two things at once:

• Everyone in the eligible pool had an equal, unbiased chance of being picked
• There's a clear, timestamped record of exactly who was picked, when, and by what method

Get this wrong, and it's not just an internal process gap — it's a compliance finding waiting to happen.

The Problem With Doing It in a Spreadsheet

Before RandPicker, our client was doing this the way many operators still do: in Excel. A formula would "randomize" a column, someone would eyeball the top few rows, and that was the selection.

It worked, technically. But it created real risk:

• No proof the formula wasn't re-run quietly until a "convenient" result appeared
• No consistent history of past selections — just scattered files on someone's laptop
• No easy way to hand an inspector a clean, exportable record on demand
• Every repeat run needed a new formula, a new sheet, and a new chance for human error

None of this meant anyone was doing something wrong. It meant the process couldn't prove it was right — and in a regulated industry, that gap is the problem.

What Our Aviation Client Actually Needed

When we sat down with the client, the requirement list was refreshingly clear:

• Pick a fair percentage of a group at random — not just one person
• Let them manage their employee list easily — type names or upload an Excel file
• Keep a timestamped history of every run, so nothing is ever "lost"
• Ask for a reason whenever the picker was run more than once in a day, so repeat runs stay traceable
• Export any run — or the full day's runs — to Excel, ready to hand over for inspection
• No technical skill required. Anyone on the compliance team should be able to use it

How We Built RandPicker

We followed the same process we use for every aviation project — the same one we use for custom aviation software in general:

• Understand: we spent time learning the actual DGCA guideline the client had to satisfy, not just the feature request. That distinction shaped every decision after it.
• Design: we mapped the workflow — add people, choose who's eligible for that round, run the pick, review and export — into a simple three-step flow so it would never feel like "compliance software," just a tool that's easy to use.
• Build: we built a percentage-based random selection engine (not a single "winner" picker), with every run automatically logged — who was in the pool, who was picked, and exactly when it happened.
• Deliver & support: we shipped it, trained the team who'd actually use it day to day, and stayed on to refine it as their process evolved.

The result is a tool where the client's compliance officer can add or upload their employee list, select who's eligible this round, click one button, and get a fair, unbiased pick — with an audit trail already attached and an Excel export one click away.

What Changed for the Client

• Selection went from a manual spreadsheet exercise to a one-click, repeatable process
• Every run — first or repeat — is logged with a timestamp and, for repeats, a documented reason
• Inspection-ready records are available on demand, instead of being reconstructed after the fact
• The team no longer has to defend a spreadsheet formula — the tool itself is the proof of fairness

You can see the finished product on our RandPicker page — it's live, and it's exactly what we built for this client.

This Is What We Do

RandPicker is one piece of a bigger picture. Aviation operators don't just need a random-selection tool — they need flight operations software, crew and FDTL compliance tracking, maintenance and MRO systems, safety and risk reporting, and crew portals that all work the way a real operation runs, not the way generic business software assumes it should.

That's the custom aviation software we build at Pazhanam Technologies. If your operation has a process like this one — something regulation-specific, something a generic tool doesn't quite fit — it's exactly the kind of problem we like solving.

Back to Blog