{"current_page":1,"data":[{"id":12149809,"change_date":"2026-06-10 21:44:00","inspection_id":"88098877","dot_number":"190262","report_state":"NH","report_number":"1085005062","insp_date":"2026-03-09 00:00:00","insp_start_time":"1220","insp_end_time":"1241","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"001","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":"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-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"3511101","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-03-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:31.000000Z","updated_at":"2026-06-21T09:31:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21106333,"change_date":"2026-06-10 21:44:00","inspection_id":"88098877","insp_unit_id":"214017871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"67958","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCG12LG27824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:57.000000Z","updated_at":"2026-06-21T09:02:33.000000Z"}]},{"id":12149367,"change_date":"2026-06-10 21:44:00","inspection_id":"88098391","dot_number":"190262","report_state":"NH","report_number":"1085005050","insp_date":"2026-03-03 00:00:00","insp_start_time":"1006","insp_end_time":"1035","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"013","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":"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-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"3510644","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-03-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:30.000000Z","updated_at":"2026-06-21T09:31:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21105816,"change_date":"2026-06-10 21:44:00","inspection_id":"88098391","insp_unit_id":"214017269","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"77","insp_unit_license":"39414","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y5AN011134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:56.000000Z","updated_at":"2026-06-21T09:02:28.000000Z"},{"id":21105817,"change_date":"2026-06-10 21:44:00","inspection_id":"88098391","insp_unit_id":"214017270","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":null,"insp_unit_license":"421434Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC4126XJT018863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:56.000000Z","updated_at":"2026-06-21T09:02:28.000000Z"}]},{"id":11285764,"change_date":"2026-03-04 21:40:00","inspection_id":"87200761","dot_number":"190262","report_state":"NH","report_number":"0996001071","insp_date":"2026-02-05 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":"2026-02-11 00:00:00","region":"ES","ci_status_code":"C","location":"011","location_desc":"NH","county_code_state":"NH","county_code":"015","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":"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":"U","pen_cen_match":"I","final_status_date":"2026-03-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2962476","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":"2026-03-04 21:40:00","snet_input_date":"2026-02-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-04 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-07T10:39:04.000000Z","updated_at":"2026-03-15T09:30:41.000000Z","inspection_violations":[{"id":18976478,"change_date":"2026-03-04 21:40:00","inspection_id":"87200761","insp_violation_id":"272189191","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"211961215","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:38.000000Z","updated_at":"2026-03-15T09:41:24.000000Z","normalized_code":"3939ALHLI"},{"id":18976479,"change_date":"2026-03-04 21:40:00","inspection_id":"87200761","insp_violation_id":"272189192","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211961215","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:38.000000Z","updated_at":"2026-03-15T09:41:24.000000Z","normalized_code":"3939ALIL"},{"id":18976480,"change_date":"2026-03-04 21:40:00","inspection_id":"87200761","insp_violation_id":"272189193","seq_no":"3","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"211961215","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:38.000000Z","updated_at":"2026-03-15T09:41:24.000000Z","normalized_code":"3939ALBL"},{"id":18976481,"change_date":"2026-03-04 21:40:00","inspection_id":"87200761","insp_violation_id":"272189194","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"211961215","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:38.000000Z","updated_at":"2026-03-15T09:41:24.000000Z","normalized_code":"3939ALLPL"},{"id":18976482,"change_date":"2026-03-04 21:40:00","inspection_id":"87200761","insp_violation_id":"272189195","seq_no":"5","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"211961216","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:38.000000Z","updated_at":"2026-03-15T09:41:24.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":19301775,"change_date":"2026-03-04 21:40:00","inspection_id":"87200761","insp_unit_id":"211961215","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"1AD53T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y9JM085209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:43.000000Z","updated_at":"2026-03-15T09:04:18.000000Z"},{"id":19301776,"change_date":"2026-03-04 21:40:00","inspection_id":"87200761","insp_unit_id":"211961216","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"2437621","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5EF2GC4033B750815","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:43.000000Z","updated_at":"2026-03-15T09:04:18.000000Z"}]},{"id":10568575,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","dot_number":"190262","report_state":"MA","report_number":"CX00001898","insp_date":"2026-01-05 00:00:00","insp_start_time":"1142","insp_end_time":"1242","registration_date":"2026-02-06 00:00:00","region":"ET","ci_status_code":"C","location":"064H","location_desc":"H-CHARLTON SERVICE PLAZA","county_code_state":"MA","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"TRADER JOES","shipping_paper_number":"299181","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":"2026-01-05 21:37:00","post_acc_ind":"Y","gross_comb_veh_wt":"126900","viol_total":"21","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"12","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"537578","transaction_code":"C","transaction_date":"2026-01-05 00:00:00","upload_date":"2026-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2026-01-05 21:37:00","snet_input_date":"2026-01-05 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-05 21:37:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-08T10:34:18.000000Z","updated_at":"2026-02-17T10:30:51.000000Z","inspection_violations":[{"id":18512769,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640324","seq_no":"1","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"2","insp_unit_id":"211480629","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"393207ASAPPAS"},{"id":18512770,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640325","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"2","insp_unit_id":"211480629","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"393207ASAPPAS"},{"id":18512771,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640326","seq_no":"3","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"393207ASAPPAS"},{"id":18512772,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640327","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"39375A3TAOL"},{"id":18512773,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640328","seq_no":"5","part_no":"393","part_no_section":"75A1-TAOBETA","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"39375A1TAOBETA"},{"id":18512774,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640329","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"3939ALLPL"},{"id":18512775,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640330","seq_no":"7","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"3922SLL"},{"id":18512776,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640331","seq_no":"8","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"39617CPI"},{"id":18512777,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640332","seq_no":"9","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"39395A4EENA"},{"id":18512778,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640333","seq_no":"10","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"39395A4EEUS"},{"id":18512779,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640334","seq_no":"11","part_no":"399","part_no_section":"211-CBP","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"399211CBP"},{"id":18512780,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640335","seq_no":"12","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"39378AWS"},{"id":18512781,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640336","seq_no":"13","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"39381H"},{"id":18512782,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640337","seq_no":"14","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"39360C"},{"id":18512783,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640338","seq_no":"15","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"39311A1CSURR"},{"id":18512784,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640339","seq_no":"16","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"3922SLL"},{"id":18512785,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640340","seq_no":"17","part_no":"398","part_no_section":"8D1-MW","insp_viol_unit":"1","insp_unit_id":"211480628","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"3988D1MW"},{"id":18512786,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640341","seq_no":"18","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":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"3922SLLTCD"},{"id":18512787,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640342","seq_no":"19","part_no":"392","part_no_section":"5A2-IP","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":"2026-02-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"3925A2IP"},{"id":18512788,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640343","seq_no":"20","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-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"3922SLL"},{"id":18512789,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_violation_id":"271640344","seq_no":"21","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-10T10:50:32.000000Z","updated_at":"2026-02-17T10:37:56.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":18859374,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_unit_id":"211480629","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478421","insp_unit_license":"421220Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41268JT018649","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-09T10:11:24.000000Z","updated_at":"2026-02-17T10:04:03.000000Z"},{"id":18859373,"change_date":"2026-02-06 21:38:00","inspection_id":"86706363","insp_unit_id":"211480628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AB38K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCK67LV79794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-09T10:11:24.000000Z","updated_at":"2026-02-17T10:04:03.000000Z"}]},{"id":10078054,"change_date":"2025-10-30 21:42:00","inspection_id":"86192296","dot_number":"190262","report_state":"NH","report_number":"1085004831","insp_date":"2025-09-02 00:00:00","insp_start_time":"1202","insp_end_time":"1223","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"001","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":"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":"2025-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"2480505","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-09-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:12.000000Z","updated_at":"2025-11-03T11:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16753282,"change_date":"2025-10-30 21:42:00","inspection_id":"86192296","insp_unit_id":"209739867","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"1AD53T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y9JM085209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:30.000000Z","updated_at":"2025-11-03T10:46:03.000000Z"},{"id":16753283,"change_date":"2025-10-30 21:42:00","inspection_id":"86192296","insp_unit_id":"209739868","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":null,"insp_unit_license":"421459Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41264JT018888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:30.000000Z","updated_at":"2025-11-03T10:46:03.000000Z"}]},{"id":9347175,"change_date":"2025-08-18 21:38:00","inspection_id":"85423991","dot_number":"190262","report_state":"CT","report_number":"3083005416","insp_date":"2025-08-07 00:00:00","insp_start_time":"1357","insp_end_time":"1432","registration_date":"2025-08-18 00:00:00","region":"ET","ci_status_code":"C","location":"142","location_desc":"TOLLAND","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL TRANS. CO. INC.","shipping_paper_number":"297738","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-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"748180","transaction_code":"C","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:27.000000Z","updated_at":"2025-08-23T10:45:26.000000Z","inspection_violations":[{"id":15351090,"change_date":"2025-08-18 21:38:00","inspection_id":"85423991","insp_violation_id":"268076232","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"1","insp_unit_id":"208437242","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V135254-2","created_at":"2025-08-21T10:42:06.000000Z","updated_at":"2025-08-22T10:42:48.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":15550296,"change_date":"2025-08-18 21:38:00","inspection_id":"85423991","insp_unit_id":"208437242","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"88922","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGLDR1CSBC7334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:21.000000Z","updated_at":"2025-08-22T09:45:07.000000Z"}]},{"id":9347191,"change_date":"2025-08-07 21:39:00","inspection_id":"85424009","dot_number":"190262","report_state":"CT","report_number":"3129006027","insp_date":"2025-08-07 00:00:00","insp_start_time":"1350","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":"145","location_desc":"UNION","county_code_state":"CT","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":"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-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"748176","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:27.000000Z","updated_at":"2025-08-12T10:42:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15397967,"change_date":"2025-08-07 21:39:00","inspection_id":"85424009","insp_unit_id":"208271897","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"97448","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGLD55FSGA8123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:15.000000Z","updated_at":"2025-08-11T09:45:10.000000Z"}]},{"id":9306805,"change_date":"2025-08-14 21:40:00","inspection_id":"85381505","dot_number":"190262","report_state":"VT","report_number":"2161010622","insp_date":"2025-07-31 00:00:00","insp_start_time":"1232","insp_end_time":"1243","registration_date":"2025-08-13 00:00:00","region":"ET","ci_status_code":"C","location":"0114","location_desc":"ORWELL","county_code_state":"VT","county_code":"001","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-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"219224","transaction_code":"C","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-31 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-08-01 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:45.000000Z","updated_at":"2025-08-20T10:43:44.000000Z","inspection_violations":[{"id":15305468,"change_date":"2025-08-14 21:40:00","inspection_id":"85381505","insp_violation_id":"268030214","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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-08-17T10:45:09.000000Z","updated_at":"2025-08-18T10:43:34.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":15509975,"change_date":"2025-08-14 21:40:00","inspection_id":"85381505","insp_unit_id":"208398788","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"78","insp_unit_license":"80992","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y1CM021524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:23.000000Z","updated_at":"2025-08-18T09:45:27.000000Z"},{"id":15509976,"change_date":"2025-08-14 21:40:00","inspection_id":"85381505","insp_unit_id":"208398789","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478616","insp_unit_license":"421415Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41266JT018844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:23.000000Z","updated_at":"2025-08-18T09:45:27.000000Z"}]},{"id":9286091,"change_date":"2025-08-12 21:39:00","inspection_id":"85359799","dot_number":"190262","report_state":"MA","report_number":"DG00001131","insp_date":"2025-07-30 00:00:00","insp_start_time":"1115","insp_end_time":"1233","registration_date":"2025-08-12 00:00:00","region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"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-07-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"126200","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"524377","transaction_code":"C","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2025-07-30 21:40:00","snet_input_date":"2025-07-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-30 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:12.000000Z","updated_at":"2025-08-16T10:00:06.000000Z","inspection_violations":[{"id":15252082,"change_date":"2025-08-12 21:39:00","inspection_id":"85359799","insp_violation_id":"267973037","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"208351177","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:26.000000Z","updated_at":"2025-08-16T10:42:51.000000Z","normalized_code":"3939ALIL"},{"id":15252083,"change_date":"2025-08-12 21:39:00","inspection_id":"85359799","insp_violation_id":"267973038","seq_no":"2","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"1","insp_unit_id":"208351177","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:26.000000Z","updated_at":"2025-08-16T10:42:51.000000Z","normalized_code":"39348ABMBCBD"},{"id":15252084,"change_date":"2025-08-12 21:39:00","inspection_id":"85359799","insp_violation_id":"267973039","seq_no":"3","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"208351177","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:26.000000Z","updated_at":"2025-08-16T10:42:51.000000Z","normalized_code":"39355D1B"},{"id":15252085,"change_date":"2025-08-12 21:39:00","inspection_id":"85359799","insp_violation_id":"267973040","seq_no":"4","part_no":"393","part_no_section":"52A-B","insp_viol_unit":"1","insp_unit_id":"208351177","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-15T10:45:26.000000Z","updated_at":"2025-08-16T10:42:51.000000Z","normalized_code":"39352AB"},{"id":15252086,"change_date":"2025-08-12 21:39:00","inspection_id":"85359799","insp_violation_id":"267973041","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"208351177","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-15T10:45:26.000000Z","updated_at":"2025-08-16T10:42:51.000000Z","normalized_code":"3963A1BOS"},{"id":15252087,"change_date":"2025-08-12 21:39:00","inspection_id":"85359799","insp_violation_id":"267973042","seq_no":"6","part_no":"393","part_no_section":"48A-BMBCAD","insp_viol_unit":"2","insp_unit_id":"208351178","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:26.000000Z","updated_at":"2025-08-16T10:42:51.000000Z","normalized_code":"39348ABMBCAD"}],"inspection_per_units":[{"id":15462851,"change_date":"2025-08-12 21:39:00","inspection_id":"85359799","insp_unit_id":"208351177","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"J1","insp_unit_license":"84275","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJA6CKX4LN31057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:15.000000Z","updated_at":"2025-08-16T09:45:07.000000Z"},{"id":15462852,"change_date":"2025-08-12 21:39:00","inspection_id":"85359799","insp_unit_id":"208351178","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"WORZ 2190","insp_unit_license":"2679308","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC28260H1001011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:15.000000Z","updated_at":"2025-08-16T09:45:07.000000Z"}]},{"id":10079032,"change_date":"2025-10-30 21:42:00","inspection_id":"86193462","dot_number":"190262","report_state":"NH","report_number":"1313000556","insp_date":"2025-07-22 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":null,"region":"ED","ci_status_code":"C","location":"237","location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COSCO SHIPPING","shipping_paper_number":"297560","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":"U","pen_cen_match":"I","final_status_date":"2025-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126950","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":"2481736","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:13.000000Z","updated_at":"2025-11-03T11:01:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16754412,"change_date":"2025-10-30 21:42:00","inspection_id":"86193462","insp_unit_id":"209741327","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"1","insp_unit_license":"67958","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCG12LG27824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:31.000000Z","updated_at":"2025-11-03T10:46:07.000000Z"},{"id":16754413,"change_date":"2025-10-30 21:42:00","inspection_id":"86193462","insp_unit_id":"209741328","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"TRHZ420034","insp_unit_license":"5342844","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC46264H1028517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:31.000000Z","updated_at":"2025-11-03T10:46:07.000000Z"}]},{"id":8490929,"change_date":"2025-05-20 21:41:00","inspection_id":"84520590","dot_number":"190262","report_state":"MA","report_number":"BV00007494","insp_date":"2025-04-29 00:00:00","insp_start_time":"0329","insp_end_time":"0346","registration_date":"2025-05-20 00:00:00","region":"ET","ci_status_code":"C","location":"342H","location_desc":"H-WAKEFIELD","county_code_state":"MA","county_code":"017","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":"2025-04-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"515985","transaction_code":"C","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2025-04-29 21:48:00","snet_input_date":"2025-04-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-29 21:48:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T10:26:46.000000Z","updated_at":"2025-05-24T10:04:45.000000Z","inspection_violations":[{"id":13838250,"change_date":"2025-05-20 21:41:00","inspection_id":"84520590","insp_violation_id":"266349623","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"206964826","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:40.000000Z","updated_at":"2025-05-24T10:22:48.000000Z","normalized_code":"3939ALRLI"},{"id":13838251,"change_date":"2025-05-20 21:41:00","inspection_id":"84520590","insp_violation_id":"266349624","seq_no":"2","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"206964826","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:40.000000Z","updated_at":"2025-05-24T10:22:48.000000Z","normalized_code":"39311A1LRR"}],"inspection_per_units":[{"id":14191903,"change_date":"2025-05-20 21:41:00","inspection_id":"84520590","insp_unit_id":"206964826","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"97448","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGLD55FSGA8123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:00.000000Z","updated_at":"2025-05-24T09:49:56.000000Z"}]},{"id":8328675,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","dot_number":"190262","report_state":"MA","report_number":"DD00002241","insp_date":"2025-04-09 00:00:00","insp_start_time":"1201","insp_end_time":"1339","registration_date":"2025-05-20 00:00:00","region":"ET","ci_status_code":"C","location":"205H","location_desc":"H-MILLBURY","county_code_state":"MA","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125900","viol_total":"13","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"514449","transaction_code":"C","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2025-04-09 21:40:00","snet_input_date":"2025-04-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-09 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-12T10:24:14.000000Z","updated_at":"2025-05-24T10:04:40.000000Z","inspection_violations":[{"id":13837451,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349028","seq_no":"1","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"39381H"},{"id":13837452,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349029","seq_no":"2","part_no":"393","part_no_section":"47A-BCFSBD-SA","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"39347ABCFSBDSA"},{"id":13837453,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349030","seq_no":"3","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"3965BHWSL"},{"id":13837454,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349031","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"39360C"},{"id":13837455,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349032","seq_no":"5","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"39395A4EEUS"},{"id":13837457,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349034","seq_no":"7","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"3922SLLMF"},{"id":13837458,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349035","seq_no":"8","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"39311A1CSLRR"},{"id":13837459,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349036","seq_no":"9","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"3922SLL"},{"id":13837460,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349037","seq_no":"10","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"39345DB"},{"id":13837461,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349038","seq_no":"11","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"39345DBAAL"},{"id":13837462,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349039","seq_no":"12","part_no":"393","part_no_section":"126B-CIM","insp_viol_unit":"2","insp_unit_id":"206964530","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"393126BCIM"},{"id":13837463,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349040","seq_no":"13","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"206964530","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"3939ALTSI"},{"id":13837456,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_violation_id":"266349033","seq_no":"6","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"206964529","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:33:29.000000Z","updated_at":"2025-05-24T10:22:31.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":14191508,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_unit_id":"206964529","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"J1","insp_unit_license":"84275","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJA6CKX4LN31057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:48:59.000000Z","updated_at":"2025-05-24T09:49:51.000000Z"},{"id":14191509,"change_date":"2025-05-20 21:41:00","inspection_id":"84349657","insp_unit_id":"206964530","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478777","insp_unit_license":"421576Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41262JT019005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:48:59.000000Z","updated_at":"2025-05-24T09:49:51.000000Z"}]},{"id":7965671,"change_date":"2025-02-26 21:41:00","inspection_id":"83967707","dot_number":"190262","report_state":"NH","report_number":"1085004573","insp_date":"2025-02-25 00:00:00","insp_start_time":"1004","insp_end_time":"1022","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","county_code_state":"NH","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":"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-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"282686","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-25 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-02-26 21:41:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:37.000000Z","updated_at":"2025-03-17T21:03:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12859048,"change_date":"2025-02-26 21:41:00","inspection_id":"83967707","insp_unit_id":"205508664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"1AD53T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y9JM085209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:01.000000Z","updated_at":"2025-03-17T23:57:01.000000Z"},{"id":12859049,"change_date":"2025-02-26 21:41:00","inspection_id":"83967707","insp_unit_id":"205508665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CVGC","insp_unit_company":null,"insp_unit_license":"2556107","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC4626251000954","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:01.000000Z","updated_at":"2025-03-17T23:57:01.000000Z"}]},{"id":7808617,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","dot_number":"190262","report_state":"CT","report_number":"3079003315","insp_date":"2025-02-07 00:00:00","insp_start_time":"0917","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"731984","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-02-07 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:20.000000Z","updated_at":"2025-03-17T21:00:20.000000Z","inspection_violations":[{"id":12203265,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388679","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"205202654","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"3922SLL"},{"id":12203266,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388680","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205202654","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"39378AWS"},{"id":12203267,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388681","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205202654","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"39360C"},{"id":12203268,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388682","seq_no":"4","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"205202654","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"39395A1"},{"id":12203269,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388683","seq_no":"5","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"205202654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"3939ALCL"},{"id":12203270,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388684","seq_no":"6","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"205202654","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"39375A3TAOL"},{"id":12203271,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388685","seq_no":"7","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"205202654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"39311A1LRR"},{"id":12203272,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388686","seq_no":"8","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"205202654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"3939ALRLI"},{"id":12203273,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388687","seq_no":"9","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"205202654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"3939ALLPL"},{"id":12203274,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388688","seq_no":"10","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"205202655","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"3939ALLPL"},{"id":12203275,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_violation_id":"264388689","seq_no":"11","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"205202655","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":12601838,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_unit_id":"205202654","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"1AB38K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCK67LV79794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:13.000000Z","updated_at":"2025-03-17T23:54:13.000000Z"},{"id":12601839,"change_date":"2025-02-07 21:39:00","inspection_id":"83802974","insp_unit_id":"205202655","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"534284","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC46266H1028499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:13.000000Z","updated_at":"2025-03-17T23:54:13.000000Z"}]},{"id":7700439,"change_date":"2025-01-24 21:40:00","inspection_id":"83689155","dot_number":"190262","report_state":"MA","report_number":"DY00000035","insp_date":"2025-01-24 00:00:00","insp_start_time":"0935","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":"064H","location_desc":"H-CHARLTON","county_code_state":"MA","county_code":"027","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-01-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"792000","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":"507961","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2025-01-24 21:40:00","snet_input_date":"2025-01-24 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-01-24 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:15.000000Z","updated_at":"2025-03-17T20:58:15.000000Z","inspection_violations":[{"id":12032044,"change_date":"2025-01-24 21:40:00","inspection_id":"83689155","insp_violation_id":"264158437","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204989550","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"147062AD","created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"39617CPI"},{"id":12032045,"change_date":"2025-01-24 21:40:00","inspection_id":"83689155","insp_violation_id":"264158438","seq_no":"2","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"3958A1HOSP"},{"id":12032046,"change_date":"2025-01-24 21:40:00","inspection_id":"83689155","insp_violation_id":"264158439","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"204989550","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"147062AD","created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":12426082,"change_date":"2025-01-24 21:40:00","inspection_id":"83689155","insp_unit_id":"204989550","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"1AB38K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCK67LV79794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:08.000000Z","updated_at":"2025-03-17T23:52:08.000000Z"},{"id":12426083,"change_date":"2025-01-24 21:40:00","inspection_id":"83689155","insp_unit_id":"204989551","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ478392","insp_unit_license":"421191Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41266JT018620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:08.000000Z","updated_at":"2025-03-17T23:52:08.000000Z"}]},{"id":7562868,"change_date":"2025-01-07 21:40:00","inspection_id":"83544776","dot_number":"190262","report_state":"MA","report_number":"CR00003395","insp_date":"2025-01-07 00:00:00","insp_start_time":"0649","insp_end_time":"0658","registration_date":null,"region":"ET","ci_status_code":"C","location":"365H","location_desc":"H-WESTBORO","county_code_state":"MA","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":"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-01-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"506566","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2025-01-07 21:40:00","snet_input_date":"2025-01-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:14.000000Z","updated_at":"2025-03-17T20:55:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12202796,"change_date":"2025-01-07 21:40:00","inspection_id":"83544776","insp_unit_id":"204681350","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"84275","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJA6CKX4LN31057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:42.000000Z","updated_at":"2025-03-17T23:49:42.000000Z"}]},{"id":7884108,"change_date":"2025-02-17 21:35:00","inspection_id":"83882297","dot_number":"190262","report_state":"MA","report_number":"PD65000088","insp_date":"2024-12-27 00:00:00","insp_start_time":"1115","insp_end_time":"1215","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BOSTON MA","county_code_state":"MA","county_code":"025","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"126250","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1370565","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":"2025-02-17 21:35:00","snet_input_date":"2024-12-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-17 21:35:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:57.000000Z","updated_at":"2025-03-17T21:01:57.000000Z","inspection_violations":[{"id":12322551,"change_date":"2025-02-17 21:35:00","inspection_id":"83882297","insp_violation_id":"264548033","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205351544","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"087845AD","created_at":"2025-03-17T22:06:11.000000Z","updated_at":"2025-03-17T22:06:11.000000Z","normalized_code":"39347E"},{"id":12322552,"change_date":"2025-02-17 21:35:00","inspection_id":"83882297","insp_violation_id":"264548034","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"205351544","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:11.000000Z","updated_at":"2025-03-17T22:06:11.000000Z","normalized_code":"39353BB"},{"id":12322553,"change_date":"2025-02-17 21:35:00","inspection_id":"83882297","insp_violation_id":"264548035","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"205351544","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:06:11.000000Z","updated_at":"2025-03-17T22:06:11.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":12725714,"change_date":"2025-02-17 21:35:00","inspection_id":"83882297","insp_unit_id":"205351544","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"97448","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGLD55FSGA8123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:37.000000Z","updated_at":"2025-03-17T23:55:37.000000Z"},{"id":12725715,"change_date":"2025-02-17 21:35:00","inspection_id":"83882297","insp_unit_id":"205351545","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"COLUMBIA T","insp_unit_company":"CIZZ478821","insp_unit_license":"421620Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41260JT019049","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:37.000000Z","updated_at":"2025-03-17T23:55:37.000000Z"}]},{"id":7031128,"change_date":"2024-10-24 21:40:00","inspection_id":"82983818","dot_number":"190262","report_state":"CT","report_number":"3091005625","insp_date":"2024-10-24 00:00:00","insp_start_time":"0831","insp_end_time":"0929","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL TRANSPORTATION COMPANY INC","shipping_paper_number":"143378793","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125900","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":"721344","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-10-24 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:39.000000Z","updated_at":"2025-03-17T20:42:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11339569,"change_date":"2024-10-24 21:40:00","inspection_id":"82983818","insp_unit_id":"203558071","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"79","insp_unit_license":"15660","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y2CM024285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:24.000000Z","updated_at":"2025-03-17T23:40:24.000000Z"},{"id":11339570,"change_date":"2024-10-24 21:40:00","inspection_id":"82983818","insp_unit_id":"203558072","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478711","insp_unit_license":"421510Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41266JT018939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:24.000000Z","updated_at":"2025-03-17T23:40:24.000000Z"}]},{"id":6901564,"change_date":"2024-10-07 21:40:00","inspection_id":"82846200","dot_number":"190262","report_state":"MA","report_number":"DQ00001317","insp_date":"2024-10-02 00:00:00","insp_start_time":"0616","insp_end_time":"0647","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-10-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"500923","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2024-10-07 21:40:00","snet_input_date":"2024-10-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-10-07 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:11.000000Z","updated_at":"2025-03-17T20:40:11.000000Z","inspection_violations":[{"id":10754404,"change_date":"2024-10-07 21:40:00","inspection_id":"82846200","insp_violation_id":"262218361","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:04.000000Z","updated_at":"2025-03-17T21:58:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11130649,"change_date":"2024-10-07 21:40:00","inspection_id":"82846200","insp_unit_id":"203294525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3099B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW07Y0GM077632","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:18.000000Z","updated_at":"2025-03-17T23:38:18.000000Z"}]},{"id":6846115,"change_date":"2024-10-08 21:40:00","inspection_id":"82787223","dot_number":"190262","report_state":"CT","report_number":"3091005574","insp_date":"2024-09-30 00:00:00","insp_start_time":"0825","insp_end_time":"0859","registration_date":"2024-10-08 00:00:00","region":"ET","ci_status_code":"C","location":"145","location_desc":"UNION","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL TRANSPORTATION COMPANY INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"719400","transaction_code":"C","transaction_date":"2024-09-30 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-30 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:59.000000Z","updated_at":"2025-03-17T20:38:59.000000Z","inspection_violations":[{"id":10663524,"change_date":"2024-10-08 21:40:00","inspection_id":"82787223","insp_violation_id":"262232208","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W1120-4004","created_at":"2025-03-17T21:57:39.000000Z","updated_at":"2025-03-17T21:57:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11040514,"change_date":"2024-10-08 21:40:00","inspection_id":"82787223","insp_unit_id":"203307057","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"83","insp_unit_license":"1AD53T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y9JM085209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:21.000000Z","updated_at":"2025-03-17T23:37:21.000000Z"}]},{"id":6745356,"change_date":"2024-09-19 21:41:00","inspection_id":"82679717","dot_number":"190262","report_state":"MA","report_number":"DD00001809","insp_date":"2024-09-17 00:00:00","insp_start_time":"1124","insp_end_time":"1145","registration_date":"2024-09-19 00:00:00","region":"ET","ci_status_code":"C","location":"021H","location_desc":"H-AUBURN","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"EVER FASHIONS","shipping_paper_number":"294798","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-09-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"103300","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":"499701","transaction_code":"C","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2024-09-17 21:44:00","snet_input_date":"2024-09-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-09-17 21:44:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:54.000000Z","updated_at":"2025-03-17T20:36:54.000000Z","inspection_violations":[{"id":10504630,"change_date":"2024-09-19 21:41:00","inspection_id":"82679717","insp_violation_id":"261916734","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"901983AC","created_at":"2025-03-17T21:56:53.000000Z","updated_at":"2025-03-17T21:56:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10876932,"change_date":"2024-09-19 21:41:00","inspection_id":"82679717","insp_unit_id":"203023525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"82","insp_unit_license":"15654","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y1JM086323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:40.000000Z","updated_at":"2025-03-17T23:35:40.000000Z"},{"id":10876933,"change_date":"2024-09-19 21:41:00","inspection_id":"82679717","insp_unit_id":"203023526","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"AJAX","insp_unit_company":"CIZZ 234801","insp_unit_license":"3814462","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1AJC23273V1004488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:40.000000Z","updated_at":"2025-03-17T23:35:40.000000Z"}]},{"id":6184247,"change_date":"2024-07-10 21:40:00","inspection_id":"82080753","dot_number":"190262","report_state":"MA","report_number":"DA00002337","insp_date":"2024-07-09 00:00:00","insp_start_time":"1607","insp_end_time":"1616","registration_date":null,"region":"ET","ci_status_code":"C","location":"038H","location_desc":"H-BOSTON","county_code_state":"MA","county_code":"025","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-07-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"495577","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":"00190262","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":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","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":[],"inspection_per_units":[{"id":9962681,"change_date":"2024-07-10 21:40:00","inspection_id":"82080753","insp_unit_id":"201813567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"66","insp_unit_license":"7195A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AA13Y5WW090342","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":9962682,"change_date":"2024-07-10 21:40:00","inspection_id":"82080753","insp_unit_id":"201813568","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478623","insp_unit_license":"421422Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41263JT018851","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":6001859,"change_date":"2024-06-17 21:42:00","inspection_id":"81884435","dot_number":"190262","report_state":"CT","report_number":"3063006585","insp_date":"2024-06-17 00:00:00","insp_start_time":"1110","insp_end_time":"1153","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL TRANSPORTATION COMPANY INC","shipping_paper_number":"293946","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"123900","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":"710204","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-06-17 21:42:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:49.000000Z","updated_at":"2025-03-17T20:21:49.000000Z","inspection_violations":[{"id":9311052,"change_date":"2024-06-17 21:42:00","inspection_id":"81884435","insp_violation_id":"260107847","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201415422","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:03.000000Z","updated_at":"2025-03-17T21:51:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9666862,"change_date":"2024-06-17 21:42:00","inspection_id":"81884435","insp_unit_id":"201415422","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"66","insp_unit_license":"7195A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AA13Y5WW090342","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:11.000000Z","updated_at":"2025-03-17T23:23:11.000000Z"},{"id":9666863,"change_date":"2024-06-17 21:42:00","inspection_id":"81884435","insp_unit_id":"201415423","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 479388","insp_unit_license":"422187Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41269JT019616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:11.000000Z","updated_at":"2025-03-17T23:23:11.000000Z"}]},{"id":6058178,"change_date":"2024-06-24 21:41:00","inspection_id":"81945278","dot_number":"190262","report_state":"NH","report_number":"1085004106","insp_date":"2024-06-13 00:00:00","insp_start_time":"0952","insp_end_time":"1017","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","county_code_state":"NH","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"275881","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-06-24 21:41:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:40.000000Z","updated_at":"2025-03-17T20:22:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9757590,"change_date":"2024-06-24 21:41:00","inspection_id":"81945278","insp_unit_id":"201551146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"15654","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y1JM086323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:04.000000Z","updated_at":"2025-03-17T23:24:04.000000Z"},{"id":9757591,"change_date":"2024-06-24 21:41:00","inspection_id":"81945278","insp_unit_id":"201551147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"5342847","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41263H1036711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:04.000000Z","updated_at":"2025-03-17T23:24:04.000000Z"}]},{"id":5140467,"change_date":"2024-03-14 21:41:00","inspection_id":"80946857","dot_number":"190262","report_state":"MA","report_number":"CY00001795","insp_date":"2024-02-27 00:00:00","insp_start_time":"0045","insp_end_time":"0108","registration_date":"2024-03-14 00:00:00","region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","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-02-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"125900","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"486169","transaction_code":"C","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2024-02-27 21:38:00","snet_input_date":"2024-02-27 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-02-27 21:38:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:30.000000Z","updated_at":"2025-03-17T20:04:30.000000Z","inspection_violations":[{"id":7928273,"change_date":"2024-03-14 21:41:00","inspection_id":"80946857","insp_violation_id":"258376950","seq_no":"3","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"199907961","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"3969D2"},{"id":7928274,"change_date":"2024-03-14 21:41:00","inspection_id":"80946857","insp_violation_id":"258376951","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"3922"},{"id":7928275,"change_date":"2024-03-14 21:41:00","inspection_id":"80946857","insp_violation_id":"258376952","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199907961","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"474308AC","created_at":"2025-03-17T21:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8276799,"change_date":"2024-03-14 21:41:00","inspection_id":"80946857","insp_unit_id":"199907961","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"1AB38K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCK67LV79794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:00.000000Z","updated_at":"2025-03-17T23:10:00.000000Z"},{"id":8276800,"change_date":"2024-03-14 21:41:00","inspection_id":"80946857","insp_unit_id":"199907962","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478789","insp_unit_license":"421588Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41269JT019017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:00.000000Z","updated_at":"2025-03-17T23:10:00.000000Z"}]},{"id":5130445,"change_date":"2024-03-04 21:40:00","inspection_id":"80935812","dot_number":"190262","report_state":"CT","report_number":"3120999746","insp_date":"2024-02-26 00:00:00","insp_start_time":"0945","insp_end_time":"1025","registration_date":"2024-03-04 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"700571","transaction_code":"C","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-26 21:41:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:13.000000Z","updated_at":"2025-03-17T20:04:13.000000Z","inspection_violations":[{"id":7911674,"change_date":"2024-03-04 21:40:00","inspection_id":"80935812","insp_violation_id":"258169530","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199723107","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"39345B2"},{"id":7911675,"change_date":"2024-03-04 21:40:00","inspection_id":"80935812","insp_violation_id":"258169531","seq_no":"3","part_no":"393","part_no_section":"25(a)","insp_viol_unit":"1","insp_unit_id":"199723107","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"39325A"},{"id":7911676,"change_date":"2024-03-04 21:40:00","inspection_id":"80935812","insp_violation_id":"258169532","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199723107","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"3939A"},{"id":7911677,"change_date":"2024-03-04 21:40:00","inspection_id":"80935812","insp_violation_id":"258169533","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199723107","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:13.000000Z","updated_at":"2025-03-17T21:44:13.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8259940,"change_date":"2024-03-04 21:40:00","inspection_id":"80935812","insp_unit_id":"199723107","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"97448","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGLD55FSGA8123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:50.000000Z","updated_at":"2025-03-17T23:09:50.000000Z"}]},{"id":5059857,"change_date":"2024-02-15 21:42:00","inspection_id":"80858770","dot_number":"190262","report_state":"MA","report_number":"CH00005172","insp_date":"2024-02-15 00:00:00","insp_start_time":"0937","insp_end_time":"1021","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":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-02-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"485310","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2024-02-15 21:42:00","snet_input_date":"2024-02-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-02-15 21:42:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:48.000000Z","updated_at":"2025-03-17T20:02:48.000000Z","inspection_violations":[{"id":7799791,"change_date":"2024-02-15 21:42:00","inspection_id":"80858770","insp_violation_id":"257858580","seq_no":"1","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"199440295","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:41.000000Z","updated_at":"2025-03-17T21:43:41.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":8145016,"change_date":"2024-02-15 21:42:00","inspection_id":"80858770","insp_unit_id":"199440295","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"JIND","insp_unit_company":"CIZZ 456568","insp_unit_license":"2535405","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LV1GV45235S105409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:51.000000Z","updated_at":"2025-03-17T23:08:51.000000Z"},{"id":8145017,"change_date":"2024-02-15 21:42:00","inspection_id":"80858770","insp_unit_id":"199440296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"15654","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y1JM086323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:51.000000Z","updated_at":"2025-03-17T23:08:51.000000Z"}]},{"id":4798513,"change_date":"2024-01-18 21:44:00","inspection_id":"80572789","dot_number":"190262","report_state":"CT","report_number":"3120004350","insp_date":"2024-01-09 00:00:00","insp_start_time":"1114","insp_end_time":"1156","registration_date":"2024-01-18 00:00:00","region":"ET","ci_status_code":"C","location":"146","location_desc":"VERNON","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIA INTERMODAL LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"125900","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":"696442","transaction_code":"C","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-10 21:43:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:42.000000Z","updated_at":"2025-03-17T19:57:42.000000Z","inspection_violations":[{"id":7402228,"change_date":"2024-01-18 21:44:00","inspection_id":"80572789","insp_violation_id":"257385535","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199003911","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V125781-0","created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7720242,"change_date":"2024-01-18 21:44:00","inspection_id":"80572789","insp_unit_id":"199003911","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"321","insp_unit_license":"67958","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCG12LG27824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:01.000000Z","updated_at":"2025-03-17T23:05:01.000000Z"},{"id":7720243,"change_date":"2024-01-18 21:44:00","inspection_id":"80572789","insp_unit_id":"199003912","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 479388","insp_unit_license":"42187Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41269JT019616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:01.000000Z","updated_at":"2025-03-17T23:05:01.000000Z"}]},{"id":4297830,"change_date":"2023-10-27 21:42:00","inspection_id":"80022822","dot_number":"190262","report_state":"CT","report_number":"3015002341","insp_date":"2023-10-26 00:00:00","insp_start_time":"1216","insp_end_time":"1227","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL TRANS CO.","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"689924","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-10-27 21:42:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:54.000000Z","updated_at":"2025-03-17T19:47:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6912229,"change_date":"2023-10-27 21:42:00","inspection_id":"80022822","insp_unit_id":"197775475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"N\/A","insp_unit_license":"97448","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGLD55FSGA8123","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":4299922,"change_date":"2023-10-27 21:42:00","inspection_id":"80025156","dot_number":"190262","report_state":"VT","report_number":"4000005315","insp_date":"2023-10-25 00:00:00","insp_start_time":"0807","insp_end_time":"0827","registration_date":null,"region":"ET","ci_status_code":"C","location":"1424","location_desc":"WOODSTOCK","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":"N","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":"117000","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":"201386","transaction_code":"A","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-25 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-10-27 21:42:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","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":[],"inspection_per_units":[{"id":6915279,"change_date":"2023-10-27 21:42:00","inspection_id":"80025156","insp_unit_id":"197779333","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"39414","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y5AN011134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"},{"id":6915280,"change_date":"2023-10-27 21:42:00","inspection_id":"80025156","insp_unit_id":"197779334","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"528-7458","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5EF2GC409RB808841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"}]},{"id":4252262,"change_date":"2023-10-31 21:39:00","inspection_id":"79972204","dot_number":"190262","report_state":"CT","report_number":"3098002278","insp_date":"2023-10-23 00:00:00","insp_start_time":"0655","insp_end_time":"0728","registration_date":"2023-10-30 00:00:00","region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL TRANS CO INC","shipping_paper_number":"291287","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125100","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"689560","transaction_code":"C","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-10-23 21:41:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:04.000000Z","updated_at":"2025-03-17T19:47:04.000000Z","inspection_violations":[{"id":6584161,"change_date":"2023-10-31 21:39:00","inspection_id":"79972204","insp_violation_id":"256130058","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197826832","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39395A"},{"id":6584162,"change_date":"2023-10-31 21:39:00","inspection_id":"79972204","insp_violation_id":"256130059","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197826832","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39360C"},{"id":6584163,"change_date":"2023-10-31 21:39:00","inspection_id":"79972204","insp_violation_id":"256130060","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197826832","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39311"},{"id":6584164,"change_date":"2023-10-31 21:39:00","inspection_id":"79972204","insp_violation_id":"256130061","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197826832","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y999580-6","created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3922"},{"id":6584165,"change_date":"2023-10-31 21:39:00","inspection_id":"79972204","insp_violation_id":"256130062","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197826832","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y999580-6","created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6838383,"change_date":"2023-10-31 21:39:00","inspection_id":"79972204","insp_unit_id":"197826832","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"334","insp_unit_license":"75622","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XKWD49X1DJ315450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:19.000000Z","updated_at":"2025-03-17T22:57:19.000000Z"},{"id":6838384,"change_date":"2023-10-31 21:39:00","inspection_id":"79972204","insp_unit_id":"197826833","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"ST","insp_unit_company":"CIZZ 478587","insp_unit_license":"421386Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC4126XJT018815","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:19.000000Z","updated_at":"2025-03-17T22:57:19.000000Z"}]},{"id":4191005,"change_date":"2023-10-13 21:40:00","inspection_id":"79904621","dot_number":"190262","report_state":"NH","report_number":"0953006639","insp_date":"2023-10-12 00:00:00","insp_start_time":"0742","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":"222","location_desc":"WARNER","county_code_state":"NH","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"270101","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-12 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-10-13 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:52.000000Z","updated_at":"2025-03-17T19:45:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6739764,"change_date":"2023-10-13 21:40:00","inspection_id":"79904621","insp_unit_id":"197541108","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"15659","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y0CM023474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"}]},{"id":4008732,"change_date":"2023-10-03 21:40:00","inspection_id":"79702390","dot_number":"190262","report_state":"CT","report_number":"3022000032","insp_date":"2023-09-20 00:00:00","insp_start_time":"0654","insp_end_time":"0839","registration_date":"2023-10-03 00:00:00","region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"290765","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118400","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"686584","transaction_code":"C","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:01.000000Z","updated_at":"2025-03-17T19:42:01.000000Z","inspection_violations":[{"id":6203254,"change_date":"2023-10-03 21:40:00","inspection_id":"79702390","insp_violation_id":"255613263","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197359694","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39360C"},{"id":6203255,"change_date":"2023-10-03 21:40:00","inspection_id":"79702390","insp_violation_id":"255613264","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"197359694","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39345"},{"id":6203256,"change_date":"2023-10-03 21:40:00","inspection_id":"79702390","insp_violation_id":"255613265","seq_no":"3","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"197359694","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":6446109,"change_date":"2023-10-03 21:40:00","inspection_id":"79702390","insp_unit_id":"197359694","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"334","insp_unit_license":"75622","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XKWD49X1DJ315450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:07.000000Z","updated_at":"2025-03-17T22:54:07.000000Z"},{"id":6446110,"change_date":"2023-10-03 21:40:00","inspection_id":"79702390","insp_unit_id":"197359695","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"WORZ 2140","insp_unit_license":"2679350","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"145C242SXGL001578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:07.000000Z","updated_at":"2025-03-17T22:54:07.000000Z"}]},{"id":3950694,"change_date":"2023-10-03 21:40:00","inspection_id":"79638014","dot_number":"190262","report_state":"MA","report_number":"CH00004942","insp_date":"2023-09-12 00:00:00","insp_start_time":"1046","insp_end_time":"1214","registration_date":"2023-10-03 00:00:00","region":"ET","ci_status_code":"C","location":"385H","location_desc":"H-WOBURN","county_code_state":"MA","county_code":"017","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL TRANS CO INC","shipping_paper_number":"290686","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-09-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"125100","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":"473788","transaction_code":"C","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2023-09-12 21:39:00","snet_input_date":"2023-09-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-09-12 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:49.000000Z","updated_at":"2025-03-17T19:40:49.000000Z","inspection_violations":[{"id":6108723,"change_date":"2023-10-03 21:40:00","inspection_id":"79638014","insp_violation_id":"255615201","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197360980","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39617C"},{"id":6108724,"change_date":"2023-10-03 21:40:00","inspection_id":"79638014","insp_violation_id":"255615202","seq_no":"2","part_no":"393","part_no_section":"60(b)","insp_viol_unit":"1","insp_unit_id":"197360980","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39360B"},{"id":6108725,"change_date":"2023-10-03 21:40:00","inspection_id":"79638014","insp_violation_id":"255615203","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197360980","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39347E"},{"id":6108726,"change_date":"2023-10-03 21:40:00","inspection_id":"79638014","insp_violation_id":"255615204","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197360980","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":6352688,"change_date":"2023-10-03 21:40:00","inspection_id":"79638014","insp_unit_id":"197360980","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"75622","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XKWD49X1DJ315450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:22.000000Z","updated_at":"2025-03-17T22:53:22.000000Z"},{"id":6352689,"change_date":"2023-10-03 21:40:00","inspection_id":"79638014","insp_unit_id":"197360981","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CTIC","insp_unit_company":"CIZZ 478616","insp_unit_license":"421415Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41266JT018844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:22.000000Z","updated_at":"2025-03-17T22:53:22.000000Z"}]},{"id":3862736,"change_date":"2023-08-30 21:43:00","inspection_id":"79540095","dot_number":"190262","report_state":"CT","report_number":"3129004280","insp_date":"2023-08-29 00:00:00","insp_start_time":"1534","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"684897","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-30 21:43:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:20.000000Z","updated_at":"2025-03-17T19:39:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6210365,"change_date":"2023-08-30 21:43:00","inspection_id":"79540095","insp_unit_id":"196798648","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"84275","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJA6CKX4LN31057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:11.000000Z","updated_at":"2025-03-17T22:52:11.000000Z"}]},{"id":3742754,"change_date":"2023-08-15 21:42:00","inspection_id":"79405981","dot_number":"190262","report_state":"MA","report_number":"CD00006553","insp_date":"2023-08-14 00:00:00","insp_start_time":"1552","insp_end_time":"1611","registration_date":null,"region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","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-08-15 21:42: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":"472041","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2023-08-15 21:42:00","snet_input_date":"2023-08-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-08-15 21:42:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:52.000000Z","updated_at":"2025-03-17T19:36:52.000000Z","inspection_violations":[{"id":5772370,"change_date":"2023-08-15 21:42:00","inspection_id":"79405981","insp_violation_id":"254651431","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:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6018087,"change_date":"2023-08-15 21:42:00","inspection_id":"79405981","insp_unit_id":"196529483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"84","insp_unit_license":"1AA98F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y8GM057054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:34.000000Z","updated_at":"2025-03-17T22:50:34.000000Z"},{"id":6018088,"change_date":"2023-08-15 21:42:00","inspection_id":"79405981","insp_unit_id":"196529484","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478638","insp_unit_license":"421437Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41265JT018866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:34.000000Z","updated_at":"2025-03-17T22:50:34.000000Z"}]},{"id":3637678,"change_date":"2023-08-08 21:40:00","inspection_id":"79288522","dot_number":"190262","report_state":"CT","report_number":"3132003994","insp_date":"2023-08-01 00:00:00","insp_start_time":"0944","insp_end_time":"1002","registration_date":"2023-08-08 00:00:00","region":"ET","ci_status_code":"C","location":"160","location_desc":"WILLINGTON","county_code_state":"CT","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":"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":"2023-08-01 21:41: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":"682130","transaction_code":"C","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-01 21:41:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:37.000000Z","updated_at":"2025-03-17T19:34:37.000000Z","inspection_violations":[{"id":5609218,"change_date":"2023-08-08 21:40:00","inspection_id":"79288522","insp_violation_id":"254523466","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":"Y9981106","created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5848965,"change_date":"2023-08-08 21:40:00","inspection_id":"79288522","insp_unit_id":"196415011","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3099B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW07Y0GM077632","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:10.000000Z","updated_at":"2025-03-17T22:49:10.000000Z"}]},{"id":3648518,"change_date":"2023-08-29 21:41:00","inspection_id":"79300536","dot_number":"190262","report_state":"NH","report_number":"1085003353","insp_date":"2023-08-01 00:00:00","insp_start_time":"1505","insp_end_time":"1615","registration_date":"2023-08-29 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"NORTHFIELD","county_code_state":"NH","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-02 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"125900","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":"268074","transaction_code":"C","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-08-02 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:56.000000Z","updated_at":"2025-03-17T19:34:56.000000Z","inspection_violations":[{"id":5625949,"change_date":"2023-08-29 21:41:00","inspection_id":"79300536","insp_violation_id":"254941779","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3922"},{"id":5625950,"change_date":"2023-08-29 21:41:00","inspection_id":"79300536","insp_violation_id":"254941780","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196778054","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":5866379,"change_date":"2023-08-29 21:41:00","inspection_id":"79300536","insp_unit_id":"196778054","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"78","insp_unit_license":"80992","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y1CM021524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:19.000000Z","updated_at":"2025-03-17T22:49:19.000000Z"},{"id":5866380,"change_date":"2023-08-29 21:41:00","inspection_id":"79300536","insp_unit_id":"196778055","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"422219Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41260JT019648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:19.000000Z","updated_at":"2025-03-17T22:49:19.000000Z"}]},{"id":3626919,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","dot_number":"190262","report_state":"CT","report_number":"3010002822","insp_date":"2023-07-31 00:00:00","insp_start_time":"0513","insp_end_time":"0605","registration_date":null,"region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ICI","shipping_paper_number":"081384","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73950","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"681903","transaction_code":"A","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-31 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-31 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:33.000000Z","updated_at":"2025-03-17T19:34:33.000000Z","inspection_violations":[{"id":5593342,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_violation_id":"254361173","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"196266670","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39345D"},{"id":5593343,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_violation_id":"254361174","seq_no":"7","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"196266670","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39345D"},{"id":5593344,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_violation_id":"254361175","seq_no":"8","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"196266670","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39345D"},{"id":5593345,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_violation_id":"254361176","seq_no":"9","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"196266670","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39345D"},{"id":5593346,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_violation_id":"254361177","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196266669","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"3922"},{"id":5593347,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_violation_id":"254361178","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196266669","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"3939A"},{"id":5593348,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_violation_id":"254361179","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196266669","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39345B2"},{"id":5593349,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_violation_id":"254361180","seq_no":"4","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"196266669","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39355D1"},{"id":5593350,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_violation_id":"254361181","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196266669","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5831504,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_unit_id":"196266669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"25","insp_unit_license":"1AB38K","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCK67LV79794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"},{"id":5831505,"change_date":"2023-07-31 21:40:00","inspection_id":"79276489","insp_unit_id":"196266670","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"WORZ 6580","insp_unit_license":"249890","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41265F1009197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"}]},{"id":3371343,"change_date":"2023-06-30 21:39:00","inspection_id":"78989413","dot_number":"190262","report_state":"CT","report_number":"3025002539","insp_date":"2023-06-26 00:00:00","insp_start_time":"1535","insp_end_time":"1609","registration_date":"2023-06-30 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EISU188650542G1","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":"2023-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125900","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":"678684","transaction_code":"C","transaction_date":"2023-06-26 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:46.000000Z","updated_at":"2025-03-17T19:29:46.000000Z","inspection_violations":[{"id":5198948,"change_date":"2023-06-30 21:39:00","inspection_id":"78989413","insp_violation_id":"253807908","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:31:06.000000Z","updated_at":"2025-03-17T21:31:06.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5419507,"change_date":"2023-06-30 21:39:00","inspection_id":"78989413","insp_unit_id":"195773735","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"84","insp_unit_license":"1AA98F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y8GM057054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:45.000000Z","updated_at":"2025-03-17T22:45:45.000000Z"},{"id":5419508,"change_date":"2023-06-30 21:39:00","inspection_id":"78989413","insp_unit_id":"195773736","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 479408","insp_unit_license":"422207Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41264JT019636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:45.000000Z","updated_at":"2025-03-17T22:45:45.000000Z"}]},{"id":3147236,"change_date":"2023-05-31 21:41:00","inspection_id":"78736468","dot_number":"190262","report_state":"CT","report_number":"3015002067","insp_date":"2023-05-26 00:00:00","insp_start_time":"0808","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL TRANSPORTATION","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"675528","transaction_code":"C","transaction_date":"2023-05-26 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-26 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","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":[],"inspection_per_units":[{"id":5061866,"change_date":"2023-05-31 21:41:00","inspection_id":"78736468","insp_unit_id":"195217039","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"N\/A","insp_unit_license":"67958","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCG12LG27824","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":2969731,"change_date":"2023-05-05 21:41:00","inspection_id":"78536264","dot_number":"190262","report_state":"CT","report_number":"3120003737","insp_date":"2023-05-05 00:00:00","insp_start_time":"0915","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL TRANS. CO., INC.","shipping_paper_number":"288897","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"673623","transaction_code":"A","transaction_date":"2023-05-05 00:00:00","upload_date":"2023-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-05 21:41:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:51.000000Z","updated_at":"2025-03-17T19:21:51.000000Z","inspection_violations":[{"id":4557671,"change_date":"2023-05-05 21:41:00","inspection_id":"78536264","insp_violation_id":"252635033","seq_no":"1","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"194761321","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:13.000000Z","updated_at":"2025-03-17T21:28:13.000000Z","normalized_code":"39375A2"}],"inspection_per_units":[{"id":4778383,"change_date":"2023-05-05 21:41:00","inspection_id":"78536264","insp_unit_id":"194761320","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"83","insp_unit_license":"1AD53T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y9JM085209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:39.000000Z","updated_at":"2025-03-17T22:40:39.000000Z"},{"id":4778384,"change_date":"2023-05-05 21:41:00","inspection_id":"78536264","insp_unit_id":"194761321","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"WORZ 2130","insp_unit_license":"238732","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"145C242S9JL003961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:39.000000Z","updated_at":"2025-03-17T22:40:39.000000Z"}]},{"id":2927593,"change_date":"2023-05-22 21:40:00","inspection_id":"78488769","dot_number":"190262","report_state":"CT","report_number":"3015002007","insp_date":"2023-05-01 00:00:00","insp_start_time":"0836","insp_end_time":"0857","registration_date":"2023-05-22 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL TRANS COMPANY INC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"673162","transaction_code":"C","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-01 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:54.000000Z","updated_at":"2025-03-17T19:20:54.000000Z","inspection_violations":[{"id":4495568,"change_date":"2023-05-22 21:40:00","inspection_id":"78488769","insp_violation_id":"252976334","seq_no":"1","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39522H4"},{"id":4495569,"change_date":"2023-05-22 21:40:00","inspection_id":"78488769","insp_violation_id":"252976335","seq_no":"2","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":4710242,"change_date":"2023-05-22 21:40:00","inspection_id":"78488769","insp_unit_id":"195055502","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"N\/A","insp_unit_license":"67958","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCG12LG27824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:09.000000Z","updated_at":"2025-03-17T22:40:09.000000Z"}]},{"id":2792484,"change_date":"2023-04-13 21:42:00","inspection_id":"78335644","dot_number":"190262","report_state":"MA","report_number":"DP00000002","insp_date":"2023-04-12 00:00:00","insp_start_time":"1044","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL TRANS CO","shipping_paper_number":"288612","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-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125900","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":"463885","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2023-04-13 21:42:00","snet_input_date":"2023-04-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-04-13 21:42:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:06.000000Z","updated_at":"2025-03-17T19:18:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4494529,"change_date":"2023-04-13 21:42:00","inspection_id":"78335644","insp_unit_id":"194358457","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"83","insp_unit_license":"1AD53T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y9JM085209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:25.000000Z","updated_at":"2025-03-17T22:38:25.000000Z"},{"id":4494530,"change_date":"2023-04-13 21:42:00","inspection_id":"78335644","insp_unit_id":"194358458","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478612","insp_unit_license":"421411Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41269JT018840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:25.000000Z","updated_at":"2025-03-17T22:38:25.000000Z"}]},{"id":2520046,"change_date":"2023-03-15 21:41:00","inspection_id":"78025526","dot_number":"190262","report_state":"CT","report_number":"3064000953","insp_date":"2023-03-07 00:00:00","insp_start_time":"1628","insp_end_time":"1653","registration_date":"2023-03-15 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"TRADER JOE'S","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":"2023-03-07 21:41: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":"668712","transaction_code":"C","transaction_date":"2023-03-07 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-07 21:41:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:17.000000Z","updated_at":"2025-03-17T19:13:17.000000Z","inspection_violations":[{"id":3875618,"change_date":"2023-03-15 21:41:00","inspection_id":"78025526","insp_violation_id":"251671892","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":"Y994431-2","created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4056180,"change_date":"2023-03-15 21:41:00","inspection_id":"78025526","insp_unit_id":"193880948","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"84275","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJA6CKX4LN31057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:05.000000Z","updated_at":"2025-03-17T22:35:05.000000Z"},{"id":4056181,"change_date":"2023-03-15 21:41:00","inspection_id":"78025526","insp_unit_id":"193880949","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAC","insp_unit_company":"CIZZ 478812","insp_unit_license":"421611Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41264JT019040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:05.000000Z","updated_at":"2025-03-17T22:35:05.000000Z"}]},{"id":2406482,"change_date":"2023-02-24 21:40:00","inspection_id":"77896364","dot_number":"190262","report_state":"VT","report_number":"53B0001661","insp_date":"2023-02-15 00:00:00","insp_start_time":"0916","insp_end_time":"0954","registration_date":"2023-02-22 00:00:00","region":"ET","ci_status_code":"C","location":"0909NB","location_desc":"RANDOLPH NB RA","county_code_state":"VT","county_code":"017","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"THE SALVATION ARMY","shipping_paper_number":"287900","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"196951","transaction_code":"C","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-15 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-02-21 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:03.000000Z","updated_at":"2025-03-17T19:11:03.000000Z","inspection_violations":[{"id":3704644,"change_date":"2023-02-24 21:40:00","inspection_id":"77896364","insp_violation_id":"251319048","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"193564391","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":3872313,"change_date":"2023-02-24 21:40:00","inspection_id":"77896364","insp_unit_id":"193564390","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"80","insp_unit_license":"15659","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y0CM023474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:44.000000Z","updated_at":"2025-03-17T22:33:44.000000Z"},{"id":3872314,"change_date":"2023-02-24 21:40:00","inspection_id":"77896364","insp_unit_id":"193564391","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"CIZZ 434141","insp_unit_license":"2530185","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC4126551014933","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:44.000000Z","updated_at":"2025-03-17T22:33:44.000000Z"}]},{"id":2300536,"change_date":"2023-03-08 21:40:00","inspection_id":"77775479","dot_number":"190262","report_state":"ME","report_number":"3998010412","insp_date":"2023-02-06 00:00:00","insp_start_time":"0925","insp_end_time":"0952","registration_date":"2023-03-08 00:00:00","region":"ET","ci_status_code":"C","location":"000231","location_desc":"HINCKLEY SCALE AREA","county_code_state":"ME","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"KENNEBEC LUMBER","shipping_paper_number":"287738","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":"I","final_status_date":"2023-02-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"360187","transaction_code":"C","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-06 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-02-06 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:12.000000Z","updated_at":"2025-03-17T19:09:12.000000Z","inspection_violations":[{"id":3546193,"change_date":"2023-03-08 21:40:00","inspection_id":"77775479","insp_violation_id":"251533524","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193760403","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3963A1"},{"id":3546194,"change_date":"2023-03-08 21:40:00","inspection_id":"77775479","insp_violation_id":"251533525","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193760403","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3703014,"change_date":"2023-03-08 21:40:00","inspection_id":"77775479","insp_unit_id":"193760403","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"80","insp_unit_license":"15659","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y0CM023474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:31.000000Z","updated_at":"2025-03-17T22:32:31.000000Z"},{"id":3703015,"change_date":"2023-03-08 21:40:00","inspection_id":"77775479","insp_unit_id":"193760404","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"TLXZ434076","insp_unit_license":"2530120","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC4126951014868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:31.000000Z","updated_at":"2025-03-17T22:32:31.000000Z"}]},{"id":2137265,"change_date":"2023-02-14 21:40:00","inspection_id":"77588965","dot_number":"190262","report_state":"MA","report_number":"CY00000481","insp_date":"2023-01-12 00:00:00","insp_start_time":"1831","insp_end_time":"1853","registration_date":"2023-02-14 00:00:00","region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","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-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"125900","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":"458677","transaction_code":"C","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2023-01-13 21:39:00","snet_input_date":"2023-01-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-01-13 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:55.000000Z","updated_at":"2025-03-17T19:05:55.000000Z","inspection_violations":[{"id":3307275,"change_date":"2023-02-14 21:40:00","inspection_id":"77588965","insp_violation_id":"251116194","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:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3439517,"change_date":"2023-02-14 21:40:00","inspection_id":"77588965","insp_unit_id":"193381636","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"81","insp_unit_license":"3099B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW07Y0GM077632","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:38.000000Z","updated_at":"2025-03-17T22:30:38.000000Z"},{"id":3439518,"change_date":"2023-02-14 21:40:00","inspection_id":"77588965","insp_unit_id":"193381637","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478620","insp_unit_license":"421419Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41263JT018848","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:38.000000Z","updated_at":"2025-03-17T22:30:38.000000Z"}]},{"id":1897559,"change_date":"2022-12-08 21:40:00","inspection_id":"77314562","dot_number":"190262","report_state":"CT","report_number":"3011000038","insp_date":"2022-12-08 00:00:00","insp_start_time":"0919","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL TRANS.","shipping_paper_number":"286910","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"104300","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":"660594","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-08 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:32.000000Z","updated_at":"2025-03-17T19:01:32.000000Z","inspection_violations":[{"id":2952627,"change_date":"2022-12-08 21:40:00","inspection_id":"77314562","insp_violation_id":"249983451","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"192318049","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":3053907,"change_date":"2022-12-08 21:40:00","inspection_id":"77314562","insp_unit_id":"192318048","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"83","insp_unit_license":"1AD53T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y9JM085209","insp_unit_decal":"Y","insp_unit_decal_number":"32053269","created_at":"2025-03-17T22:27:54.000000Z","updated_at":"2025-03-17T22:27:54.000000Z"},{"id":3053908,"change_date":"2022-12-08 21:40:00","inspection_id":"77314562","insp_unit_id":"192318049","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"AJAX","insp_unit_company":"CIZZ 213643","insp_unit_license":"3716368","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1AJC23289W1005025","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:54.000000Z","updated_at":"2025-03-17T22:27:54.000000Z"}]},{"id":1865049,"change_date":"2022-12-05 21:39:00","inspection_id":"77277661","dot_number":"190262","report_state":"CT","report_number":"3132003395","insp_date":"2022-12-05 00:00:00","insp_start_time":"0807","insp_end_time":"0827","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"660228","transaction_code":"A","transaction_date":"2022-12-05 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-05 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:05.000000Z","updated_at":"2025-03-17T19:01:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3001577,"change_date":"2022-12-05 21:39:00","inspection_id":"77277661","insp_unit_id":"192244473","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"67958","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJBBCG12LG27824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:33.000000Z","updated_at":"2025-03-17T22:27:33.000000Z"}]},{"id":1777809,"change_date":"2022-11-21 21:40:00","inspection_id":"77177691","dot_number":"190262","report_state":"MA","report_number":"CR00002657","insp_date":"2022-11-21 00:00:00","insp_start_time":"0800","insp_end_time":"0829","registration_date":null,"region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","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":"2022-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"455754","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2022-11-21 21:40:00","snet_input_date":"2022-11-21 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-11-21 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:20.000000Z","updated_at":"2025-03-17T18:59:20.000000Z","inspection_violations":[{"id":2783505,"change_date":"2022-11-21 21:40:00","inspection_id":"77177691","insp_violation_id":"249697903","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192044164","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:05.000000Z","updated_at":"2025-03-17T21:20:05.000000Z","normalized_code":"3963A1"},{"id":2783506,"change_date":"2022-11-21 21:40:00","inspection_id":"77177691","insp_violation_id":"249697904","seq_no":"2","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"192044164","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:05.000000Z","updated_at":"2025-03-17T21:20:05.000000Z","normalized_code":"39343A"},{"id":2783507,"change_date":"2022-11-21 21:40:00","inspection_id":"77177691","insp_violation_id":"249697905","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192044164","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:05.000000Z","updated_at":"2025-03-17T21:20:05.000000Z","normalized_code":"3963A1"},{"id":2783508,"change_date":"2022-11-21 21:40:00","inspection_id":"77177691","insp_violation_id":"249697906","seq_no":"4","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"192044164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:05.000000Z","updated_at":"2025-03-17T21:20:05.000000Z","normalized_code":"39345"},{"id":2783509,"change_date":"2022-11-21 21:40:00","inspection_id":"77177691","insp_violation_id":"249697907","seq_no":"5","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"192044164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:05.000000Z","updated_at":"2025-03-17T21:20:05.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":2860244,"change_date":"2022-11-21 21:40:00","inspection_id":"77177691","insp_unit_id":"192044164","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"84275","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJA6CKX4LN31057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:35.000000Z","updated_at":"2025-03-17T22:26:35.000000Z"}]},{"id":1299275,"change_date":"2022-10-11 21:40:00","inspection_id":"76625756","dot_number":"190262","report_state":"MA","report_number":"CD00005503","insp_date":"2022-09-16 00:00:00","insp_start_time":"0542","insp_end_time":"0603","registration_date":"2022-10-11 00:00:00","region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","county_code_state":"MA","county_code":"017","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":"2022-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"452096","transaction_code":"C","transaction_date":"2022-09-16 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":"2022-09-16 21:40:00","snet_input_date":"2022-09-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-09-16 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"1529","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:31.000000Z","updated_at":"2025-03-17T18:50:31.000000Z","inspection_violations":[{"id":2055985,"change_date":"2022-10-11 21:40:00","inspection_id":"76625756","insp_violation_id":"248928677","seq_no":"1","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"191355386","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"39323"}],"inspection_per_units":[{"id":2091477,"change_date":"2022-10-11 21:40:00","inspection_id":"76625756","insp_unit_id":"191355385","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"76","insp_unit_license":"90076","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y08N003114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:21.000000Z","updated_at":"2025-03-17T22:21:21.000000Z"},{"id":2091478,"change_date":"2022-10-11 21:40:00","inspection_id":"76625756","insp_unit_id":"191355386","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478787","insp_unit_license":"421586Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41265JT019015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:21.000000Z","updated_at":"2025-03-17T22:21:21.000000Z"}]},{"id":939963,"change_date":"2022-08-16 21:38:00","inspection_id":"76207401","dot_number":"190262","report_state":"CT","report_number":"3091004115","insp_date":"2022-08-02 00:00:00","insp_start_time":"1430","insp_end_time":"1505","registration_date":"2022-08-16 00:00:00","region":"ET","ci_status_code":"C","location":"077","location_desc":"MANCHESTER","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"IDEAL TRANSPORTATION COMPANY INC","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"650472","transaction_code":"C","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-02 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:07.000000Z","updated_at":"2025-03-17T18:44:07.000000Z","inspection_violations":[{"id":1483008,"change_date":"2022-08-16 21:38:00","inspection_id":"76207401","insp_violation_id":"247723797","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:14:03.000000Z","updated_at":"2025-03-17T21:14:03.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1513120,"change_date":"2022-08-16 21:38:00","inspection_id":"76207401","insp_unit_id":"190318320","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"78","insp_unit_license":"80992","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y1CM021524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:31.000000Z","updated_at":"2025-03-17T22:17:31.000000Z"}]},{"id":949277,"change_date":"2022-08-22 21:41:00","inspection_id":"76218307","dot_number":"190262","report_state":"CT","report_number":"3010001942","insp_date":"2022-08-02 00:00:00","insp_start_time":"1548","insp_end_time":"1621","registration_date":"2022-08-22 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-03 21:41: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":"650502","transaction_code":"C","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-03 21:41:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:24.000000Z","updated_at":"2025-03-17T18:44:24.000000Z","inspection_violations":[{"id":1497833,"change_date":"2022-08-22 21:41:00","inspection_id":"76218307","insp_violation_id":"247864432","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":"Y990256-6","created_at":"2025-03-17T21:14:05.000000Z","updated_at":"2025-03-17T21:14:05.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":1528764,"change_date":"2022-08-22 21:41:00","inspection_id":"76218307","insp_unit_id":"190438511","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"84275","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGLDR9CSBD6542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:37.000000Z","updated_at":"2025-03-17T22:17:37.000000Z"},{"id":1528765,"change_date":"2022-08-22 21:41:00","inspection_id":"76218307","insp_unit_id":"190438512","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CVGC","insp_unit_company":"CIZZ 430903","insp_unit_license":"252839","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LT1CC41205C009770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:37.000000Z","updated_at":"2025-03-17T22:17:37.000000Z"}]},{"id":940065,"change_date":"2022-08-02 21:39:00","inspection_id":"76207528","dot_number":"190262","report_state":"ME","report_number":"4456001745","insp_date":"2022-08-01 00:00:00","insp_start_time":"1419","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":"000440","location_desc":"SIDNEY - SCALES","county_code_state":"ME","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"62080","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":"350735","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-02 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-08-02 21:39:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:21.000000Z","updated_at":"2025-03-17T18:44:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1513256,"change_date":"2022-08-02 21:39:00","inspection_id":"76207528","insp_unit_id":"190077484","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"15659","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y0CM023474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:31.000000Z","updated_at":"2025-03-17T22:17:31.000000Z"},{"id":1513257,"change_date":"2022-08-02 21:39:00","inspection_id":"76207528","insp_unit_id":"190077485","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GSCR","insp_unit_company":null,"insp_unit_license":"2592156","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"48ZSC23232W001868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:31.000000Z","updated_at":"2025-03-17T22:17:31.000000Z"}]},{"id":767504,"change_date":"2022-07-07 21:41:00","inspection_id":"76005492","dot_number":"190262","report_state":"NH","report_number":"1291002335","insp_date":"2022-07-06 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"080","location_desc":"CONCORD","county_code_state":"NH","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":"2022-07-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123900","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":"258190","transaction_code":"A","transaction_date":"2022-07-06 00:00:00","upload_date":"2022-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-06 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-07-07 21:41:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:13.000000Z","updated_at":"2025-03-17T18:41:13.000000Z","inspection_violations":[{"id":1210856,"change_date":"2022-07-07 21:41:00","inspection_id":"76005492","insp_violation_id":"246939286","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"3922"},{"id":1210857,"change_date":"2022-07-07 21:41:00","inspection_id":"76005492","insp_violation_id":"246939287","seq_no":"2","part_no":"391","part_no_section":"11(b)(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:12:40.000000Z","updated_at":"2025-03-17T21:12:40.000000Z","normalized_code":"39111B2"}],"inspection_per_units":[{"id":1234576,"change_date":"2022-07-07 21:41:00","inspection_id":"76005492","insp_unit_id":"189645181","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"79","insp_unit_license":"15660","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AW02Y2CM024285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:46.000000Z","updated_at":"2025-03-17T22:15:46.000000Z"},{"id":1234577,"change_date":"2022-07-07 21:41:00","inspection_id":"76005492","insp_unit_id":"189645182","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CLMB","insp_unit_company":"TAXZ 478473","insp_unit_license":"421272Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41266JT018701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:46.000000Z","updated_at":"2025-03-17T22:15:46.000000Z"}]},{"id":314957,"change_date":"2022-05-04 21:40:00","inspection_id":"75468771","dot_number":"190262","report_state":"CT","report_number":"3120002935","insp_date":"2022-05-04 00:00:00","insp_start_time":"0756","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CONLEY TERMINALS","shipping_paper_number":"282554","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123900","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":"643514","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00190262","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-05-04 21:40:00","insp_carrier_name":"IDEAL TRANSPORTATION COMPANY INC","insp_carrier_street":"17 OAK STREET","insp_carrier_city":"PEABODY","insp_carrier_state":"MA","insp_carrier_zip_code":"01960","insp_colonia":null,"docket_number":"152947","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:58.000000Z","updated_at":"2025-03-17T18:32:58.000000Z","inspection_violations":[{"id":491306,"change_date":"2022-05-04 21:40:00","inspection_id":"75468771","insp_violation_id":"245558165","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188491059","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3922"},{"id":491307,"change_date":"2022-05-04 21:40:00","inspection_id":"75468771","insp_violation_id":"245558166","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188491059","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":509506,"change_date":"2022-05-04 21:40:00","inspection_id":"75468771","insp_unit_id":"188491059","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"66","insp_unit_license":"7195A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AA13Y5WW090342","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:19.000000Z","updated_at":"2025-03-17T22:11:19.000000Z"},{"id":509507,"change_date":"2022-05-04 21:40:00","inspection_id":"75468771","insp_unit_id":"188491060","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CIZZ 478832","insp_unit_license":"421631Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1M1AA13Y5WW090342","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:19.000000Z","updated_at":"2025-03-17T22:11:19.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/190262\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/190262\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/190262\/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\/190262\/inspections","per_page":100,"prev_page_url":null,"to":57,"total":57}