UCC Lien Filings: New UCC-1s, Lapsing & Lien Check (CO, CT, OR)

Get new UCC-1 financing statements every day, a "lapsing soon" list of active UCC liens about to expire, and a bulk UCC lien search by company name, straight from the official Colorado, Connecticut and Oregon filing-office open data. Every filing comes back in one normalized schema (JSON, CSV, Excel): filing number, type, filing and lapse dates, status, business debtor, secured party (lender) and, for Colorado, the collateral description.

Last verified: 2026-10-16 (daily automated self-test against the live state sources).

Tested accuracy (Oct 17, 2026, live build)

Active lien counts	Matched the official CO and CT records for 6 of 6 lien debtors (e.g. 19 of 19 active filings for a brewer with 58 filings on record)
Expired or closed liens	Not counted: with Active filings only (the default) lapsed, terminated and released filings are excluded
Amendments	Not double-counted: amendments and continuations are attached to the original filing (one company with 30 state rows = 9 active liens)
Exact-match-only billing	51 charged filings = the 51 exact-name filings returned; 21 similar-name filings returned free (charged: false). A run with a spend limit stopped cleanly at the limit
Rows	One row per input: companies with no filings get a NO_FILINGS_FOUND row
Speed	~4.8 s per company in a lien check of 20 companies
Billing	Free when a source fails: SEARCH_FAILED, and NO_FILINGS_FOUND when any state failed, are not charged

What to check in any KYB or lien tool

1. Expired liens counted as active: a UCC filing lapses after 5 years unless continued, and can be terminated earlier. "Active" should mean not terminated and not lapsed.
2. Amendments double-counted: amendments and continuations are separate rows in state data; they belong to the original lien, not on top of it.
3. Wrong-company matches: short and common names ("M & C Concrete", "Star Group") easily match another company. Look for a match score, the matched legal name, and similar names kept apart.
4. Charged for failed rows: check whether you pay when a state source fails or nothing is found. Every input should get a row that says found, not found or failed.

Built for teams that run it on a schedule and feed the results into a CRM, a credit workflow or a data pipeline.

Who it's for

• Equipment finance, commercial lenders, MCA and factoring companies: see which businesses just financed equipment or pledged receivables, who their lender is, and which liens lapse soon (refinance and renewal windows).
• Credit, underwriting and collections teams: check a list of customers or borrowers for existing UCC liens (blanket liens, competing lenders, recent new debt) before you extend credit or file your own UCC-1.
• KYB, due-diligence and M&A teams: a lien check alongside the company registry check, with a link to the official record for every row.
• B2B sales and lead-generation teams selling to businesses that are actively investing: new equipment loans and leases are a buying signal for services such as payroll, fleet, IT, accounting and equipment maintenance.

Why this Actor

• Three jobs in one Actor: new-filings feed, lapsing-soon list, and lien check by company name.
• Made for schedules: Only new since last run returns each filing once across daily or weekly runs, including filings the state publishes late.
• Official state open-data APIs only: no scraping, no logins, no proxies, no CAPTCHAs. Each row links to the official record.
• Business debtors only, ordinary UCC financing statements only: tax liens, judgment, hospital, labor, municipal, child-support/statutory liens, fixture filings and manufactured-home filings are left out by design, and so are individual (person) debtors. See Privacy.
• Pay per filing, no start fee, and NO_FILINGS_FOUND answers in lien checks cost less than a filing.
• Exact-match billing in lien checks: you pay only for filings under your company's exact name (after normalizing punctuation, spacing and word order; Inc = Corp = Co and LLC = L.L.C. count as the same). A filing under the same words with a conflicting legal form ("Star Group LP" for "Star Group LLC"; LLC vs LP vs Inc/Corp vs LLP) is a similar name: free, flagged and not counted. Similar-name filings (a typo, or extra words such as "Gold Star Trucking Group" for "Star Group") are returned free with name_match: SIMILAR_NAME and charged: false, and are never counted.
• Agent-ready: plain, machine-readable input descriptions, so it works as a tool through the Apify MCP server and API.

Why choose this Actor

