Search an N-number or registration on Aircraft Research and sometimes you'll be redirected to a different kind of result: a record flagged "Not an FAA-registered aircraft." These come from NTSB's own accident and incident data, for aircraft that were investigated but never matched to anything in the FAA's civil aircraft registry. We checked how many of these records exist, and what they actually are — and the answer surprised us.
The scale: 35,764 aircraft, 38,935 events
As of this check, AeroPlanet's database holds 35,764 of these "stub" aircraft records, tied to 38,935 separate NTSB accident/incident events. 2,394 of those aircraft — about 6.7% — appear in more than one event.
The assumption we expected to confirm
Going in, the working assumption was that this population would mostly be genuinely foreign-registered aircraft — NTSB investigates crashes and incidents involving non-US aircraft under international agreement in certain circumstances, plus military and drone/UAS aircraft that fall outside the FAA's civil registry entirely. We checked the country of registration recorded for each one:
| Country (as recorded by NTSB) | Count |
|---|---|
| USA | 29,924 |
| Brazil (BR) | 451 |
| Canada (CA) | 300 |
| Australia (AU) | 294 |
| Mexico (MX) | 285 |
| United Kingdom (GB) | 265 |
| Colombia (CO) | 202 |
| France (FR) | 199 |
| Germany (DE) | 156 |
| Spain (ES) | 143 |
| Argentina (AR) | 138 |
| Venezuela (VE) | 121 |
| South Africa (ZA) | 114 |
| Japan (JP) | 108 |
| Burkina Faso (BF) | 104 |
The actual finding: most of these aircraft are American
83.7% of stub records — nearly 30,000 of the 35,764 — are recorded with a US country of registration. Only about 16.3% are genuinely non-US, spread across dozens of countries.
That flips the expected story. The overwhelming majority of aircraft in this database that "aren't in the FAA registry" aren't foreign, military, or drone aircraft at all — they're American aircraft that simply don't appear in the specific, current FAA civil registry extract this site's Aircraft Research tool checks against. NTSB's own accident data reaches back to 1962; the FAA registry snapshot behind Aircraft Research reflects the current, active registry. An aircraft that had an accident decades ago and was deregistered, scrapped, or otherwise dropped out of that current snapshot long before this site existed still has its NTSB record intact — it just no longer has a matching row in today's FAA table.
The genuinely foreign, military, and drone aircraft in the data are real and worth knowing about too — from a Brazilian-registered agricultural aircraft to an Australian helicopter to aircraft flagged from Burkina Faso, where NTSB's international-assistance investigations show up in aviation accident data most US-only sources never surface at all. They're just a smaller slice of the picture than the "foreign aircraft" framing alone would suggest.
Look up a specific registration
If a registration doesn't turn up on Aircraft Research, it may still have an NTSB record on file as a stub aircraft — the tool cross-references both automatically.
Look Up an Aircraft