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
Service Difficulty Report (SDR) Query
Copter
Contains approximately 1,500,000 publicly available Service Difficulty Reports (SDR)s filed with the FAA from 1975 to the present.

If this is your first time or you are not sure how to generate this (SDR) Service Difficulty Report 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)
Date Of Report From
To
Operator Control Number
Unique Sequential Number
Date Of Occurrence From
To
Aircraft Registration (no leading "N")
Aircraft Manufacturer
Aircraft Manufacturer Model
Aircraft Make Model Sequence
Precautionary Procedures
Segment
Operation Type
Carrier Name
Air Carrier Operator Code
(JASC) Air Transport Association Code
Nature Of Condition
Submitter
Report Status
Alert
Original Report Microfilm Roll
Original Report Microfilm Frame
Region
Report District Office
Defective Part Name    
Defective Part Location On Aircraft    
Defective Part Condition    
Part Total Time
Part Total Time Since Overhaul
Component Manufacturer
Component Manufacturer Model
Component Manufacturer Number
Manufacturer Part Number
Stage Of Operation
Severity Factor
Air Transport Association (ATA) code
FAA Assigned Aircraft Group Code
Region Responsible for Aircraft
Aircraft Manufacturer Number
Aircraft Weight Class
Aircraft Wing Type
Aircraft Power Class Code
Number Of Engines
Design Characteristic Code
Landing Gear Code
Aircraft Type Certificate
FAA Assigned Engine Group Code
Engine Manufacturer
Engine Manufacturer Model
Engine Make Model Sequence
Region Responsible for Engine
Engine Power Class Code
Engine Type Code
Engine Type Certificate
FAA Assigned Propeller Group Code
Propeller Manufacturer Name
Propeller Manufacturer Model
Region Responsible for Propeller
Propeller Manufacturer Number
Propeller Power Code
Propeller Type Code
Propeller Type Certificate
Remarks

   

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


Date of Report
The date the SDR was filed, not the date it occurred.
Along with the Unique Sequential Number, used to uniquely identify an SDR.
Always displayed and cannot be deselected.
Output is sorted by this field.

Operator Control Number
A 5 character field used to uniquely identify an SDR.
Always displayed and cannot be deselected.
Output is sorted by this field.

Date Of Occurrence
The date the SDR occurred, not the date it was filed.

Aircraft Registration
The FAA identification for the aircraft. Also known as "tail" number.
If searching for a specific N Number, do not enter the leading "N" for the search value

Carrier Name
Airline or Air Carrier name. Not always present. Use a "contains" predicate for best results.

Air Carrier Operator Code
First four alphanumeric characters of the operator's certificate number. Constrains report to specific air carriers. Use when "Carrier Name" is no present.

Defective Part Name
Not consistently coded, so can only be displayed, not search on.

Defective Part Location On Aircraft
Not consistently coded, so can only be displayed, not search on.

Defective Part Condition
Not consistently coded, so can only be displayed, not search on.

Aircraft Manufacturer Number
The complete aircraft serial number assigned to the aircraft by the manufacturer.
Not consistently coded.

Remarks
Free form text.
Legal Copyright 2001 - 2011 AviationDB.com Corp. All Rights Reserved Contact Us