NPN Lookup is where you resolve a batch of National Producer Numbers against NIPR's PDB in one session, so you can confirm who each NPN belongs to, what type of entity it is, and where it holds a resident license without looking producers up one at a time.

NPN Lookup is a self-service batch verifier. You hand it a file or a typed list of NPNs, and it returns the name, entity type, resident licensing footprint, and the FEIN (for firms) or date of birth (for individuals) for each one, in a table you can export to CSV.

Who uses it. Licensing managers, compliance analysts, and operations leads at carriers, MGAs, and other enterprise upstream organizations use NPN Lookup when they need to triage a list of producers quickly. Typical jobs to be done: vetting a new producer roster before onboarding, validating a downstream agency's submitted producer list, or sanity-checking NPNs pulled from a renewal spreadsheet.

NPN Lookup lets you:

The breadcrumb at the top of the page reads Tools → NPN Lookup. Click Tools in the breadcrumb at any time to return to the tool hub.

What's visible on the page. The page shows different panels depending on which step of the flow you are in:

When you'd do this. You already have the NPNs in a spreadsheet, exported list, or PDF (for example a producer roster from a downstream agency or a renewal report) and you do not want to type them in by hand.

The upload area accepts the following:

Note: If the file extension is not in the accepted list, the panel shows "Unsupported file type" with the full list of accepted extensions and does not start extraction. If the file is over 10 MB, it shows "File size exceeds the 10 MB limit."

When you'd do this. You have a small handful of NPNs (a dozen or fewer is typical) you want to verify on the spot, for example NPNs pasted from an email, taken from a phone call with a producer, or copied from a single line in a contract.

Tip: You can paste a comma- or space-separated list straight into the input box, and Turris splits it into individual tags automatically. Pasting 12345, 67890, 11111 adds three tags in one go.

When you'd do this. Only file uploads go through this step. Use it to inspect what Turris pulled out of your file before spending the time on the lookup itself, because extraction reads anything that looks like an NPN, including stray numbers in unrelated columns.

Note: If the extracted list exceeds 500 NPNs, the count shows "(capped at 500)" in amber text and only the first 500 are processed. Trim the list yourself if you need control over which 500 are run.

When you'd do this. As soon as you click Look Up N NPNs or Lookup N NPNs, this panel takes over the page. Use it to confirm the job is moving and to estimate how long it will take.

The progress card shows:

Results begin appearing in the table below the progress card as soon as the first batch returns from NIPR, so you do not need to wait for the whole batch to finish before scanning what is already in.

Tip: Lookup speed depends on NIPR response time. A session stays active for 30 minutes; if a job has not finished in that window the session expires and you will need to restart.

Once results begin arriving, two areas appear: the summary card row and the results table.

Summary cards. Four cards sit above the table, each showing a count for one outcome bucket. Clicking a card filters the table to that outcome; clicking it again removes the filter. Activating all four cards is treated the same as no filter (the page shows everything).

Results table. Each row is one NPN. The columns are:

Pagination appears automatically once the result set is more than 10 rows. If a filter leaves no matching rows, the table area reads "No results yet."

When you'd do this. You want to archive the lookup, share it with a teammate, or feed it into another tool such as a spreadsheet, your agency management system, or a downstream report. Results live only for the duration of the session, so export before you navigate away if you need a copy.

When you'd do this. You have finished reviewing one batch and want to run another against a different list of NPNs.

Note: New Lookup discards the in-memory results. If you have not exported the CSV yet, do so before clicking it.

Click a card again to remove its filter. Selecting all four cards is the same as selecting none.

The results table also has a search box that matches against the Name (typing part of a name finds it) and the ID (typing part of an NPN or FEIN finds it). Sort the table by clicking the Name or Type column headers.

The Type column uses a color-coded badge so outcomes are easy to scan, and the summary cards above the table use the same colors. Job-level failures appear as a red banner at the top of the page.

How many NPNs can I look up at once? Each session supports up to 500 NPNs. If your file contains more, only the first 500 are processed after the review step.

What file types are supported for upload? CSV (.csv), text (.txt), Excel (.xls, .xlsx), and PDF (.pdf). The maximum file size is 10 MB.

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

What data does NPN Lookup return? For each NPN: the producer or firm name, the entity type (Individual or Firm), the FEIN for firms, the resident license states, and the date of birth for individuals when NIPR provides it.

Why are some of my NPNs marked Not Found? A Not Found result means NIPR returned no record for that NPN. The most common causes are a typo in the source data, a producer whose record is no longer active in PDB, or a number that was never issued.

Why are some NPNs marked Error? Error means the lookup itself failed for that NPN, typically because of a NIPR-side error, a timeout, or a transient network issue. You can re-run errored NPNs in a new session.

Are results saved between sessions? No. NPN Lookup is a single-session tool. Results are kept for 30 minutes in 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 above the results downloads every result row. Filters applied with the summary cards do not narrow the CSV; the export always contains the complete result set.

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

Can I look up an NPN from a US territory like Puerto Rico or Guam? Yes. Resident states in the results include the US states and territories that NIPR returns (for example, PR, GU, VI). If the producer holds a resident license in a territory, it appears in the Resident States column.

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