Would it be possible to bind a specific aircraft reg. number to specific flights upon flights creation instead of simply an aircraft type? For example flight IALxxx from LGAV to EDDT is flown with 737 but would it be possible to have this bound to specific 737 (e.g. SX-AFY)?
I am asking this as it would prevent problems and confusion in a multi hub airline.
Consider the following example:
Let's say airline A has three hubs: LGAV, EDDT, EGLL
There is flight IAL010:LGAV-EDDT and flight IAL011:EDDT-LGAV flown by 737 operated by LGAV hub
There is flight IAL110:EDDT-EGLL and flight IAL111:EGLL-EDDT flown by 737 operated by EDDT hub
Now let's say that the LGAV's 737 has just landed at EDDT and a pilot wants to fly IAL110 from EDDT to EGLL.
The result might be that all LGAV aircrafts end up in London ot in other hubs if they were even more.
If on the otherhand, upon booking a flight we could not any 737 which is present at the departure airport, but only the one (based on reg. number) which is assigned to do the specific flight this problem would never occur.
Do you see my point?
Bound aircrafts (reg numbers) to flights
Moderator: FSAirlines Staff
Bound aircrafts (reg numbers) to flights
CEO
Ionathan Airlines
Ionathan Airlines
Any opinions on the suggestion?
Technically speaking I believe there is a field "AssignedACType" in a "Flights" table. Whenever a flight is booked there is a select statement like:
select ACType from Aircrafts
where Aircrafts.ACType=Flights.AssignedACType
and Aircrafts.Location=Pilots.CurrentLocation
Now, if the Flights table was enriched with a field AssignedRegNum and the above select query was changed to
select ACType from Aircrafts
where Aircraft.ACRegNum=Flights.AssignedRegNum
and Aircrafts.Location=Pilots.CurrentLocation
the problem would be solved.
Technically speaking I believe there is a field "AssignedACType" in a "Flights" table. Whenever a flight is booked there is a select statement like:
select ACType from Aircrafts
where Aircrafts.ACType=Flights.AssignedACType
and Aircrafts.Location=Pilots.CurrentLocation
Now, if the Flights table was enriched with a field AssignedRegNum and the above select query was changed to
select ACType from Aircrafts
where Aircraft.ACRegNum=Flights.AssignedRegNum
and Aircrafts.Location=Pilots.CurrentLocation
the problem would be solved.
CEO
Ionathan Airlines
Ionathan Airlines