Home AirLine Industry Statistical Reports and Queries,   Fee Based Services,   Database Description
  Aviation Reports and Queries    >   Airman,   Aircraft,   SDR,   Aircraft Operator,   NTSB Accident,   NTSB Pre 1982 Accident,   FAA Accident,

Home
Aircraft Operator Query

Sky Crane Contains the full FAA database of aircraft operators operating under FAR Parts:
91 General Aviation
121 Domestic, Flag and Supplemental Air Carriers and Commercial Operators of Large Aircraft
125 US Civil Airplanes, seating 20 or more passengers or a maximum payload capacity 6,000 pounds or more
129 Foreign Air Carrier and Foreign Operators of US registered aircraft engaged in common carriage
133 Rotorcraft External Load Operations
135 Air Taxi Operators and Commercial Operators
137 Agricultural Aircraft Operations

If you are not sure how to generate this Aircraft Operator report, help is available. In addition, help is provided for a data item when it is displayed as a link. Hints to find what you are looking for: Should you require custom reports or queries using this data (or any other AviationDB database) on a one time or periodic basis or would like to integrate an AviationDB database into your application, please contact us.

Data Item Criteria Value(s)
Operator name
FAR part
Certificate number
Certification type
Certificate issue date From
To
Certificate status date From
To
Certificate expiration date From
To
Total pilots (captains)
Total pilots (other)
Total flight engineers
Total flight attendants
Total dispatchers
Total navigators
Total noncertificated mechanics
Total certificated mechanics
Total repairmen
Total all employees
Principal employee name
Principal title
Principal address
Principal city
Principal state
Principal postal (zip) code
Principal country
Principal phone
Aircraft operated

   

General Help

A summary screen will be displayed with data selected. Pressing the "Details" button on that screen will display details for each row.

The fields can be used to select the data to return, choose the output format, and to reset the fields to their default values. For best results, start with the fewest values and broadest criteria ( for instance "contains" instead of "equals"). If there are too many results, use more values and narrower criteria. Depending on the criteria used, it could take as much as 2 minutes to return the results of the query.

Criteria
One and only one may be chosen per data item and take effect if any entries are made into the "value(s)" column. Comparisons are not case sensitive and the data item need not be selected for display to be used as criteria. The selections are:
Equal (default)
Exactly matches the specified value. Multiple values, separated by a comma, may be entered.
Not Equal
Does not match the specified value. One and only value may be entered.
Equal or Less
Matches the specified value and any values less than that entered. One and only value may be entered.
Equal or More
Matches the specified value and any values more than that entered. One and only value may be entered.
Between
Equal to or greater than and equal to or less than the specified values (two are required).
Starts With
Matches all items that start with this value. One and only value may be entered.
Contains
Matches all items that contain this value. One and only value may be entered.

Value(s)
Dates can be entered in many formats including "YYYY-MM-DD" or "MM/DD/YYYY".
Are not case sensitive.
Can be drop down list boxes or entered values.
Multiple values can be selected in drop down list boxes using the "control" or "shift" keys.
Values in drop down list boxes can be de-selected by click on the value while pressing the "control" key.
If more than one value is entered, separated them with a comma (stuff,more stuff).

Data Item Help


Operator name
Company or business name.
Always displayed and cannot be deselected.
Output is sorted by this column.

Principal employee name
This is the name of president, CEO, owner, etc.
The field is a concatenation of the last and then the first name separated by a comma.
Use the "starts with" criteria if searching by only the last name.

Principal address
This is the address of the principal (see above) and is usually the business address

Principal phone
Usually a ten character number, with the first 3 characters being the area code.
Use "starts with" to search by area code.

Aircraft operated
Contains the aircraft manufacturer name, aircraft model, and number of aircraft for each type of aircraft operated, one line per aircraft.
Aircraft manufacturer name is abbreviated to six characters.
Use "starts with" or "contains" to select by manufacturer.
Legal Copyright 2001 - 2011 AviationDB.com Corp. All Rights Reserved Contact Us