Manufacturer density in the PartsPerk published catalog

Sample size (live DB aggregates)

Captured 2026-11-14T20:32:08.315Z · source live_db_published_scope

• Published identities: 50,832
• With manufacturer name: 50,832 (100%)
• Distinct manufacturers: 641
• Singleton manufacturers (1 product): 182
• Small (2–9 products): 242
• Medium (10–99 products): 165
• Large (≥100 products): 52
• Max products per manufacturer: 7,789
• Average products per manufacturer: 79.3
• Top-10 manufacturer product share: 30,743 (60.5%)
• Top-50 manufacturer product share: 43,910 (86.4%)

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

Methodology

1. Denominator is independent_catalog_products rows with publicationState = 'published'.
2. Manufacturer present means length(trim(COALESCE(manufacturerName, ''))) > 0 on the product row.
3. Distinct manufacturers are COUNT(DISTINCT lower(trim(manufacturerName))) over published rows with a non-empty manufacturer name.
4. Density buckets group those distinct manufacturers by published product count: singleton (=1), small (2–9), medium (10–99), large (≥100).
5. Top-10 / top-50 manufacturer product shares sum product counts for the largest manufacturers by count (names are not published in this report).
6. Average products per manufacturer is round(avg(count) * 10) / 10 over the distinct-manufacturer groups.
7. Percentages are rounded to one decimal place: round(1000 * part / total) / 10.
8. Counts are existence and concentration aggregates only — no manufacturer names, titles, or private evidence are published in this report.

Limitations

• This is PartsPerk’s published catalog only — not FAA, DLA, OEM directories, or industry-wide manufacturer coverage.
• A manufacturer name on a catalog row does not imply authorization, OEM affiliation, stock, interchange, airworthiness, or price.
• Manufacturer string quality (canonicalization beyond lower(trim), mergers, DBA aliases) is out of scope for 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 manufacturer rosters is not offered (licensing / privacy); only aggregate JSON is downloadable.

Provenance

• Table: independent_catalog_products
• Publication filter: publicationState = 'published'
• Loader: loadManufacturerDensityAggregates() in aviation-intelligence-os.ts
• Public path: /market-intelligence/manufacturer-density
• Aggregate JSON: /api/public/market-intelligence/manufacturer-density