{"current_page":1,"data":[{"id":11951968,"change_date":"2026-05-28 21:41:00","inspection_id":"87887699","dot_number":"2007149","report_state":"MA","report_number":"CW00004436","insp_date":"2026-05-18 00:00:00","insp_start_time":"1444","insp_end_time":"1502","registration_date":"2026-05-28 00:00:00","region":"ES","ci_status_code":"C","location":"383S","location_desc":"MA","county_code_state":"MA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"22492","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":"3356151","transaction_code":"C","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":null,"census_search_date":"2026-05-18 21:39:00","snet_input_date":"2026-05-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-18 21:39:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-21T09:41:09.000000Z","updated_at":"2026-06-08T09:30:09.000000Z","inspection_violations":[{"id":20787996,"change_date":"2026-05-28 21:41:00","inspection_id":"87887699","insp_violation_id":"274550286","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-21T10:02:23.000000Z","updated_at":"2026-06-08T09:42:35.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":20782261,"change_date":"2026-05-28 21:41:00","inspection_id":"87887699","insp_unit_id":"213791471","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"W14289","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GBE5C1918F407201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-21T09:20:34.000000Z","updated_at":"2026-06-08T09:01:06.000000Z"},{"id":20782262,"change_date":"2026-05-28 21:41:00","inspection_id":"87887699","insp_unit_id":"213791472","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":null,"insp_unit_license":"TZ743F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"MATR1702506208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-21T09:20:34.000000Z","updated_at":"2026-06-08T09:01:06.000000Z"}]},{"id":11461609,"change_date":"2026-03-24 21:40:00","inspection_id":"87379624","dot_number":"2007149","report_state":"VT","report_number":"62A0000850","insp_date":"2026-02-03 00:00:00","insp_start_time":"0931","insp_end_time":"0937","registration_date":null,"region":"ES","ci_status_code":"C","location":"1408","location_desc":"VT","county_code_state":"VT","county_code":"027","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":"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":"U","pen_cen_match":"I","final_status_date":"2026-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"3057725","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:18.000000Z","updated_at":"2026-04-04T09:30:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19632174,"change_date":"2026-03-24 21:40:00","inspection_id":"87379624","insp_unit_id":"212302700","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"143","insp_unit_license":"1AG76Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0XXHM414370","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:22:57.000000Z","updated_at":"2026-04-04T09:04:01.000000Z"}]},{"id":10175758,"change_date":"2025-11-12 21:40:00","inspection_id":"86295336","dot_number":"2007149","report_state":"MA","report_number":"DT00000559","insp_date":"2025-11-12 00:00:00","insp_start_time":"0635","insp_end_time":"0652","registration_date":null,"region":"ET","ci_status_code":"C","location":"178H","location_desc":"H-LUDLOW","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"533557","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-11-12 21:40:00","snet_input_date":"2025-11-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-11-12 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:36.000000Z","updated_at":"2025-11-16T10:30:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16945526,"change_date":"2025-11-12 21:40:00","inspection_id":"86295336","insp_unit_id":"209968741","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"V11823","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0X1HM411812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:31.000000Z","updated_at":"2025-11-16T10:00:39.000000Z"}]},{"id":10064516,"change_date":"2025-10-29 21:40:00","inspection_id":"86177943","dot_number":"2007149","report_state":"MA","report_number":"CW00004091","insp_date":"2025-10-28 00:00:00","insp_start_time":"1555","insp_end_time":"1615","registration_date":null,"region":"ET","ci_status_code":"C","location":"123S","location_desc":"S-GOSHEN","county_code_state":"MA","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"532498","transaction_code":"A","transaction_date":"2025-10-29 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-10-29 21:40:00","snet_input_date":"2025-10-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-29 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:25.000000Z","updated_at":"2025-11-02T11:00:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16728797,"change_date":"2025-10-29 21:40:00","inspection_id":"86177943","insp_unit_id":"209714247","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"X51615","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HN4REC25283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:01.000000Z","updated_at":"2025-11-02T10:46:05.000000Z"}]},{"id":9863653,"change_date":"2025-10-06 21:40:00","inspection_id":"85966272","dot_number":"2007149","report_state":"MA","report_number":"CW00004047","insp_date":"2025-10-03 00:00:00","insp_start_time":"1730","insp_end_time":"1940","registration_date":null,"region":"ET","ci_status_code":"C","location":"016S","location_desc":"S-ASHFIELD","county_code_state":"MA","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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":"2025-10-06 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"160000","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":"530649","transaction_code":"A","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-10-06 21:40:00","snet_input_date":"2025-10-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-06 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:47.000000Z","updated_at":"2025-10-10T10:00:54.000000Z","inspection_violations":[{"id":16252269,"change_date":"2025-10-06 21:40:00","inspection_id":"85966272","insp_violation_id":"269118047","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"1","insp_unit_id":"209314696","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"740492AD","created_at":"2025-10-09T10:16:09.000000Z","updated_at":"2025-10-10T10:16:32.000000Z","normalized_code":"3922SLLED"},{"id":16252270,"change_date":"2025-10-06 21:40:00","inspection_id":"85966272","insp_violation_id":"269118048","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"209314696","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"740492AD","created_at":"2025-10-09T10:16:09.000000Z","updated_at":"2025-10-10T10:16:32.000000Z","normalized_code":"3922SLLEWG3"},{"id":16252271,"change_date":"2025-10-06 21:40:00","inspection_id":"85966272","insp_violation_id":"269118049","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"209314696","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"740492AD","created_at":"2025-10-09T10:16:09.000000Z","updated_at":"2025-10-10T10:16:32.000000Z","normalized_code":"3922SLLEWA3"},{"id":16252272,"change_date":"2025-10-06 21:40:00","inspection_id":"85966272","insp_violation_id":"269118050","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"209314696","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"740492AD","created_at":"2025-10-09T10:16:09.000000Z","updated_at":"2025-10-10T10:16:32.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":16360735,"change_date":"2025-10-06 21:40:00","inspection_id":"85966272","insp_unit_id":"209314696","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AK66C","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPCP4EX0ND793157","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:44.000000Z","updated_at":"2025-10-10T09:46:11.000000Z"},{"id":16360736,"change_date":"2025-10-06 21:40:00","inspection_id":"85966272","insp_unit_id":"209314697","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LIDD","insp_unit_company":null,"insp_unit_license":"3216463","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1L94L5339MB564058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:44.000000Z","updated_at":"2025-10-10T09:46:11.000000Z"}]},{"id":9630046,"change_date":"2025-09-09 21:40:00","inspection_id":"85721075","dot_number":"2007149","report_state":"MA","report_number":"EP00000047","insp_date":"2025-09-08 00:00:00","insp_start_time":"1551","insp_end_time":"1619","registration_date":null,"region":"ET","ci_status_code":"C","location":"1","location_desc":"I91 NORTHAMPTON","county_code_state":"MA","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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":"2025-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"528157","transaction_code":"A","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-09-09 21:40:00","snet_input_date":"2025-09-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-09 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:05.000000Z","updated_at":"2025-09-13T10:46:39.000000Z","inspection_violations":[{"id":15755466,"change_date":"2025-09-09 21:40:00","inspection_id":"85721075","insp_violation_id":"268549631","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"2","insp_unit_id":"208823975","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"688134AD","created_at":"2025-09-12T10:51:21.000000Z","updated_at":"2025-09-13T10:49:10.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":15908649,"change_date":"2025-09-09 21:40:00","inspection_id":"85721075","insp_unit_id":"208823974","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"110","insp_unit_license":"1AC55D","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0X8GM325475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:44.000000Z","updated_at":"2025-09-13T09:59:26.000000Z"},{"id":15908650,"change_date":"2025-09-09 21:40:00","inspection_id":"85721075","insp_unit_id":"208823975","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CEEZ","insp_unit_company":null,"insp_unit_license":"TZ7668D","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"4CZPE3719J127H075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:44.000000Z","updated_at":"2025-09-13T09:59:26.000000Z"}]},{"id":9352300,"change_date":"2025-08-18 21:39:00","inspection_id":"85429468","dot_number":"2007149","report_state":"MA","report_number":"EP00000022","insp_date":"2025-08-06 00:00:00","insp_start_time":"1452","insp_end_time":"1512","registration_date":null,"region":"ET","ci_status_code":"C","location":"2","location_desc":"RT 291 CHICOPEE","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"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":"2025-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"525137","transaction_code":"C","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:40.000000Z","updated_at":"2025-08-23T10:45:32.000000Z","inspection_violations":[{"id":15357767,"change_date":"2025-08-18 21:39:00","inspection_id":"85429468","insp_violation_id":"268086408","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"208445306","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:19.000000Z","updated_at":"2025-08-22T10:43:18.000000Z","normalized_code":"3922SLLTL"},{"id":15357768,"change_date":"2025-08-18 21:39:00","inspection_id":"85429468","insp_violation_id":"268086409","seq_no":"2","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"208445306","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:19.000000Z","updated_at":"2025-08-22T10:43:18.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":15555303,"change_date":"2025-08-18 21:39:00","inspection_id":"85429468","insp_unit_id":"208445306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"145","insp_unit_license":"1AG742","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPCXPEX8MD742127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:32.000000Z","updated_at":"2025-08-22T09:45:26.000000Z"}]},{"id":8958877,"change_date":"2025-06-23 21:40:00","inspection_id":"85015481","dot_number":"2007149","report_state":"MA","report_number":"CW00003871","insp_date":"2025-06-18 00:00:00","insp_start_time":"1628","insp_end_time":"1650","registration_date":null,"region":"ET","ci_status_code":"C","location":"231S","location_desc":"S-NORTH ADAMS","county_code_state":"MA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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":"2025-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"521037","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-06-23 21:40:00","snet_input_date":"2025-06-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-06-23 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:29.000000Z","updated_at":"2025-06-28T10:00:29.000000Z","inspection_violations":[{"id":14389451,"change_date":"2025-06-23 21:40:00","inspection_id":"85015481","insp_violation_id":"266982435","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"207502749","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:15:50.000000Z","updated_at":"2025-06-27T10:17:28.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":14685757,"change_date":"2025-06-23 21:40:00","inspection_id":"85015481","insp_unit_id":"207502749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W31787","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT8LDA01255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:32.000000Z","updated_at":"2025-06-27T09:45:40.000000Z"}]},{"id":8871255,"change_date":"2025-06-11 21:42:00","inspection_id":"84922175","dot_number":"2007149","report_state":"MA","report_number":"CW00003854","insp_date":"2025-06-11 00:00:00","insp_start_time":"0522","insp_end_time":"0540","registration_date":null,"region":"ET","ci_status_code":"C","location":"123S","location_desc":"S-GOSHEN","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":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"520069","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:59.000000Z","updated_at":"2025-06-15T10:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14529746,"change_date":"2025-06-11 21:42:00","inspection_id":"84922175","insp_unit_id":"207330287","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"141","insp_unit_license":"X69577","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT9RDA00463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:09.000000Z","updated_at":"2025-06-15T09:45:42.000000Z"}]},{"id":8603690,"change_date":"2025-05-12 21:40:00","inspection_id":"84639486","dot_number":"2007149","report_state":"MA","report_number":"CW00003756","insp_date":"2025-05-07 00:00:00","insp_start_time":"0944","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"082S","location_desc":"S-DALTON","county_code_state":"MA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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":"2025-05-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"516462","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-05-12 21:40:00","snet_input_date":"2025-05-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-12 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-15T10:01:08.000000Z","updated_at":"2025-05-17T10:04:50.000000Z","inspection_violations":[{"id":13672301,"change_date":"2025-05-12 21:40:00","inspection_id":"84639486","insp_violation_id":"266159603","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"403388AD","created_at":"2025-05-15T10:19:37.000000Z","updated_at":"2025-05-16T10:25:01.000000Z","normalized_code":"39216D"},{"id":13672302,"change_date":"2025-05-12 21:40:00","inspection_id":"84639486","insp_violation_id":"266159604","seq_no":"2","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"403388AD","created_at":"2025-05-15T10:19:37.000000Z","updated_at":"2025-05-16T10:25:01.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":14045445,"change_date":"2025-05-12 21:40:00","inspection_id":"84639486","insp_unit_id":"206803662","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"145","insp_unit_license":"1AG74Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPCXPEX8MD742127","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:13.000000Z","updated_at":"2025-05-16T09:50:06.000000Z"}]},{"id":8472055,"change_date":"2025-04-28 21:35:00","inspection_id":"84500702","dot_number":"2007149","report_state":"MA","report_number":"CW00003734","insp_date":"2025-04-28 00:00:00","insp_start_time":"0758","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":"374H","location_desc":"H-WHATLEY","county_code_state":"MA","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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":"2025-04-28 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"515905","transaction_code":"A","transaction_date":"2025-04-28 00:00:00","upload_date":"2025-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-04-28 21:35:00","snet_input_date":"2025-04-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-28 21:35:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-01T10:00:41.000000Z","updated_at":"2025-05-02T10:22:09.000000Z","inspection_violations":[{"id":13395386,"change_date":"2025-04-28 21:35:00","inspection_id":"84500702","insp_violation_id":"265837226","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-01T10:16:11.000000Z","updated_at":"2025-05-02T10:40:48.000000Z","normalized_code":"39216AD"},{"id":13395387,"change_date":"2025-04-28 21:35:00","inspection_id":"84500702","insp_violation_id":"265837227","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","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-05-01T10:16:11.000000Z","updated_at":"2025-05-02T10:40:48.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":13766127,"change_date":"2025-04-28 21:35:00","inspection_id":"84500702","insp_unit_id":"206496545","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"100","insp_unit_license":"5632B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMSAAR78H644044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-01T09:46:03.000000Z","updated_at":"2025-05-02T09:50:13.000000Z"}]},{"id":8080221,"change_date":"2025-03-11 21:40:00","inspection_id":"84088199","dot_number":"2007149","report_state":"MA","report_number":"CW00003636","insp_date":"2025-03-10 00:00:00","insp_start_time":"1610","insp_end_time":"1625","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":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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":"2025-03-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"511770","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-03-11 21:40:00","snet_input_date":"2025-03-10 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-03-11 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:14.000000Z","updated_at":"2025-03-17T21:06:14.000000Z","inspection_violations":[{"id":12628761,"change_date":"2025-03-11 21:40:00","inspection_id":"84088199","insp_violation_id":"264940929","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205728377","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:49.000000Z","updated_at":"2025-03-17T22:07:49.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13046131,"change_date":"2025-03-11 21:40:00","inspection_id":"84088199","insp_unit_id":"205728377","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AC55D","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0X8GM325475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:14.000000Z","updated_at":"2025-03-17T23:59:14.000000Z"}]},{"id":7953288,"change_date":"2025-02-25 21:40:00","inspection_id":"83954746","dot_number":"2007149","report_state":"MA","report_number":"CW00003591","insp_date":"2025-02-24 00:00:00","insp_start_time":"1654","insp_end_time":"1710","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":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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":"2025-02-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"510453","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-02-25 21:40:00","snet_input_date":"2025-02-24 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-02-25 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:17.000000Z","updated_at":"2025-03-17T21:03:17.000000Z","inspection_violations":[{"id":12427922,"change_date":"2025-02-25 21:40:00","inspection_id":"83954746","insp_violation_id":"264684091","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"205484730","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:44.000000Z","updated_at":"2025-03-17T22:06:44.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":12839030,"change_date":"2025-02-25 21:40:00","inspection_id":"83954746","insp_unit_id":"205484730","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"X13170","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HN0NEF50247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:48.000000Z","updated_at":"2025-03-17T23:56:48.000000Z"}]},{"id":7772127,"change_date":"2025-02-03 21:39:00","inspection_id":"83764674","dot_number":"2007149","report_state":"MA","report_number":"DT00000014","insp_date":"2025-01-31 00:00:00","insp_start_time":"1429","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":"151H","location_desc":"H-HOLYOKE","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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":"2025-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"79500","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":"508568","transaction_code":"A","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2025-02-03 21:39:00","snet_input_date":"2025-01-31 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-02-03 21:39:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:33.000000Z","updated_at":"2025-03-17T20:59:33.000000Z","inspection_violations":[{"id":12144651,"change_date":"2025-02-03 21:39:00","inspection_id":"83764674","insp_violation_id":"264306072","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"205128982","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":12543265,"change_date":"2025-02-03 21:39:00","inspection_id":"83764674","insp_unit_id":"205128982","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"129","insp_unit_license":"1AE14A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPCX4EX8HD420219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:31.000000Z","updated_at":"2025-03-17T23:53:31.000000Z"}]},{"id":7437539,"change_date":"2024-12-17 21:39:00","inspection_id":"83413164","dot_number":"2007149","report_state":"MA","report_number":"CW00003423","insp_date":"2024-12-16 00:00:00","insp_start_time":"1620","insp_end_time":"1635","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":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"505394","transaction_code":"A","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2024-12-17 21:39:00","snet_input_date":"2024-12-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-12-17 21:39:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:11.000000Z","updated_at":"2025-03-17T20:51:11.000000Z","inspection_violations":[{"id":11622515,"change_date":"2024-12-17 21:39:00","inspection_id":"83413164","insp_violation_id":"263513043","seq_no":"1","part_no":"392","part_no_section":"5A1-I","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"10","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:37.000000Z","updated_at":"2025-03-17T22:02:37.000000Z","normalized_code":"3925A1I"},{"id":11622516,"change_date":"2024-12-17 21:39:00","inspection_id":"83413164","insp_violation_id":"263513044","seq_no":"2","part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"204427195","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:37.000000Z","updated_at":"2025-03-17T22:02:37.000000Z","normalized_code":"177834AHMC"}],"inspection_per_units":[{"id":11998921,"change_date":"2024-12-17 21:39:00","inspection_id":"83413164","insp_unit_id":"204427195","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"X13170","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HN0NEF50247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:27.000000Z","updated_at":"2025-03-17T23:47:27.000000Z"}]},{"id":7217588,"change_date":"2024-11-18 21:40:00","inspection_id":"83181497","dot_number":"2007149","report_state":"VT","report_number":"51A0000896","insp_date":"2024-11-15 00:00:00","insp_start_time":"1004","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"0208","location_desc":"RT 7 POWNAL PULL OFF","county_code_state":"VT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"211860","transaction_code":"A","transaction_date":"2024-11-15 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-15 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-11-18 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"707924","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:30.000000Z","updated_at":"2025-03-17T20:46:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11641677,"change_date":"2024-11-18 21:40:00","inspection_id":"83181497","insp_unit_id":"203928356","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"93","insp_unit_license":"V76875","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDNF6AY9KDF04145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:39.000000Z","updated_at":"2025-03-17T23:43:39.000000Z"}]},{"id":6259667,"change_date":"2024-07-19 21:37:00","inspection_id":"82161595","dot_number":"2007149","report_state":"MA","report_number":"CW00003079","insp_date":"2024-07-18 00:00:00","insp_start_time":"1645","insp_end_time":"1705","registration_date":null,"region":"ET","ci_status_code":"C","location":"123S","location_desc":"S-GOSHEN","county_code_state":"MA","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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-07-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"17000","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":"496075","transaction_code":"A","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:40.000000Z","updated_at":"2025-03-17T20:26:40.000000Z","inspection_violations":[{"id":9723301,"change_date":"2024-07-19 21:37:00","inspection_id":"82161595","insp_violation_id":"260732122","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10085519,"change_date":"2024-07-19 21:37:00","inspection_id":"82161595","insp_unit_id":"201967891","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T32648","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X4HT5HEF40374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"}]},{"id":6184257,"change_date":"2024-07-10 21:40:00","inspection_id":"82080763","dot_number":"2007149","report_state":"MA","report_number":"CW00003055","insp_date":"2024-07-09 00:00:00","insp_start_time":"1627","insp_end_time":"1645","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":"SAME","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":"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-07-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"495573","transaction_code":"A","transaction_date":"2024-07-10 00:00:00","upload_date":"2024-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2024-07-10 21:40:00","snet_input_date":"2024-07-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-07-10 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:21.000000Z","updated_at":"2025-03-17T20:25:21.000000Z","inspection_violations":[{"id":9603472,"change_date":"2024-07-10 21:40:00","inspection_id":"82080763","insp_violation_id":"260560483","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:30.000000Z","updated_at":"2025-03-17T21:52:30.000000Z","normalized_code":"39216A"},{"id":9603473,"change_date":"2024-07-10 21:40:00","inspection_id":"82080763","insp_violation_id":"260560484","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:30.000000Z","updated_at":"2025-03-17T21:52:30.000000Z","normalized_code":"39141A"},{"id":9603474,"change_date":"2024-07-10 21:40:00","inspection_id":"82080763","insp_violation_id":"260560485","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"201813583","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:30.000000Z","updated_at":"2025-03-17T21:52:30.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":9962697,"change_date":"2024-07-10 21:40:00","inspection_id":"82080763","insp_unit_id":"201813583","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T32648","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X4HT5HEF40374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:14.000000Z","updated_at":"2025-03-17T23:26:14.000000Z"}]},{"id":5826059,"change_date":"2024-05-23 21:41:00","inspection_id":"81693692","dot_number":"2007149","report_state":"MA","report_number":"CW00002915","insp_date":"2024-05-23 00:00:00","insp_start_time":"0730","insp_end_time":"0750","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"492342","transaction_code":"A","transaction_date":"2024-05-23 00:00:00","upload_date":"2024-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2024-05-23 21:41:00","snet_input_date":"2024-05-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-05-23 21:41:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:15.000000Z","updated_at":"2025-03-17T20:18:15.000000Z","inspection_violations":[{"id":9027030,"change_date":"2024-05-23 21:41:00","inspection_id":"81693692","insp_violation_id":"259690658","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9383072,"change_date":"2024-05-23 21:41:00","inspection_id":"81693692","insp_unit_id":"201051254","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"V11823","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0X1HM411812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:24.000000Z","updated_at":"2025-03-17T23:20:24.000000Z"}]},{"id":4834431,"change_date":"2024-01-16 21:44:00","inspection_id":"80612226","dot_number":"2007149","report_state":"MA","report_number":"CE00006773","insp_date":"2024-01-15 00:00:00","insp_start_time":"1318","insp_end_time":"1339","registration_date":null,"region":"ET","ci_status_code":"C","location":"086H","location_desc":"H-DEERFIELD","county_code_state":"MA","county_code":"011","insp_level_id":"2","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"59000","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":"482885","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2024-01-16 21:44:00","snet_input_date":"2024-01-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:28.000000Z","updated_at":"2025-03-17T19:58:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7778197,"change_date":"2024-01-16 21:44:00","inspection_id":"80612226","insp_unit_id":"198963216","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"62","insp_unit_license":"3866A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NPRLN0X88M755834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:30.000000Z","updated_at":"2025-03-17T23:05:30.000000Z"}]},{"id":4329293,"change_date":"2023-11-01 21:43:00","inspection_id":"80057561","dot_number":"2007149","report_state":"MA","report_number":"DR00000203","insp_date":"2023-11-01 00:00:00","insp_start_time":"0609","insp_end_time":"0625","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":"CARRIER","shipping_paper_number":"NA","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":"2023-11-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"17000","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":"477549","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2023-11-01 21:43:00","snet_input_date":"2023-11-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:44.000000Z","updated_at":"2025-03-17T19:48:44.000000Z","inspection_violations":[{"id":6696892,"change_date":"2023-11-01 21:43:00","inspection_id":"80057561","insp_violation_id":"256155024","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":"257547AC","created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6962469,"change_date":"2023-11-01 21:43:00","inspection_id":"80057561","insp_unit_id":"197847901","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T32648","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X4HT5HEF40374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:27.000000Z","updated_at":"2025-03-17T22:58:27.000000Z"}]},{"id":4298924,"change_date":"2023-10-27 21:42:00","inspection_id":"80024035","dot_number":"2007149","report_state":"MA","report_number":"CW00002217","insp_date":"2023-10-27 00:00:00","insp_start_time":"0545","insp_end_time":"0605","registration_date":null,"region":"ET","ci_status_code":"C","location":"151H","location_desc":"H-HOLYOKE","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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-10-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"17000","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":"1","hazmat_oos_total":"1","snet_sequence_id":"477279","transaction_code":"A","transaction_date":"2023-10-27 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2023-10-27 21:42:00","snet_input_date":"2023-10-27 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-27 21:42:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:55.000000Z","updated_at":"2025-03-17T19:47:55.000000Z","inspection_violations":[{"id":6650969,"change_date":"2023-10-27 21:42:00","inspection_id":"80024035","insp_violation_id":"256079872","seq_no":"1","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"197777531","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"177834A"}],"inspection_per_units":[{"id":6913969,"change_date":"2023-10-27 21:42:00","inspection_id":"80024035","insp_unit_id":"197777531","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V14218","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X4HT0KEC16143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:58.000000Z","updated_at":"2025-03-17T22:57:58.000000Z"}]},{"id":3783748,"change_date":"2023-09-11 21:39:00","inspection_id":"79451648","dot_number":"2007149","report_state":"MA","report_number":"CW00002002","insp_date":"2023-08-18 00:00:00","insp_start_time":"1425","insp_end_time":"1535","registration_date":"2023-09-11 00:00:00","region":"ET","ci_status_code":"C","location":"151H","location_desc":"H-HOLYOKE","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"79500","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":"472349","transaction_code":"C","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2023-08-21 21:41:00","snet_input_date":"2023-08-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-08-21 21:41:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:39.000000Z","updated_at":"2025-03-17T19:37:39.000000Z","inspection_violations":[{"id":5837302,"change_date":"2023-09-11 21:39:00","inspection_id":"79451648","insp_violation_id":"255182225","seq_no":"1","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196981028","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":6083933,"change_date":"2023-09-11 21:39:00","inspection_id":"79451648","insp_unit_id":"196981028","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AE14A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPCX4EX8HD420219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:07.000000Z","updated_at":"2025-03-17T22:51:07.000000Z"}]},{"id":3681575,"change_date":"2023-09-11 21:39:00","inspection_id":"79337929","dot_number":"2007149","report_state":"MA","report_number":"DA00001063","insp_date":"2023-07-28 00:00:00","insp_start_time":"1559","insp_end_time":"1613","registration_date":"2023-09-11 00:00:00","region":"ET","ci_status_code":"C","location":"085H","location_desc":"H-DEDHAM","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"471349","transaction_code":"C","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2023-08-07 21:41:00","snet_input_date":"2023-07-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-08-07 21:41:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","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":5676872,"change_date":"2023-09-11 21:39:00","inspection_id":"79337929","insp_violation_id":"255181943","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5919211,"change_date":"2023-09-11 21:39:00","inspection_id":"79337929","insp_unit_id":"196980879","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"R98184","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDAF57P47EB31797","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":3572217,"change_date":"2023-09-11 21:39:00","inspection_id":"79215169","dot_number":"2007149","report_state":"MA","report_number":"CW00001903","insp_date":"2023-07-21 00:00:00","insp_start_time":"1810","insp_end_time":"1825","registration_date":"2023-09-11 00:00:00","region":"ET","ci_status_code":"C","location":"082S","location_desc":"S-DALTON","county_code_state":"MA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"470669","transaction_code":"C","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2023-07-24 21:41:00","snet_input_date":"2023-07-21 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-07-24 21:41:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:33.000000Z","updated_at":"2025-03-17T19:33:33.000000Z","inspection_violations":[{"id":5508475,"change_date":"2023-09-11 21:39:00","inspection_id":"79215169","insp_violation_id":"255182221","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:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5743782,"change_date":"2023-09-11 21:39:00","inspection_id":"79215169","insp_unit_id":"196981026","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T49690","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD9X4HTXHED73193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:19.000000Z","updated_at":"2025-03-17T22:48:19.000000Z"}]},{"id":3147440,"change_date":"2023-05-26 21:39:00","inspection_id":"78736684","dot_number":"2007149","report_state":"MA","report_number":"CW00001708","insp_date":"2023-05-26 00:00:00","insp_start_time":"0630","insp_end_time":"0650","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":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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-05-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17000","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":"466769","transaction_code":"A","transaction_date":"2023-05-26 00:00:00","upload_date":"2023-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2023-05-26 21:39:00","snet_input_date":"2023-05-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-05-26 21:39:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:20.000000Z","updated_at":"2025-03-17T19:25:20.000000Z","inspection_violations":[{"id":4846093,"change_date":"2023-05-26 21:39:00","inspection_id":"78736684","insp_violation_id":"253094611","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"995304AB","created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5062168,"change_date":"2023-05-26 21:39:00","inspection_id":"78736684","insp_unit_id":"195156126","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"P33801","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDAX57P26EC73044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:54.000000Z","updated_at":"2025-03-17T22:42:54.000000Z"}]},{"id":2847569,"change_date":"2023-06-13 21:41:00","inspection_id":"78398041","dot_number":"2007149","report_state":"MA","report_number":"CW00001536","insp_date":"2023-04-10 00:00:00","insp_start_time":"1413","insp_end_time":"1422","registration_date":"2023-06-13 00:00:00","region":"ET","ci_status_code":"C","location":"082S","location_desc":"S-DALTON","county_code_state":"MA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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-04-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"464179","transaction_code":"C","transaction_date":"2023-04-20 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2023-04-20 21:41:00","snet_input_date":"2023-04-10 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-04-20 21:41:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:16.000000Z","updated_at":"2025-03-17T19:19:16.000000Z","inspection_violations":[{"id":4369146,"change_date":"2023-06-13 21:41:00","inspection_id":"78398041","insp_violation_id":"253459007","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":"909751AB","created_at":"2025-03-17T21:27:24.000000Z","updated_at":"2025-03-17T21:27:24.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4582296,"change_date":"2023-06-13 21:41:00","inspection_id":"78398041","insp_unit_id":"195459167","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"5179B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2FZHAZAS92AJ64829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:08.000000Z","updated_at":"2025-03-17T22:39:08.000000Z"}]},{"id":2629890,"change_date":"2023-04-03 21:39:00","inspection_id":"78150442","dot_number":"2007149","report_state":"MA","report_number":"CE00006193","insp_date":"2023-03-21 00:00:00","insp_start_time":"1615","insp_end_time":"1640","registration_date":"2023-04-03 00:00:00","region":"ET","ci_status_code":"C","location":"086S","location_desc":"S-DEERFIELD","county_code_state":"MA","county_code":"011","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":"2023-03-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"462514","transaction_code":"C","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2023-03-22 21:42:00","snet_input_date":"2023-03-21 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-03-22 21:42:00","insp_carrier_name":"JS RAE","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:11.000000Z","updated_at":"2025-03-17T19:15:11.000000Z","inspection_violations":[{"id":4043115,"change_date":"2023-04-03 21:39:00","inspection_id":"78150442","insp_violation_id":"251998657","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194179413","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"39617C"},{"id":4043116,"change_date":"2023-04-03 21:39:00","inspection_id":"78150442","insp_violation_id":"251998658","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"38323A2"},{"id":4043117,"change_date":"2023-04-03 21:39:00","inspection_id":"78150442","insp_violation_id":"251998659","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194179412","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4233621,"change_date":"2023-04-03 21:39:00","inspection_id":"78150442","insp_unit_id":"194179412","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V61409","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X4HT1KEG12789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:21.000000Z","updated_at":"2025-03-17T22:36:21.000000Z"},{"id":4233622,"change_date":"2023-04-03 21:39:00","inspection_id":"78150442","insp_unit_id":"194179413","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CAMS","insp_unit_company":null,"insp_unit_license":"F43379","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5JWCF192XMP522244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:21.000000Z","updated_at":"2025-03-17T22:36:21.000000Z"}]},{"id":1793109,"change_date":"2022-11-22 21:40:00","inspection_id":"77195266","dot_number":"2007149","report_state":"MA","report_number":"CW00001120","insp_date":"2022-11-21 00:00:00","insp_start_time":"1650","insp_end_time":"1710","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":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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-11-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"455865","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2022-11-22 21:40:00","snet_input_date":"2022-11-21 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-11-22 21:40:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:40.000000Z","updated_at":"2025-03-17T18:59:40.000000Z","inspection_violations":[{"id":2804817,"change_date":"2022-11-22 21:40:00","inspection_id":"77195266","insp_violation_id":"249732029","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":"687305AB","created_at":"2025-03-17T21:20:15.000000Z","updated_at":"2025-03-17T21:20:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2884526,"change_date":"2022-11-22 21:40:00","inspection_id":"77195266","insp_unit_id":"192077528","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AC55D","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP3LJ0X8GM325475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:44.000000Z","updated_at":"2025-03-17T22:26:44.000000Z"}]},{"id":1418751,"change_date":"2022-10-17 21:40:00","inspection_id":"76764502","dot_number":"2007149","report_state":"MA","report_number":"CW00001005","insp_date":"2022-10-01 00:00:00","insp_start_time":"0655","insp_end_time":"0730","registration_date":"2022-10-17 00:00:00","region":"ET","ci_status_code":"C","location":"005S","location_desc":"S-ADAMS","county_code_state":"MA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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-10-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"452898","transaction_code":"C","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2022-10-03 21:39:00","snet_input_date":"2022-10-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-10-03 21:39:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:45.000000Z","updated_at":"2025-03-17T18:52:45.000000Z","inspection_violations":[{"id":2235712,"change_date":"2022-10-17 21:40:00","inspection_id":"76764502","insp_violation_id":"249054304","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:17:14.000000Z","updated_at":"2025-03-17T21:17:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2283900,"change_date":"2022-10-17 21:40:00","inspection_id":"76764502","insp_unit_id":"191462877","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"3867A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPWX4EX2CD169204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:37.000000Z","updated_at":"2025-03-17T22:22:37.000000Z"}]},{"id":1174242,"change_date":"2022-09-20 21:41:00","inspection_id":"76480702","dot_number":"2007149","report_state":"MA","report_number":"CW00000935","insp_date":"2022-08-30 00:00:00","insp_start_time":"1604","insp_end_time":"1612","registration_date":"2022-09-20 00:00:00","region":"ET","ci_status_code":"C","location":"236H","location_desc":"H-NORTHAMPTON","county_code_state":"MA","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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-31 21:42: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":"451233","transaction_code":"C","transaction_date":"2022-08-31 00:00:00","upload_date":"2022-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2022-08-31 21:42:00","snet_input_date":"2022-08-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-31 21:42:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:19.000000Z","updated_at":"2025-03-17T18:48:19.000000Z","inspection_violations":[{"id":1864120,"change_date":"2022-09-20 21:41:00","inspection_id":"76480702","insp_violation_id":"248518079","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":"576229AB","created_at":"2025-03-17T21:15:37.000000Z","updated_at":"2025-03-17T21:15:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1888497,"change_date":"2022-09-20 21:41:00","inspection_id":"76480702","insp_unit_id":"190988696","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"42","insp_unit_license":"P67769","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HT7DEA57677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:59.000000Z","updated_at":"2025-03-17T22:19:59.000000Z"}]},{"id":1174243,"change_date":"2022-09-20 21:41:00","inspection_id":"76480703","dot_number":"2007149","report_state":"MA","report_number":"CW00000936","insp_date":"2022-08-30 00:00:00","insp_start_time":"1623","insp_end_time":"1640","registration_date":"2022-09-20 00:00:00","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":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"451228","transaction_code":"C","transaction_date":"2022-08-31 00:00:00","upload_date":"2022-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2022-08-31 21:42:00","snet_input_date":"2022-08-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-31 21:42:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:19.000000Z","updated_at":"2025-03-17T18:48:19.000000Z","inspection_violations":[{"id":1864121,"change_date":"2022-09-20 21:41:00","inspection_id":"76480703","insp_violation_id":"248518080","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":"576270AB","created_at":"2025-03-17T21:15:37.000000Z","updated_at":"2025-03-17T21:15:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1888498,"change_date":"2022-09-20 21:41:00","inspection_id":"76480703","insp_unit_id":"190988697","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"68","insp_unit_license":"T46456","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDXF47P05EC97543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:59.000000Z","updated_at":"2025-03-17T22:19:59.000000Z"}]},{"id":1091897,"change_date":"2022-09-20 21:41:00","inspection_id":"76384992","dot_number":"2007149","report_state":"MA","report_number":"CW00000911","insp_date":"2022-08-22 00:00:00","insp_start_time":"0732","insp_end_time":"0740","registration_date":"2022-09-20 00:00:00","region":"ET","ci_status_code":"C","location":"086S","location_desc":"S-DEERFIELD","county_code_state":"MA","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"59000","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":"450688","transaction_code":"C","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2022-08-22 21:41:00","snet_input_date":"2022-08-22 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-22 21:41:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:55.000000Z","updated_at":"2025-03-17T18:46:55.000000Z","inspection_violations":[{"id":1719732,"change_date":"2022-09-20 21:41:00","inspection_id":"76384992","insp_violation_id":"248518035","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"565128AB","created_at":"2025-03-17T21:14:59.000000Z","updated_at":"2025-03-17T21:14:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1756168,"change_date":"2022-09-20 21:41:00","inspection_id":"76384992","insp_unit_id":"190988680","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"62","insp_unit_license":"3886A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NPRLN0X88M755834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:05.000000Z","updated_at":"2025-03-17T22:19:05.000000Z"}]},{"id":170784,"change_date":"2022-04-14 21:41:00","inspection_id":"75296595","dot_number":"2007149","report_state":"MA","report_number":"CE00005720","insp_date":"2022-04-14 00:00:00","insp_start_time":"0613","insp_end_time":"0633","registration_date":null,"region":"ET","ci_status_code":"C","location":"131S","location_desc":"S-HADLEY","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-04-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"444605","transaction_code":"A","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02007149","upload_search_indicator":"M","census_search_date":"2022-04-14 21:41:00","snet_input_date":"2022-04-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-04-14 21:41:00","insp_carrier_name":"JOSEPH S RAE LLC","insp_carrier_street":"2231 MOHAWK TRAIL ROUTE 2","insp_carrier_city":"CHARLEMONT","insp_carrier_state":"MA","insp_carrier_zip_code":"01339","insp_colonia":null,"docket_number":"7079","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:30.000000Z","updated_at":"2025-03-17T18:30:30.000000Z","inspection_violations":[{"id":256827,"change_date":"2022-04-14 21:41:00","inspection_id":"75296595","insp_violation_id":"245142940","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:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"3922"},{"id":256828,"change_date":"2022-04-14 21:41:00","inspection_id":"75296595","insp_violation_id":"245142941","seq_no":"2","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:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":276856,"change_date":"2022-04-14 21:41:00","inspection_id":"75296595","insp_unit_id":"188142367","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V21218","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5GT7CEC68429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:52.000000Z","updated_at":"2025-03-17T22:09:52.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2007149\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2007149\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2007149\/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\/2007149\/inspections","per_page":100,"prev_page_url":null,"to":34,"total":34}