US Tech Automations

Other dated records TTB appear / disappear list 843,025 rows held

What the alcohol permit feed covers, and what it does not

Every state and territory we hold, how many permits sit in each, and the date of the newest copy we sealed for it. Where the government's file stops, we say so instead of filling the gap.

Price
$99/mo
Built for
Beverage compliance and wholesaler ops
Read
About every week
Newest sealed read
2026-09-30

Subscribe — $99 a month$99 a month, billed monthly, for one state or territory you name — not the national file. You get every permit that appeared and every permit that stopped being listed between the copies we hold, with the permit number, the city, the state, the industry, and the business name where our copy holds one. Some rows have no business name in our copy. We print the gap rather than filling it in, because a permit number you can look up is worth more than a name we guessed. Cancel any month by email, with no account to close and no notice period.

Newest sealed read: 2026-09-30. We read this source about every 7 days. We hold 10 sealed runs going back to 2026-08-08. Collection has paused. We last read this source 15 days ago, and we read it about every 7 days, so no number on this page moves until collection starts again.

What this page is843,025 rows held · newest sealed read 2026-09-30

  • Between 23 Sep 2026 and 30 Sep 2026 we detected 214 changes in this list: 88 permits appeared for the first time, 36 permits were on the 23 Sep 2026 copy and gone from the 30 Sep 2026 one, and 86 permits sat on both copies with 90 fields that moved between them. 4 of those permits had more than one field move at once, which is why the 90 is the bigger number.
  • We hold 843,025 dated permit rows for this slice, across 10 sealed copies of the government's list dated 8 Aug 2026, 11 Aug 2026, 19 Aug 2026, 25 Aug 2026, 1 Sep 2026, 8 Sep 2026, 9 Sep 2026, 16 Sep 2026, 23 Sep 2026 and 30 Sep 2026. 84,518 permits sit on the newest one.
  • The collector's log holds 20 run records. 10 of those runs downloaded the file and sealed a copy. The rest either found nothing new or came back with nothing at all.
  • The feed covers 52 states and territories and 4 trades: Distilled Spirits Plant, Importer (Alcohol), Wholesaler (Alcohol) and Wine Producer.

Real rows out of our sealed copies

These are rows we read out of dated copies we keep ourselves. The live source shows today only, so once a row moves, what it said before is gone from the place you would go to look.

Every change between two sealed copies of the national list — 12 of 214 changes 23 Sep 2026 → 30 Sep 2026
PermitBusinessWhereWhat changed
AR-P-21142Whistle Stop CellarsPea Ridge, ARFirst listed 30 Sep 2026
AZ-W-21145Vultures Tears VineyardPearce, AZFirst listed 30 Sep 2026
CA-I-24424name not in our copySalinas, CAFirst listed 30 Sep 2026
CA-I-24425BOZZANO & CO.Morgan Hill, CAFirst listed 30 Sep 2026
CA-I-24426Harbor DistributingHuntington Beach, CAFirst listed 30 Sep 2026
CA-I-24427name not in our copyCarlsbad, CAFirst listed 30 Sep 2026
CA-I-24428Eulisses VargasSan Jose, CAFirst listed 30 Sep 2026
CA-P-27557AbloomCalistoga, CAFirst listed 30 Sep 2026
CA-P-27558name not in our copySalinas, CAFirst listed 30 Sep 2026
CA-P-27559name not in our copyCompton, CAFirst listed 30 Sep 2026
CA-P-27560La Infiel ImportsLong Beach, CAFirst listed 30 Sep 2026
CA-P-27561HAMMER VODKANewport Beach, CAFirst listed 30 Sep 2026
Every state and territory we hold — all 52 of them, counted on the 30 Sep 2026 copy 30 Sep 2026
State or territoryPermitsNewest sealed read
California21,03830 Sep 2026
Florida5,97130 Sep 2026
New York5,89530 Sep 2026
Texas5,18930 Sep 2026
Washington4,14030 Sep 2026
Oregon2,97630 Sep 2026
Pennsylvania2,45030 Sep 2026
Illinois2,34830 Sep 2026
Virginia2,03630 Sep 2026
North Carolina1,91930 Sep 2026
Michigan1,88430 Sep 2026
Colorado1,71730 Sep 2026
Ohio1,68030 Sep 2026
New Jersey1,62230 Sep 2026
Georgia1,51630 Sep 2026
Massachusetts1,32930 Sep 2026
South Carolina1,26730 Sep 2026
Iowa1,24230 Sep 2026
Maryland1,21130 Sep 2026
Missouri1,20430 Sep 2026
Kansas1,11530 Sep 2026
Wisconsin1,00030 Sep 2026
Arizona95730 Sep 2026
Connecticut95130 Sep 2026
Kentucky95130 Sep 2026
Puerto Rico86330 Sep 2026
Tennessee86130 Sep 2026
Nevada79430 Sep 2026
Minnesota77530 Sep 2026
Indiana68330 Sep 2026
Maine62530 Sep 2026
Mississippi55830 Sep 2026
New Mexico41830 Sep 2026
Louisiana40730 Sep 2026
Idaho40330 Sep 2026
Arkansas38330 Sep 2026
Washington DC36030 Sep 2026
Alabama35830 Sep 2026
Delaware35430 Sep 2026
Vermont35130 Sep 2026
Oklahoma31630 Sep 2026
West Virginia30230 Sep 2026
Hawaii29930 Sep 2026
Rhode Island29030 Sep 2026
Montana27230 Sep 2026
New Hampshire26330 Sep 2026
Utah21430 Sep 2026
Nebraska18630 Sep 2026
Wyoming17830 Sep 2026
Alaska16530 Sep 2026
North Dakota11630 Sep 2026
South Dakota11630 Sep 2026

