Doe Appliance Certification Database Search Data: Dataset Structure and Field Coverage

The searchable asset is the CCMS Compliance Certification Database, published by the US Department of Energy alongside the efficiency standards and test procedures the Appliance and Equipment Standards Program administers across more than 70 regulated products. Datadory catalogs it as the DOE Appliance and Equipment Standards Program and scores it 9 out of 10 on its rubric.

Scale is the headline. A live count returned 4,657,149 certified basic-model records across 73 product groups, ranging from hundreds of rows in small groups to 15,357 for residential refrigerators, refrigerator-freezers and freezers. Granularity is strict: one record per certified basic model, with product-group-specific attribute sets, so a refrigerator row answers different fields than a clothes washer row. Pinning the right product group before you type anything else is what separates a working lookup from a false negative.

Legal status matters as much as scale. Every value is a manufacturer representation that DOE republishes; the agency makes no warranty of accuracy and states that the public database has no legal significance, because regulatory compliance is established when the manufacturer submits the certification in CCMS under 10 CFR Part 429, not when DOE displays it. Read a hit as documented certification, and read a miss as a coverage question first - the twelve-month window below explains why - before treating it as evidence of anything.

A repeatable model-level check looks like this:

1. Pin the product group. The database organizes every record into 73 product groups - refrigeration, laundry, dishwashing, cooking, room air conditioning and the rest of the federally regulated set. Searching the wrong group is the most common reason a model you know is on the market appears to be missing.

1. Read the rating plate for the basic model number. The record unit is the certified basic model rather than the marketing SKU, so the basic model designation printed on the plate is the string that resolves cleanly.

1. Validate against the group's own attribute set. Fields are product-group specific, so check the energy-use and capacity figures defined for that group instead of assuming one universal column layout across all 73 groups.

The two US registries sit at different tiers, and their record counts make the split visible.

ENERGY STAR Certified Products & Datasets (Socrata) is the EPA's voluntary tier above the federal standard: roughly 90 Socrata datasets refreshed daily, exported as CSV or Excel without registration or pulled through an open REST API, counting 4,759 certified residential refrigerator models, 753 dishwashers, 663 clothes dryers, 665 freezers, 550 dehumidifiers, 463 room ACs, 401 clothes washers and 237 room air cleaners.

The DOE CCMS database is the compliance floor beneath it: 4,657,149 records across 73 product groups covering every federally regulated basic model regardless of efficiency tier, refreshed weekly rather than daily. Set the two refrigerator numbers side by side - 15,357 certified basic models in DOE's refrigeration group versus 4,759 certified-efficient residential refrigerator models at ENERGY STAR - and you are looking at the label premium made visible: the difference between may legally be sold and earns the label.

Both sources are free and commercial delivery terms, so the practical answer is to run both: confirm sale legality in CCMS, then flag the efficient subset from ENERGY STAR and join on brand and model. The field-by-field trade-offs sit on the dedicated page comparing ENERGY STAR certified products with the DOE standards database.

Three neighbors in Datadory's 14-dataset household-appliances slice take over where a US certification lookup stops.

European models. EU EPREL - European Product Registry for Energy Labelling registers every energy-labelled model on the EU market across all 33 product groups - 55,757 refrigerating appliances, 23,178 washing machines and 32,523 air conditioners - through a free JSON API once you email a digitally signed declaration for an access key. The Commission targets 95% monthly API availability and permits commercial reuse with attribution.

Ownership questions. EIA Residential Energy Consumption Survey (RECS) 2020 - Appliances Tables (HC3.x) quantifies how many US households own each product across tables HC3.1-HC3.9, backed by a public microdata file of 18,496 households by 799 columns with state identifiers and prior waves back to 1993.

The DOE appliance certification database search settles one question - may this basic model legally be sold in the United States - and settles it for free, at model level, across 4.6 million records. Everything else hangs off that answer.