Flight Number Availability & Allocation Audit

Overview

This companion guide provides operational teams, network planners, and scheduling analysts with a standardized workflow to evaluate flight number block utilization, detect unallocated flight numbers, and find contiguous open ranges for new route pairings or seasonal expansions.

Natural Language Prompt Template

Copy and paste the prompt below into the assistant, replacing the bracketed placeholders [...] with your target parameters:

PROMPT

Run a Flight Number Availability & Allocation Audit for carrier [Carrier IATA Code, e.g., DL, AA, UA, LH] using schedule data from [Dataset ID / "the latest published schedule"]: 1. Parameters: - Target Carrier: [Carrier IATA Code] - Target Flight Number Range: [Start Number, e.g., 500] to [End Number, e.g., 999] - Timeframe: [Start Date: YYYY-MM-DD] to [End Date: YYYY-MM-DD] - Service Type Scope: Scheduled passenger services (service_type = 'J') - Operation Filter: [All Published Flights / Own-Metal & Regional Operating Flights Only (operating_airline_disclosure IS NULL OR operating_airline_disclosure = 'X')] - Block Grouping Interval: Blocks of [N, e.g., 100] numbers (e.g., 500–599, 600–699) 2. Query Logic: - Generate the complete integer sequence between [Start Number] and [End Number]. - Identify all flight numbers actively scheduled for [Carrier] where: operation_from <= [End Date] AND COALESCE(operation_to, '2099-12-31') >= [Start Date]. - Compute the unassigned / available flight numbers (Sequence Numbers EXCEPT Scheduled Numbers). - Group results by the specified block interval. 3. Deliverables & Output Structure: Summary Table: Flight Number Block Utilization - Flight Number Block (e.g., '500–599') - Total Number Capacity in Block - Allocated / Active Flight Numbers Count - Available / Unassigned Flight Numbers Count - Utilization Rate (%) - Available / Open Flight Numbers List (comma-separated, or 'None (100% Allocated)') Executive Summary: - Overall series utilization rate across the entire audited range. - Blocks with the highest availability / headroom for new route filings. - Identification of contiguous blocks of unassigned numbers (e.g., 3+ consecutive available numbers suitable for new multi-leg pairings). - Any notable unallocated singletons (e.g., unassigned aircraft model numbers like 737/777 or omitted numbers).

Parameter Definitions

Parameter	Type	Description	Example
Target Carrier	String (2-letter IATA)	Carrier whose flight range is being audited.	DL, UA, BA
Target Range	Integer Range	Starting and ending integer boundaries of the flight number series.	1–999, 500–599
Timeframe	Date Range (YYYY-MM-DD)	Operational validity window for checking scheduled records.	2025-06-01 to 2025-10-31
Service Type	Character Code	IATA SSIM Service Type filter (J = Scheduled Passenger).	service_type = 'J'
Operation Filter	Filter Condition	Scope by operating carrier disclosure (Own-Metal vs Codeshare).	operating_airline_disclosure IS NULL
Block Interval	Integer	Grouping bucket size for aggregation and reporting.	50, 100, 250

Audit Logic & Methodology

1. Sequence Generation: Constructs a continuous virtual series of integers from [Start Number] through [End Number].
2. Active Schedule Extraction: Filters published SSIM/schedule records matching the carrier code, date overlap, and service type criteria.
3. Set Difference Analysis: Identifies gaps in active flight sequences: Available Numbers = Full Sequence \ Active Numbers
4. Block Aggregation: Evaluates metrics per bucket: Utilization Rate (%) = (Allocated Numbers / Total Block Capacity) × 100
5. Pattern Detection: Scans available sequences for contiguous slots (3+ consecutive numbers) and marketing/model singletons.

Expected Output Format

1. Flight Number Block Utilization Summary

Flight Number Block	Total Capacity	Allocated Count	Available Count	Utilization Rate (%)	Available / Open Flight Numbers
500–599	100	82	18	82.0%	504, 512, 513, 514, 545, 560–572
600–699	100	95	5	95.0%	601, 622, 633, 688, 699
700–799	100	40	60	40.0%	700–740, 777, 780–799

2. Executive Summary Highlights

• Overall Range Utilization: Total percentage of numbers allocated across all audited blocks.
• Headroom & Expansion Blocks: Identification of blocks with the lowest utilization for new schedule drops.
• Multi-Leg Pairing Candidates: Consecutive sequences of available numbers (e.g., 512–514, 700–740).
• Notable Singletons / Omissions: Specific marketing or aircraft-matching numbers currently open (e.g., 777).