Airline Fleet Database/Website

Research (CEESAR) directorate of Transport Canada (herein called
Transport Canada) requires data on airline fleets to
successfully fulfill aviation data requests both from within and
external to Transport Canada.
In addition to fulfilling aviation fleet requests, airline fleet
data will allow Transport Canada to remain informed of current
trends within the aviation industry, both domestic and
international.
Data extracted and manipulated from an airline fleet web-based
querying tool and flat file will be used in public and internal
documents of Transport Canada, to provide information on a given
air carrier or an aggregate analysis of fleet utilization and
characteristics as well as complement Transport Canada's other
data sources.
REQUIREMENT
Transport Canada's requirements are as follows:
1. Format: Data on airline fleets must be accessible via a
web-based querying tool and a flat file.
a. The web-based querying tool must:
i. Be easily accessible to employees of Transport Canada and not
require an installation of software on the employees' computer.
ii. Be dynamic, allowing for custom and advanced data searches
that are readily exportable or downloadable to Microsoft Excel.
This feature must be available for all data fields and time
periods accessible through the website.
b. The flat file must be downloadable to an organized database,
and its structure must not change without adequate (three
months) warning.
2. Timeliness:
a. The dataset available to users must not be older than the
last quarter and must be updated at least quarterly on the
web-based querying tool and be accessible 24 hours a day/seven
days a week except for routine maintenance and outages.
b. Flat files must be delivered through email, transfer
protocol or any other electronic means deemed acceptable to both
parties on an annual basis.
3. Data requirements:
a. Both Canadian and foreign (non-Canadian) airlines must be
included with the airline fleet data. The product must represent
at least 90% of the scheduled Canadian airline capacity on the
Canadian market and 90% of the scheduled foreign airlines
capacity on the Canadian market.
a. The product must contain specific data fields with respect to
airline fleets. Any additional data fields that are sought will
be considered as an asset. See the Required Data Fields and
Optional Data Fields sections below for details.
b. The product must provide both current (2014-15) and
historical (minimum of five years) data that must fall within
specific time variables such as year or yearly/monthly time
periods.
4. Customer support: A comprehensive support network that will
address any questions or concerns regarding access to the
product or its content must be provided at no additional cost.
The support network must have a reasonable response time (1 to 2
business days) and be available throughout the entire
contractual period.
5. Licenses: As a minimum, one of the following two options must
be provided:
a. Two (2) concurrent user licenses shared amongst any Transport
Canada employee; or
b. Five (5) individual user licenses to be assigned at the
discretion of Transport Canada.
Required Data Fields:
· Aircraft Type: This refers to the type of aircraft (example:
commercial jetliners, regional aircraft, executive jets and
miscellaneous aircraft).
· Aircraft Status: This refers to the state of an aircraft at
any point in its lifetime (example: active, retired, in
storage).
· Manufacture Date: This refers to the year in which an aircraft
was manufactured.
· Engine Type: This refers to a generic description by the
engine manufacturer.
· Maximum Takeoff Weight: This is the maximum allowable weight
of the aircraft at take off, in pounds or kilograms.
· Maximum Seats: This is the maximum seating capacity for
passenger aircraft either certified or subject to certification.
· Registration/Tail Number: This refers to the registration of
the aircraft.
· Operator Name: This is the operator's name.
· Operator Code: This refers to the two-character International
Air Transport Association (IATA) code or to the three-letter
International Civil Aviation Organization (ICAO) code
(identifying the operator). If there is no official code
available, an unofficial code used by the airline may apply or
other system as identified by the data provider.
· Leased/Owned Indicator: This indicates whether the aircraft is
leased or owned at any point in its lifetime.

Optional Data Fields:

· Belly Volume: This is the total volume of the aircraft's lower
deck cargo hold, including all forward, rear and bulk
compartments, in cubic feet or meters.
· Main Deck Volume: This is the total volume of the main deck of
freighter aircraft expressed in cubic feet or meters.
· Seat Class: This refers to seat class (example: economy,
coach, business, first) including the number of seats per class.
· Total Seats: This refers to the total number of seats on the
aircraft based on carrier configuration.
· Pay Load Capacity: This would include the weight of the
following three categories - passengers, luggage and freight -
that an aircraft can maintain.
· Fuel Capacity: This includes the total amount of fuel
available for propulsion.
· Range with Maximum Fuel: This is the range with maximum fuel
on board and no payload.
· Range with Maximum Payload: This is the range with maximum
payload on board.
· Overall Length: This is the overall length of the aircraft in
feet or meters.
· Aircraft Noise Class: This field refers to engine noise
classifications.
· Number of Engines: This refers to the number of engines for an
aircraft.
· Hours Flown: Total hours flown during the aircraft's years of
activity.
· Registered Owner Name: This is the registered owner's name.
· Lease Expiration Date: This refers to the date when an
aircraft lease expires.
· Present Value: The current resale value of the aircraft.

Delivery Date: Above-mentioned

The Crown retains the right to negotiate with suppliers on any
procurement.

Documents may be submitted in either official language of Canada.