{"current_page":1,"data":[{"id":12343583,"change_date":"2026-07-02 21:40:00","inspection_id":"88303136","dot_number":"173757","report_state":"CT","report_number":"3064001806","insp_date":"2026-07-02 00:00:00","insp_start_time":"0656","insp_end_time":"0714","registration_date":null,"region":"ED","ci_status_code":"C","location":"043","location_desc":"CT","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"61000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3670442","transaction_code":"A","transaction_date":"2026-07-02 00:00:00","upload_date":"2026-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2026-07-02 21:40:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-02 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-05T09:42:13.000000Z","updated_at":"2026-07-09T09:37:11.000000Z","inspection_violations":[{"id":21485228,"change_date":"2026-07-02 21:40:00","inspection_id":"88303136","insp_violation_id":"275270296","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"214415890","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V139333-0","created_at":"2026-07-05T10:05:25.000000Z","updated_at":"2026-07-09T09:52:34.000000Z","normalized_code":"3922SLLIFTA"},{"id":21485229,"change_date":"2026-07-02 21:40:00","inspection_id":"88303136","insp_violation_id":"275270297","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"214415890","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-05T10:05:25.000000Z","updated_at":"2026-07-09T09:52:34.000000Z","normalized_code":"3922SLLSIV"},{"id":21485230,"change_date":"2026-07-02 21:40:00","inspection_id":"88303136","insp_violation_id":"275270298","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214415890","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-05T10:05:25.000000Z","updated_at":"2026-07-09T09:52:34.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21436322,"change_date":"2026-07-02 21:40:00","inspection_id":"88303136","insp_unit_id":"214415890","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"449","insp_unit_license":"70420A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTGRSJT3DJ324054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:41.000000Z","updated_at":"2026-07-09T09:11:10.000000Z"}]},{"id":11675940,"change_date":"2026-05-14 21:41:00","inspection_id":"87601001","dot_number":"173757","report_state":"CT","report_number":"3086000018","insp_date":"2026-04-17 00:00:00","insp_start_time":"0935","insp_end_time":"1104","registration_date":"2026-05-14 00:00:00","region":"ET","ci_status_code":"C","location":"162","location_desc":"WINCHESTER","county_code_state":"CT","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"K.F. PROPERTIES LLC","shipping_paper_number":"S3615456.002","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"74300","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"770571","transaction_code":"C","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2026-04-17 21:40:00","snet_input_date":"2026-04-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-04-17 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:32:35.000000Z","updated_at":"2026-05-25T09:30:04.000000Z","inspection_violations":[{"id":20271721,"change_date":"2026-05-14 21:41:00","inspection_id":"87601001","insp_violation_id":"274240147","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"213537551","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:46:03.000000Z","updated_at":"2026-05-25T09:41:26.000000Z","normalized_code":"39345DB"},{"id":20271722,"change_date":"2026-05-14 21:41:00","inspection_id":"87601001","insp_violation_id":"274240148","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"213537551","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:46:03.000000Z","updated_at":"2026-05-25T09:41:26.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":20271723,"change_date":"2026-05-14 21:41:00","inspection_id":"87601001","insp_violation_id":"274240149","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"213537551","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:46:03.000000Z","updated_at":"2026-05-25T09:41:26.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":20301030,"change_date":"2026-05-14 21:41:00","inspection_id":"87601001","insp_unit_id":"213537551","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"438","insp_unit_license":"67201A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVMG3DV6LHMA0834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:06:10.000000Z","updated_at":"2026-05-25T09:02:00.000000Z"}]},{"id":10544110,"change_date":"2025-12-31 21:37:00","inspection_id":"86680671","dot_number":"173757","report_state":"CT","report_number":"3082001775","insp_date":"2025-12-31 00:00:00","insp_start_time":"0842","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"103","location_desc":"NORWALK","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SUPERIOR BRIDGEPORT","shipping_paper_number":"S3582259.002","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-31 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"76350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"762035","transaction_code":"A","transaction_date":"2025-12-31 00:00:00","upload_date":"2025-12-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2025-12-31 21:37:00","snet_input_date":"2025-12-31 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-31 21:37:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-03T10:35:00.000000Z","updated_at":"2026-01-11T10:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17663855,"change_date":"2025-12-31 21:37:00","inspection_id":"86680671","insp_unit_id":"210860300","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"437","insp_unit_license":"67137A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVMG3DV4LHMA0833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-03T10:05:50.000000Z","updated_at":"2026-01-11T10:00:09.000000Z"}]},{"id":10415123,"change_date":"2025-12-17 21:38:00","inspection_id":"86545999","dot_number":"173757","report_state":"CT","report_number":"0057000101","insp_date":"2025-12-12 00:00:00","insp_start_time":"1130","insp_end_time":"1215","registration_date":"2025-12-17 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"760613","transaction_code":"C","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2025-12-12 21:40:00","snet_input_date":"2025-12-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-12 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-15T10:31:49.000000Z","updated_at":"2025-12-28T10:30:05.000000Z","inspection_violations":[{"id":17535024,"change_date":"2025-12-17 21:38:00","inspection_id":"86545999","insp_violation_id":"270726124","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210646961","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-20T10:31:58.000000Z","updated_at":"2025-12-28T10:30:09.000000Z","normalized_code":"3922SLLSR"},{"id":17535025,"change_date":"2025-12-17 21:38:00","inspection_id":"86545999","insp_violation_id":"270726125","seq_no":"2","part_no":"382","part_no_section":"15-SSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-20T10:31:58.000000Z","updated_at":"2025-12-28T10:30:09.000000Z","normalized_code":"38215SSF"}],"inspection_per_units":[{"id":17491722,"change_date":"2025-12-17 21:38:00","inspection_id":"86545999","insp_unit_id":"210646961","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"402","insp_unit_license":"AE04127","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JP3D4S50509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:37.000000Z","updated_at":"2025-12-28T10:00:08.000000Z"}]},{"id":10282513,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","dot_number":"173757","report_state":"CT","report_number":"3019006822","insp_date":"2025-11-25 00:00:00","insp_start_time":"1239","insp_end_time":"1352","registration_date":"2025-12-04 00:00:00","region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-25 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"29380","viol_total":"9","oos_total":"4","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"6","hazmat_oos_total":"2","snet_sequence_id":"758979","transaction_code":"C","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2025-11-25 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-25 21:38:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-28T10:31:44.000000Z","updated_at":"2025-12-08T10:30:06.000000Z","inspection_violations":[{"id":17312970,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_violation_id":"270443671","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:13.000000Z","normalized_code":"38323A2LCDLN"},{"id":17312971,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_violation_id":"270443672","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:13.000000Z","normalized_code":"38323A2LCDL"},{"id":17312972,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_violation_id":"270443673","seq_no":"3","part_no":"172","part_no_section":"400A1-HML","insp_viol_unit":"1","insp_unit_id":"210397925","insp_violation_category_id":"33","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:13.000000Z","normalized_code":"172400A1HML"},{"id":17312973,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_violation_id":"270443674","seq_no":"4","part_no":"172","part_no_section":"504A-HMPS","insp_viol_unit":"1","insp_unit_id":"210397925","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:13.000000Z","normalized_code":"172504AHMPS"},{"id":17312974,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_violation_id":"270443675","seq_no":"5","part_no":"172","part_no_section":"200A-HMSPSNSP","insp_viol_unit":"1","insp_unit_id":"210397925","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:13.000000Z","normalized_code":"172200AHMSPSNSP"},{"id":17312975,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_violation_id":"270443676","seq_no":"6","part_no":"107","part_no_section":"608B-HMAMC","insp_viol_unit":"1","insp_unit_id":"210397925","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:13.000000Z","normalized_code":"107608BHMAMC"},{"id":17312976,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_violation_id":"270443677","seq_no":"7","part_no":"172","part_no_section":"600C1-HMER","insp_viol_unit":"1","insp_unit_id":"210397925","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:13.000000Z","normalized_code":"172600C1HMER"},{"id":17312977,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_violation_id":"270443678","seq_no":"8","part_no":"172","part_no_section":"602A-HMER","insp_viol_unit":"1","insp_unit_id":"210397925","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:13.000000Z","normalized_code":"172602AHMER"},{"id":17312978,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_violation_id":"270443679","seq_no":"9","part_no":"172","part_no_section":"604A-HMER","insp_viol_unit":"1","insp_unit_id":"210397925","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:13.000000Z","normalized_code":"172604AHMER"}],"inspection_per_units":[{"id":17283700,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_unit_id":"210397925","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"451","insp_unit_license":"BA86826","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FD0X5HT6LEE53176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:19.000000Z","updated_at":"2025-12-08T10:00:09.000000Z"},{"id":17283701,"change_date":"2025-12-04 21:37:00","inspection_id":"86407272","insp_unit_id":"210397926","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HAULO","insp_unit_company":null,"insp_unit_license":"AH47856","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5CUEM2024HA000010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:19.000000Z","updated_at":"2025-12-08T10:00:09.000000Z"}]},{"id":9242063,"change_date":"2025-07-25 21:39:00","inspection_id":"85313307","dot_number":"173757","report_state":"CT","report_number":"3071A00357","insp_date":"2025-07-25 00:00:00","insp_start_time":"1301","insp_end_time":"1314","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RT 7 NORTH DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"S3501545.001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"747152","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2025-07-25 21:39:00","snet_input_date":"2025-07-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-25 21:39:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:11.000000Z","updated_at":"2025-07-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15209137,"change_date":"2025-07-25 21:39:00","inspection_id":"85313307","insp_unit_id":"208068319","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"454","insp_unit_license":"72118A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AX18C7FM028637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:28.000000Z","updated_at":"2025-07-29T09:45:10.000000Z"}]},{"id":8260057,"change_date":"2025-04-01 21:39:00","inspection_id":"84277533","dot_number":"173757","report_state":"NY","report_number":"D103400107","insp_date":"2025-03-25 00:00:00","insp_start_time":"1022","insp_end_time":"1100","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FULTONVILLE NY","county_code_state":"NY","county_code":"057","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1537565","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2025-04-01 21:39:00","snet_input_date":"2025-03-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-01 21:39:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-04T10:20:37.000000Z","updated_at":"2025-04-06T10:17:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13367519,"change_date":"2025-04-01 21:39:00","inspection_id":"84277533","insp_unit_id":"206089292","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"402","insp_unit_license":"AE04127","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JP3D4S50509","insp_unit_decal":"Y","insp_unit_decal_number":"34943984","created_at":"2025-04-04T10:02:57.000000Z","updated_at":"2025-04-05T09:49:52.000000Z"}]},{"id":6555406,"change_date":"2024-09-19 21:41:00","inspection_id":"82477613","dot_number":"173757","report_state":"CT","report_number":"3132004880","insp_date":"2024-08-26 00:00:00","insp_start_time":"0838","insp_end_time":"0901","registration_date":"2024-09-19 00:00:00","region":"ET","ci_status_code":"C","location":"139","location_desc":"SUFFIELD","county_code_state":"CT","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"716412","transaction_code":"C","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2024-08-26 21:41:00","snet_input_date":"2024-08-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-26 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:49.000000Z","updated_at":"2025-03-17T20:32:49.000000Z","inspection_violations":[{"id":10185599,"change_date":"2024-09-19 21:41:00","inspection_id":"82477613","insp_violation_id":"261907982","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203015885","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:19.000000Z","updated_at":"2025-03-17T21:55:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10568023,"change_date":"2024-09-19 21:41:00","inspection_id":"82477613","insp_unit_id":"203015885","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE04127","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JP3D4S50509","insp_unit_decal":"Y","insp_unit_decal_number":"34380142","created_at":"2025-03-17T23:32:28.000000Z","updated_at":"2025-03-17T23:32:28.000000Z"}]},{"id":6519053,"change_date":"2024-08-22 21:41:00","inspection_id":"82438920","dot_number":"173757","report_state":"CT","report_number":"3070006239","insp_date":"2024-08-21 00:00:00","insp_start_time":"1522","insp_end_time":"1535","registration_date":"2024-08-22 00:00:00","region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"716032","transaction_code":"C","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2024-08-21 21:41:00","snet_input_date":"2024-08-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-21 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:01.000000Z","updated_at":"2025-03-17T20:32:01.000000Z","inspection_violations":[{"id":10127556,"change_date":"2024-08-22 21:41:00","inspection_id":"82438920","insp_violation_id":"261334039","seq_no":"1","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"202520198","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"393130"}],"inspection_per_units":[{"id":10509141,"change_date":"2024-08-22 21:41:00","inspection_id":"82438920","insp_unit_id":"202520197","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"39681A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M1AK06Y96N009030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:50.000000Z","updated_at":"2025-03-17T23:31:50.000000Z"},{"id":10509142,"change_date":"2024-08-22 21:41:00","inspection_id":"82438920","insp_unit_id":"202520198","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"AE44556","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1LH440UH5G1A23642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:50.000000Z","updated_at":"2025-03-17T23:31:50.000000Z"}]},{"id":6496930,"change_date":"2024-09-20 21:41:00","inspection_id":"82415399","dot_number":"173757","report_state":"CT","report_number":"3061002554","insp_date":"2024-08-16 00:00:00","insp_start_time":"1605","insp_end_time":"1614","registration_date":"2024-09-20 00:00:00","region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52001","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"715680","transaction_code":"C","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2024-08-19 21:41:00","snet_input_date":"2024-08-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-19 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:37.000000Z","updated_at":"2025-03-17T20:31:37.000000Z","inspection_violations":[{"id":10089042,"change_date":"2024-09-20 21:41:00","inspection_id":"82415399","insp_violation_id":"261932892","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10472714,"change_date":"2024-09-20 21:41:00","inspection_id":"82415399","insp_unit_id":"203037275","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"27901","insp_unit_license":"66226A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGEDV9LDMA0836","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:29.000000Z","updated_at":"2025-03-17T23:31:29.000000Z"},{"id":10472715,"change_date":"2024-09-20 21:41:00","inspection_id":"82415399","insp_unit_id":"203037276","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":"T-1","insp_unit_license":"BL14496","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1LH440VH7R1B36431","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:29.000000Z","updated_at":"2025-03-17T23:31:29.000000Z"}]},{"id":6383675,"change_date":"2024-08-12 21:42:00","inspection_id":"82294372","dot_number":"173757","report_state":"CT","report_number":"3069000087","insp_date":"2024-08-05 00:00:00","insp_start_time":"1348","insp_end_time":"1410","registration_date":"2024-08-12 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARREIR","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"714604","transaction_code":"C","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2024-08-05 21:41:00","snet_input_date":"2024-08-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-05 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:28.000000Z","updated_at":"2025-03-17T20:29:28.000000Z","inspection_violations":[{"id":9908038,"change_date":"2024-08-12 21:42:00","inspection_id":"82294372","insp_violation_id":"261123549","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10287510,"change_date":"2024-08-12 21:42:00","inspection_id":"82294372","insp_unit_id":"202330290","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"276","insp_unit_license":"39681A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M1AK06Y96N009030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:33.000000Z","updated_at":"2025-03-17T23:29:33.000000Z"},{"id":10287511,"change_date":"2024-08-12 21:42:00","inspection_id":"82294372","insp_unit_id":"202330291","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"AE44556","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1LH440UH5G1A23642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:33.000000Z","updated_at":"2025-03-17T23:29:33.000000Z"}]},{"id":4584042,"change_date":"2023-12-08 21:40:00","inspection_id":"80338292","dot_number":"173757","report_state":"CT","report_number":"3070005507","insp_date":"2023-12-08 00:00:00","insp_start_time":"0800","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":"035","location_desc":"DARIEN","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"S3299697","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"76350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"693950","transaction_code":"A","transaction_date":"2023-12-08 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-12-08 21:40:00","snet_input_date":"2023-12-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-12-08 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:45.000000Z","updated_at":"2025-03-17T19:53:45.000000Z","inspection_violations":[{"id":7090509,"change_date":"2023-12-08 21:40:00","inspection_id":"80338292","insp_violation_id":"256779993","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198408558","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7373078,"change_date":"2023-12-08 21:40:00","inspection_id":"80338292","insp_unit_id":"198408558","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"279085","insp_unit_license":"67137A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVMG3DV4LHMA0833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:58.000000Z","updated_at":"2025-03-17T23:01:58.000000Z"}]},{"id":4129559,"change_date":"2023-10-05 21:39:00","inspection_id":"79836792","dot_number":"173757","report_state":"CT","report_number":"0104000041","insp_date":"2023-10-05 00:00:00","insp_start_time":"1246","insp_end_time":"1319","registration_date":null,"region":"ET","ci_status_code":"C","location":"028E","location_desc":"EXIT 18 ROUTE 2","county_code_state":"CT","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SUPERIOR","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"61400","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"688046","transaction_code":"A","transaction_date":"2023-10-05 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-10-05 21:39:00","snet_input_date":"2023-10-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-10-05 21:39:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:27.000000Z","updated_at":"2025-03-17T19:44:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6639749,"change_date":"2023-10-05 21:39:00","inspection_id":"79836792","insp_unit_id":"197406096","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"449","insp_unit_license":"70420A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHLDV0NDMY5722","insp_unit_decal":"Y","insp_unit_decal_number":"33438501","created_at":"2025-03-17T22:55:41.000000Z","updated_at":"2025-03-17T22:55:41.000000Z"}]},{"id":4141286,"change_date":"2023-10-06 21:40:00","inspection_id":"79849767","dot_number":"173757","report_state":"NY","report_number":"SPK0195417","insp_date":"2023-10-03 00:00:00","insp_start_time":"0835","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057","location_desc":"BEDFORD","county_code_state":"NY","county_code":"119","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2876306","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":"M","census_search_date":"2023-10-06 21:40:00","snet_input_date":"2023-10-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-06 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:53.000000Z","updated_at":"2025-03-17T19:44:53.000000Z","inspection_violations":[{"id":6410607,"change_date":"2023-10-06 21:40:00","inspection_id":"79849767","insp_violation_id":"255695939","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"197430922","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39021A"},{"id":6410608,"change_date":"2023-10-06 21:40:00","inspection_id":"79849767","insp_violation_id":"255695940","seq_no":"2","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"197430922","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39341"},{"id":6410609,"change_date":"2023-10-06 21:40:00","inspection_id":"79849767","insp_violation_id":"255695941","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197430922","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39617C"},{"id":6410610,"change_date":"2023-10-06 21:40:00","inspection_id":"79849767","insp_violation_id":"255695942","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197430922","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5H7XRQL","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3939A"},{"id":6410611,"change_date":"2023-10-06 21:40:00","inspection_id":"79849767","insp_violation_id":"255695943","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197430922","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5H7XRS7","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39378"},{"id":6410612,"change_date":"2023-10-06 21:40:00","inspection_id":"79849767","insp_violation_id":"255695944","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197430922","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6658715,"change_date":"2023-10-06 21:40:00","inspection_id":"79849767","insp_unit_id":"197430922","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"249","insp_unit_license":"J95510","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDWE35L63HB32861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"}]},{"id":3862848,"change_date":"2023-08-30 21:43:00","inspection_id":"79540214","dot_number":"173757","report_state":"CT","report_number":"3015002240","insp_date":"2023-08-30 00:00:00","insp_start_time":"0854","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"650 STORRES ROAD MANSFIELD,CT.","county_code_state":"CT","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SUPERIOR EAST HARTFORD","shipping_paper_number":"S3266524","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"74300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"684923","transaction_code":"A","transaction_date":"2023-08-30 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-08-30 21:43:00","snet_input_date":"2023-08-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-30 21:43:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:20.000000Z","updated_at":"2025-03-17T19:39:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6210513,"change_date":"2023-08-30 21:43:00","inspection_id":"79540214","insp_unit_id":"196799021","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"N\/A","insp_unit_license":"67201A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVMG3DV6LHMA0834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:11.000000Z","updated_at":"2025-03-17T22:52:11.000000Z"}]},{"id":3462484,"change_date":"2023-07-10 21:41:00","inspection_id":"79092148","dot_number":"173757","report_state":"CT","report_number":"3013000496","insp_date":"2023-07-10 00:00:00","insp_start_time":"1300","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"7000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"679935","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-07-10 21:41:00","snet_input_date":"2023-07-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-10 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:39.000000Z","updated_at":"2025-03-17T19:31:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5567700,"change_date":"2023-07-10 21:41:00","inspection_id":"79092148","insp_unit_id":"195895554","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"MULT","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5SLBG1426PL039622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:57.000000Z","updated_at":"2025-03-17T22:46:57.000000Z"}]},{"id":3462485,"change_date":"2023-07-10 21:41:00","inspection_id":"79092149","dot_number":"173757","report_state":"CT","report_number":"3013000497","insp_date":"2023-07-10 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"2995","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"679937","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-07-10 21:41:00","snet_input_date":"2023-07-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-10 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:39.000000Z","updated_at":"2025-03-17T19:31:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5567701,"change_date":"2023-07-10 21:41:00","inspection_id":"79092149","insp_unit_id":"195895555","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"MULT","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"4GNBG0910PB066438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:57.000000Z","updated_at":"2025-03-17T22:46:57.000000Z"}]},{"id":3462486,"change_date":"2023-07-10 21:41:00","inspection_id":"79092150","dot_number":"173757","report_state":"CT","report_number":"3013000498","insp_date":"2023-07-10 00:00:00","insp_start_time":"1330","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"7000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"679940","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-07-10 21:41:00","snet_input_date":"2023-07-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-10 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:39.000000Z","updated_at":"2025-03-17T19:31:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5567702,"change_date":"2023-07-10 21:41:00","inspection_id":"79092150","insp_unit_id":"195895556","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"ALLIA","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"7H6BY15A0PA010480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:57.000000Z","updated_at":"2025-03-17T22:46:57.000000Z"}]},{"id":3462487,"change_date":"2023-07-10 21:41:00","inspection_id":"79092151","dot_number":"173757","report_state":"CT","report_number":"3013000499","insp_date":"2023-07-10 00:00:00","insp_start_time":"1345","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"2900","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"679925","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-07-10 21:41:00","snet_input_date":"2023-07-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-10 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:39.000000Z","updated_at":"2025-03-17T19:31:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5567703,"change_date":"2023-07-10 21:41:00","inspection_id":"79092151","insp_unit_id":"195895557","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"BARRE","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1B9UH0616PL280131","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:57.000000Z","updated_at":"2025-03-17T22:46:57.000000Z"}]},{"id":3462492,"change_date":"2023-07-10 21:41:00","inspection_id":"79092156","dot_number":"173757","report_state":"CT","report_number":"3013000500","insp_date":"2023-07-10 00:00:00","insp_start_time":"1400","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"2900","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"679918","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-07-10 21:41:00","snet_input_date":"2023-07-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-10 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:39.000000Z","updated_at":"2025-03-17T19:31:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5567709,"change_date":"2023-07-10 21:41:00","inspection_id":"79092156","insp_unit_id":"195895563","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"BARRE","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1B9UH0618PL280132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:57.000000Z","updated_at":"2025-03-17T22:46:57.000000Z"}]},{"id":3101836,"change_date":"2023-05-22 21:40:00","inspection_id":"78685341","dot_number":"173757","report_state":"CT","report_number":"3013000393","insp_date":"2023-05-22 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"2760","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"675246","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-05-22 21:40:00","snet_input_date":"2023-05-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-22 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:32.000000Z","updated_at":"2025-03-17T19:24:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4989295,"change_date":"2023-05-22 21:40:00","inspection_id":"78685341","insp_unit_id":"195055467","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"MULT","insp_unit_company":"10","insp_unit_license":null,"insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"4GNBM0913PB065678","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:20.000000Z","updated_at":"2025-03-17T22:42:20.000000Z"}]},{"id":3101837,"change_date":"2023-05-22 21:40:00","inspection_id":"78685342","dot_number":"173757","report_state":"CT","report_number":"3013000394","insp_date":"2023-05-22 00:00:00","insp_start_time":"1345","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"675245","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-05-22 21:40:00","snet_input_date":"2023-05-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-22 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:32.000000Z","updated_at":"2025-03-17T19:24:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4989296,"change_date":"2023-05-22 21:40:00","inspection_id":"78685342","insp_unit_id":"195055468","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"MULT","insp_unit_company":"04","insp_unit_license":null,"insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5SLBG1525PL039724","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:20.000000Z","updated_at":"2025-03-17T22:42:20.000000Z"}]},{"id":3101838,"change_date":"2023-05-22 21:40:00","inspection_id":"78685343","dot_number":"173757","report_state":"CT","report_number":"3013000395","insp_date":"2023-05-22 00:00:00","insp_start_time":"1415","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"5699","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"675261","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-05-22 21:40:00","snet_input_date":"2023-05-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-22 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:32.000000Z","updated_at":"2025-03-17T19:24:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4989297,"change_date":"2023-05-22 21:40:00","inspection_id":"78685343","insp_unit_id":"195055469","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"VERN","insp_unit_company":"45","insp_unit_license":null,"insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1VRD11ACXP1052897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:20.000000Z","updated_at":"2025-03-17T22:42:20.000000Z"}]},{"id":3101944,"change_date":"2023-05-22 21:40:00","inspection_id":"78685459","dot_number":"173757","report_state":"CT","report_number":"3013000392","insp_date":"2023-05-22 00:00:00","insp_start_time":"1300","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"EAST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"2760","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"675260","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-05-22 21:40:00","snet_input_date":"2023-05-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-22 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:32.000000Z","updated_at":"2025-03-17T19:24:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4989452,"change_date":"2023-05-22 21:40:00","inspection_id":"78685459","insp_unit_id":"195055773","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"MULT","insp_unit_company":"11","insp_unit_license":null,"insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"4GNBM0914PB065673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:20.000000Z","updated_at":"2025-03-17T22:42:20.000000Z"}]},{"id":2982020,"change_date":"2023-05-15 21:41:00","inspection_id":"78550370","dot_number":"173757","report_state":"CT","report_number":"1147001601","insp_date":"2023-05-08 00:00:00","insp_start_time":"0708","insp_end_time":"0730","registration_date":"2023-05-15 00:00:00","region":"ET","ci_status_code":"C","location":"155","location_desc":"WEST HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"149450","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"673771","transaction_code":"C","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-05-08 21:41:00","snet_input_date":"2023-05-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-08 21:41:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:13.000000Z","updated_at":"2025-03-17T19:22:13.000000Z","inspection_violations":[{"id":4577754,"change_date":"2023-05-15 21:41:00","inspection_id":"78550370","insp_violation_id":"252816407","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:19.000000Z","updated_at":"2025-03-17T21:28:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4797740,"change_date":"2023-05-15 21:41:00","inspection_id":"78550370","insp_unit_id":"194917831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"404","insp_unit_license":"60736A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJGNDV0GDHE5536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:48.000000Z","updated_at":"2025-03-17T22:40:48.000000Z"},{"id":4797741,"change_date":"2023-05-15 21:41:00","inspection_id":"78550370","insp_unit_id":"194917832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"AE45883","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1LH440VH5H1A24094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:48.000000Z","updated_at":"2025-03-17T22:40:48.000000Z"}]},{"id":2691733,"change_date":"2023-03-30 21:40:00","inspection_id":"78221309","dot_number":"173757","report_state":"CT","report_number":"3132003711","insp_date":"2023-03-30 00:00:00","insp_start_time":"0941","insp_end_time":"0947","registration_date":null,"region":"ET","ci_status_code":"C","location":"078","location_desc":"MANSFIELD","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"670982","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-03-30 21:40:00","snet_input_date":"2023-03-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-30 21:40:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:14.000000Z","updated_at":"2025-03-17T19:16:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4333402,"change_date":"2023-03-30 21:40:00","inspection_id":"78221309","insp_unit_id":"194134206","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"AE04127","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNE8JP3D4S50509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:07.000000Z","updated_at":"2025-03-17T22:37:07.000000Z"}]},{"id":2661884,"change_date":"2023-03-28 21:40:00","inspection_id":"78186595","dot_number":"173757","report_state":"CT","report_number":"3076002283","insp_date":"2023-03-27 00:00:00","insp_start_time":"1017","insp_end_time":"1045","registration_date":"2023-03-28 00:00:00","region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"S3214740.001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"3","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"670494","transaction_code":"C","transaction_date":"2023-03-27 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2023-03-27 21:39:00","snet_input_date":"2023-03-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-27 21:39:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:49.000000Z","updated_at":"2025-03-17T19:15:49.000000Z","inspection_violations":[{"id":4091649,"change_date":"2023-03-28 21:40:00","inspection_id":"78186595","insp_violation_id":"251892376","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"1","insp_unit_id":"194087118","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"393110B"},{"id":4091650,"change_date":"2023-03-28 21:40:00","inspection_id":"78186595","insp_violation_id":"251892377","seq_no":"2","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"1","insp_unit_id":"194087118","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"393110B"},{"id":4091651,"change_date":"2023-03-28 21:40:00","inspection_id":"78186595","insp_violation_id":"251892378","seq_no":"3","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"1","insp_unit_id":"194087118","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"393110B"}],"inspection_per_units":[{"id":4285746,"change_date":"2023-03-28 21:40:00","inspection_id":"78186595","insp_unit_id":"194087118","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"454","insp_unit_license":"72118A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2AX18C7FM028637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:46.000000Z","updated_at":"2025-03-17T22:36:46.000000Z"}]},{"id":2009548,"change_date":"2022-12-23 21:33:00","inspection_id":"77442926","dot_number":"173757","report_state":"VT","report_number":"59A0003051","insp_date":"2022-12-20 00:00:00","insp_start_time":"1137","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":"0307SB","location_desc":"LYNDONVILLE SB RA","county_code_state":"VT","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-23 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"69000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"195800","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00173757","upload_search_indicator":null,"census_search_date":"2022-12-23 21:33:00","snet_input_date":"2022-12-20 00:00:00","source_office":"1VTS001","mcmis_add_date":"2022-12-23 21:33:00","insp_carrier_name":"SUPERIOR PRODUCTS DISTRIBUTORS INC","insp_carrier_street":"1403 MERIDEN-WATERBURY RD","insp_carrier_city":"MILLDALE","insp_carrier_state":"CT","insp_carrier_zip_code":"06467","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:40.000000Z","updated_at":"2025-03-17T19:03:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3232742,"change_date":"2022-12-23 21:33:00","inspection_id":"77442926","insp_unit_id":"192568062","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"67201A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVMG3DV6LHMA0834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:08.000000Z","updated_at":"2025-03-17T22:29:08.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/173757\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/173757\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/173757\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/173757\/inspections","per_page":100,"prev_page_url":null,"to":28,"total":28}