Reliability	20 of 20 runs succeeded since launch (Oct 16, 2026); 107 sampled rows matched the state records field by field; timeouts, 429 and 5xx errors retried with exponential backoff (up to 5 attempts); if every portal is down you get a free SEARCH_FAILED row; any state that failed is listed in states_failed, and a NO_FILINGS_FOUND with a failed state is free
Jobs	New-filings feed, lapsing-soon list and lien check by company name in one Actor
Repeat use	Only new since last run returns each filing once across daily or weekly runs
Lender view	Secured party contains filter in every mode; Colorado collateral text included
Lapsing soon	Active financing statements expiring in the next N days (Colorado, Connecticut)
Batch lien checks	A list of companies in one run, newest filing first, plus a NO_FILINGS_FOUND row per clean company
Compliance	Business debtors and ordinary UCC financing statements only; no tax, judgment, hospital or individual records; no phones or emails
Price	$4.00 per 1,000 filings, $1.00 per 1,000 NO_FILINGS_FOUND answers, no start fee
Speed	One-company lien check across 3 states: about 5 s end to end by API, measured Oct 16, 2026

Quick start

New UCC-1 filings from the last 7 days (all three states):

{ "mode": "newFilings", "lastNDays": 7, "maxItems": 500 }

Daily scheduled feed (returns only filings you have not received yet):

{ "mode": "newFilings", "states": ["CO", "CT"], "lastNDays": 3, "onlyNewSinceLastRun": true, "maxItems": 2000 }

Only filings by certain lenders (e.g. equipment finance captives):

{ "mode": "newFilings", "lastNDays": 30, "securedPartyNames": ["John Deere", "Caterpillar", "Kubota"], "maxItems": 1000 }

UCC liens lapsing in the next 90 days (refinance / renewal list):

{ "mode": "lapsingSoon", "states": ["CO", "CT"], "lapsingWithinDays": 90, "maxItems": 1000 }

Lien check for a list of companies:

{ "mode": "lienCheck", "debtorNames": ["New Belgium Brewing", "Specialty Saw Inc", "Rickabaugh Construction"] }

Track payoffs and renewals (Colorado terminations and continuations):

{ "mode": "newFilings", "states": ["CO"], "lastNDays": 7, "filingTypes": ["TERMINATION", "CONTINUATION"], "maxItems": 1000 }

What you get (one row per filing)

Field	Description
state, filing_number, original_filing_number	Filing office, this record's number, and the original UCC-1 it belongs to
filing_type, filing_type_raw	INITIAL, AMENDMENT, CONTINUATION, ASSIGNMENT, TERMINATION, and the state's own label
lien_type	UCC, or UCC (agricultural) for Colorado farm-products financing statements
filing_date, lapse_date, days_until_lapse	When it was filed and when it expires (after any continuation)
status	ACTIVE, LAPSED, TERMINATED, RELEASED, or FILED (Oregon, see below)
debtor_name, debtor_city, debtor_state, debtor_zip	First business debtor as filed (street line only with Include debtor street line)
debtors, debtor_count	All business debtors on the filing
secured_party_name, secured_party_city, secured_party_state	First secured party: the lender or lessor, or its filing service ("... as Representative")
secured_parties, secured_party_count	All organization secured parties
collateral	Collateral text as filed (Colorado only), e.g. an equipment list or "all assets"
query, match_score, matched_debtor_name, result	Lien check only: your input, the match, or NO_FILINGS_FOUND / SEARCH_FAILED
name_match, charged	Lien check only: EXACT (score 95+, charged) or SIMILAR_NAME (85-94, incl. conflicting legal forms at 90; free, for review; up to 10 per company, not counted against Max items). NO_FILINGS_FOUND rows carry similar_name_filings = how many free similar-name rows follow
source_record_url, source_dataset_url, official_search_url	Official open-data record, dataset page and the state's own UCC search
retrieved_at	When the row was read

Sample row:

{
  "state": "CT", "filing_number": "0005415943", "filing_type": "INITIAL", "filing_date": "2026-10-15",
  "lapse_date": "2031-10-15", "status": "ACTIVE", "debtor_name": "SPECIALTY SAW INC.", "debtor_city": "Simsbury",
  "debtor_state": "CT", "secured_party_name": "OLD SECOND NATIONAL BANK",
  "source_record_url": "https://data.ct.gov/resource/xfev-8smz.json?id_ucc_flng_nbr=0005415943&..."
}

A run summary (RUN_SUMMARY in the key-value store) lists results per state, the newest filing date each state has published, how many records were excluded for privacy, and any errors.

Modes

newFilings: filings in a date window (Filed in the last N days, or Filed on or after / before), newest first. Default type is INITIAL (new UCC-1s); add UCC-3 types to track amendments, continuations, assignments and terminations. Debtor company names and Secured party contains work as keyword filters.

