The 35,764 Aircraft in NTSB's Database That Aren't in Any FAA Registry Search

NTSB's accident data includes aircraft that never show up in a US FAA registry search. We expected that population to be mostly foreign-registered aircraft. The real numbers say otherwise.

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
USA29,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