US Tech Automations

Other dated records TTB appear / disappear list 336,582 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-08-25

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. Often it does not: across the dated copies we hold today, about half the appear and disappear rows carry no business name. 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-08-25. We read this source about every 7 days. We hold 4 sealed runs going back to 2026-08-08.

What this page is336,582 rows held · newest sealed read 2026-08-25

  • Between 19 Aug 2026 and 25 Aug 2026 we detected 219 changes in this list: 105 permits appeared for the first time, 15 permits were on the 19 Aug 2026 copy and gone from the 25 Aug 2026 one, and 93 permits sat on both copies with 99 fields that moved between them. 6 of those permits had more than one field move at once, which is why the 99 is the bigger number.
  • We hold 336,582 dated permit rows for this slice, across 4 sealed copies of the government's list dated 8 Aug 2026, 11 Aug 2026, 19 Aug 2026 and 25 Aug 2026. 84,273 permits sit on the newest one.
  • The collector's log holds 12 run records. 4 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 219 changes 19 Aug 2026 → 25 Aug 2026
PermitBusinessWhereWhat changed
AK-I-21014Columbia DistributingFairbanks, AKFirst listed 25 Aug 2026
AK-I-21015Columbia DistributingJuneau, AKFirst listed 25 Aug 2026
AK-P-21042Columbia DistributingFairbanks, AKFirst listed 25 Aug 2026
AK-P-21043Columbia DistributingJuneau, AKFirst listed 25 Aug 2026
AL-P-21102name not in our copyHuntsville, ALFirst listed 25 Aug 2026
AZ-I-21231name not in our copyMesa, AZFirst listed 25 Aug 2026
AZ-P-21326name not in our copyScottsdale, AZFirst listed 25 Aug 2026
AZ-S-20081Oro De SonoraPhoenix, AZFirst listed 25 Aug 2026
CA-I-24409name not in our copySan Diego, CAFirst listed 25 Aug 2026
CA-I-24410name not in our copyWestminster, CAFirst listed 25 Aug 2026
CA-I-24411Amigos AgaverosRiverside, CAFirst listed 25 Aug 2026
CA-I-24412name not in our copyDenair, CAFirst listed 25 Aug 2026
Every state and territory we hold — all 52 of them, counted on the 25 Aug 2026 copy 25 Aug 2026
State or territoryPermitsNewest sealed read
California21,00225 Aug 2026
Florida5,93625 Aug 2026
New York5,88725 Aug 2026
Texas5,15325 Aug 2026
Washington4,13925 Aug 2026
Oregon2,96325 Aug 2026
Pennsylvania2,45025 Aug 2026
Illinois2,34225 Aug 2026
Virginia2,02525 Aug 2026
North Carolina1,91325 Aug 2026
Michigan1,88125 Aug 2026
Colorado1,71025 Aug 2026
Ohio1,68025 Aug 2026
New Jersey1,62025 Aug 2026
Georgia1,50325 Aug 2026
Massachusetts1,32925 Aug 2026
South Carolina1,26025 Aug 2026
Iowa1,23825 Aug 2026
Maryland1,20625 Aug 2026
Missouri1,20325 Aug 2026
Kansas1,10925 Aug 2026
Wisconsin99525 Aug 2026
Arizona95025 Aug 2026
Kentucky94625 Aug 2026
Connecticut94525 Aug 2026
Puerto Rico86425 Aug 2026
Tennessee86225 Aug 2026
Nevada79125 Aug 2026
Minnesota77125 Aug 2026
Indiana68025 Aug 2026
Maine62525 Aug 2026
Mississippi55625 Aug 2026
New Mexico41625 Aug 2026
Louisiana40725 Aug 2026
Idaho40225 Aug 2026
Arkansas38325 Aug 2026
Washington DC36025 Aug 2026
Alabama35925 Aug 2026
Vermont35225 Aug 2026
Delaware35125 Aug 2026
Oklahoma31825 Aug 2026
West Virginia30025 Aug 2026
Hawaii29625 Aug 2026
Rhode Island28925 Aug 2026
Montana27125 Aug 2026
New Hampshire26325 Aug 2026
Utah21425 Aug 2026
Nebraska18725 Aug 2026
Wyoming17725 Aug 2026
Alaska16225 Aug 2026
North Dakota11625 Aug 2026
South Dakota11625 Aug 2026

What this page cannot tell you

  • 40,812 of the 84,273 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 4 times: 8 Aug 2026, 11 Aug 2026, 19 Aug 2026 and 25 Aug 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: a person emails you the whole file as a CSV — the same plain spreadsheet as the sample file above, not a login and not a web page — within one working day of your payment.

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. Often it does not: across the dated copies we hold today, about half the appear and disappear rows carry no business name. 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. After you pay, a person emails you the whole appear / disappear file as a CSV within one working day, and a new one every week for as long as the subscription runs. That weekly email is what we undertake to send you. The TTB says on its own page that it posts updates weekly. We have read the source 4 times — 8, 11, 19 and 25 August 2026 — and the gaps were 3, 8 and 6 days, not one of them 7. What we have measured ourselves does not match that weekly rhythm, so the weekly email is what we undertake to send you, not a rhythm we claim to have seen. Where a week brings no new copy of the source, or we could not collect it, that week's file says so rather than repeating itself, and if we stop being able to read the source at all the file says that too. The TTB publishes the permit list as it stands today and overwrites the last one. It publishes the new permits free each week in its own short file, so most of the appearances in your file can also be had free from the TTB: in the most recent week we sealed, 96 of the 105 appearances were in that free file. What is published nowhere free is the permits that stopped being listed and the quiet changes to permits already on the list, and that is what you are paying us to keep. We tell you exactly which dated copies we hold for your state or territory before you pay anything.

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 · 4 reads so far, 3, 8 and 6 days apart

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. Often it does not: across the dated copies we hold today, about half the appear and disappear rows carry no business name. 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. After you pay, a person emails you the whole appear / disappear file as a CSV within one working day, and a new one every week for as long as the subscription runs. That weekly email is what we undertake to send you. The TTB says on its own page that it posts updates weekly. We have read the source 4 times — 8, 11, 19 and 25 August 2026 — and the gaps were 3, 8 and 6 days, not one of them 7. What we have measured ourselves does not match that weekly rhythm, so the weekly email is what we undertake to send you, not a rhythm we claim to have seen. Where a week brings no new copy of the source, or we could not collect it, that week's file says so rather than repeating itself, and if we stop being able to read the source at all the file says that too. The TTB publishes the permit list as it stands today and overwrites the last one. It publishes the new permits free each week in its own short file, so most of the appearances in your file can also be had free from the TTB: in the most recent week we sealed, 96 of the 105 appearances were in that free file. What is published nowhere free is the permits that stopped being listed and the quiet changes to permits already on the list, and that is what you are paying us to keep. We tell you exactly which dated copies we hold for your state or territory before you pay anything.

Rather ask first? Email operations@ustechautomations.com. Say that you want What this feed covers and we will tell you which weeks we hold for it before you pay.

More from this feed