Home
Aircraft Query
ER2
Contains all current, deregistered, and reserved U.S. civil aircraft maintained by the FAA. Displays current and historical ownership, summary SDR, Accident, and other related data for aircraft with the same N Number.

Use these query results with caution. Over time registration numbers (N Numbers) are assigned to different aircraft and diverse data stores with inconsistent data are being joined.

Other AviationDB queries include:
SDR, NTSB Accident, NTSB Pre 1982 Accident, and FAA Accident and Incident detailed aircraft related reports.
Airman Query for FAA licensed airmen, mechanics, and others.
Aviation Business Queries for FBO's, flight schools, aircraft dealers, and more.
The database also contains extensive Air Carrier reports with virtually every domestic scheduled flight since October 1987 including On Time performance, seat capacity and usage, and extensive airline financial data.
In addition to these free reports and queries, we provide Custom Reporting using the AviationDB database, including one time and periodic report generation.

General help is available if you are not sure how to generate this Aircraft report. Help is also provided for a Data Item when it is displayed as a link.

       
Data Item Criteria Value(s)
N Number (no leading "N")
Last Action Date From
To
Aircraft Manufacturer Name
Aircraft Model Name
Serial Number
Year Manufactured
Registrant Name
Street
City
State
Zip Code
Country
FAA Region
Registrant Type
Fractional Owner
Airworthiness Date From
To
Expiration Date From
To
Certificate Issue Date From
To
Certificate Status
Aircraft Type
Aircraft Category
Builder Certification
Number of Engines
Number of Seats
Aircraft Weight
Cruising Speed
Airworthiness Classification
Approved Operation Codes    
Transponder Mode S Code
Engine Manufacturer
Engine Model Name
Engine Type
Engine Horsepower Thrust
Fuel Consumed

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.

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 "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


N Number
The FAA identification for the aircraft.
If searching for a specific N Number, do not enter the leading "N" for the search value
Always displayed and cannot be deselected.
Output is sorted by N Number, Last Action Date, Aircraft Manufacturer Name, Aircraft Model Name, Serial Number.
See here for a sequential list of N Numbers.

Last Action Date
The last time the status of the aircraft changed.
Always displayed and cannot be deselected.
Output is sorted by N Number, Last Action Date, Aircraft Manufacturer Name, Aircraft Model Name, Serial Number.

Aircraft Manufacturer Name
Not coded consistently and can have values that are similar but not identical, such as ROCKWELL INTERNATIONAL CORP and ROCKWELL INTERNATIONAL.
Using the CONTAINS or STARTS WITH criteria might be useful.
Always displayed and cannot be deselected.
Output is sorted by N Number, Last Action Date, Aircraft Manufacturer Name, Aircraft Model Name, Serial Number.

Aircraft Model Name
Not coded consistently.
Using the CONTAINS or STARTS WITH criteria might be useful.
Always displayed and cannot be deselected.
Output is sorted by N Number, Last Action Date, Aircraft Manufacturer Name, Aircraft Model Name, Serial Number.

Serial Number
The complete aircraft serial number assigned to the aircraft by the manufacturer.
Always displayed and cannot be deselected.
Output is sorted by N Number, Last Action Date, Aircraft Manufacturer Name, Aircraft Model Name, Serial Number.

Registrant Name
The first registrant's name which appears on the Application for Registration, FAA Form 8050-1.
This value is usually coded as last name, a space, first name, a space, and middle name.
It can also contain miscellaneous text such as " REGISTRATION PENDING".

State
Use the standard 2 character abbreviation.
Inconsistently coded when country is not USA.

Zip Code
When the country is not USA, the format is the postal code for that country.

Aircraft Weight
CLASS 1 is Up to 12,499 lbs
CLASS 2 is 12,500 - 19,999 lbs
CLASS 3 is 20,000 and over lbs

Cruising Speed
In many instances, has a value of 0.

Approved Operation Codes
Cannot be used as a selection criteria, but can be displayed.

Engine Manufacturer
Not coded consistently and can have values that are similar but not identical, such as BMW ROLLS and ROLL-ROYCE.
Using the CONTAINS or STARTS WITH criteria might be useful.

Engine Model Name
Not coded consistently.
Using the CONTAINS or STARTS WITH criteria might be useful.

Engine Horsepower Thrust
Either the horsepower or thrust.
Not present or 0 for non powered aircraft.

Fuel Consumed
Not consistently present.

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