lapsingSoon: active original financing statements whose current lapse date falls between today and today + Lapsing within N days, soonest first (Colorado and Connecticut). A UCC-1 lapses five years after filing unless continued; a lapsing lien is often a loan that is ending or being refinanced.

lienCheck: each company in Debtor company names is searched in the full UCC index of each state (fuzzy name match: legal-form words, punctuation and "&" vs "and" are ignored; Minimum name match score 85 by default). You get one row per matching financing statement, newest first, or one NO_FILINGS_FOUND row. Active filings only is on by default.

Run it on a schedule

1. Save your input as a task (e.g. "CO+CT new UCC-1s, daily").
2. Turn on Only new since last run and use a window a bit longer than the schedule (e.g. lastNDays: 3 for a daily run) so late-published filings are still caught; already-returned filings are skipped.
3. Add a schedule in Apify Console (Schedules > Create) for the task, e.g. every weekday at 7:00.
4. Deliver the results:
   • Webhooks: add a webhook on the task for ACTOR.RUN.SUCCEEDED and point it at your endpoint (or Zapier / Make / n8n); fetch rows from resource.defaultDatasetId.
   • Integrations: Apify's built-in Google Sheets, Slack, email, Airbyte and Zapier / Make integrations work with the dataset as is.
   • API: GET https://api.apify.com/v2/actor-tasks/<TASK_ID>/runs/last/dataset/items?format=csv&status=SUCCEEDED.
5. Set Max cost per run (maxTotalChargeUsd) on the task if you want a hard spending cap; the run stops cleanly at the cap and only saved rows are charged.

The seen-filings memory lives in a named key-value store on your own account (ucc-lien-filings-state). Delete that store to start fresh.

