{"current_page":1,"data":[{"id":11318195,"change_date":"2026-03-08 21:33:00","inspection_id":"87234707","dot_number":"688757","report_state":"CT","report_number":"3120005879","insp_date":"2026-03-06 00:00:00","insp_start_time":"1054","insp_end_time":"1137","registration_date":null,"region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"VALERO MARKETING & SUPPLY","shipping_paper_number":"0000767766","cargo_tank":"NON","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":"2026-03-08 21:33: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":"767137","transaction_code":"A","transaction_date":"2026-03-06 00:00:00","upload_date":"2026-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2026-03-08 21:33:00","snet_input_date":"2026-03-06 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-08 21:33:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-11T09:38:20.000000Z","updated_at":"2026-03-19T09:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19364841,"change_date":"2026-03-08 21:33:00","inspection_id":"87234707","insp_unit_id":"212031726","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35","insp_unit_license":"AU40552","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJGEDV6CLBE4732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-11T09:13:26.000000Z","updated_at":"2026-03-19T09:02:03.000000Z"},{"id":19364842,"change_date":"2026-03-08 21:33:00","inspection_id":"87234707","insp_unit_id":"212031727","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"365","insp_unit_license":"V82903","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1H4T04422EK016906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-11T09:13:26.000000Z","updated_at":"2026-03-19T09:02:03.000000Z"}]},{"id":9084329,"change_date":"2025-07-08 21:38:00","inspection_id":"85132243","dot_number":"688757","report_state":"CT","report_number":"3120005400","insp_date":"2025-07-07 00:00:00","insp_start_time":"0925","insp_end_time":"1012","registration_date":"2025-07-08 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BEST OIN INC","shipping_paper_number":"701625","cargo_tank":"406","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-07-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"745005","transaction_code":"C","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2025-07-07 21:38:00","snet_input_date":"2025-07-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-07 21:38:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:43.000000Z","updated_at":"2025-07-12T10:44:29.000000Z","inspection_violations":[{"id":14631441,"change_date":"2025-07-08 21:38:00","inspection_id":"85132243","insp_violation_id":"267254048","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"207742323","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-11T10:46:59.000000Z","updated_at":"2025-07-13T10:47:57.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":14908781,"change_date":"2025-07-08 21:38:00","inspection_id":"85132243","insp_unit_id":"207742323","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"BA87514","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJGEBG4ELFJ9108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-11T09:46:31.000000Z","updated_at":"2025-07-12T09:45:05.000000Z"},{"id":14908782,"change_date":"2025-07-08 21:38:00","inspection_id":"85132243","insp_unit_id":"207742324","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"T9","insp_unit_license":"BE62867","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5HTAB4420V7H61531","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-11T09:46:31.000000Z","updated_at":"2025-07-12T09:45:05.000000Z"}]},{"id":7551313,"change_date":"2025-01-06 21:38:00","inspection_id":"83532619","dot_number":"688757","report_state":"CT","report_number":"3132005244","insp_date":"2025-01-06 00:00:00","insp_start_time":"0930","insp_end_time":"0951","registration_date":null,"region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SHELL NEW HAVEN","shipping_paper_number":"0002270049","cargo_tank":"NON","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-01-06 21:38: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":"728571","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2025-01-06 21:38:00","snet_input_date":"2025-01-06 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-06 21:38:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:54.000000Z","updated_at":"2025-03-17T20:54:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12183866,"change_date":"2025-01-06 21:38:00","inspection_id":"83532619","insp_unit_id":"204657571","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AU40552","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJGEDV6CLBE4732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:29.000000Z","updated_at":"2025-03-17T23:49:29.000000Z"},{"id":12183867,"change_date":"2025-01-06 21:38:00","inspection_id":"83532619","insp_unit_id":"204657572","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"V82903","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1H4T04422EK016906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:29.000000Z","updated_at":"2025-03-17T23:49:29.000000Z"}]},{"id":7491638,"change_date":"2024-12-24 21:34:00","inspection_id":"83470030","dot_number":"688757","report_state":"CT","report_number":"3132005207","insp_date":"2024-12-24 00:00:00","insp_start_time":"0852","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"GLOBAL","shipping_paper_number":"4734","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-12-24 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"727679","transaction_code":"A","transaction_date":"2024-12-24 00:00:00","upload_date":"2024-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2024-12-24 21:34:00","snet_input_date":"2024-12-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-24 21:34:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:20.000000Z","updated_at":"2025-03-17T20:52:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12085999,"change_date":"2024-12-24 21:34:00","inspection_id":"83470030","insp_unit_id":"204539840","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"AB08270","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2FZACGCS36AW27373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:28.000000Z","updated_at":"2025-03-17T23:48:28.000000Z"}]},{"id":7065648,"change_date":"2024-11-01 21:39:00","inspection_id":"83020416","dot_number":"688757","report_state":"CT","report_number":"0481000132","insp_date":"2024-10-28 00:00:00","insp_start_time":"1700","insp_end_time":"1729","registration_date":"2024-11-01 00:00:00","region":"ET","ci_status_code":"C","location":"T074","location_desc":"ROUTE 254 X RTE 118 LITCHFIELD","county_code_state":"CT","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEST OIL","shipping_paper_number":"904663","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-10-29 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"33000","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":"721793","transaction_code":"C","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2024-10-29 21:41:00","snet_input_date":"2024-10-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-10-29 21:41:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:25.000000Z","updated_at":"2025-03-17T20:43:25.000000Z","inspection_violations":[{"id":11029270,"change_date":"2024-11-01 21:39:00","inspection_id":"83020416","insp_violation_id":"262674908","seq_no":"1","part_no":"392","part_no_section":"2-SLTFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Z464083-3","created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"3922SLTFC"}],"inspection_per_units":[{"id":11395363,"change_date":"2024-11-01 21:39:00","inspection_id":"83020416","insp_unit_id":"203690610","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BJ26340","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACXFEXPDUM3351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:00.000000Z","updated_at":"2025-03-17T23:41:00.000000Z"}]},{"id":5660410,"change_date":"2024-05-03 21:38:00","inspection_id":"81513734","dot_number":"688757","report_state":"CT","report_number":"3132004523","insp_date":"2024-05-03 00:00:00","insp_start_time":"1023","insp_end_time":"1044","registration_date":null,"region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL COMPANIES LLC","shipping_paper_number":"359407","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":"2024-05-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"706554","transaction_code":"A","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2024-05-03 21:38:00","snet_input_date":"2024-05-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-03 21:38:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:02.000000Z","updated_at":"2025-03-17T20:15:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9116908,"change_date":"2024-05-03 21:38:00","inspection_id":"81513734","insp_unit_id":"200708122","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"AB08270","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2FZACGCS36AW27373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:50.000000Z","updated_at":"2025-03-17T23:17:50.000000Z"}]},{"id":5118800,"change_date":"2024-02-28 21:41:00","inspection_id":"80923040","dot_number":"688757","report_state":"CT","report_number":"1147002049","insp_date":"2024-02-22 00:00:00","insp_start_time":"1429","insp_end_time":"1454","registration_date":"2024-02-28 00:00:00","region":"ET","ci_status_code":"C","location":"101","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DENNIS K BURKE HO (334)","shipping_paper_number":"0002189260","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-02-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"700355","transaction_code":"C","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2024-02-23 21:40:00","snet_input_date":"2024-02-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-23 21:40:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:52.000000Z","updated_at":"2025-03-17T20:03:52.000000Z","inspection_violations":[{"id":7893256,"change_date":"2024-02-28 21:41:00","inspection_id":"80923040","insp_violation_id":"258073075","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:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3922"},{"id":7893257,"change_date":"2024-02-28 21:41:00","inspection_id":"80923040","insp_violation_id":"258073076","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199628878","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8240973,"change_date":"2024-02-28 21:41:00","inspection_id":"80923040","insp_unit_id":"199628878","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"28","insp_unit_license":"AB08283","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJA6DEX4LN25803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:42.000000Z","updated_at":"2025-03-17T23:09:42.000000Z"},{"id":8240974,"change_date":"2024-02-28 21:41:00","inspection_id":"80923040","insp_unit_id":"199628879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"7","insp_unit_license":"AE44375","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1H4T04221LL018902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:42.000000Z","updated_at":"2025-03-17T23:09:42.000000Z"}]},{"id":3728265,"change_date":"2023-08-12 21:30:00","inspection_id":"79389887","dot_number":"688757","report_state":"CT","report_number":"3019004672","insp_date":"2023-08-11 00:00:00","insp_start_time":"0836","insp_end_time":"0854","registration_date":null,"region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","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":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-12 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1","hazmat_oos_total":"0","snet_sequence_id":"683250","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2023-08-12 21:30:00","snet_input_date":"2023-08-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-12 21:30:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:30.000000Z","updated_at":"2025-03-17T19:36:30.000000Z","inspection_violations":[{"id":5750172,"change_date":"2023-08-12 21:30:00","inspection_id":"79389887","insp_violation_id":"254618229","seq_no":"1","part_no":"171","part_no_section":"2(k)","insp_viol_unit":"1","insp_unit_id":"196498820","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:38.000000Z","updated_at":"2025-03-17T21:33:38.000000Z","normalized_code":"1712K"}],"inspection_per_units":[{"id":5994539,"change_date":"2023-08-12 21:30:00","inspection_id":"79389887","insp_unit_id":"196498820","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"F5","insp_unit_license":"BA88239","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDUF5HT7NDA07857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"}]},{"id":3681609,"change_date":"2023-08-07 21:41:00","inspection_id":"79337968","dot_number":"688757","report_state":"MA","report_number":"CW00001935","insp_date":"2023-07-30 00:00:00","insp_start_time":"1125","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"236H","location_desc":"H-NORTHAMPTON","county_code_state":"MA","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":"406","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":"2023-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"471570","transaction_code":"A","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":"M","census_search_date":"2023-08-07 21:41:00","snet_input_date":"2023-07-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-08-07 21:41:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:38.000000Z","updated_at":"2025-03-17T19:35:38.000000Z","inspection_violations":[{"id":5676954,"change_date":"2023-08-07 21:41:00","inspection_id":"79337968","insp_violation_id":"254496457","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:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5919260,"change_date":"2023-08-07 21:41:00","inspection_id":"79337968","insp_unit_id":"196388737","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE50938","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTKJPVK8LH330745","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:45.000000Z","updated_at":"2025-03-17T22:49:45.000000Z"}]},{"id":2881033,"change_date":"2023-04-28 21:38:00","inspection_id":"78435843","dot_number":"688757","report_state":"CT","report_number":"3129003929","insp_date":"2023-04-25 00:00:00","insp_start_time":"0755","insp_end_time":"0835","registration_date":"2023-04-28 00:00:00","region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BUCKEYE","shipping_paper_number":"0000497164","cargo_tank":"NON","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":"2023-04-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"672703","transaction_code":"C","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2023-04-25 21:39:00","snet_input_date":"2023-04-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-04-25 21:39:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:01.000000Z","updated_at":"2025-03-17T19:20:01.000000Z","inspection_violations":[{"id":4421895,"change_date":"2023-04-28 21:38:00","inspection_id":"78435843","insp_violation_id":"252498395","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194637739","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:39.000000Z","updated_at":"2025-03-17T21:27:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4635583,"change_date":"2023-04-28 21:38:00","inspection_id":"78435843","insp_unit_id":"194637738","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35","insp_unit_license":"AU40552","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJGEDV6CLBE4732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:34.000000Z","updated_at":"2025-03-17T22:39:34.000000Z"},{"id":4635584,"change_date":"2023-04-28 21:38:00","inspection_id":"78435843","insp_unit_id":"194637739","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"365","insp_unit_license":"V82903","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1H4T04422EK01690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:34.000000Z","updated_at":"2025-03-17T22:39:34.000000Z"}]},{"id":2520083,"change_date":"2023-03-07 21:41:00","inspection_id":"78025567","dot_number":"688757","report_state":"CT","report_number":"3129003819","insp_date":"2023-03-07 00:00:00","insp_start_time":"0900","insp_end_time":"0931","registration_date":null,"region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BUCKEYE","shipping_paper_number":"0000482226","cargo_tank":"OTH","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":"2023-03-07 21:41: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":"668591","transaction_code":"A","transaction_date":"2023-03-07 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2023-03-07 21:41:00","snet_input_date":"2023-03-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-07 21:41:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:17.000000Z","updated_at":"2025-03-17T19:13:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4056231,"change_date":"2023-03-07 21:41:00","inspection_id":"78025567","insp_unit_id":"193738486","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"35","insp_unit_license":"AU40552","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJGEDV6CLBE4732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:05.000000Z","updated_at":"2025-03-17T22:35:05.000000Z"},{"id":4056232,"change_date":"2023-03-07 21:41:00","inspection_id":"78025567","insp_unit_id":"193738487","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"365","insp_unit_license":"V82903","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1H4T04422EK01690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:05.000000Z","updated_at":"2025-03-17T22:35:05.000000Z"}]},{"id":1968561,"change_date":"2022-12-19 21:40:00","inspection_id":"77396228","dot_number":"688757","report_state":"CT","report_number":"3087002288","insp_date":"2022-12-17 00:00:00","insp_start_time":"0615","insp_end_time":"0635","registration_date":null,"region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","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":"2022-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"661375","transaction_code":"A","transaction_date":"2022-12-17 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2022-12-19 21:40:00","snet_input_date":"2022-12-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-19 21:40:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:56.000000Z","updated_at":"2025-03-17T19:02:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3167344,"change_date":"2022-12-19 21:40:00","inspection_id":"77396228","insp_unit_id":"192475599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"AB08270","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2FZACGCS36AW27373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:41.000000Z","updated_at":"2025-03-17T22:28:41.000000Z"}]},{"id":1701465,"change_date":"2022-11-17 21:39:00","inspection_id":"77090046","dot_number":"688757","report_state":"CT","report_number":"0997000476","insp_date":"2022-11-09 00:00:00","insp_start_time":"1217","insp_end_time":"1315","registration_date":"2022-11-17 00:00:00","region":"ET","ci_status_code":"C","location":"130","location_desc":"SOUTHBURY","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"178953","cargo_tank":"331","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"658400","transaction_code":"C","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2022-11-09 21:39:00","snet_input_date":"2022-11-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-11-09 21:39:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:09.000000Z","updated_at":"2025-03-17T18:58:09.000000Z","inspection_violations":[{"id":2667210,"change_date":"2022-11-17 21:39:00","inspection_id":"77090046","insp_violation_id":"249647729","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:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"39216A"},{"id":2667211,"change_date":"2022-11-17 21:39:00","inspection_id":"77090046","insp_violation_id":"249647730","seq_no":"2","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:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"3922"},{"id":2667212,"change_date":"2022-11-17 21:39:00","inspection_id":"77090046","insp_violation_id":"249647731","seq_no":"3","part_no":"383","part_no_section":"71(h)","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:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"38371H"},{"id":2667213,"change_date":"2022-11-17 21:39:00","inspection_id":"77090046","insp_violation_id":"249647732","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191998811","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2737782,"change_date":"2022-11-17 21:39:00","inspection_id":"77090046","insp_unit_id":"191998811","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3","insp_unit_license":"AU39997","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMAAN47H458192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:44.000000Z","updated_at":"2025-03-17T22:25:44.000000Z"}]},{"id":901148,"change_date":"2022-08-01 21:38:00","inspection_id":"76161578","dot_number":"688757","report_state":"CT","report_number":"3120003148","insp_date":"2022-07-27 00:00:00","insp_start_time":"0650","insp_end_time":"0739","registration_date":"2022-08-01 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BEST OIN INC","shipping_paper_number":"N\/A","cargo_tank":"NON","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":"2022-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"111760","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"649939","transaction_code":"C","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2022-07-27 21:40:00","snet_input_date":"2022-07-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-27 21:40:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:40.000000Z","updated_at":"2025-03-17T18:43:40.000000Z","inspection_violations":[{"id":1422167,"change_date":"2022-08-01 21:38:00","inspection_id":"76161578","insp_violation_id":"247416223","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190050410","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:44.000000Z","updated_at":"2025-03-17T21:13:44.000000Z","normalized_code":"3922"},{"id":1422168,"change_date":"2022-08-01 21:38:00","inspection_id":"76161578","insp_violation_id":"247416224","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190050410","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:44.000000Z","updated_at":"2025-03-17T21:13:44.000000Z","normalized_code":"39311"},{"id":1422169,"change_date":"2022-08-01 21:38:00","inspection_id":"76161578","insp_violation_id":"247416225","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190050410","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:44.000000Z","updated_at":"2025-03-17T21:13:44.000000Z","normalized_code":"39345B2"},{"id":1422170,"change_date":"2022-08-01 21:38:00","inspection_id":"76161578","insp_violation_id":"247416226","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190050411","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:44.000000Z","updated_at":"2025-03-17T21:13:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1450795,"change_date":"2022-08-01 21:38:00","inspection_id":"76161578","insp_unit_id":"190050410","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"34","insp_unit_license":"AE18359","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJF0CV67LX37411","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:08.000000Z","updated_at":"2025-03-17T22:17:08.000000Z"},{"id":1450796,"change_date":"2022-08-01 21:38:00","inspection_id":"76161578","insp_unit_id":"190050411","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"5","insp_unit_license":"AE44399","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"10BEA92V1YF0B1710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:08.000000Z","updated_at":"2025-03-17T22:17:08.000000Z"}]},{"id":509665,"change_date":"2022-06-07 21:38:00","inspection_id":"75700700","dot_number":"688757","report_state":"CT","report_number":"3129003184","insp_date":"2022-05-27 00:00:00","insp_start_time":"0929","insp_end_time":"1013","registration_date":"2022-06-06 00:00:00","region":"ET","ci_status_code":"C","location":"093","location_desc":"NEW HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","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":"2022-05-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"645344","transaction_code":"C","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00688757","upload_search_indicator":null,"census_search_date":"2022-05-31 21:41:00","snet_input_date":"2022-05-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-05-31 21:41:00","insp_carrier_name":"BEST OIN INC","insp_carrier_street":"237 HUNTINGDON AVE","insp_carrier_city":"WATERBURY","insp_carrier_state":"CT","insp_carrier_zip_code":"06708","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:41.000000Z","updated_at":"2025-03-17T18:36:41.000000Z","inspection_violations":[{"id":810646,"change_date":"2022-06-07 21:38:00","inspection_id":"75700700","insp_violation_id":"246279124","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189095446","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:51.000000Z","updated_at":"2025-03-17T21:10:51.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":819800,"change_date":"2022-06-07 21:38:00","inspection_id":"75700700","insp_unit_id":"189095445","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA87514","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJGEBG4ELFJ9108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:15.000000Z","updated_at":"2025-03-17T22:13:15.000000Z"},{"id":819801,"change_date":"2022-06-07 21:38:00","inspection_id":"75700700","insp_unit_id":"189095446","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"V82903","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1H4T04422EK01690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:15.000000Z","updated_at":"2025-03-17T22:13:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/688757\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/688757\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/688757\/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\/688757\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}