Wisconsin Insurance License Lookup (NAIC SBS)

Verify insurance producer licenses in Wisconsin using the NAIC State Based Systems public API. Returns name, NPN, license type, lines of authority, status, and expiration date. No proxy required — this actor calls a government JSON endpoint directly.

Part of a 25-state portfolio. Separate actors exist for every NAIC SBS state (IA, NC, NJ, MO, TN, WI, CT, and more) so you can track usage and runs per state independently.

---

⚠️ Important: use NPN lookup, not name search

The NAIC SBS API returns at most 25 results per query — a hard server-side limit with no pagination. Searching by last name for a common surname ("Smith", "Johnson") will silently truncate at 25 results.

The right workflow for compliance verification:

1. Export your producer list from your AMS as a CSV
2. Copy the NPN column
3. Paste NPNs into the NPN List field (one per line)
4. Run — you get back exactly one record per NPN, no truncation risk

Name search is best for one-off spot checks on a specific person, not bulk verification.

---

Input

NPN List (recommended for bulk runs)

Paste one National Producer Number per line in the NPN List field. NPNs are 6–10 digit numbers — find them on a producer's license certificate, on NIPR.com, or in a previous license verification report.

1234567
9876543
5551234

Each NPN is looked up independently. Results are deduplicated automatically.

Run time and cost: 100 NPNs ≈ 60 seconds, ~$0.50. 500 NPNs ≈ 5 minutes, ~$2.50.

Not found / inactive:

• If an NPN has no license on record in this state, the actor writes a record with "status": "NOT FOUND" and "is_active": false.
• If an NPN has records but all are expired or terminated (and Active Licenses Only is on), the actor writes "status": "NO ACTIVE LICENSE" and "is_active": false.

Both sentinel records include every output field (nulls/empty arrays for unresolvable fields) so your spreadsheet or AMS ingestion doesn't get column-count mismatches.

Single name lookup

Fill in Last Name (and optionally First Name) for a one-off search. Remember the 25-result cap applies here.

Other options

Field	Default	Description
Active Licenses Only	On	Excludes expired, inactive, and terminated licenses. Turn off if you need a full history.
Entity Type	Individual	Switch to Business/Agency for agency lookups
State	WI	Pre-filled — only change if searching a different SBS state

---

Output

Each row in the Dataset is one license record. Key fields:

Field	Example	Notes
npn	"1234567"	National Producer Number — use this to cross-reference across states
license_number	"1234567"	State license number (often same as NPN on SBS states)
name	"Mary Ann Johnson"	Title-cased, First Last order
first_name	"Mary"	First word of given name only
middle_name	"Ann"	Middle name/initial if present; null otherwise
last_name	"Johnson"	Surname
license_type	"Insurance Producer"	License class. Common values: Insurance Producer, Staff Adjuster
license_type_code	"PRO"	Short code for license class. Known values: PRO (Insurance Producer), SAJ (Staff Adjuster)
status	"Active"	Active, Expired, Inactive, Terminated, Surrendered, Revoked, NOT FOUND, or NO ACTIVE LICENSE
is_active	true	Boolean — use this for quick filtering in your downstream system
lines_of_authority	["Life (effective 2010-06-01)"]	Array of LOAs with effective dates
effective_date	"2010-06-01"	Date this license version became effective
expiration_date	"2027-05-31"	License expiration date
residency	"Resident"	Resident or Non-Resident
business_phone	"312-555-0100"	Formatted as XXX-XXX-XXXX
address_city	"Chicago"	Title-cased city
address_state	"IL"	Producer's home state (may differ from search jurisdiction for non-residents)
designated_home_state	null	Always null on NAIC SBS states; reserved for compact/non-resident workflows

Example record

{
    "npn": "1234567",
    "license_number": "1234567",
    "jurisdiction": "WI",
    "licensee_type": "Individual",
    "name": "Mary Ann Johnson",
    "first_name": "Mary",
    "middle_name": "Ann",
    "last_name": "Johnson",
    "dba_name": null,
    "fein": null,
    "license_type_code": "PRO",
    "license_type": "Insurance Producer",
    "lines_of_authority": [
        "Life (effective 2010-06-01)",
        "Accident and Health (effective 2010-06-01)"
    ],
    "status": "Active",
    "is_active": true,
    "residency": "Resident",
    "designated_home_state": null,
    "effective_date": "2010-06-01",
    "expiration_date": "2027-05-31",
    "business_phone": "312-555-0100",
    "address_city": "Chicago",
    "address_state": "WI",
    "address_raw": "CHICAGO, IL 60601",
    "source_url": "https://sbs.naic.org/solar-external-lookup/?jurisdiction=WI&searchType=Licensee",
    "scraped_at": "2026-05-25T12:00:00.000Z"
}

Exporting results

After a run completes, click the Export button in the Dataset tab to download your results as CSV or Excel. This works directly in the Apify Console — no additional tools needed.

---

Pricing

Pay-per-event at $0.005 per license record returned. Empty searches are never charged. A typical bulk run of 100 NPNs costs $0.50.

---

States in this portfolio

AL · AK · AR · CT · DC · ID · WI · IA · KS · MO · MT · NH · NJ · NM · NC · ND · OK · OR · RI · SD · TN · VT · WV · WI

---

Data source

NAIC State Based Systems External Lookup — public government data, no authentication required.