How it works

One spreadsheet, every Tuesday, by email from [email protected]. Add that address to your contacts so it doesn’t land in spam.

Three steps

1

Email me your trade, your zip codes and your company name.

2

I send you one free list for your area. No card.

3

If it’s useful, subscribe and get a new list every Tuesday. Cancel anytime by email.

Get a free list

What the list doesn’t tell you

  • “No renewal on file” means L&I doesn’t have one as of the day I pull the list. Contractors file after the inspection, so some rows are late paperwork. It doesn’t mean the building is out of compliance.
  • No phone numbers or emails. You get the owner’s name and mailing address.
  • Business buildings only: commercial, office, hotel and industrial buildings owned by a business or institution. Homes, apartment buildings and buildings owned by individuals are left out, and so are City, School District and Commonwealth buildings.
  • The list isn’t exclusive. Other contractors can subscribe too.
  • Source: City of Philadelphia L&I building certifications and violation records, joined to OPA property records, provided as is.

Where this data comes from

Every row comes from public records published by the City of Philadelphia, provided as is:

  • L&I (Department of Licenses and Inspections): building certification records for Fire Cert Watch, and code violation records for Fire Violations.
  • OPA (Office of Property Assessment): property records, joined in for the owner’s name, mailing address and property type.
  • City open data: both are pulled through the City’s open data service (OpenDataPhilly).

Pull date: Nov 18, 2026. Figures from that pull:

  • 469Fire Cert Watch, run Nov 18: rows at 417 buildings. 250 are due in 30 days and 219 have no renewal on file.
  • 92Fire Violations, week Nov 2 to Nov 8: rows at 35 buildings (business owners only). Fire protection is 68 rows at 26 buildings (pulled Nov 15, 2026).

These are one run’s counts, not averages. New List Studio is independent and is not affiliated with the City, L&I or the Fire Department.

Why each row matters

A row is one building. Here is what each column holds and what you can do with it.

Fire Cert Watch

Fire Cert Watch columns
ColumnWhat it holdsWhy it matters
StatusDue in 30 days, or Expired, no renewal on file.Due in 30 days means the owner needs a contractor soon. No renewal on file means L&I has none as of the pull date, so check before you reach out.
SystemFire alarm, sprinkler, special hazards, or emergency and standby power.You take only the systems you service.
Building address, Zip, Property typeWhere the building is, and whether it is commercial, office, hotel or industrial.Lets you cut the file to your territory and the building types you work on.
Certification expires, DaysThe expiration date, and days to it. A negative number means it has expired.Tells you how soon the work is due.
Last inspected, Last resultThe date and result of the latest inspection on file.Shows when the building was last looked at and how it went.
Last inspected by, Last certified byThe contractors on the latest inspection and the last certification.Shows who has been doing the work. Buildings where you filed or inspected last are taken out of your file.
Owner and mailing addressThe owner’s name and mailing address from City records.Tells you who to write to and where. A mailing address in another city means the owner is not at the building.
Open fire violationsThe count of open fire-code violations at the property.A violation is cited by the city and still open as of the pull date.
Licensed business at addressBusinesses with an active City license at the address, with the license type.A food license at the address, for example, points to a commercial kitchen.
Parcels at addressA count of 2 or more means a condo or multi-unit commercial building.The owner shown is one of several, so the building may have more than one decision-maker.
Check on City AtlasA link to the City’s Atlas page for the address.Lets you confirm the record before you reach out.

Fire Violations

Fire Violations columns
ColumnWhat it holdsWhy it matters
CitedThe date the city cited the violation.Shows how fresh the row is. The file covers last week, Monday to Sunday.
Violation, CodeThe violation in the city’s own wording, and its code.Tells you what the city cited, so you can see if it is work you do.
Case number, PriorityThe city’s case number and priority.Lets you look up the case, and shows how the city ranked it.
Address, Zip, Property typeWhere the building is, and its type.Lets you cut the file to your territory.
Owner and mailing addressThe owner’s name and mailing address from City records.Tells you who to write to. It also says whether the owner’s mailing address is somewhere else.
Licensed business at addressThe business licensed at that address.Tells you who operates there, which can differ from the owner.
Atlas linkA link to check the case on the City’s Atlas map.Lets you confirm the record before you reach out.
Get a free list