FSC × FSG coverage in the PartsPerk published catalog

Sample size (live DB aggregates)

Captured 2026-11-14T19:27:21.675Z · source live_db_published_scope

• Published identities: 50,832
• With NSN identifier: 10,464
• With derivable FSC (NSN digit prefix): 10,464 (20.6%)
• Distinct FSCs: 151
• Distinct FSGs: 51
• Singleton FSCs (1 product): 44
• Small FSCs (2–9 products): 50
• Medium FSCs (10–99 products): 36
• Large FSCs (≥100 products): 21
• Max products per FSC: 1,497
• Max products per FSG: 6,969
• Average products per FSC: 69.3
• Top-10 FSC product share: 7,406 (14.6%)
• Top-5 FSG product share: 9,141 (18%)

Download aggregate JSON (counts only) — FSC/FSG codes and row-level catalog export are not offered.

Methodology

1. Denominator is independent_catalog_products rows with publicationState = 'published'.
2. NSN present means at least one independent_catalog_identifiers row with kind = 'nsn' joined to that published product.
3. FSC is derived as the first 4 digits of regexp_replace(searchValue, non-digits, '') when that prefix matches ^[0-9]{4}$.
4. FSG is derived as the first 2 digits of the same digit string (Federal Supply Group).
5. Distinct FSC / FSG counts are COUNT(DISTINCT prefix) over published products with a derivable FSC.
6. Density buckets group distinct FSCs by published product count: singleton (=1), small (2–9), medium (10–99), large (≥100).
7. Top-10 FSC / top-5 FSG product shares sum product counts for the largest classes/groups by count (codes are not published in this report).
8. Average products per FSC is round(avg(count) * 10) / 10 over the distinct-FSC groups.
9. Percentages are rounded to one decimal place: round(1000 * part / total) / 10.
10. Counts are existence and concentration aggregates only — no FSC/FSG code values, NSN values, titles, or private evidence are published in this report.

Limitations

• This is PartsPerk’s published catalog only — not FAA, DLA FLIS, OEM, or industry-wide FSC/FSG coverage.
• An FSC or FSG derived from an NSN does not imply stock, authorization, interchange, airworthiness, or price.
• FSC/FSG are derived from NSN digit prefixes on owned-catalog identifier rows; dedicated kind='fsc' identifier rows are not required and are not used.
• 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 FSC/FSG code rosters is not offered (licensing / privacy); only aggregate JSON is downloadable.

Provenance

• Tables: independent_catalog_products, independent_catalog_identifiers
• Publication filter: publicationState = 'published'
• Derivation: FSC = left(digits(NSN searchValue), 4); FSG = left(digits(NSN searchValue), 2)
• Loader: loadFscFsgCoverageAggregates() in aviation-intelligence-os.ts
• Public path: /market-intelligence/fsc-fsg-coverage
• Aggregate JSON: /api/public/market-intelligence/fsc-fsg-coverage