NPN Lookup is where you resolve a batch of National Producer Numbers (NPNs) against NIPR in one pass, so you can answer "who are these producers and where are they licensed" without opening each NPN by hand. It is built for the moments when you have a spreadsheet, a list pasted from an email, or a PDF appointment letter, and you need clean producer data fast.

NPN Lookup is a self-service tool that takes a list of NPNs, queries NIPR for each one, and returns a consolidated view of the producer's name, entity type, FEIN (for firms), date of birth (for individuals), and resident license states.

Who uses it. Licensing managers, compliance analysts, and onboarding teams at a carrier or MGA. Reach for it when you need to verify producer identity in bulk: vetting a downstream agency's roster, validating a producer list before sending appointment paperwork, or reconciling an inherited dataset of names and NPNs against NIPR.

With NPN Lookup you can:

From the Upstream Entity app, open Left sidebar → Tools → NPN Lookup. The breadcrumb at the top of the page reads Tools / NPN Lookup, and the page opens to the input card with two tabs.

NPN Lookup is part of the Tools feature set. If you do not see Tools in the left sidebar, your organization may not have the Tools feature enabled. Contact your account owner or Turris support to turn it on.

What's visible on the page:

There is no open-row action on this page. The page is single-purpose: you submit input, watch progress, then read or export the results.

When you'd do this. You have one or more NPNs (in a file, a chat message, or a pasted list) and you want NIPR's record for each one without querying them individually.

The flow has up to four steps depending on the input method. File uploads add a Review Extracted NPNs step before the lookup runs. Manual entry skips review and goes straight to processing.

When you'd do this. You already have the NPNs in a document and would rather not retype them. A CSV from your producer system, a PDF appointment letter from a market, or an Excel roster from a downstream agency are all valid inputs.

Supported file requirements:

Note: If the extension is not accepted or the file exceeds 10 MB, the validation banner appears and the file is rejected before any upload happens. You stay on the input card and can pick a different file. The file type is also re-checked on the server, so an unsupported file never reaches the extractor.

When you'd do this. You have a short list of NPNs in hand, in a chat message, or copied from a webpage, and you want to skip the file step entirely.

Input rules:

Tip: You can paste a whole list at once. When you paste text containing commas or spaces, Turris splits it and adds each numeric value as its own tag. Duplicate NPNs are ignored automatically, and once you reach 500 tags the input stops accepting more and shows "Maximum of 500 NPNs reached."

When you'd do this. Right after a file upload finishes extracting. This is your chance to remove stray numbers the extractor caught (employee IDs, ZIP codes, phone fragments) and add NPNs the file did not contain.

The Review Extracted NPNs panel shows every NPN found, with a count line that reads "N NPNs found". If extraction returned more than 500, you also see "(capped at 500)" in amber next to the count.

From this panel you can:

Tip: Trim the list before running the lookup. Extraction is intentionally permissive (it accepts plain numeric sequences) so a file with phone numbers or ZIP codes can produce false-positive NPNs. Cleaning the list now saves you from reading "Not Found" rows later.

Once the lookup starts, the input card is replaced with a progress card showing:

Results begin appearing in a table below as soon as the first NIPR batch returns. You do not have to wait for the entire batch to finish before reading partial results.

When at least one result has arrived, the page shows a summary card row, a result table, and an export button.

The four cards above the table show counts by outcome and double as filters. Click a card to filter the table to that entity type; click it again to clear it. Selecting all four behaves the same as clearing the filter.

The table supports column sorting on Name and Type, and substring search across Name and ID. Pagination appears automatically when the result count exceeds 10 rows.

Click Export CSV above the table to download every result row. The CSV always reflects the full result set; active summary-card filters do not narrow the export. The file columns are NPN, Type, Name, Resident States (semicolon-separated), FEIN, Date of Birth, and Error. The filename is npn-lookup-results-YYYY-MM-DD.csv.

After processing completes, a New Lookup button appears at the bottom right of the results. Click it to reset the page, clear the current job, and return to the input card for the next batch.

Filtering and search are scoped to the active result set. There is no cross-session filtering, because results live only for the duration of the job.

The table's search box (shown once results exceed 10 rows) matches against the Name and ID columns. The ID column matches the NPN and, for firms, the FEIN. Partial substrings work: typing 412 against an NPN of 412116993 returns that row.

The Type column and the summary cards share the same color scheme, so a row's outcome is scannable at a glance.

If the lookup fails wholesale (the job times out, NIPR is unreachable, or the file extractor crashed), a red banner appears at the top of the page with the error message and the input card is restored so you can correct and retry. Note that returning to the input card resets it to the default Upload File tab.

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 during the review step and the count line shows "(capped at 500)" so you know which NPNs the lookup will skip.

What file types are supported for upload? CSV (.csv), text (.txt), Excel (.xls, .xlsx), and PDF (.pdf). The maximum file size is 10 MB. Files outside these limits are rejected before the upload completes.

How does Turris extract NPNs from my file? Turris scans the file for numeric sequences that look like NPNs. For CSVs and spreadsheets, the cell values are inspected; for PDFs, the text content is read. The extraction is intentionally permissive, so the Review Extracted NPNs step gives you a chance to remove false positives like ZIP codes or employee IDs.

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 is a firm, the resident license states, 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. Common causes: 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 a NIPR-side error, a request timeout, or a transient network issue. Re-running the failed NPNs in a new session usually clears them.

Are results saved between sessions? No. NPN Lookup is single-session by design. Results are kept for 30 minutes in the active job and are not stored against any agent, agency, or policy record in your organization. Export the CSV before navigating away if you need a copy.

Can I export only the filtered rows? No. Export CSV always downloads the full result set, regardless of which summary-card filter is active. To produce a filtered CSV, open the file in your spreadsheet tool and filter there.

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

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