What this page cannot tell you

  • 40,938 of the 84,518 permits on the newest copy have no trading name. The government's own file leaves that box empty, so we cannot fill it. Those rows carry the permit number and the town and say the name is missing, rather than showing an empty cell as though it were a name.
  • A permit dropping off means it was on one dated copy and not on the next one. That is all it means. It is not proof that TTB revoked the permit, and it is not proof that the business closed: the government's file carries no issue date, no expiry date and no status, so nobody reading it can tell you why a row left, and we will not guess. We sealed our first copy on 8 Aug 2026, so anything that moved before that date is not in what we hold.
  • Not in the government's file at all: American Samoa, Guam, Northern Mariana Islands and US Virgin Islands. It lists 4 trades and no others, so breweries and retailers are not in this feed. It carries no owner names, no street addresses and no phone numbers either, so neither do we.
  • A permit is placed in a state by the address on its own row. Only when a row has no address at all do we fall back to the state letters at the front of the permit number. Town and county names arrive from the government in capital letters. We print them in ordinary mixed case. Nothing else about a row is changed.
  • We have read this file 10 times: 8 Aug 2026, 11 Aug 2026, 19 Aug 2026, 25 Aug 2026, 1 Sep 2026, 8 Sep 2026, 9 Sep 2026, 16 Sep 2026, 23 Sep 2026 and 30 Sep 2026. That is not enough to know how often it changes, so the 7-day figure on this page is what we promise to send you, not a rhythm we measured. Everything above is one of those copies compared with another.

See the file before you pay

You do not have to take our word for what is in the file. Here are 25 rows of the real thing, carrying all 8 of its columns, cut out of the dated copies we sealed ourselves. Nothing in it is made up and nothing in it is tidied up.

  • Open the 25 rows as a CSVA plain spreadsheet file. It saves to your machine rather than painting itself into a browser tab, and it opens in Excel, Numbers or Google Sheets.
  • The same 25 rows as JSONThe same rows again, laid out for reading with code.

What arrives after you pay: Stripe sends you to the receipt page. After payment confirmation, your dated CSV for the state or territory selected at checkout appears there. Keep the receipt link for subsequent files. Nobody emails you. The subscriber CSV uses machine-readable column names and includes appeared, changed and gone rows, plus a coverage row naming the two source dates. The public preview uses shorter labels.

What you would be paying for: $99 a month, billed monthly, for one state or territory you name — not the national file. You get every permit that appeared and every permit that stopped being listed between the copies we hold, with the permit number, the city, the state, the industry, and the business name where our copy holds one. Some rows have no business name in our copy. We print the gap rather than filling it in, because a permit number you can look up is worth more than a name we guessed. Cancel any month by email, with no account to close and no notice period. At checkout, choose one state or territory in the required Which state field. After your active payment is confirmed, the receipt page shows a dated CSV for that state. New source comparisons add dated files when available. Missing or invalid state input remains unassigned; email operations@ustechautomations.com to correct it.

These 25 rows are a slice of the file, not the whole of it. What we cannot show you here is how far back it goes: that is the part you are paying for.

Subscribe to this feed

$99/mo · Dated source pairs

Subscribe — $99 a month

$99 a month, billed monthly, for one state or territory you name — not the national file. You get every permit that appeared and every permit that stopped being listed between the copies we hold, with the permit number, the city, the state, the industry, and the business name where our copy holds one. Some rows have no business name in our copy. We print the gap rather than filling it in, because a permit number you can look up is worth more than a name we guessed. Cancel any month by email, with no account to close and no notice period. At checkout, choose one state or territory in the required Which state field. After your active payment is confirmed, the receipt page shows a dated CSV for that state. New source comparisons add dated files when available. Missing or invalid state input remains unassigned; email operations@ustechautomations.com to correct it.

Rather ask first? Email operations@ustechautomations.com. Select the state or territory at checkout; the receipt page carries that selection and the dated state CSV. Email operations@ustechautomations.com to correct missing or invalid input.

More from this feed