Schedule B density in the PartsPerk published catalog

Sample size (live DB aggregates)

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

• Published identities: 50,832
• With Schedule B attribute: 40,763 (80.2%)
• Distinct Schedule B keys: 1,209
• Singleton keys (1 product): 506
• Small (2–9 products): 430
• Medium (10–99 products): 214
• Large (≥100 products): 59
• Max products per Schedule B key: 4,753
• Average products per Schedule B key: 33.7
• Top-10 Schedule B product share: 20,890 (41.1%)
• Top-50 Schedule B product share: 30,826 (60.6%)

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

Methodology

1. Denominator is independent_catalog_products rows with publicationState = 'published'.
2. Schedule B present means at least one independent_catalog_attributes row with label = 'Schedule B (source assertion only)' and non-empty trim(value) joined to that published product.
3. Distinct Schedule B keys are COUNT(DISTINCT lower(trim(value))) over published products with a non-empty Schedule B attribute (one key per product via MIN of lower(trim(value)) when multiple attribute rows exist).
4. Density buckets group those distinct Schedule B keys by published product count: singleton (=1), small (2–9), medium (10–99), large (≥100).
5. Top-10 / top-50 Schedule B product shares sum product counts for the largest keys by count (Schedule B codes/values are not published in this report).
6. Average products per Schedule B key is round(avg(count) * 10) / 10 over the distinct-key groups.
7. Percentages are rounded to one decimal place: round(1000 * part / total) / 10.
8. Counts are existence and concentration aggregates only — no Schedule B codes, titles, or private evidence are published in this report.

Limitations

• This is PartsPerk’s published catalog Schedule B attributes only — not a Census Bureau, CBP, FAA, DLA, or industry-wide Harmonized System census.
• A Schedule B attribute on a catalog row does not imply stock, authorization, interchange, airworthiness, export clearance, duty rate, or price.
• Schedule B string quality (canonicalization beyond lower(trim), multi-value rows, source assertion accuracy) 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 Schedule B code rosters is not offered (licensing / privacy); only aggregate JSON is downloadable.

Provenance

• Tables: independent_catalog_products, independent_catalog_attributes
• Publication filter: publicationState = 'published'
• Attribute filter: label = 'Schedule B (source assertion only)' AND length(trim(value)) > 0
• Loader: loadScheduleBDensityAggregates() in aviation-intelligence-os.ts
• Public path: /market-intelligence/schedule-b-density
• Aggregate JSON: /api/public/market-intelligence/schedule-b-density