Category density in the PartsPerk published catalog

Sample size (live DB aggregates)

Captured 2026-11-12T00:25:10.587Z · source live_db_published_scope

• Published identities: 50,832
• With category membership: 50,832 (100%)
• Distinct categories with memberships: 288
• Taxonomy nodes total: 297
• Singleton categories (1 product): 28
• Small (2–9 products): 85
• Medium (10–99 products): 103
• Large (≥100 products): 72
• Max products per category: 8,498
• Average products per category: 176.5
• Top-10 category product share: 27,834 (54.8%)
• Top-50 category product share: 44,172 (86.9%)
• Categories at depth 0 / 1 / 2 / ≥3: 5 / 112 / 152 / 19
• Memberships at depth 0 / 1 / 2 / ≥3: 6,698 / 10,163 / 32,587 / 1,385

Download aggregate JSON (counts only) — category names/slugs and row-level catalog export are not offered.

Methodology

1. Denominator is independent_catalog_products rows with publicationState = 'published'.
2. Category present means at least one independent_catalog_memberships row joined to that published product.
3. Distinct categories are COUNT(DISTINCT categoryId) over memberships of published products.
4. categoryNodesTotal is the count of independent_catalog_categories rows (taxonomy nodes), including nodes with zero published memberships.
5. Density buckets group distinct categories-with-memberships by published product count: singleton (=1), small (2–9), medium (10–99), large (≥100).
6. Top-10 / top-50 category product shares sum published product counts for the largest categories by count (names/slugs are not published in this report).
7. Depth counts group those distinct categories by independent_catalog_categories.depth (0, 1, 2, and ≥3); membershipsAtDepth* sum product memberships for categories at that depth.
8. Average products per category is round(avg(count) * 10) / 10 over the distinct-category-with-membership groups.
9. Percentages are rounded to one decimal place: round(1000 * part / total) / 10.
10. Counts are existence and concentration aggregates only — no category names, slugs, titles, or private evidence are published in this report.

Limitations

• This is PartsPerk’s published catalog taxonomy only — not FAA, ATA, OEM, or industry-wide classification coverage.
• A category membership on a catalog row does not imply stock, authorization, interchange, airworthiness, or price.
• Taxonomy quality (slug canonicalization, multi-membership products, orphan nodes) is out of scope beyond these density 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 or category rosters is not offered (licensing / privacy); only aggregate JSON is downloadable.

Provenance

• Tables: independent_catalog_products, independent_catalog_memberships, independent_catalog_categories
• Publication filter: publicationState = 'published'
• Loader: loadCategoryDensityAggregates() in aviation-intelligence-os.ts
• Public path: /market-intelligence/category-density
• Aggregate JSON: /api/public/market-intelligence/category-density