NPN Lookup is where you resolve a batch of National Producer Numbers against NIPR in one pass, so you can confirm who each NPN belongs to, whether it's an individual or a firm, and where the entity holds a resident license, without checking each number by hand.

NPN Lookup takes a list of NPNs, queries NIPR's Producer Database in the background, and streams back a consolidated, filterable, exportable result set on the same screen.

Who uses it. Licensing coordinators, compliance analysts, and operations staff at agencies and TPAs reach for this when they have a list of producer numbers from a spreadsheet, a carrier file, or an onboarding application and need to verify who those producers are before onboarding them, paying commissions, or requesting appointments.

With NPN Lookup you can:

Left sidebar → Tools → NPN Lookup. The page opens directly to the input screen.

What's visible on the page:

Once a lookup finishes, the input panel is replaced by four summary cards and the results table. Click New Lookup below the results to return to this input screen.

When you'd do this. A carrier or MGA sent you a spreadsheet of producers they want appointed, or you exported a list from another system, and you want to verify each NPN before adding the producers to your roster.

Note: A file with an unsupported extension is rejected before extraction starts, with an inline error above the upload area: "Unsupported file type. Accepted: .csv, .xlsx, .xls, .pdf, .txt". A file over the size limit shows "File size exceeds the 10 MB limit."

Tip: For CSVs and spreadsheets, extraction inspects every cell; for PDFs, it reads the text content. You get a chance to remove false positives in the review step, so don't worry if your source file has extra columns or stray numbers.

When you'd do this. Immediately after a file finishes extracting. The Review Extracted NPNs panel shows a count ("123 NPNs found") and every extracted NPN as a removable tag. This review step appears only for file uploads; manual entry starts the lookup directly.

From this panel you can:

Tip: If the list exceeds 500, the panel shows "(capped at 500)" next to the count and only the first 500 are processed. Trim the list manually if you want to control which NPNs are kept.

When you'd do this. You have a short list of producer numbers, pasted from an email, jotted down from a call, or a handful you want to spot-check, and skipping the file step is faster than building a spreadsheet.

Note: You can paste a comma- or space-separated list (for example 1234567, 89456123 12345678) and each valid value is parsed into its own tag. Once 500 tags are reached, the input shows "Maximum of 500 NPNs reached." and stops accepting more.

While the lookup runs, a progress card replaces the input panel:

Results begin appearing in the table below as soon as the first batch returns from NIPR. You can read partial results, sort them, and search across them while the rest of the batch is still in flight.

When the lookup completes, the page shows four summary cards at the top, the results table below them, an Export CSV button in the top-right, and a New Lookup button below the table.

The four cards above the table show counts by outcome and double as clickable filter toggles:

Click any card to filter the table to just that outcome. Click it again to remove the filter. Activating all four at once is equivalent to clearing the filter, and every row shows.

The table's search box matches against Name and ID. Sorting is available on Name and Type. Pagination appears automatically when there are more than 10 rows.

Click Export CSV in the top-right of the page to download the full result set as a CSV file. Active summary-card filters do not affect the export, so every row from the lookup is included.

Click New Lookup below the results to clear the current results, drop any active summary-card filters, and return to the input screen.

The four summary cards are the only filter controls; each one toggles the table to a single outcome category.

The search box on the table matches the producer or firm name and the ID column (NPN and FEIN). Partial matches work, so typing Trav finds Travelers, and typing the last few digits of an NPN finds that row.

The Type column uses color-coded badges so each outcome is scannable at a glance. The same color scheme is reflected in the summary cards.

If the whole job fails (for example, NIPR is unreachable or the session times out), a red banner appears at the top of the page with the error message and the input screen is restored so you can retry.

How many NPNs can I look up at once? Each session supports up to 500 NPNs. If your file contains more, the list is capped at 500 in the review step. To process more than 500, run multiple sessions back-to-back.

What file types are supported for upload? CSV (.csv), text (.txt), Excel (.xls, .xlsx), and PDF (.pdf), up to 10 MB. Files outside this list are rejected with an inline error before extraction starts.

How does Turris extract NPNs from my file? Turris scans the file for numeric sequences that match the NPN format. For CSVs and spreadsheets, every cell is inspected; for PDFs, the text content is read. You can review and edit the extracted list before running the lookup.

What data does NPN Lookup return? For each NPN, Turris returns the producer or firm name, the entity type (Individual or Firm), the FEIN if it's a firm, the states where the entity holds a resident license, and the date of birth for individuals when NIPR provides it.

Why are some of my NPNs marked Not Found? "Not Found" means NIPR returned no record for that NPN. This usually points to a typo in the source data, a producer whose record is no longer active in PDB, or a number that was never issued. Verify each Not Found NPN against the original source before assuming it's invalid.

Why are some NPNs marked Error? "Error" means the NIPR request itself failed for that NPN, typically a NIPR-side error, a timeout, or a transient network issue. Errored NPNs can be retried in a new session and usually succeed on the second attempt.

Are results saved between sessions? No. NPN Lookup is a single-session tool. Results live only for the duration of the active job and are not stored against any agent, agency, or policy record in Turris. Export to CSV if you need to keep the data.

Can I export the results? Yes. The Export CSV button in the top-right downloads every result row. Filters applied to the on-screen table do not affect the export, so the full result set is included.

Does NPN Lookup change anything in my organization? No. NPN Lookup is read-only. It queries NIPR and renders the response. It does not create or modify any agents, agencies, licenses, or appointments in your account.

If you have questions about NPN Lookup or encounter any issues, contact our support team at support@turris.com.