Aircraft, Airman, Accident, and SDR Reports and Queries
We provide these reports and queries as a demonstration of the reporting capabilities and data content of our database and hope you find them useful. The queries can be customized to select and analyze the data to suit your needs.
In addition to the free reports and queries, we provide Custom Reporting using the AviationDB database, including one time and periodic report generation.
The data is extracted from a variety of government agencies, transformed, and loaded into our database. See the Database Description for specific information.
Aircraft Query - Create Aircraft reports against all U.S. Civil Aircraft maintained by the FAA, Civil Aviation Registry, Aircraft Registration Branch, AFS-750. Contains fixed and rotary wing aircraft, gliders, and amateur/homebuilt craft. Search on any combination of criteria such as N-Number, make, model, owner name, address, and more. Query returns SDR, NTSB Accident, FAA Accident, Deregistered Aircraft, and other data related to the aircraft.
Airman Query - Create Airman reports against the full FAA database of Airman, their ratings, type certificates, and type ratings, both domestic and foreign. Also includes non aircrew personnel such as control tower operations, mechanics, dispatchers, drone operators (Remote Pilot - Small Unmanned Aircraft System), and others. Search on any combination of criteria such as name, address, rating, and much more. Over 2,000,000 airman are in the database.
Accidents
NTSB Accidents Query - Information from 1982 and later about civil aviation accidents and selected incidents within the United States, its territories and possessions, and in international waters. Contains fewer (about 90,000), but more serious events than the FAA data store.
NTSB Pre 1982 Accidents Query - Information similiar to the above but from 1962 through 1981. Data is not in the same format or as complete as the newer NTSB accident database. Contains over 80,000 accidents.
FAA Accidents and Incidents Query - Over 330,000 publicly available Accident and Incident reports filed with the FAA from 1973 to the present, searchable on 30 criteria.
SDR Query - Contains approximately 2,200,000 publicly available SDRs filed with the FAA from 1975 to the present. Search on any combination of many criteria.