Aircraft Dealer Query

Contains current and expired FAA licensed aircraft dealers, plus renewal history. About 19,000 records are present with about 2,000 current certificates.
See the related Aircraft Operator Query for domestic and foreign aircraft operators under FAR Parts 91, 121, 125, 129, 133, 135, and 137. Includes Licensed Air Carriers, Flight Schools, Maintenance Facilities, Charter Operations, and more.

In addition to the free reports and queries, we provide Custom Solutions using the AviationDB database, including one time and periodic report generation.

General help and hints are available if you are not getting the results you wanted on the Aircraft Dealer report. Help is also provided for a Data Item when it is displayed as a link.

Data Item Criteria Value(s)
Dealer Name
Certificate Number
Certificate Issue Date From
Certificate Expiration Date From
Cumulative Issue Count
Zip Code

General Help

If more than one record is returned, a summary screen will be displayed with data selected. Pressing the "Details" button on that screen will display details for each row. Depending on the criteria used, it could take as much as 2 minutes to return the results of the query. For best results, start with the fewest values and broadest criteria (for instance "contains" instead of "equals").
Hints to get results
Criteria values restrict the results to match all the values entered.
All data is returned when no criteria values are used.
If there are too many results, enter more criteria.
If there are not enough results use only one criteria value, use "contains" with a minimum number of characters or use broad ranges until results are returned.
Spelling, punctuation, and spaces can be inconsistant in any text such as names, addresses, serial numbers, etc.

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.
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.
Matches all items that contain this value. One and only value may be entered.

Dates can be entered in "YYYY-MM-DD" format.
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

Dealer name
Can be more than one.
Output is sorted by this column.

Custom Reports Copyright 2001 - 2024 AviationDB.com Corp. All Rights Reserved Legal Contact Us