{"current_page":1,"data":[{"id":12268184,"change_date":"2026-06-25 21:49:00","inspection_id":"88227330","dot_number":"2447858","report_state":"CT","report_number":"3010005181","insp_date":"2026-06-24 00:00:00","insp_start_time":"0538","insp_end_time":"0631","registration_date":null,"region":"ED","ci_status_code":"C","location":"152","location_desc":"CT","county_code_state":"CT","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SEVEN D WHOLESALE OF CT LP","shipping_paper_number":"H0532588","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-06-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3609321","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2026-06-25 21:49:00","snet_input_date":"2026-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:49:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-28T09:39:21.000000Z","updated_at":"2026-07-06T09:30:46.000000Z","inspection_violations":[{"id":21354697,"change_date":"2026-06-25 21:49:00","inspection_id":"88227330","insp_violation_id":"275101725","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"214262974","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-28T09:55:51.000000Z","updated_at":"2026-07-06T09:44:25.000000Z","normalized_code":"39375A3TAOL"},{"id":21354698,"change_date":"2026-06-25 21:49:00","inspection_id":"88227330","insp_violation_id":"275101726","seq_no":"2","part_no":"393","part_no_section":"118D-CDL","insp_viol_unit":"1","insp_unit_id":"214262974","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-28T09:55:51.000000Z","updated_at":"2026-07-06T09:44:25.000000Z","normalized_code":"393118DCDL"}],"inspection_per_units":[{"id":21303751,"change_date":"2026-06-25 21:49:00","inspection_id":"88227330","insp_unit_id":"214262974","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"527675","insp_unit_license":"78520A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV4SDVV5637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:14:38.000000Z","updated_at":"2026-07-06T09:02:03.000000Z"},{"id":21303752,"change_date":"2026-06-25 21:49:00","inspection_id":"88227330","insp_unit_id":"214262975","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"5417","insp_unit_license":"PT418L1","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482C4N3299278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:14:38.000000Z","updated_at":"2026-07-06T09:02:03.000000Z"}]},{"id":12233416,"change_date":"2026-06-19 21:38:00","inspection_id":"88190989","dot_number":"2447858","report_state":"NH","report_number":"1305000358","insp_date":"2026-06-19 00:00:00","insp_start_time":"1215","insp_end_time":"1235","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SEVEN D WHOLESALE OF CT LP","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":"Y","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-06-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"3581305","transaction_code":"A","transaction_date":"2026-06-19 00:00:00","upload_date":"2026-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2026-06-19 21:38:00","snet_input_date":"2026-06-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-19 21:38:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-22T09:41:26.000000Z","updated_at":"2026-06-30T09:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21245093,"change_date":"2026-06-19 21:38:00","inspection_id":"88190989","insp_unit_id":"214191678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"202138","insp_unit_license":"81746A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HSDWSZRXTN141075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-22T09:18:40.000000Z","updated_at":"2026-06-30T09:01:42.000000Z"},{"id":21245094,"change_date":"2026-06-19 21:38:00","inspection_id":"88190989","insp_unit_id":"214191679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"PT847L3","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482S3M3281909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-22T09:18:40.000000Z","updated_at":"2026-06-30T09:01:42.000000Z"}]},{"id":11812604,"change_date":"2026-05-03 21:33:00","inspection_id":"87746302","dot_number":"2447858","report_state":"RI","report_number":"0232000293","insp_date":"2026-04-27 00:00:00","insp_start_time":"1754","insp_end_time":"1823","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"H0529398","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-03 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"125350","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":"3251199","transaction_code":"A","transaction_date":"2026-05-02 00:00:00","upload_date":"2026-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2026-05-03 21:33:00","snet_input_date":"2026-04-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-03 21:33:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-06T09:39:40.000000Z","updated_at":"2026-05-13T13:07:19.000000Z","inspection_violations":[{"id":20543027,"change_date":"2026-05-03 21:33:00","inspection_id":"87746302","insp_violation_id":"274009792","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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":"2026-05-06T09:58:47.000000Z","updated_at":"2026-05-13T13:16:40.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":20546190,"change_date":"2026-05-03 21:33:00","inspection_id":"87746302","insp_unit_id":"213352626","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"202138","insp_unit_license":"81746A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HSDWSZRXTN141075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-06T09:19:01.000000Z","updated_at":"2026-05-13T12:52:33.000000Z"},{"id":20546191,"change_date":"2026-05-03 21:33:00","inspection_id":"87746302","insp_unit_id":"213352627","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":"5115","insp_unit_license":"PT468B7","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482CXH3022641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-06T09:19:01.000000Z","updated_at":"2026-05-13T12:52:33.000000Z"}]},{"id":11537143,"change_date":"2026-04-01 21:39:00","inspection_id":"87459314","dot_number":"2447858","report_state":"PA","report_number":"K151609120","insp_date":"2026-04-01 00:00:00","insp_start_time":"0745","insp_end_time":"0820","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"UPPER MERION TOWNSHIP PA","county_code_state":"PA","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"2026-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"3101862","transaction_code":"A","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2026-04-01 21:39:00","snet_input_date":"2026-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-01 21:39:00","insp_carrier_name":"SEVEN D WHOLESALE","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"CT","created_at":"2026-04-04T09:43:18.000000Z","updated_at":"2026-04-12T09:31:22.000000Z","inspection_violations":[{"id":19494449,"change_date":"2026-04-01 21:39:00","inspection_id":"87459314","insp_violation_id":"272787357","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"212466757","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:05.000000Z","updated_at":"2026-04-11T09:47:09.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":19767867,"change_date":"2026-04-01 21:39:00","inspection_id":"87459314","insp_unit_id":"212466757","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PT418L4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3HSDZAPR9RN464837","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:37.000000Z","updated_at":"2026-04-12T09:09:36.000000Z"},{"id":19767868,"change_date":"2026-04-01 21:39:00","inspection_id":"87459314","insp_unit_id":"212466758","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":null,"insp_unit_license":"PT418L4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482CS3299284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:37.000000Z","updated_at":"2026-04-12T09:09:36.000000Z"}]},{"id":11261745,"change_date":"2026-03-10 21:38:00","inspection_id":"87175562","dot_number":"2447858","report_state":"CT","report_number":"3029003662","insp_date":"2026-03-02 00:00:00","insp_start_time":"0550","insp_end_time":"0617","registration_date":"2026-03-10 00:00:00","region":"ET","ci_status_code":"C","location":"156","location_desc":"WEST HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SEVEN D WHOLESALE OF CT LP","shipping_paper_number":"H0527367","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":"2026-03-02 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"766498","transaction_code":"C","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2026-03-02 21:37:00","snet_input_date":"2026-03-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-02 21:37:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:38:49.000000Z","updated_at":"2026-03-21T09:30:07.000000Z","inspection_violations":[{"id":19069312,"change_date":"2026-03-10 21:38:00","inspection_id":"87175562","insp_violation_id":"272296982","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V137913-1","created_at":"2026-03-13T10:04:35.000000Z","updated_at":"2026-03-21T09:47:22.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":19385046,"change_date":"2026-03-10 21:38:00","inspection_id":"87175562","insp_unit_id":"212052297","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"356981","insp_unit_license":"66856A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV6LLLY6536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:14.000000Z","updated_at":"2026-03-21T09:08:55.000000Z"},{"id":19385047,"change_date":"2026-03-10 21:38:00","inspection_id":"87175562","insp_unit_id":"212052298","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTR","insp_unit_company":"554","insp_unit_license":"PT847L4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482SXM3281910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:14.000000Z","updated_at":"2026-03-21T09:08:55.000000Z"}]},{"id":10337485,"change_date":"2025-12-05 21:41:00","inspection_id":"86464795","dot_number":"2447858","report_state":"CT","report_number":"0791001237","insp_date":"2025-12-03 00:00:00","insp_start_time":"1510","insp_end_time":"1549","registration_date":"2025-12-05 00:00:00","region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"2025-12-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"759586","transaction_code":"C","transaction_date":"2025-12-03 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2025-12-03 21:38:00","snet_input_date":"2025-12-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-03 21:38:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-06T10:31:21.000000Z","updated_at":"2025-12-09T10:30:04.000000Z","inspection_violations":[{"id":17333809,"change_date":"2025-12-05 21:41:00","inspection_id":"86464795","insp_violation_id":"270474404","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210426451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:24.000000Z","updated_at":"2025-12-09T10:30:07.000000Z","normalized_code":"3939ALHLI"},{"id":17333810,"change_date":"2025-12-05 21:41:00","inspection_id":"86464795","insp_violation_id":"270474405","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"210426451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:24.000000Z","updated_at":"2025-12-09T10:30:07.000000Z","normalized_code":"3939ALFTSI"},{"id":17333811,"change_date":"2025-12-05 21:41:00","inspection_id":"86464795","insp_violation_id":"270474406","seq_no":"3","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"210426451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:24.000000Z","updated_at":"2025-12-09T10:30:07.000000Z","normalized_code":"39319"},{"id":17333812,"change_date":"2025-12-05 21:41:00","inspection_id":"86464795","insp_violation_id":"270474407","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"210426452","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-08T10:32:24.000000Z","updated_at":"2025-12-09T10:30:07.000000Z","normalized_code":"39375A3TAOL"},{"id":17333813,"change_date":"2025-12-05 21:41:00","inspection_id":"86464795","insp_violation_id":"270474408","seq_no":"5","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"210426452","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-08T10:32:24.000000Z","updated_at":"2025-12-09T10:30:07.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":17304930,"change_date":"2025-12-05 21:41:00","inspection_id":"86464795","insp_unit_id":"210426451","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"356977","insp_unit_license":"66851A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV9LLLY6532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:47.000000Z","updated_at":"2025-12-09T10:00:05.000000Z"},{"id":17304931,"change_date":"2025-12-05 21:41:00","inspection_id":"86464795","insp_unit_id":"210426452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"PT468B7","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482CXH3022641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:47.000000Z","updated_at":"2025-12-09T10:00:05.000000Z"}]},{"id":10123933,"change_date":"2025-11-05 21:40:00","inspection_id":"86240636","dot_number":"2447858","report_state":"NY","report_number":"SPG3080385","insp_date":"2025-10-30 00:00:00","insp_start_time":"0734","insp_end_time":"0750","registration_date":null,"region":"ED","ci_status_code":"C","location":"10753M","location_desc":"SCHODACK LANDING NY","county_code_state":"NY","county_code":"083","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","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-11-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2503709","transaction_code":"A","transaction_date":"2025-11-05 00:00:00","upload_date":"2025-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2025-11-05 21:40:00","snet_input_date":"2025-10-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-05 21:40:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-08T10:31:47.000000Z","updated_at":"2025-11-09T10:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16848175,"change_date":"2025-11-05 21:40:00","inspection_id":"86240636","insp_unit_id":"209849326","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":"5157","insp_unit_license":"PT847L3","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482S3M3281909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:06.000000Z","updated_at":"2025-11-09T10:00:37.000000Z"},{"id":16848176,"change_date":"2025-11-05 21:40:00","inspection_id":"86240636","insp_unit_id":"209849327","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"356981","insp_unit_license":"66856A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV6LLLY6536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:06.000000Z","updated_at":"2025-11-09T10:00:37.000000Z"}]},{"id":8130108,"change_date":"2025-03-25 21:35:00","inspection_id":"84140726","dot_number":"2447858","report_state":"CT","report_number":"3077A00279","insp_date":"2025-03-17 00:00:00","insp_start_time":"0919","insp_end_time":"1003","registration_date":"2025-03-25 00:00:00","region":"ET","ci_status_code":"C","location":"007","location_desc":"BERLIN\/KENSINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SEVEN D WHOLESALE OF CT LP","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"735049","transaction_code":"C","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2025-03-17 21:39:00","snet_input_date":"2025-03-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-17 21:39:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:16:20.000000Z","updated_at":"2025-03-29T10:19:34.000000Z","inspection_violations":[{"id":12860463,"change_date":"2025-03-25 21:35:00","inspection_id":"84140726","insp_violation_id":"265233705","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"205971415","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:32:36.000000Z","updated_at":"2025-03-28T10:48:33.000000Z","normalized_code":"3939ALHLI"},{"id":12860464,"change_date":"2025-03-25 21:35:00","inspection_id":"84140726","insp_violation_id":"265233706","seq_no":"2","part_no":"393","part_no_section":"9A-LPL","insp_viol_unit":"1","insp_unit_id":"205971415","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:32:36.000000Z","updated_at":"2025-03-28T10:48:33.000000Z","normalized_code":"3939ALPL"},{"id":12860465,"change_date":"2025-03-25 21:35:00","inspection_id":"84140726","insp_violation_id":"265233707","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"205971415","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:32:36.000000Z","updated_at":"2025-03-28T10:48:33.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":13259374,"change_date":"2025-03-25 21:35:00","inspection_id":"84140726","insp_unit_id":"205971415","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"361103","insp_unit_license":"66674A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV7LSLZ0955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:04:52.000000Z","updated_at":"2025-03-29T09:57:53.000000Z"},{"id":13259375,"change_date":"2025-03-25 21:35:00","inspection_id":"84140726","insp_unit_id":"205971416","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"5157","insp_unit_license":"PT847L3","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482S3M3281909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:04:52.000000Z","updated_at":"2025-03-29T09:57:53.000000Z"}]},{"id":7731706,"change_date":"2025-01-29 21:40:00","inspection_id":"83721876","dot_number":"2447858","report_state":"CT","report_number":"3129005519","insp_date":"2025-01-29 00:00:00","insp_start_time":"0659","insp_end_time":"0720","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","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":"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-01-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"731026","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2025-01-29 21:40:00","snet_input_date":"2025-01-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-29 21:40:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:42.000000Z","updated_at":"2025-03-17T20:58:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12476925,"change_date":"2025-01-29 21:40:00","inspection_id":"83721876","insp_unit_id":"205050736","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"66855A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV4LLLY6535","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"},{"id":12476926,"change_date":"2025-01-29 21:40:00","inspection_id":"83721876","insp_unit_id":"205050737","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTR","insp_unit_company":null,"insp_unit_license":"PT468B7","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482CXH3022641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"}]},{"id":7733265,"change_date":"2025-01-29 21:40:00","inspection_id":"83723522","dot_number":"2447858","report_state":"NY","report_number":"SPT3110370","insp_date":"2025-01-22 00:00:00","insp_start_time":"0915","insp_end_time":"0931","registration_date":null,"region":"ES","ci_status_code":"C","location":"80698R","location_desc":"SUFFERN NY","county_code_state":"NY","county_code":"087","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":"U","pen_cen_match":"I","final_status_date":"2025-01-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1297701","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2025-01-29 21:40:00","snet_input_date":"2025-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-29 21:40:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:43.000000Z","updated_at":"2025-03-17T20:58:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12479490,"change_date":"2025-01-29 21:40:00","inspection_id":"83723522","insp_unit_id":"205053731","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"36110","insp_unit_license":"66674A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV7LSLZ0955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"},{"id":12479491,"change_date":"2025-01-29 21:40:00","inspection_id":"83723522","insp_unit_id":"205053732","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":"5128","insp_unit_license":"PT334E2","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482C4K3150493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"}]},{"id":6716020,"change_date":"2024-09-13 21:40:00","inspection_id":"82648614","dot_number":"2447858","report_state":"CT","report_number":"3022000745","insp_date":"2024-09-13 00:00:00","insp_start_time":"0705","insp_end_time":"0728","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SEVEN D WHOLESALE OF PA","shipping_paper_number":"G0213896","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"717841","transaction_code":"A","transaction_date":"2024-09-13 00:00:00","upload_date":"2024-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2024-09-13 21:40:00","snet_input_date":"2024-09-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-13 21:40:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:08.000000Z","updated_at":"2025-03-17T20:36:08.000000Z","inspection_violations":[{"id":10454415,"change_date":"2024-09-13 21:40:00","inspection_id":"82648614","insp_violation_id":"261775495","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V129869-0","created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"3922"},{"id":10454416,"change_date":"2024-09-13 21:40:00","inspection_id":"82648614","insp_violation_id":"261775496","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V129869-0","created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10829260,"change_date":"2024-09-13 21:40:00","inspection_id":"82648614","insp_unit_id":"202901630","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"356978","insp_unit_license":"66955A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV0LLLY6533","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:07.000000Z","updated_at":"2025-03-17T23:35:07.000000Z"},{"id":10829261,"change_date":"2024-09-13 21:40:00","inspection_id":"82648614","insp_unit_id":"202901631","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAN","insp_unit_company":"5148","insp_unit_license":"PT418L2","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482C6N3299279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:07.000000Z","updated_at":"2025-03-17T23:35:07.000000Z"}]},{"id":6030878,"change_date":"2024-06-26 21:42:00","inspection_id":"81915681","dot_number":"2447858","report_state":"CT","report_number":"3090003983","insp_date":"2024-06-20 00:00:00","insp_start_time":"0859","insp_end_time":"0935","registration_date":"2024-06-26 00:00:00","region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"710439","transaction_code":"C","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2024-06-20 21:42:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-06-20 21:42:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:15.000000Z","updated_at":"2025-03-17T20:22:15.000000Z","inspection_violations":[{"id":9356065,"change_date":"2024-06-26 21:42:00","inspection_id":"81915681","insp_violation_id":"260312320","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201591957","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:15.000000Z","updated_at":"2025-03-17T21:51:15.000000Z","normalized_code":"3922"},{"id":9356066,"change_date":"2024-06-26 21:42:00","inspection_id":"81915681","insp_violation_id":"260312321","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201591957","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:15.000000Z","updated_at":"2025-03-17T21:51:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9713528,"change_date":"2024-06-26 21:42:00","inspection_id":"81915681","insp_unit_id":"201591957","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"356977","insp_unit_license":"66158A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV9LLLY6532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:39.000000Z","updated_at":"2025-03-17T23:23:39.000000Z"},{"id":9713529,"change_date":"2024-06-26 21:42:00","inspection_id":"81915681","insp_unit_id":"201591958","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"5136","insp_unit_license":"PT172H8","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"13N1428C9L1540455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:39.000000Z","updated_at":"2025-03-17T23:23:39.000000Z"}]},{"id":5883830,"change_date":"2024-06-06 21:41:00","inspection_id":"81755957","dot_number":"2447858","report_state":"MA","report_number":"CH00005341","insp_date":"2024-05-31 00:00:00","insp_start_time":"0838","insp_end_time":"0903","registration_date":"2024-06-06 00:00:00","region":"ET","ci_status_code":"C","location":"380H","location_desc":"H-WILMINGTON","county_code_state":"MA","county_code":"017","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":"Y","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-05-31 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"492904","transaction_code":"C","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":"M","census_search_date":"2024-05-31 21:38:00","snet_input_date":"2024-05-31 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-05-31 21:38:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:26.000000Z","updated_at":"2025-03-17T20:19:26.000000Z","inspection_violations":[{"id":9122539,"change_date":"2024-06-06 21:41:00","inspection_id":"81755957","insp_violation_id":"259936442","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9476630,"change_date":"2024-06-06 21:41:00","inspection_id":"81755957","insp_unit_id":"201262685","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"356979","insp_unit_license":"66854A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV2LLLY6534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"},{"id":9476631,"change_date":"2024-06-06 21:41:00","inspection_id":"81755957","insp_unit_id":"201262686","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"PT847L4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482SXM3281910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"}]},{"id":5328989,"change_date":"2024-05-06 21:43:00","inspection_id":"81152270","dot_number":"2447858","report_state":"NJ","report_number":"SPRSI00692","insp_date":"2024-03-19 00:00:00","insp_start_time":"1019","insp_end_time":"1125","registration_date":"2024-03-19 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"KNOWLTON SCALES","county_code_state":"NJ","county_code":"041","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125280","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":"1201020","transaction_code":"C","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2024-03-20 21:42:00","snet_input_date":"2024-03-19 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-03-20 21:42:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:17.000000Z","updated_at":"2025-03-17T20:08:17.000000Z","inspection_violations":[{"id":8221595,"change_date":"2024-05-06 21:43:00","inspection_id":"81152270","insp_violation_id":"259328885","seq_no":"1","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"200738498","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":8581912,"change_date":"2024-05-06 21:43:00","inspection_id":"81152270","insp_unit_id":"200738498","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"66854A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV2LLLY6534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:50.000000Z","updated_at":"2025-03-17T23:12:50.000000Z"},{"id":8581913,"change_date":"2024-05-06 21:43:00","inspection_id":"81152270","insp_unit_id":"200738499","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":null,"insp_unit_license":"PT418L1","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482C4N3299278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:50.000000Z","updated_at":"2025-03-17T23:12:50.000000Z"}]},{"id":4403552,"change_date":"2023-11-13 21:41:00","inspection_id":"80139761","dot_number":"2447858","report_state":"NY","report_number":"SPL0164640","insp_date":"2023-11-07 00:00:00","insp_start_time":"0910","insp_end_time":"0928","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","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-11-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2886454","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2023-11-13 21:41:00","snet_input_date":"2023-11-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-13 21:41:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:16.000000Z","updated_at":"2025-03-17T19:50:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7081737,"change_date":"2023-11-13 21:41:00","inspection_id":"80139761","insp_unit_id":"198011459","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"66854A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV2LLLY6534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:27.000000Z","updated_at":"2025-03-17T22:59:27.000000Z"},{"id":7081738,"change_date":"2023-11-13 21:41:00","inspection_id":"80139761","insp_unit_id":"198011460","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":"5153","insp_unit_license":"PR418L4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482CS3299284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:27.000000Z","updated_at":"2025-03-17T22:59:27.000000Z"}]},{"id":3939252,"change_date":"2023-09-11 21:39:00","inspection_id":"79625392","dot_number":"2447858","report_state":"CT","report_number":"3015002261","insp_date":"2023-09-11 00:00:00","insp_start_time":"0717","insp_end_time":"0739","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-84 E\/B NEAR EXIT 71","county_code_state":"CT","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SEVEN D WHOLESALE OF CT","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":"N","pen_cen_match":null,"final_status_date":"2023-09-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"685671","transaction_code":"A","transaction_date":"2023-09-11 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2023-09-11 21:39:00","snet_input_date":"2023-09-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-09-11 21:39:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:31.000000Z","updated_at":"2025-03-17T19:40:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6334017,"change_date":"2023-09-11 21:39:00","inspection_id":"79625392","insp_unit_id":"196979577","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"N\/A","insp_unit_license":"66675A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV9LSLZ0956","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:12.000000Z","updated_at":"2025-03-17T22:53:12.000000Z"},{"id":6334018,"change_date":"2023-09-11 21:39:00","inspection_id":"79625392","insp_unit_id":"196979578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"N\/A","insp_unit_license":"PT206D6","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"5JYFB4520KED15283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:12.000000Z","updated_at":"2025-03-17T22:53:12.000000Z"}]},{"id":3840129,"change_date":"2023-08-28 21:41:00","inspection_id":"79514846","dot_number":"2447858","report_state":"NH","report_number":"1128000984","insp_date":"2023-08-28 00:00:00","insp_start_time":"0508","insp_end_time":"0535","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOOKSETT","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SEVEN D WHOLESALE","shipping_paper_number":"H0484228","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"268716","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2023-08-28 21:41:00","snet_input_date":"2023-08-28 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-08-28 21:41:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:53.000000Z","updated_at":"2025-03-17T19:38:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6174074,"change_date":"2023-08-28 21:41:00","inspection_id":"79514846","insp_unit_id":"196748400","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"36110","insp_unit_license":"66674A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHTDV7LSLZ0955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:51.000000Z","updated_at":"2025-03-17T22:51:51.000000Z"},{"id":6174075,"change_date":"2023-08-28 21:41:00","inspection_id":"79514846","insp_unit_id":"196748401","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":null,"insp_unit_license":"PT418L1","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482C4N3299278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:51.000000Z","updated_at":"2025-03-17T22:51:51.000000Z"}]},{"id":3796029,"change_date":"2023-08-22 21:42:00","inspection_id":"79465373","dot_number":"2447858","report_state":"CT","report_number":"3087002620","insp_date":"2023-08-22 00:00:00","insp_start_time":"1349","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","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-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"684247","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2023-08-22 21:42:00","snet_input_date":"2023-08-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-22 21:42:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:43.000000Z","updated_at":"2025-03-17T19:37:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6103643,"change_date":"2023-08-22 21:42:00","inspection_id":"79465373","insp_unit_id":"196650730","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"316284","insp_unit_license":"61583A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHLDV5JSJR1383","insp_unit_decal":"Y","insp_unit_decal_number":"33110661","created_at":"2025-03-17T22:51:16.000000Z","updated_at":"2025-03-17T22:51:16.000000Z"},{"id":6103644,"change_date":"2023-08-22 21:42:00","inspection_id":"79465373","insp_unit_id":"196650731","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":"5153","insp_unit_license":"PT418L4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482CXN3299284","insp_unit_decal":"Y","insp_unit_decal_number":"33110662","created_at":"2025-03-17T22:51:16.000000Z","updated_at":"2025-03-17T22:51:16.000000Z"}]},{"id":3712277,"change_date":"2023-08-10 21:41:00","inspection_id":"79372097","dot_number":"2447858","report_state":"NY","report_number":"SPWG100755","insp_date":"2023-08-09 00:00:00","insp_start_time":"1025","insp_end_time":"1101","registration_date":null,"region":"ET","ci_status_code":"C","location":"10753","location_desc":"SCHODACK (EB)","county_code_state":"NY","county_code":"083","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-08-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2856709","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":"M","census_search_date":"2023-08-10 21:41:00","snet_input_date":"2023-08-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-10 21:41:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:08.000000Z","updated_at":"2025-03-17T19:36:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5968459,"change_date":"2023-08-10 21:41:00","inspection_id":"79372097","insp_unit_id":"196460652","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"356979","insp_unit_license":"66854A","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FUJHTDV2LLLY6534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:09.000000Z","updated_at":"2025-03-17T22:50:09.000000Z"},{"id":5968460,"change_date":"2023-08-10 21:41:00","inspection_id":"79372097","insp_unit_id":"196460653","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"5153","insp_unit_license":"PT418L4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482CS3299284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:09.000000Z","updated_at":"2025-03-17T22:50:09.000000Z"}]},{"id":3319544,"change_date":"2023-06-20 21:40:00","inspection_id":"78931378","dot_number":"2447858","report_state":"NY","report_number":"SPL0113362","insp_date":"2023-06-14 00:00:00","insp_start_time":"0820","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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-06-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2837695","transaction_code":"A","transaction_date":"2023-06-20 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":"M","census_search_date":"2023-06-20 21:40:00","snet_input_date":"2023-06-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-20 21:40:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:35.000000Z","updated_at":"2025-03-17T19:28:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5336113,"change_date":"2023-06-20 21:40:00","inspection_id":"78931378","insp_unit_id":"195573078","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"356978","insp_unit_license":"66955A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDVOLLY6533","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:06.000000Z","updated_at":"2025-03-17T22:45:06.000000Z"},{"id":5336114,"change_date":"2023-06-20 21:40:00","inspection_id":"78931378","insp_unit_id":"195573079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"5136","insp_unit_license":"PT172H8","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"13N1428C9L1540455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:06.000000Z","updated_at":"2025-03-17T22:45:06.000000Z"}]},{"id":3155581,"change_date":"2023-05-31 21:41:00","inspection_id":"78745892","dot_number":"2447858","report_state":"CT","report_number":"3129003987","insp_date":"2023-05-26 00:00:00","insp_start_time":"1514","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-27 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"675607","transaction_code":"C","transaction_date":"2023-05-26 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2023-05-27 21:31:00","snet_input_date":"2023-05-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-27 21:31:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:23.000000Z","updated_at":"2025-03-17T19:25:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5074890,"change_date":"2023-05-31 21:41:00","inspection_id":"78745892","insp_unit_id":"195217311","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":null,"insp_unit_license":"PT418L1","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482C4N3299278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:59.000000Z","updated_at":"2025-03-17T22:42:59.000000Z"},{"id":5074891,"change_date":"2023-05-31 21:41:00","inspection_id":"78745892","insp_unit_id":"195217312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"356979","insp_unit_license":"66854A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV2LLLY6534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:59.000000Z","updated_at":"2025-03-17T22:42:59.000000Z"}]},{"id":1546533,"change_date":"2022-10-24 21:40:00","inspection_id":"76912110","dot_number":"2447858","report_state":"CT","report_number":"3129003487","insp_date":"2022-10-19 00:00:00","insp_start_time":"0640","insp_end_time":"0721","registration_date":"2022-10-24 00:00:00","region":"ET","ci_status_code":"C","location":"152SN","location_desc":"WATERFORD SCALE N\/B","county_code_state":"CT","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"H87055","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":"2022-10-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"656627","transaction_code":"C","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2022-10-19 21:40:00","snet_input_date":"2022-10-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-10-19 21:40:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:11.000000Z","updated_at":"2025-03-17T18:55:11.000000Z","inspection_violations":[{"id":2433606,"change_date":"2022-10-24 21:40:00","inspection_id":"76912110","insp_violation_id":"249189240","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"191586327","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"393110B"}],"inspection_per_units":[{"id":2488865,"change_date":"2022-10-24 21:40:00","inspection_id":"76912110","insp_unit_id":"191586326","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"316284","insp_unit_license":"61583A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHLDV5JSJR1383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:03.000000Z","updated_at":"2025-03-17T22:24:03.000000Z"},{"id":2488866,"change_date":"2022-10-24 21:40:00","inspection_id":"76912110","insp_unit_id":"191586327","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"5156","insp_unit_license":"PT847L4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482SXM3281910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:03.000000Z","updated_at":"2025-03-17T22:24:03.000000Z"}]},{"id":889752,"change_date":"2022-07-27 21:40:00","inspection_id":"76148182","dot_number":"2447858","report_state":"CT","report_number":"3091004096","insp_date":"2022-07-26 00:00:00","insp_start_time":"1307","insp_end_time":"1340","registration_date":"2022-07-27 00:00:00","region":"ET","ci_status_code":"C","location":"077","location_desc":"MANCHESTER","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SEVEN D WHOLESALE OF CT LP","shipping_paper_number":"H0464251","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":"2022-07-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127484","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":"649898","transaction_code":"C","transaction_date":"2022-07-26 00:00:00","upload_date":"2022-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2022-07-26 21:41:00","snet_input_date":"2022-07-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-26 21:41:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:23.000000Z","updated_at":"2025-03-17T18:43:23.000000Z","inspection_violations":[{"id":1401078,"change_date":"2022-07-27 21:40:00","inspection_id":"76148182","insp_violation_id":"247337118","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1432482,"change_date":"2022-07-27 21:40:00","inspection_id":"76148182","insp_unit_id":"189983497","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"316284","insp_unit_license":"61583A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3AKJHLDV5JSJR1383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:00.000000Z","updated_at":"2025-03-17T22:17:00.000000Z"},{"id":1432483,"change_date":"2022-07-27 21:40:00","inspection_id":"76148182","insp_unit_id":"189983498","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"5134","insp_unit_license":"PT172H7","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"13N1482C5L1540453","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:00.000000Z","updated_at":"2025-03-17T22:17:00.000000Z"}]},{"id":645441,"change_date":"2022-07-11 21:41:00","inspection_id":"75862107","dot_number":"2447858","report_state":"CT","report_number":"3091004009","insp_date":"2022-06-20 00:00:00","insp_start_time":"1432","insp_end_time":"1506","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"MANCHESTER","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-20 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"127484","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":"646896","transaction_code":"C","transaction_date":"2022-07-10 00:00:00","upload_date":"2022-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":null,"census_search_date":"2022-06-20 21:35:00","snet_input_date":"2022-06-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-20 21:35:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:09.000000Z","updated_at":"2025-03-17T18:39:09.000000Z","inspection_violations":[{"id":1016008,"change_date":"2022-07-11 21:41:00","inspection_id":"75862107","insp_violation_id":"246990508","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WR735-3093","created_at":"2025-03-17T21:11:44.000000Z","updated_at":"2025-03-17T21:11:44.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1037513,"change_date":"2022-07-11 21:41:00","inspection_id":"75862107","insp_unit_id":"189689916","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"356978","insp_unit_license":"66955A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV0LLLY6533","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:34.000000Z","updated_at":"2025-03-17T22:14:34.000000Z"},{"id":1037514,"change_date":"2022-07-11 21:41:00","inspection_id":"75862107","insp_unit_id":"189689917","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"5134","insp_unit_license":"PT172H7","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"13N1482C5L1540453","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:34.000000Z","updated_at":"2025-03-17T22:14:34.000000Z"}]},{"id":342944,"change_date":"2022-05-09 21:40:00","inspection_id":"75501941","dot_number":"2447858","report_state":"NY","report_number":"SPL0154404","insp_date":"2022-05-05 00:00:00","insp_start_time":"0750","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":"10753A","location_desc":"SCHODACK (WB)","county_code_state":"NY","county_code":"083","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":"2022-05-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"2703879","transaction_code":"A","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02447858","upload_search_indicator":"M","census_search_date":"2022-05-09 21:40:00","snet_input_date":"2022-05-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-09 21:40:00","insp_carrier_name":"SEVEN D WHOLESALE OF CT LP","insp_carrier_street":"145 DIVIDEND RD","insp_carrier_city":"ROCKY HILL","insp_carrier_state":"CT","insp_carrier_zip_code":"06067","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:37.000000Z","updated_at":"2025-03-17T18:33:37.000000Z","inspection_violations":[{"id":538189,"change_date":"2022-05-09 21:40:00","inspection_id":"75501941","insp_violation_id":"245646211","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"188563095","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":554610,"change_date":"2022-05-09 21:40:00","inspection_id":"75501941","insp_unit_id":"188563094","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"66851A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJHTDV9LLLY6532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:36.000000Z","updated_at":"2025-03-17T22:11:36.000000Z"},{"id":554611,"change_date":"2022-05-09 21:40:00","inspection_id":"75501941","insp_unit_id":"188563095","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"PT468B7","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1TTF482CXH3022641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:36.000000Z","updated_at":"2025-03-17T22:11:36.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2447858\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2447858\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2447858\/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\/2447858\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}