First-party report
NSN × MPN coverage in the PartsPerk published catalog
A first-party measurement of how many published PartsPerk catalog identities carry a manufacturer part number (MPN), an NSN identifier, or both — derived from live owned-catalog tables, not a market-wide census.
- Author
- PartsPerk
- Editor
- PartsPerk Catalog Intelligence
- datePublished
- dateModified
Sample size (live DB aggregates)
Captured · source live_db_published_scope
- Published identities: 50,832
- With MPN: 50,832 (100%)
- With NSN identifier: 10,464 (20.6%)
- Distinct published NSNs: 9,994
- With both MPN and NSN: 10,464 (20.6%)
- MPN without NSN: 40,368
- NSN without MPN: 0
Download aggregate JSON (counts only) — row-level catalog export is not offered.
Methodology
- Denominator is independent_catalog_products rows with publicationState = 'published'.
- MPN present means length(trim(manufacturerPartNumber)) > 0 on the product row.
- NSN present means at least one independent_catalog_identifiers row with kind = 'nsn' joined to that published product.
- Distinct NSN count is COUNT(DISTINCT searchValue) over those published NSN identifier rows with non-empty searchValue.
- Both means the published product has a non-empty MPN and at least one NSN identifier.
- Percentages are rounded to one decimal place: round(1000 * part / total) / 10.
- Counts are existence aggregates only — no identifier values, titles, or private evidence are published in this report.
Limitations
- This is PartsPerk’s published catalog only — not FAA, DLA, OEM, or industry-wide coverage.
- An NSN or MPN on a catalog row does not imply stock, authorization, interchange, airworthiness, or price.
- Identifier quality (format validity, supersession, alternate mapping) is out of scope for these existence counts.
- When DATABASE_URL is unavailable at render time, the page states aggregates unavailable rather than inventing figures.
- Row-level CSV/JSON export of catalog identities is not offered (licensing / privacy); only aggregate JSON is downloadable.
Provenance
- Tables: independent_catalog_products, independent_catalog_identifiers
- Publication filter: publicationState = 'published'
- Loader: loadNsnMpnCoverageAggregates() in aviation-intelligence-os.ts
- Public path: /market-intelligence/nsn-mpn-coverage
- Aggregate JSON: /api/public/market-intelligence/nsn-mpn-coverage