{"current_page":1,"data":[{"id":11843334,"change_date":"2026-05-07 21:39:00","inspection_id":"87778996","dot_number":"1586421","report_state":"CT","report_number":"0704000381","insp_date":"2026-05-07 00:00:00","insp_start_time":"1130","insp_end_time":"1225","registration_date":null,"region":"ET","ci_status_code":"C","location":"148","location_desc":"I-91 N\/B X14","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CT FINE WINES AND SPIRITS","shipping_paper_number":"WBCT0408","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-05-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"772159","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01586421","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-05-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-05-07 21:39:00","insp_carrier_name":"RAV TRUCKING LLC","insp_carrier_street":"347 CHESTNUT HILL ROAD","insp_carrier_city":"COLCHESTER","insp_carrier_state":"CT","insp_carrier_zip_code":"06415","insp_colonia":null,"docket_number":"587323","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:24.000000Z","updated_at":"2026-05-18T09:30:14.000000Z","inspection_violations":[{"id":20597967,"change_date":"2026-05-07 21:39:00","inspection_id":"87778996","insp_violation_id":"274096514","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"213420285","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:14.000000Z","updated_at":"2026-05-18T09:40:47.000000Z","normalized_code":"39021TB2DOT"},{"id":20597968,"change_date":"2026-05-07 21:39:00","inspection_id":"87778996","insp_violation_id":"274096515","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"213420285","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:14.000000Z","updated_at":"2026-05-18T09:40:47.000000Z","normalized_code":"39021TB1MC"},{"id":20597969,"change_date":"2026-05-07 21:39:00","inspection_id":"87778996","insp_violation_id":"274096516","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"213420285","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:14.000000Z","updated_at":"2026-05-18T09:40:47.000000Z","normalized_code":"39617CPI"},{"id":20597970,"change_date":"2026-05-07 21:39:00","inspection_id":"87778996","insp_violation_id":"274096517","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213420286","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:14.000000Z","updated_at":"2026-05-18T09:40:47.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":20596370,"change_date":"2026-05-07 21:39:00","inspection_id":"87778996","insp_unit_id":"213420285","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"79882A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1XP5DB9XXYD551D75","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:32.000000Z","updated_at":"2026-05-18T09:02:15.000000Z"},{"id":20596371,"change_date":"2026-05-07 21:39:00","inspection_id":"87778996","insp_unit_id":"213420286","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"5389276","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0626AW701172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:32.000000Z","updated_at":"2026-05-18T09:02:15.000000Z"}]},{"id":11637518,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","dot_number":"1586421","report_state":"CT","report_number":"3076003714","insp_date":"2026-04-14 00:00:00","insp_start_time":"0931","insp_end_time":"1107","registration_date":"2026-04-21 00:00:00","region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RETAIL SERVICES & SYSTEMS","shipping_paper_number":"RS11245838","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-14 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"11","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"770166","transaction_code":"C","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01586421","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-04-14 21:38:00","insp_carrier_name":"RAV TRUCKING LLC","insp_carrier_street":"347 CHESTNUT HILL ROAD","insp_carrier_city":"COLCHESTER","insp_carrier_state":"CT","insp_carrier_zip_code":"06415","insp_colonia":null,"docket_number":"587323","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:37:05.000000Z","updated_at":"2026-05-02T09:30:05.000000Z","inspection_violations":[{"id":20338427,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735919","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"213127848","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V1383322 0","created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"3922SLLEQP"},{"id":20338428,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735920","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213127848","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V1383322 0","created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"3922SLLSR"},{"id":20338429,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735921","seq_no":"3","part_no":"393","part_no_section":"209D-STPAL","insp_viol_unit":"1","insp_unit_id":"213127848","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V1383322 0","created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"393209DSTPAL"},{"id":20338430,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735922","seq_no":"4","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"213127848","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"3963A1BALAC"},{"id":20338431,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735923","seq_no":"5","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"213127848","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"3963A1BALR"},{"id":20338432,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735924","seq_no":"6","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"213127848","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V1383322 0","created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"3969D2FTF"},{"id":20338433,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735925","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213127849","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"39347E"},{"id":20338434,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735926","seq_no":"8","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"213127849","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"39353BB"},{"id":20338435,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735927","seq_no":"9","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213127849","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"39347E"},{"id":20338437,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735929","seq_no":"11","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"213127849","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V1383322 0","created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"3963A1BOS"},{"id":20338436,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_violation_id":"273735928","seq_no":"10","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213127849","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:53:38.000000Z","updated_at":"2026-05-02T09:41:20.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":20242381,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_unit_id":"213127849","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"5389276","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0626AW701172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:04.000000Z","updated_at":"2026-05-02T09:02:11.000000Z"},{"id":20242380,"change_date":"2026-04-21 21:38:00","inspection_id":"87566376","insp_unit_id":"213127848","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75725A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJA6AV72LJ19852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:04.000000Z","updated_at":"2026-05-02T09:02:11.000000Z"}]},{"id":11280247,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","dot_number":"1586421","report_state":"CT","report_number":"3079004221","insp_date":"2026-03-04 00:00:00","insp_start_time":"0902","insp_end_time":"1119","registration_date":"2026-03-19 00:00:00","region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RETAIL SERVICES & SYSTEMS INC","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":"2026-03-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"12","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"766874","transaction_code":"C","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01586421","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-04 21:40:00","insp_carrier_name":"RAV TRUCKING LLC","insp_carrier_street":"347 CHESTNUT HILL ROAD","insp_carrier_city":"COLCHESTER","insp_carrier_state":"CT","insp_carrier_zip_code":"06415","insp_colonia":null,"docket_number":"587323","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-07T10:38:57.000000Z","updated_at":"2026-03-30T09:30:04.000000Z","inspection_violations":[{"id":19244354,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486653","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V137952-5","created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"3922SLL"},{"id":19244355,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486654","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"3922SLLEQP"},{"id":19244356,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486655","seq_no":"3","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"39311A1CSURR"},{"id":19244357,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486656","seq_no":"4","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"3939ALHLI"},{"id":19244358,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486657","seq_no":"5","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"3939ALFTSI"},{"id":19244359,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486658","seq_no":"6","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"3939ALRLI"},{"id":19244360,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486659","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"3922SLLSR"},{"id":19244361,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486660","seq_no":"8","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"212209290","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V137952-5","created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"3939ALSLIWR"},{"id":19244362,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486661","seq_no":"9","part_no":"393","part_no_section":"209D-STPAL","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V137952-5","created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"393209DSTPAL"},{"id":19244363,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486662","seq_no":"10","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V137952-5","created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"39345B2BHTD"},{"id":19244364,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486663","seq_no":"11","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"3969D2FTF"},{"id":19244365,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_violation_id":"272486664","seq_no":"12","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"212209289","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:28.000000Z","updated_at":"2026-03-30T09:53:58.000000Z","normalized_code":"393203CCBP"}],"inspection_per_units":[{"id":19546889,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_unit_id":"212209289","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1313","insp_unit_license":"75725A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJA6AV72LJ19852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:20.000000Z","updated_at":"2026-03-30T09:04:35.000000Z"},{"id":19546890,"change_date":"2026-03-19 21:38:00","inspection_id":"87194874","insp_unit_id":"212209290","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"513442","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1GRAA06247W704788","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:20.000000Z","updated_at":"2026-03-30T09:04:35.000000Z"}]},{"id":10255196,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","dot_number":"1586421","report_state":"CT","report_number":"3075004169","insp_date":"2025-11-21 00:00:00","insp_start_time":"0737","insp_end_time":"0808","registration_date":"2025-12-26 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RAV TRUCKING LLC","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":"2025-11-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"758473","transaction_code":"C","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01586421","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-21 21:38:00","insp_carrier_name":"RAV TRUCKING LLC","insp_carrier_street":"347 CHESTNUT HILL ROAD","insp_carrier_city":"COLCHESTER","insp_carrier_state":"CT","insp_carrier_zip_code":"06415","insp_colonia":null,"docket_number":"587323","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:35.000000Z","updated_at":"2026-01-06T10:30:04.000000Z","inspection_violations":[{"id":17656858,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","insp_violation_id":"270894413","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"210799733","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-29T10:41:22.000000Z","updated_at":"2026-01-06T10:30:07.000000Z","normalized_code":"3922SLLIRP"},{"id":17656859,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","insp_violation_id":"270894414","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210799733","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-29T10:41:22.000000Z","updated_at":"2026-01-06T10:30:07.000000Z","normalized_code":"3939ALHLI"},{"id":17656860,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","insp_violation_id":"270894415","seq_no":"3","part_no":"393","part_no_section":"45C-BSG","insp_viol_unit":"1","insp_unit_id":"210799733","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-29T10:41:22.000000Z","updated_at":"2026-01-06T10:30:07.000000Z","normalized_code":"39345CBSG"},{"id":17656861,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","insp_violation_id":"270894416","seq_no":"4","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"210799733","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-29T10:41:22.000000Z","updated_at":"2026-01-06T10:30:07.000000Z","normalized_code":"3939ALBL"},{"id":17656862,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","insp_violation_id":"270894417","seq_no":"5","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"210799733","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-29T10:41:22.000000Z","updated_at":"2026-01-06T10:30:07.000000Z","normalized_code":"39311A1CSLRR"},{"id":17656863,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","insp_violation_id":"270894418","seq_no":"6","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"210799733","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-29T10:41:22.000000Z","updated_at":"2026-01-06T10:30:07.000000Z","normalized_code":"39345B2BAIR"},{"id":17656864,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","insp_violation_id":"270894419","seq_no":"7","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"210799734","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-29T10:41:22.000000Z","updated_at":"2026-01-06T10:30:07.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":17612416,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","insp_unit_id":"210799733","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"75725A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJA6AV72LJ19852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-29T10:11:15.000000Z","updated_at":"2026-01-06T10:00:06.000000Z"},{"id":17612417,"change_date":"2025-12-26 21:33:00","inspection_id":"86378589","insp_unit_id":"210799734","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"22","insp_unit_license":"5389276","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0626AW701172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-29T10:11:15.000000Z","updated_at":"2026-01-06T10:00:06.000000Z"}]},{"id":5894272,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","dot_number":"1586421","report_state":"MA","report_number":"CW00002943","insp_date":"2024-06-01 00:00:00","insp_start_time":"0611","insp_end_time":"0635","registration_date":null,"region":"ET","ci_status_code":"C","location":"141H","location_desc":"H-HATFIELD","county_code_state":"MA","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"C&S","shipping_paper_number":"476128017","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-06-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"492923","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01586421","upload_search_indicator":"M","census_search_date":"2024-06-03 21:42:00","snet_input_date":"2024-06-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"RAV TRUCKING LLC","insp_carrier_street":"347 CHESTNUT HILL ROAD","insp_carrier_city":"COLCHESTER","insp_carrier_state":"CT","insp_carrier_zip_code":"06415","insp_colonia":null,"docket_number":"5873","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:29.000000Z","updated_at":"2025-03-17T20:19:29.000000Z","inspection_violations":[{"id":9139052,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_violation_id":"259855449","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201194258","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3922"},{"id":9139053,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_violation_id":"259855450","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201194258","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3922"},{"id":9139054,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_violation_id":"259855451","seq_no":"3","part_no":"399","part_no_section":"207","insp_viol_unit":"1","insp_unit_id":"201194258","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"399207"},{"id":9139055,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_violation_id":"259855452","seq_no":"4","part_no":"393","part_no_section":"60(b)","insp_viol_unit":"1","insp_unit_id":"201194258","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39360B"},{"id":9139056,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_violation_id":"259855453","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201194259","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3922"},{"id":9139057,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_violation_id":"259855454","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201194259","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3939A"},{"id":9139058,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_violation_id":"259855455","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201194259","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3939A"},{"id":9139059,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_violation_id":"259855456","seq_no":"8","part_no":"393","part_no_section":"25(f)","insp_viol_unit":"2","insp_unit_id":"201194259","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39325F"}],"inspection_per_units":[{"id":9493901,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_unit_id":"201194258","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"75502A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1XP50B9XXY0551075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"},{"id":9493902,"change_date":"2024-06-03 21:42:00","inspection_id":"81767306","insp_unit_id":"201194259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2827634","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA96263W044901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"}]},{"id":5701245,"change_date":"2024-05-08 21:42:00","inspection_id":"81558292","dot_number":"1586421","report_state":"PA","report_number":"E937412894","insp_date":"2024-05-07 00:00:00","insp_start_time":"0634","insp_end_time":"0727","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I78 W MM 70.0","county_code_state":"PA","county_code":"095","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"6","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2439753","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01586421","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-07 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-05-08 21:42:00","insp_carrier_name":"RAV TRUCKING LLC","insp_carrier_street":"347 CHESTNUT HILL ROAD","insp_carrier_city":"COLCHESTER","insp_carrier_state":"CT","insp_carrier_zip_code":"06415","insp_colonia":null,"docket_number":"587323","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:51.000000Z","updated_at":"2025-03-17T20:15:51.000000Z","inspection_violations":[{"id":8818892,"change_date":"2024-05-08 21:42:00","inspection_id":"81558292","insp_violation_id":"259387886","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":"TA0012025-6","created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3922"},{"id":8818893,"change_date":"2024-05-08 21:42:00","inspection_id":"81558292","insp_violation_id":"259387887","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:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3922"},{"id":8818894,"change_date":"2024-05-08 21:42:00","inspection_id":"81558292","insp_violation_id":"259387888","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200794415","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0012026-0","created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39021TB"},{"id":8818895,"change_date":"2024-05-08 21:42:00","inspection_id":"81558292","insp_violation_id":"259387889","seq_no":"4","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3958A1"},{"id":8818896,"change_date":"2024-05-08 21:42:00","inspection_id":"81558292","insp_violation_id":"259387890","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200794415","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3922"},{"id":8818897,"change_date":"2024-05-08 21:42:00","inspection_id":"81558292","insp_violation_id":"259387891","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200794416","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0012027-1","created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9182847,"change_date":"2024-05-08 21:42:00","inspection_id":"81558292","insp_unit_id":"200794415","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"75502A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1XP50B9XXY0551075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:27.000000Z","updated_at":"2025-03-17T23:18:27.000000Z"},{"id":9182848,"change_date":"2024-05-08 21:42:00","inspection_id":"81558292","insp_unit_id":"200794416","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2827634","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA96263W044901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:27.000000Z","updated_at":"2025-03-17T23:18:27.000000Z"}]},{"id":5505450,"change_date":"2024-08-22 21:41:00","inspection_id":"81344939","dot_number":"1586421","report_state":"CT","report_number":"1229001120","insp_date":"2024-04-15 00:00:00","insp_start_time":"1216","insp_end_time":"1247","registration_date":"2024-08-22 00:00:00","region":"ET","ci_status_code":"C","location":null,"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":"2024-04-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"78840","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":"704892","transaction_code":"C","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01586421","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-15 21:40:00","insp_carrier_name":"RAV TRUCKING LLC","insp_carrier_street":"347 CHESTNUT HILL ROAD","insp_carrier_city":"COLCHESTER","insp_carrier_state":"CT","insp_carrier_zip_code":"06415","insp_colonia":null,"docket_number":"587323","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:55.000000Z","updated_at":"2025-03-17T20:11:55.000000Z","inspection_violations":[{"id":8505106,"change_date":"2024-08-22 21:41:00","inspection_id":"81344939","insp_violation_id":"261333911","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202520127","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:13.000000Z","updated_at":"2025-03-17T21:47:13.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8868368,"change_date":"2024-08-22 21:41:00","inspection_id":"81344939","insp_unit_id":"202520127","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"345","insp_unit_license":"75502A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1XP50B9XXY0551075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:29.000000Z","updated_at":"2025-03-17T23:15:29.000000Z"},{"id":8868369,"change_date":"2024-08-22 21:41:00","inspection_id":"81344939","insp_unit_id":"202520128","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4800","insp_unit_license":"2827634","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA96263W044901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:29.000000Z","updated_at":"2025-03-17T23:15:29.000000Z"}]},{"id":5454219,"change_date":"2024-07-05 21:35:00","inspection_id":"81288792","dot_number":"1586421","report_state":"CT","report_number":"3017001547","insp_date":"2024-04-08 00:00:00","insp_start_time":"0150","insp_end_time":"0225","registration_date":"2024-07-05 00:00:00","region":"ET","ci_status_code":"C","location":"107","location_desc":"ORANGE","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COCA COLA","shipping_paper_number":"309330096","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-04-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"704302","transaction_code":"C","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01586421","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-08 21:43:00","insp_carrier_name":"RAV TRUCKING LLC","insp_carrier_street":"347 CHESTNUT HILL ROAD","insp_carrier_city":"COLCHESTER","insp_carrier_state":"CT","insp_carrier_zip_code":"06415","insp_colonia":null,"docket_number":"587323","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:43.000000Z","updated_at":"2025-03-17T20:10:43.000000Z","inspection_violations":[{"id":8418153,"change_date":"2024-07-05 21:35:00","inspection_id":"81288792","insp_violation_id":"260475117","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V127147-1","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3922"},{"id":8418154,"change_date":"2024-07-05 21:35:00","inspection_id":"81288792","insp_violation_id":"260475118","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":"V127147-1","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8785632,"change_date":"2024-07-05 21:35:00","inspection_id":"81288792","insp_unit_id":"201739253","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75725A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJA6AV72LJ19852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:43.000000Z","updated_at":"2025-03-17T23:14:43.000000Z"},{"id":8785633,"change_date":"2024-07-05 21:35:00","inspection_id":"81288792","insp_unit_id":"201739254","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"305897","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1FUJA6AV72LJ19852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:43.000000Z","updated_at":"2025-03-17T23:14:43.000000Z"}]},{"id":1083185,"change_date":"2022-08-19 21:35:00","inspection_id":"76374718","dot_number":"1586421","report_state":"MA","report_number":"CE00005857","insp_date":"2022-08-18 00:00:00","insp_start_time":"1745","insp_end_time":"1815","registration_date":null,"region":"ET","ci_status_code":"C","location":"236S","location_desc":"S-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":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":"2022-08-19 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"450584","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01586421","upload_search_indicator":"M","census_search_date":"2022-08-19 21:35:00","snet_input_date":"2022-08-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-19 21:35:00","insp_carrier_name":"RAV TRUCKING LLC","insp_carrier_street":"347 CHESTNUT HILL ROAD","insp_carrier_city":"COLCHESTER","insp_carrier_state":"CT","insp_carrier_zip_code":"06415","insp_colonia":null,"docket_number":"5873","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:52.000000Z","updated_at":"2025-03-17T18:46:52.000000Z","inspection_violations":[{"id":1707526,"change_date":"2022-08-19 21:35:00","inspection_id":"76374718","insp_violation_id":"247844215","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:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"3922"},{"id":1707527,"change_date":"2022-08-19 21:35:00","inspection_id":"76374718","insp_violation_id":"247844216","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190418422","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"3922"},{"id":1707528,"change_date":"2022-08-19 21:35:00","inspection_id":"76374718","insp_violation_id":"247844217","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190418422","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"560665AB","created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1742158,"change_date":"2022-08-19 21:35:00","inspection_id":"76374718","insp_unit_id":"190418422","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"63001A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FUJCRCK67PX66550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:59.000000Z","updated_at":"2025-03-17T22:18:59.000000Z"},{"id":1742159,"change_date":"2022-08-19 21:35:00","inspection_id":"76374718","insp_unit_id":"190418423","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"256693C","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS25319M7017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:59.000000Z","updated_at":"2025-03-17T22:18:59.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1586421\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1586421\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1586421\/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\/1586421\/inspections","per_page":100,"prev_page_url":null,"to":9,"total":9}