{"current_page":1,"data":[{"id":10622211,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","dot_number":"2519799","report_state":"NY","report_number":"SPF3030802","insp_date":"2026-01-05 00:00:00","insp_start_time":"1052","insp_end_time":"1201","registration_date":"2026-01-29 00:00:00","region":"ES","ci_status_code":"C","location":"80881M","location_desc":"SLATE HILL NY","county_code_state":"NY","county_code":"071","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"TRANSLOOP","shipping_paper_number":"31346-32503","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"8","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2752232","transaction_code":"C","transaction_date":"2026-01-11 00:00:00","upload_date":"2026-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":null,"census_search_date":"2026-01-12 21:38:00","snet_input_date":"2026-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-12 21:38:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-15T10:36:52.000000Z","updated_at":"2026-02-10T10:31:27.000000Z","inspection_violations":[{"id":18235213,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","insp_violation_id":"271509939","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"211360656","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:01.000000Z","updated_at":"2026-02-10T10:40:23.000000Z","normalized_code":"39021TB1MC"},{"id":18235214,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","insp_violation_id":"271509940","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:01.000000Z","updated_at":"2026-02-10T10:40:23.000000Z","normalized_code":"3922SLL"},{"id":18235217,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","insp_violation_id":"271509943","seq_no":"5","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:01.000000Z","updated_at":"2026-02-10T10:40:23.000000Z","normalized_code":"3958EHOSPD"},{"id":18235218,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","insp_violation_id":"271509944","seq_no":"6","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:01.000000Z","updated_at":"2026-02-10T10:40:23.000000Z","normalized_code":"3958EHOSPD"},{"id":18235216,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","insp_violation_id":"271509942","seq_no":"4","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:01.000000Z","updated_at":"2026-02-10T10:40:23.000000Z","normalized_code":"3958EHOSPD"},{"id":18235215,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","insp_violation_id":"271509941","seq_no":"3","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"211360656","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:01.000000Z","updated_at":"2026-02-10T10:40:23.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":18235219,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","insp_violation_id":"271509945","seq_no":"7","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:01.000000Z","updated_at":"2026-02-10T10:40:23.000000Z","normalized_code":"3958EHOSPD"},{"id":18235220,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","insp_violation_id":"271509946","seq_no":"8","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"211360656","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:01.000000Z","updated_at":"2026-02-10T10:40:23.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18307790,"change_date":"2026-01-30 21:39:00","inspection_id":"86762681","insp_unit_id":"211360656","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5","insp_unit_license":"X16667","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT2F4S55972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-02T10:10:05.000000Z","updated_at":"2026-02-10T10:04:19.000000Z"}]},{"id":10409715,"change_date":"2025-12-11 21:45:00","inspection_id":"86540384","dot_number":"2519799","report_state":"NJ","report_number":"SPRXI01954","insp_date":"2025-12-10 00:00:00","insp_start_time":"0755","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":"2107","location_desc":"GREENWICH SCALE EASTBOUND","county_code_state":"NJ","county_code":"041","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"TRANSLOOP","shipping_paper_number":"31415-53621","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-11 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1328360","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-10 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-12-11 21:45:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"874638","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-14T10:31:47.000000Z","updated_at":"2025-12-15T10:31:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17410017,"change_date":"2025-12-11 21:45:00","inspection_id":"86540384","insp_unit_id":"210555777","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5","insp_unit_license":"X16667","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT2F4S55972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:01.000000Z","updated_at":"2025-12-15T10:01:42.000000Z"}]},{"id":10362028,"change_date":"2026-04-28 21:39:00","inspection_id":"86490486","dot_number":"2519799","report_state":"NJ","report_number":"SPRUI00581","insp_date":"2025-12-04 00:00:00","insp_start_time":"0906","insp_end_time":"0947","registration_date":"2025-12-11 00:00:00","region":"ES","ci_status_code":"C","location":"2107","location_desc":"NJ","county_code_state":"NJ","county_code":"041","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"TRANSLOOP","shipping_paper_number":"31402924631","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3224108","transaction_code":"C","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":null,"census_search_date":"2026-04-28 21:39:00","snet_input_date":"2025-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-05 21:42:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:31:58.000000Z","updated_at":"2026-05-09T09:30:03.000000Z","inspection_violations":[{"id":17350309,"change_date":"2026-04-28 21:39:00","inspection_id":"86490486","insp_violation_id":"273900304","seq_no":"1","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"213263253","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-08T10:32:52.000000Z","updated_at":"2026-05-09T09:41:24.000000Z","normalized_code":"3963A1BOS"},{"id":17350310,"change_date":"2026-04-28 21:39:00","inspection_id":"86490486","insp_violation_id":"273900305","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":"210441353","insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:52.000000Z","updated_at":"2026-05-09T09:41:24.000000Z","normalized_code":"3958A1HOSP"},{"id":17350311,"change_date":"2026-04-28 21:39:00","inspection_id":"86490486","insp_violation_id":"273900306","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213263253","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:52.000000Z","updated_at":"2026-05-09T09:41:24.000000Z","normalized_code":"39347E"},{"id":17350312,"change_date":"2026-04-28 21:39:00","inspection_id":"86490486","insp_violation_id":"273900307","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"213263253","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:52.000000Z","updated_at":"2026-05-09T09:41:24.000000Z","normalized_code":"39353BB"},{"id":17350313,"change_date":"2026-04-28 21:39:00","inspection_id":"86490486","insp_violation_id":"273900308","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213263253","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:52.000000Z","updated_at":"2026-05-09T09:41:24.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":17318957,"change_date":"2026-04-28 21:39:00","inspection_id":"86490486","insp_unit_id":"213263253","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5","insp_unit_license":"X16667","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT2F4S55972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:05.000000Z","updated_at":"2026-05-09T09:02:03.000000Z"}]},{"id":10190515,"change_date":"2026-02-18 21:38:00","inspection_id":"86310806","dot_number":"2519799","report_state":"ME","report_number":"9094000275","insp_date":"2025-11-13 00:00:00","insp_start_time":"0750","insp_end_time":"0806","registration_date":"2026-02-17 00:00:00","region":"ET","ci_status_code":"C","location":"000440","location_desc":"SIDNEY","county_code_state":"ME","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ICON INC","shipping_paper_number":"S03090165","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"404661","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-13 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-11-13 21:39:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"874638","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-16T10:31:54.000000Z","updated_at":"2026-03-01T10:30:11.000000Z","inspection_violations":[{"id":18700934,"change_date":"2026-02-18 21:38:00","inspection_id":"86310806","insp_violation_id":"271872448","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"211686213","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:25.000000Z","updated_at":"2026-03-01T10:39:33.000000Z","normalized_code":"39395A1"},{"id":18700933,"change_date":"2026-02-18 21:38:00","inspection_id":"86310806","insp_violation_id":"271872447","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:25.000000Z","updated_at":"2026-03-01T10:39:33.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":19049638,"change_date":"2026-02-18 21:38:00","inspection_id":"86310806","insp_unit_id":"211686213","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"-","insp_unit_license":"W64523","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAMMMML4GL112200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:05.000000Z","updated_at":"2026-03-01T10:03:54.000000Z"}]},{"id":10158153,"change_date":"2025-11-09 21:34:00","inspection_id":"86276708","dot_number":"2519799","report_state":"VT","report_number":"50B0002510","insp_date":"2025-11-06 00:00:00","insp_start_time":"1150","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":"1408NB","location_desc":"WHITE RIVER NB","county_code_state":"VT","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-09 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"221830","transaction_code":"A","transaction_date":"2025-11-06 00:00:00","upload_date":"2025-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-06 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-11-09 21:34:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"874638","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-12T10:30:26.000000Z","updated_at":"2025-11-13T10:30:21.000000Z","inspection_violations":[{"id":16859943,"change_date":"2025-11-09 21:34:00","inspection_id":"86276708","insp_violation_id":"269833853","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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-11-12T10:30:40.000000Z","updated_at":"2025-11-13T10:30:36.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":16911842,"change_date":"2025-11-09 21:34:00","inspection_id":"86276708","insp_unit_id":"209927529","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5","insp_unit_license":"X16667","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT2F4S55972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-12T10:00:30.000000Z","updated_at":"2025-11-13T10:00:25.000000Z"}]},{"id":8603907,"change_date":"2025-05-12 21:40:00","inspection_id":"84639716","dot_number":"2519799","report_state":"MA","report_number":"DZ00000358","insp_date":"2025-05-01 00:00:00","insp_start_time":"1627","insp_end_time":"1650","registration_date":null,"region":"ET","ci_status_code":"C","location":"020H","location_desc":"H-ATTLEBORO","county_code_state":"MA","county_code":"005","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-05-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"516516","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":"02519799","upload_search_indicator":"M","census_search_date":"2025-05-12 21:40:00","snet_input_date":"2025-05-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-12 21:40:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-15T10:01:08.000000Z","updated_at":"2025-05-17T10:04:53.000000Z","inspection_violations":[{"id":13672770,"change_date":"2025-05-12 21:40:00","inspection_id":"84639716","insp_violation_id":"266160152","seq_no":"1","part_no":"391","part_no_section":"45A-MCEM","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-05-15T10:19:46.000000Z","updated_at":"2025-05-16T10:25:22.000000Z","normalized_code":"39145AMCEM"},{"id":13672771,"change_date":"2025-05-12 21:40:00","inspection_id":"84639716","insp_violation_id":"266160153","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206803985","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:19:46.000000Z","updated_at":"2025-05-16T10:25:22.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14045738,"change_date":"2025-05-12 21:40:00","inspection_id":"84639716","insp_unit_id":"206803985","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"X20560","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNE8JP6E4S50778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:13.000000Z","updated_at":"2025-05-16T09:50:10.000000Z"}]},{"id":7517280,"change_date":"2024-12-30 21:38:00","inspection_id":"83496906","dot_number":"2519799","report_state":"MA","report_number":"DQ00001677","insp_date":"2024-12-28 00:00:00","insp_start_time":"1620","insp_end_time":"1639","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","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":"2024-12-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"506046","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2024-12-30 21:38:00","snet_input_date":"2024-12-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-12-30 21:38:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:44.000000Z","updated_at":"2025-03-17T20:52:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12127872,"change_date":"2024-12-30 21:38:00","inspection_id":"83496906","insp_unit_id":"204588549","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"X16667","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT2F4S55972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:53.000000Z","updated_at":"2025-03-17T23:48:53.000000Z"}]},{"id":7237934,"change_date":"2024-11-20 21:40:00","inspection_id":"83202908","dot_number":"2519799","report_state":"MA","report_number":"CH00005586","insp_date":"2024-11-19 00:00:00","insp_start_time":"1700","insp_end_time":"1728","registration_date":null,"region":"ET","ci_status_code":"C","location":"319S","location_desc":"S-STONEHAM","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"503832","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2024-11-20 21:40:00","snet_input_date":"2024-11-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-20 21:40:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:52.000000Z","updated_at":"2025-03-17T20:46:52.000000Z","inspection_violations":[{"id":11314772,"change_date":"2024-11-20 21:40:00","inspection_id":"83202908","insp_violation_id":"262995116","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLL"},{"id":11314773,"change_date":"2024-11-20 21:40:00","inspection_id":"83202908","insp_violation_id":"262995117","seq_no":"2","part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"39111B5LNCDLNVL"}],"inspection_per_units":[{"id":11674695,"change_date":"2024-11-20 21:40:00","inspection_id":"83202908","insp_unit_id":"203968728","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"W66206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAM92H411787","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:58.000000Z","updated_at":"2025-03-17T23:43:58.000000Z"}]},{"id":7131866,"change_date":"2024-11-06 21:40:00","inspection_id":"83090701","dot_number":"2519799","report_state":"MA","report_number":"DO00000276","insp_date":"2024-11-06 00:00:00","insp_start_time":"0950","insp_end_time":"1011","registration_date":null,"region":"ET","ci_status_code":"C","location":"363H","location_desc":"H-WEST SPRINGFIELD","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":"2024-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"502948","transaction_code":"A","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2024-11-06 21:40:00","snet_input_date":"2024-11-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-06 21:40:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:41.000000Z","updated_at":"2025-03-17T20:44:41.000000Z","inspection_violations":[{"id":11141550,"change_date":"2024-11-06 21:40:00","inspection_id":"83090701","insp_violation_id":"262754708","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3922SLLML"},{"id":11141551,"change_date":"2024-11-06 21:40:00","inspection_id":"83090701","insp_violation_id":"262754709","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":"VERBAL","created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3922SLLCP"},{"id":11141552,"change_date":"2024-11-06 21:40:00","inspection_id":"83090701","insp_violation_id":"262754710","seq_no":"3","part_no":"393","part_no_section":"80A","insp_viol_unit":"1","insp_unit_id":"203757418","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"39380A"}],"inspection_per_units":[{"id":11502924,"change_date":"2024-11-06 21:40:00","inspection_id":"83090701","insp_unit_id":"203757418","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"X16667","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT2F4S55972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:10.000000Z","updated_at":"2025-03-17T23:42:10.000000Z"}]},{"id":6080846,"change_date":"2024-07-11 21:41:00","inspection_id":"81969615","dot_number":"2519799","report_state":"MA","report_number":"DD00001658","insp_date":"2024-06-25 00:00:00","insp_start_time":"1700","insp_end_time":"1716","registration_date":"2024-07-11 00:00:00","region":"ET","ci_status_code":"C","location":"116H","location_desc":"H-FRAMINGHAM","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"494770","transaction_code":"C","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-25 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:20.000000Z","updated_at":"2025-03-17T20:23:20.000000Z","inspection_violations":[{"id":9437320,"change_date":"2024-07-11 21:41:00","inspection_id":"81969615","insp_violation_id":"260584854","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"732609AC","created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39282A1"},{"id":9437321,"change_date":"2024-07-11 21:41:00","inspection_id":"81969615","insp_violation_id":"260584855","seq_no":"2","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":"732609AC","created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9794315,"change_date":"2024-07-11 21:41:00","inspection_id":"81969615","insp_unit_id":"201834524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"X20560","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNE8JP6E4S50778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:25.000000Z","updated_at":"2025-03-17T23:24:25.000000Z"}]},{"id":6034808,"change_date":"2024-06-20 21:43:00","inspection_id":"81920031","dot_number":"2519799","report_state":"MA","report_number":"DS00000800","insp_date":"2024-06-19 00:00:00","insp_start_time":"0837","insp_end_time":"0852","registration_date":"2024-06-20 00:00:00","region":"ET","ci_status_code":"C","location":"319S","location_desc":"S-STONEHAM","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"494264","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2024-06-20 21:43:00","snet_input_date":"2024-06-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-20 21:43:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:17.000000Z","updated_at":"2025-03-17T20:22:17.000000Z","inspection_violations":[{"id":9362229,"change_date":"2024-06-20 21:43:00","inspection_id":"81920031","insp_violation_id":"260207672","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:51:19.000000Z","updated_at":"2025-03-17T21:51:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9720004,"change_date":"2024-06-20 21:43:00","inspection_id":"81920031","insp_unit_id":"201502211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"X16667","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT2F4S55972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:44.000000Z","updated_at":"2025-03-17T23:23:44.000000Z"}]},{"id":5752023,"change_date":"2024-05-15 21:43:00","inspection_id":"81613301","dot_number":"2519799","report_state":"MA","report_number":"DA00002167","insp_date":"2024-05-14 00:00:00","insp_start_time":"1820","insp_end_time":"1840","registration_date":null,"region":"ET","ci_status_code":"C","location":"020H","location_desc":"H-ATTLEBORO","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"491791","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2024-05-15 21:43:00","snet_input_date":"2024-05-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:42.000000Z","updated_at":"2025-03-17T20:16:42.000000Z","inspection_violations":[{"id":8902635,"change_date":"2024-05-15 21:43:00","inspection_id":"81613301","insp_violation_id":"259511236","seq_no":"1","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:06.000000Z","updated_at":"2025-03-17T21:49:06.000000Z","normalized_code":"39115A"},{"id":8902636,"change_date":"2024-05-15 21:43:00","inspection_id":"81613301","insp_violation_id":"259511237","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200899195","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:06.000000Z","updated_at":"2025-03-17T21:49:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9264567,"change_date":"2024-05-15 21:43:00","inspection_id":"81613301","insp_unit_id":"200899195","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"6","insp_unit_license":"W64523","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAMMMML4GL112200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:12.000000Z","updated_at":"2025-03-17T23:19:12.000000Z"}]},{"id":5336582,"change_date":"2024-03-21 21:40:00","inspection_id":"81160598","dot_number":"2519799","report_state":"MA","report_number":"DC00001574","insp_date":"2024-03-20 00:00:00","insp_start_time":"1911","insp_end_time":"1922","registration_date":null,"region":"ET","ci_status_code":"C","location":"020H","location_desc":"H-ATTLEBORO","county_code_state":"MA","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"488159","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2024-03-21 21:40:00","snet_input_date":"2024-03-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-03-21 21:40:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:19.000000Z","updated_at":"2025-03-17T20:08:19.000000Z","inspection_violations":[{"id":8234995,"change_date":"2024-03-21 21:40:00","inspection_id":"81160598","insp_violation_id":"258508822","seq_no":"1","part_no":"393","part_no_section":"55(b)","insp_viol_unit":"1","insp_unit_id":"200020865","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"39355B"},{"id":8234996,"change_date":"2024-03-21 21:40:00","inspection_id":"81160598","insp_violation_id":"258508823","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200020865","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"39395A"},{"id":8234997,"change_date":"2024-03-21 21:40:00","inspection_id":"81160598","insp_violation_id":"258508824","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200020865","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8594419,"change_date":"2024-03-21 21:40:00","inspection_id":"81160598","insp_unit_id":"200020865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"W66206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAM92H411787","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:56.000000Z","updated_at":"2025-03-17T23:12:56.000000Z"}]},{"id":5198473,"change_date":"2024-03-04 21:41:00","inspection_id":"81009689","dot_number":"2519799","report_state":"RI","report_number":"0084000148","insp_date":"2024-02-27 00:00:00","insp_start_time":"0640","insp_end_time":"0720","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"JOHNSTON RI","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEST BUY","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25550","viol_total":"1","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":"289183","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":null,"census_search_date":"2024-03-04 21:41:00","snet_input_date":"2024-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-04 21:41:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:24.000000Z","updated_at":"2025-03-17T20:05:24.000000Z","inspection_violations":[{"id":8014551,"change_date":"2024-03-04 21:41:00","inspection_id":"81009689","insp_violation_id":"258176514","seq_no":"1","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:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":8370731,"change_date":"2024-03-04 21:41:00","inspection_id":"81009689","insp_unit_id":"199728928","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"W66206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAM92H411787","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:51.000000Z","updated_at":"2025-03-17T23:10:51.000000Z"}]},{"id":4951548,"change_date":"2024-02-14 21:41:00","inspection_id":"80740264","dot_number":"2519799","report_state":"MA","report_number":"DC00001418","insp_date":"2024-01-31 00:00:00","insp_start_time":"1713","insp_end_time":"1725","registration_date":"2024-02-14 00:00:00","region":"ET","ci_status_code":"C","location":"115H","location_desc":"H-FOXBORO","county_code_state":"MA","county_code":"021","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-02-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"484241","transaction_code":"C","transaction_date":"2024-02-01 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2024-02-01 21:43:00","snet_input_date":"2024-01-31 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-02-01 21:43:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:50.000000Z","updated_at":"2025-03-17T20:00:50.000000Z","inspection_violations":[{"id":7627232,"change_date":"2024-02-14 21:41:00","inspection_id":"80740264","insp_violation_id":"257829988","seq_no":"1","part_no":"387","part_no_section":"303(b)(4)","insp_viol_unit":"1","insp_unit_id":"199416414","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:50.000000Z","updated_at":"2025-03-17T21:42:50.000000Z","normalized_code":"387303B4"},{"id":7627233,"change_date":"2024-02-14 21:41:00","inspection_id":"80740264","insp_violation_id":"257829989","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199416414","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:50.000000Z","updated_at":"2025-03-17T21:42:50.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7968852,"change_date":"2024-02-14 21:41:00","inspection_id":"80740264","insp_unit_id":"199416414","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"X16667","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT2F4S55972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:13.000000Z","updated_at":"2025-03-17T23:07:13.000000Z"}]},{"id":4882533,"change_date":"2024-02-08 21:42:00","inspection_id":"80664682","dot_number":"2519799","report_state":"MA","report_number":"DC00001383","insp_date":"2024-01-22 00:00:00","insp_start_time":"1751","insp_end_time":"1806","registration_date":"2024-02-08 00:00:00","region":"ET","ci_status_code":"C","location":"020H","location_desc":"H-ATTLEBORO","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-23 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"483519","transaction_code":"C","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2024-01-23 21:44:00","snet_input_date":"2024-01-22 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-01-23 21:44:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:35.000000Z","updated_at":"2025-03-17T19:59:35.000000Z","inspection_violations":[{"id":7524227,"change_date":"2024-02-08 21:42:00","inspection_id":"80664682","insp_violation_id":"257729289","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:42:19.000000Z","updated_at":"2025-03-17T21:42:19.000000Z","normalized_code":"3922"},{"id":7524228,"change_date":"2024-02-08 21:42:00","inspection_id":"80664682","insp_violation_id":"257729290","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:19.000000Z","updated_at":"2025-03-17T21:42:19.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7856063,"change_date":"2024-02-08 21:42:00","inspection_id":"80664682","insp_unit_id":"199326129","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"X20560","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNE8JP6E4S50778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:13.000000Z","updated_at":"2025-03-17T23:06:13.000000Z"}]},{"id":4268315,"change_date":"2023-11-08 21:40:00","inspection_id":"79990069","dot_number":"2519799","report_state":"MA","report_number":"DC00001105","insp_date":"2023-10-23 00:00:00","insp_start_time":"1730","insp_end_time":"1746","registration_date":"2023-11-08 00:00:00","region":"ET","ci_status_code":"C","location":"344H","location_desc":"H-WALPOLE","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-10-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"477029","transaction_code":"C","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2023-10-24 21:39:00","snet_input_date":"2023-10-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-24 21:39:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:26.000000Z","updated_at":"2025-03-17T19:47:26.000000Z","inspection_violations":[{"id":6603012,"change_date":"2023-11-08 21:40:00","inspection_id":"79990069","insp_violation_id":"256280122","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:37:50.000000Z","updated_at":"2025-03-17T21:37:50.000000Z","normalized_code":"3922"},{"id":6603013,"change_date":"2023-11-08 21:40:00","inspection_id":"79990069","insp_violation_id":"256280123","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:37:50.000000Z","updated_at":"2025-03-17T21:37:50.000000Z","normalized_code":"39216A"},{"id":6603014,"change_date":"2023-11-08 21:40:00","inspection_id":"79990069","insp_violation_id":"256280124","seq_no":"3","part_no":"387","part_no_section":"303(b)(4)","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:37:50.000000Z","updated_at":"2025-03-17T21:37:50.000000Z","normalized_code":"387303B4"}],"inspection_per_units":[{"id":6864549,"change_date":"2023-11-08 21:40:00","inspection_id":"79990069","insp_unit_id":"197960470","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"W64523","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAMMMML4GL112200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:32.000000Z","updated_at":"2025-03-17T22:57:32.000000Z"}]},{"id":3528676,"change_date":"2023-07-18 21:41:00","inspection_id":"79166099","dot_number":"2519799","report_state":"MA","report_number":"DB00000968","insp_date":"2023-07-14 00:00:00","insp_start_time":"0725","insp_end_time":"0736","registration_date":null,"region":"ET","ci_status_code":"C","location":"290H","location_desc":"H-SANDWICH","county_code_state":"MA","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"HOME DEPOT","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-07-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"470002","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-07-18 21:41:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"874638","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:48.000000Z","updated_at":"2025-03-17T19:32:48.000000Z","inspection_violations":[{"id":5441421,"change_date":"2023-07-18 21:41:00","inspection_id":"79166099","insp_violation_id":"254111523","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196044639","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:17.000000Z","updated_at":"2025-03-17T21:32:17.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5673746,"change_date":"2023-07-18 21:41:00","inspection_id":"79166099","insp_unit_id":"196044639","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5","insp_unit_license":"X16667","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT2F4S55972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:46.000000Z","updated_at":"2025-03-17T22:47:46.000000Z"}]},{"id":3392979,"change_date":"2023-07-27 21:40:00","inspection_id":"79013791","dot_number":"2519799","report_state":"MA","report_number":"CP00003239","insp_date":"2023-06-28 00:00:00","insp_start_time":"1642","insp_end_time":"1703","registration_date":"2023-07-27 00:00:00","region":"ET","ci_status_code":"C","location":"153H","location_desc":"H-HOPKINGTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24990","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"469147","transaction_code":"C","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2023-06-29 21:41:00","snet_input_date":"2023-06-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-06-29 21:41:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:11.000000Z","updated_at":"2025-03-17T19:30:11.000000Z","inspection_violations":[{"id":5231773,"change_date":"2023-07-27 21:40:00","inspection_id":"79013791","insp_violation_id":"254304528","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":"051801AC","created_at":"2025-03-17T21:31:17.000000Z","updated_at":"2025-03-17T21:31:17.000000Z","normalized_code":"38323A2"},{"id":5231774,"change_date":"2023-07-27 21:40:00","inspection_id":"79013791","insp_violation_id":"254304529","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196217122","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"051801AC","created_at":"2025-03-17T21:31:17.000000Z","updated_at":"2025-03-17T21:31:17.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5454978,"change_date":"2023-07-27 21:40:00","inspection_id":"79013791","insp_unit_id":"196217122","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"W64523","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAMMAAL7EL772781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:01.000000Z","updated_at":"2025-03-17T22:46:01.000000Z"}]},{"id":2538548,"change_date":"2023-03-21 21:41:00","inspection_id":"78046437","dot_number":"2519799","report_state":"MA","report_number":"CC00006187","insp_date":"2023-03-08 00:00:00","insp_start_time":"1803","insp_end_time":"1823","registration_date":"2023-03-21 00:00:00","region":"ET","ci_status_code":"C","location":"270H","location_desc":"H-RAYNHAM","county_code_state":"MA","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"461866","transaction_code":"C","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02519799","upload_search_indicator":"M","census_search_date":"2023-03-09 21:41:00","snet_input_date":"2023-03-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-03-09 21:41:00","insp_carrier_name":"ANDREWS CARRIERS LIMITED PARTNERSHIP","insp_carrier_street":"200 DEAN ST","insp_carrier_city":"SEEKONK","insp_carrier_state":"MA","insp_carrier_zip_code":"02771","insp_colonia":null,"docket_number":"8746","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:23.000000Z","updated_at":"2025-03-17T19:13:23.000000Z","inspection_violations":[{"id":3904930,"change_date":"2023-03-21 21:41:00","inspection_id":"78046437","insp_violation_id":"251770147","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193970247","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"3939A"},{"id":3904931,"change_date":"2023-03-21 21:41:00","inspection_id":"78046437","insp_violation_id":"251770148","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193970247","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"850960AB","created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4086090,"change_date":"2023-03-21 21:41:00","inspection_id":"78046437","insp_unit_id":"193970247","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"W66206","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAM92H411787","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:18.000000Z","updated_at":"2025-03-17T22:35:18.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2519799\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2519799\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2519799\/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\/2519799\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}