Oregon cadence: Oregon publishes one list per month (the previous month's new filings, around the 1st). Schedule Oregon monthly, or use lastNDays: 45.

Coverage and freshness

State	Source (official open data)	Updated	Notes
Colorado	Colorado Department of State UCC filings, debtors, secured parties and collateral (data.colorado.gov wffy-3uut, 8upq-58vz, ap62-sav4, 4am6-w6u4)	Daily	Full history; collateral text included; status from termination records and lapse date
Connecticut	Office of the Secretary of the State, UCC Lien Filings (data.ct.gov xfev-8smz)	Daily	Active liens plus those lapsed less than 1 year; recent UCC-3 records (continuations, terminations) are published as AMENDMENT
Oregon	Secretary of State, UCC List of Filings Entered Last Month (data.oregon.gov snfi-f79b)	Monthly	Previous month only, initial filings and amendments; status shown as FILED because later changes are not published; no lapsing-soon list

Volume (Sep 16 to Oct 15, 2026): about 2,200 Connecticut and 4,400 Colorado new UCC-1s a month, and 2,200 in Oregon's monthly list, before the business-debtor filter.

Privacy and what is excluded

This Actor returns business-to-business secured-transaction records only:

• Only UCC financing statements (and their amendments). Not returned: federal and state tax liens, judgment liens, hospital liens, child-support and other statutory liens, labor and municipal liens, utility and public-finance filings, vessel and aircraft liens, effective financing statements (farm products), fixture filings and manufactured-home filings.
• Only organization debtors and secured parties. Individual debtors, sole proprietors filed under a person's name, personal and family trusts, estates and self-filed "sovereign" filings are excluded. Filings with only individual debtors, or with only an individual as secured party, are skipped entirely. Person-name columns are never downloaded.
• No phone numbers or emails, and no contact enrichment. Debtor street lines are off by default.
• The person filter works on the name text the state publishes; a small number of business names that look like a person's name are skipped too.

Use the data lawfully. If you contact businesses from this list, follow the rules that apply to you (for example CAN-SPAM and TCPA in the US).

Pricing

Pay per event, no start fee:

Event	No discount	Bronze	Silver	Gold+
Filing row (per 1,000); in lien checks only filings under the exact company name	$4.00	$3.72	$3.48	$3.20
Lien check, similar-name filing (name_match: SIMILAR_NAME)	free
Lien check, NO_FILINGS_FOUND (per 1,000 companies)	$1.00	$0.93	$0.87	$0.80
NO_FILINGS_FOUND while any searched state portal failed (states_failed not empty)	free
SEARCH_FAILED (every searched state portal was down)	free

Example: Colorado + Connecticut produced 648 business-debtor UCC-1s in 7 days (Oct 9-16, 2026), so a daily feed of both states costs about $0.37 per day. Set Max results or a run spend limit (Max cost per run) to cap a run; the run stops cleanly at the limit and only saved rows are charged.

Filters (Secured party contains, Debtor company names in feed mode) are applied after download, so narrow filters over long windows take longer, but you are only charged for rows returned.

Use it from your app (one company per call)

curl -X POST "https://api.apify.com/v2/acts/cpt_engineering~ucc-lien-filings/run-sync-get-dataset-items?token=<YOUR_APIFY_TOKEN>" \
  -H "Content-Type: application/json" \
  -d '{"mode": "lienCheck", "debtorNames": ["Specialty Saw Inc"]}'

Related Actors (same publisher)

• Company Due Diligence Check: registry status, UCC liens, OFAC sanctions and SAM.gov exclusions screens for a company in one row, with risk flags.
• US Company Lookup & KYB Verification: check that each debtor is a registered company in good standing (CO, CT, NY, OR, PA, TX) before or after a lien check.
• US New Business Registrations: daily list of newly formed companies in six states.

FAQ

Is this a certified UCC search? No. It is built from the states' open data, which can lag the filing office by a day or more. For a certified search (e.g. for closing a loan), use the state's official search page linked in each row.

Why are some filings missing compared to the state's own search? Filings with only individual debtors, non-UCC liens and the other excluded types are left out by design (see Privacy). Connecticut's open data also drops liens more than one year past lapse.

Which secured party is "Corporation Service Company, as Representative"? Filing services (CSC, Middesk, TAH Services, ...) often file on behalf of the real lender. The collateral text (Colorado) or the official record usually names the lender.

Can I search by lender? Yes: Secured party contains works in every mode, e.g. all new John Deere filings in the last 30 days.

Support

Open an issue on this Actor or email cpt-datatools@mail.grokbot.com. We reply to issues and support emails within 1 business day.

Changelog

• Oct 17, 2026 (afternoon): lien checks treat conflicting legal forms (LLC vs LP vs Inc/Corp vs LLP, when both names have one) as SIMILAR_NAME: free, flagged, not counted. Equivalent forms (Inc / Incorporated / Corp / Corporation / Co; LLC / L.L.C. / Limited Liability Company) still match exactly.
• Oct 17, 2026 (midday): added the Tested accuracy results (20-company test on the live build) and a buyer's checklist.
• Oct 17, 2026: exact-match billing in lien checks: only filings under the company's exact (normalized) name are charged and counted; similar-name filings are returned free with name_match: SIMILAR_NAME.
• Oct 17, 2026: lien check: short names such as "M & C Concrete LLC" now run an extra 'starts with' search so their own filings can't be cut off, and a more generic debtor name ("The Concrete Company") no longer matches a more specific company.
• Oct 16, 2026 (night): NO_FILINGS_FOUND is now free when any searched state portal failed (listed in states_failed); daily automated self-test with source schema-change detection; Last verified line; support response promise.
• Oct 16, 2026 (midday): NO_FILINGS_FOUND answers priced at $1.00 per 1,000 (tiers $0.93 / $0.87 / $0.80); run summary now reports companies_cut_by_limit separately when a spend limit stops a run.
• Oct 16, 2026: launched: CO, CT, OR; new-filings feed, lapsing soon, lien check, Only new since last run.

Source data disclaimer

The data made available here has been modified for use from its original source, which is the State of Colorado. THE STATE OF COLORADO MAKES NO REPRESENTATIONS OR WARRANTY AS TO THE COMPLETENESS, ACCURACY, TIMELINESS, OR CONTENT OF ANY DATA MADE AVAILABLE THROUGH THIS SITE. THE STATE OF COLORADO EXPRESSLY DISCLAIMS ALL WARRANTIES, WHETHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF MERCHANTABILITY, OR FITNESS FOR A PARTICULAR PURPOSE. The data is subject to change as modifications and updates are complete. It is understood that the information contained in the Web feed is being used at one's own risk.

Connecticut data: Connecticut Office of the Secretary of the State, via data.ct.gov. Oregon data: Oregon Secretary of State, via data.oregon.gov. Both are provided "as is", without warranty of accuracy, completeness or timeliness. This Actor is not affiliated with or endorsed by any state.