{"current_page":1,"data":[{"id":12372969,"change_date":"2026-07-07 21:40:00","inspection_id":"88335456","dot_number":"3350619","report_state":"MI","report_number":"LITTJ05753","insp_date":"2026-07-07 00:00:00","insp_start_time":"0935","insp_end_time":"0950","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"U","pen_cen_match":"I","final_status_date":"2026-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3697861","transaction_code":"A","transaction_date":"2026-07-07 00:00:00","upload_date":"2026-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-07-07 21:40:00","snet_input_date":"2026-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-07 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-10T09:40:18.000000Z","updated_at":"2026-07-18T09:30:40.000000Z","inspection_violations":[{"id":21533868,"change_date":"2026-07-07 21:40:00","inspection_id":"88335456","insp_violation_id":"275333921","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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-07-10T09:59:11.000000Z","updated_at":"2026-07-18T09:41:59.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":21485488,"change_date":"2026-07-07 21:40:00","inspection_id":"88335456","insp_unit_id":"214475213","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"NONE","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:34.000000Z","updated_at":"2026-07-18T09:01:55.000000Z"},{"id":21485489,"change_date":"2026-07-07 21:40:00","inspection_id":"88335456","insp_unit_id":"214475214","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADVT","insp_unit_company":"NONE","insp_unit_license":"TUE4510","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:34.000000Z","updated_at":"2026-07-18T09:01:55.000000Z"}]},{"id":12271061,"change_date":"2026-06-25 21:50:00","inspection_id":"88230352","dot_number":"3350619","report_state":"PA","report_number":"XL00112506","insp_date":"2026-06-24 00:00:00","insp_start_time":"0845","insp_end_time":"0930","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MIFFLIN TWP PA","county_code_state":"PA","county_code":"037","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SALEM TUBE","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":"U","pen_cen_match":"I","final_status_date":"2026-06-25 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3611062","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-06-25 21:50:00","snet_input_date":"2026-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:50:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"OH","created_at":"2026-06-28T09:39:28.000000Z","updated_at":"2026-07-06T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21308454,"change_date":"2026-06-25 21:50:00","inspection_id":"88230352","insp_unit_id":"214267997","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:14:49.000000Z","updated_at":"2026-07-06T09:02:40.000000Z"},{"id":21308455,"change_date":"2026-06-25 21:50:00","inspection_id":"88230352","insp_unit_id":"214267998","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADVANCE TR","insp_unit_company":null,"insp_unit_license":"TUE4510","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:14:49.000000Z","updated_at":"2026-07-06T09:02:40.000000Z"}]},{"id":12217986,"change_date":"2026-06-18 21:41:00","inspection_id":"88175544","dot_number":"3350619","report_state":"OH","report_number":"1706000895","insp_date":"2026-06-16 00:00:00","insp_start_time":"1029","insp_end_time":"1058","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WAPAKONETA OH","county_code_state":"OH","county_code":"011","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AESI","shipping_paper_number":"2570073","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3566856","transaction_code":"A","transaction_date":"2026-06-17 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-06-18 21:41:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:28.000000Z","updated_at":"2026-06-29T09:30:13.000000Z","inspection_violations":[{"id":21265564,"change_date":"2026-06-18 21:41:00","inspection_id":"88175544","insp_violation_id":"274983538","seq_no":"1","part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"2","insp_unit_id":"214164235","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:38.000000Z","updated_at":"2026-06-29T09:41:45.000000Z","normalized_code":"393205CWRAWFLMIB"}],"inspection_per_units":[{"id":21219590,"change_date":"2026-06-18 21:41:00","inspection_id":"88175544","insp_unit_id":"214164235","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"7","insp_unit_license":"TUE4510","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:15.000000Z","updated_at":"2026-06-29T09:01:02.000000Z"},{"id":21219589,"change_date":"2026-06-18 21:41:00","inspection_id":"88175544","insp_unit_id":"214164234","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"8","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:15.000000Z","updated_at":"2026-06-29T09:01:02.000000Z"}]},{"id":12002023,"change_date":"2026-05-23 21:35:00","inspection_id":"87940544","dot_number":"3350619","report_state":"OH","report_number":"1808001267","insp_date":"2026-05-21 00:00:00","insp_start_time":"1437","insp_end_time":"1523","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CANTON OH","county_code_state":"OH","county_code":"151","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ADVANCED BULK & CONVEYING INC.","shipping_paper_number":"4824432","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-23 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3389494","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-05-23 21:35:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-23 21:35:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-26T09:42:19.000000Z","updated_at":"2026-06-03T09:30:23.000000Z","inspection_violations":[{"id":20882395,"change_date":"2026-05-23 21:35:00","inspection_id":"87940544","insp_violation_id":"274463919","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"213720898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-26T10:04:21.000000Z","updated_at":"2026-06-03T09:40:03.000000Z","normalized_code":"3939ALSML"},{"id":20882394,"change_date":"2026-05-23 21:35:00","inspection_id":"87940544","insp_violation_id":"274463918","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"213720898","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-26T10:04:21.000000Z","updated_at":"2026-06-03T09:40:03.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":20863824,"change_date":"2026-05-23 21:35:00","inspection_id":"87940544","insp_unit_id":"213720897","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"14","insp_unit_license":"PNR6266","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4HG713307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-26T09:20:17.000000Z","updated_at":"2026-06-03T09:01:56.000000Z"},{"id":20863825,"change_date":"2026-05-23 21:35:00","inspection_id":"87940544","insp_unit_id":"213720898","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJ TRAILER","insp_unit_company":"3","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-26T09:20:17.000000Z","updated_at":"2026-06-03T09:01:56.000000Z"}]},{"id":11922469,"change_date":"2026-05-15 21:43:00","inspection_id":"87856704","dot_number":"3350619","report_state":"WI","report_number":"2505002562","insp_date":"2026-05-12 00:00:00","insp_start_time":"0904","insp_end_time":"0938","registration_date":null,"region":"CD","ci_status_code":"C","location":"S21","location_desc":"PLEASANT PRAIRIE WI","county_code_state":"WI","county_code":"059","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3328981","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-05-15 21:43:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:43:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:24.000000Z","updated_at":"2026-05-26T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20734856,"change_date":"2026-05-15 21:43:00","inspection_id":"87856704","insp_unit_id":"213568611","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:32.000000Z","updated_at":"2026-05-26T09:02:35.000000Z"},{"id":20734857,"change_date":"2026-05-15 21:43:00","inspection_id":"87856704","insp_unit_id":"213568612","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADVANCE MF","insp_unit_company":null,"insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:32.000000Z","updated_at":"2026-05-26T09:02:35.000000Z"}]},{"id":11846880,"change_date":"2026-05-07 21:39:00","inspection_id":"87782719","dot_number":"3350619","report_state":"WV","report_number":"PSC1431876","insp_date":"2026-05-07 00:00:00","insp_start_time":"0605","insp_end_time":"0626","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MORGANTOWN WV","county_code_state":"WV","county_code":"061","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"READING TRUCK GROUP","shipping_paper_number":"2308529","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":"U","pen_cen_match":"I","final_status_date":"2026-05-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3276853","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-05-07 21:39:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-07 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:30.000000Z","updated_at":"2026-05-18T09:30:40.000000Z","inspection_violations":[{"id":20604020,"change_date":"2026-05-07 21:39:00","inspection_id":"87782719","insp_violation_id":"274103695","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"213426873","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:27.000000Z","updated_at":"2026-05-18T09:41:34.000000Z","normalized_code":"3939ALRLI"},{"id":20604021,"change_date":"2026-05-07 21:39:00","inspection_id":"87782719","insp_violation_id":"274103696","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"213426873","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:27.000000Z","updated_at":"2026-05-18T09:41:34.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20602263,"change_date":"2026-05-07 21:39:00","inspection_id":"87782719","insp_unit_id":"213426872","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PNR6266","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4HG713307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:45.000000Z","updated_at":"2026-05-18T09:02:56.000000Z"},{"id":20602264,"change_date":"2026-05-07 21:39:00","inspection_id":"87782719","insp_unit_id":"213426873","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJ TRAILER","insp_unit_company":null,"insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:45.000000Z","updated_at":"2026-05-18T09:02:56.000000Z"}]},{"id":11856288,"change_date":"2026-05-11 21:38:00","inspection_id":"87792537","dot_number":"3350619","report_state":"MD","report_number":"2099C00660","insp_date":"2026-05-07 00:00:00","insp_start_time":"0701","insp_end_time":"0735","registration_date":"2026-05-11 00:00:00","region":"ED","ci_status_code":"C","location":"059045","location_desc":"VIENNA MD","county_code_state":"MD","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ADVANCED ARCHITECTURAL PRODUCTS","shipping_paper_number":"6489","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":"U","pen_cen_match":"I","final_status_date":"2026-05-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3284054","transaction_code":"C","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-05-08 21:38:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-08 21:38:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-11T09:39:59.000000Z","updated_at":"2026-05-22T09:30:13.000000Z","inspection_violations":[{"id":20621507,"change_date":"2026-05-11 21:38:00","inspection_id":"87792537","insp_violation_id":"274166589","seq_no":"2","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":"WARNING","created_at":"2026-05-11T09:59:48.000000Z","updated_at":"2026-05-22T09:42:06.000000Z","normalized_code":"3922SLLTCD"},{"id":20621506,"change_date":"2026-05-11 21:38:00","inspection_id":"87792537","insp_violation_id":"274166588","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"213476951","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-11T09:59:48.000000Z","updated_at":"2026-05-22T09:42:06.000000Z","normalized_code":"3939ALLPL"},{"id":20621508,"change_date":"2026-05-11 21:38:00","inspection_id":"87792537","insp_violation_id":"274166590","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213476951","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-11T09:59:48.000000Z","updated_at":"2026-05-22T09:42:06.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20617549,"change_date":"2026-05-11 21:38:00","inspection_id":"87792537","insp_unit_id":"213476951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"8","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:21.000000Z","updated_at":"2026-05-22T09:02:21.000000Z"},{"id":20617550,"change_date":"2026-05-11 21:38:00","inspection_id":"87792537","insp_unit_id":"213476952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADVANCE MF","insp_unit_company":"7","insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:21.000000Z","updated_at":"2026-05-22T09:02:21.000000Z"}]},{"id":11824116,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","dot_number":"3350619","report_state":"NY","report_number":"D507802370","insp_date":"2026-05-04 00:00:00","insp_start_time":"0916","insp_end_time":"1038","registration_date":"2026-05-08 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"ANGOLA NY","county_code_state":"NY","county_code":"029","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23800","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3261905","transaction_code":"C","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-05-05 21:39:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-05 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-08T09:40:24.000000Z","updated_at":"2026-05-22T09:30:09.000000Z","inspection_violations":[{"id":20561640,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","insp_violation_id":"274172075","seq_no":"7","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"213481452","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-22T09:42:39.000000Z","normalized_code":"3963A1BOS"},{"id":20561635,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","insp_violation_id":"274172070","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"2","insp_unit_id":"213481452","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-22T09:42:39.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":20561636,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","insp_violation_id":"274172071","seq_no":"3","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"213481452","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-22T09:42:39.000000Z","normalized_code":"39343DB"},{"id":20561637,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","insp_violation_id":"274172072","seq_no":"4","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"2","insp_unit_id":"213481452","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-22T09:42:39.000000Z","normalized_code":"393201AFRCLS"},{"id":20561638,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","insp_violation_id":"274172073","seq_no":"5","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"2","insp_unit_id":"213481452","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-22T09:42:39.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":20561634,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","insp_violation_id":"274172069","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213481452","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-22T09:42:39.000000Z","normalized_code":"39617CPI"},{"id":20561639,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","insp_violation_id":"274172074","seq_no":"6","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"213481452","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-22T09:42:39.000000Z","normalized_code":"39348ABIHE"}],"inspection_per_units":[{"id":20565103,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","insp_unit_id":"213481451","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"POF6528","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63R3CL7TG212296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:12.000000Z","updated_at":"2026-05-22T09:02:17.000000Z"},{"id":20565104,"change_date":"2026-05-11 21:38:00","inspection_id":"87758778","insp_unit_id":"213481452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"TUA9257","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:12.000000Z","updated_at":"2026-05-22T09:02:17.000000Z"}]},{"id":11659146,"change_date":"2026-04-16 21:40:00","inspection_id":"87589043","dot_number":"3350619","report_state":"NY","report_number":"SPA3070880","insp_date":"2026-04-09 00:00:00","insp_start_time":"1221","insp_end_time":"1246","registration_date":"2026-04-09 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SILVER CREEK NY","county_code_state":"NY","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":"U","pen_cen_match":"I","final_status_date":"2026-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25800","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":"3165446","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:30:34.000000Z","updated_at":"2026-04-27T09:30:34.000000Z","inspection_violations":[{"id":20249073,"change_date":"2026-04-16 21:40:00","inspection_id":"87589043","insp_violation_id":"273632846","seq_no":"1","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"213040379","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:08.000000Z","updated_at":"2026-04-27T09:43:08.000000Z","normalized_code":"39522H4ELDBRODS"}],"inspection_per_units":[{"id":20281246,"change_date":"2026-04-16 21:40:00","inspection_id":"87589043","insp_unit_id":"213040378","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"TUA9257","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:03:15.000000Z","updated_at":"2026-04-27T09:03:15.000000Z"},{"id":20281247,"change_date":"2026-04-16 21:40:00","inspection_id":"87589043","insp_unit_id":"213040379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"POF6528","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63R3CL7TG212296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:03:15.000000Z","updated_at":"2026-04-27T09:03:15.000000Z"}]},{"id":11421396,"change_date":"2026-03-20 21:38:00","inspection_id":"87337135","dot_number":"3350619","report_state":"WV","report_number":"PSC1131129","insp_date":"2026-03-19 00:00:00","insp_start_time":"1108","insp_end_time":"1135","registration_date":null,"region":"ED","ci_status_code":"C","location":"I070EB","location_desc":"WHEELING WV","county_code_state":"WV","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"AES INDUSTRIES","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3026940","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-03-20 21:38:00","snet_input_date":"2026-03-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-20 21:38:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:19.000000Z","updated_at":"2026-03-31T09:30:07.000000Z","inspection_violations":[{"id":19265549,"change_date":"2026-03-20 21:38:00","inspection_id":"87337135","insp_violation_id":"272510415","seq_no":"1","part_no":"395","part_no_section":"24","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":"2026-03-23T10:13:12.000000Z","updated_at":"2026-03-31T09:47:26.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":19564479,"change_date":"2026-03-20 21:38:00","inspection_id":"87337135","insp_unit_id":"212228566","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"14","insp_unit_license":"PNR6266","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4HG713307","insp_unit_decal":"Y","insp_unit_decal_number":"none","created_at":"2026-03-23T09:29:52.000000Z","updated_at":"2026-03-31T09:07:36.000000Z"},{"id":19564480,"change_date":"2026-03-20 21:38:00","inspection_id":"87337135","insp_unit_id":"212228567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FABRIQUE","insp_unit_company":null,"insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"Y","insp_unit_decal_number":"none","created_at":"2026-03-23T09:29:52.000000Z","updated_at":"2026-03-31T09:07:36.000000Z"}]},{"id":11213865,"change_date":"2026-02-24 21:39:00","inspection_id":"87125252","dot_number":"3350619","report_state":"OH","report_number":"3257000591","insp_date":"2026-02-23 00:00:00","insp_start_time":"0806","insp_end_time":"0829","registration_date":null,"region":"ES","ci_status_code":"C","location":"01","location_desc":"CAMBRIDGE OH","county_code_state":"OH","county_code":"059","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SYNCHROGISHTICS LLC","shipping_paper_number":"600486","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2926122","transaction_code":"A","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-02-24 21:39:00","snet_input_date":"2026-02-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-24 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-27T10:37:42.000000Z","updated_at":"2026-03-07T10:30:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19149619,"change_date":"2026-02-24 21:39:00","inspection_id":"87125252","insp_unit_id":"211785642","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"14","insp_unit_license":"PNR6266","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4HG713307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:16.000000Z","updated_at":"2026-03-07T10:02:52.000000Z"},{"id":19149620,"change_date":"2026-02-24 21:39:00","inspection_id":"87125252","insp_unit_id":"211785643","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"3","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:16.000000Z","updated_at":"2026-03-07T10:02:52.000000Z"}]},{"id":11203228,"change_date":"2026-02-23 21:38:00","inspection_id":"87114216","dot_number":"3350619","report_state":"WV","report_number":"PSC1550610","insp_date":"2026-02-17 00:00:00","insp_start_time":"1503","insp_end_time":"1521","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"AMMA WV","county_code_state":"WV","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2923142","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-02-23 21:38:00","snet_input_date":"2026-02-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-23 21:38:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-26T10:36:56.000000Z","updated_at":"2026-03-06T10:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19130966,"change_date":"2026-02-23 21:38:00","inspection_id":"87114216","insp_unit_id":"211763056","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"8","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:11.000000Z","updated_at":"2026-03-06T10:03:06.000000Z"},{"id":19130967,"change_date":"2026-02-23 21:38:00","inspection_id":"87114216","insp_unit_id":"211763057","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADVANCE MF","insp_unit_company":"7","insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:11.000000Z","updated_at":"2026-03-06T10:03:06.000000Z"}]},{"id":11073442,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","dot_number":"3350619","report_state":"OH","report_number":"3288001441","insp_date":"2026-02-05 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":null,"region":"ES","ci_status_code":"C","location":"10","location_desc":"WILMINGTON OH","county_code_state":"OH","county_code":"027","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"WHITECAP","shipping_paper_number":"260204-00297","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":"2026-02-07 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"7","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2856892","transaction_code":"A","transaction_date":"2026-02-06 00:00:00","upload_date":"2026-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-02-07 21:33:00","snet_input_date":"2026-02-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-07 21:33:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-10T10:37:27.000000Z","updated_at":"2026-02-18T10:30:13.000000Z","inspection_violations":[{"id":18534367,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","insp_violation_id":"271656131","seq_no":"3","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"1","insp_unit_id":"211497252","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-10T10:51:11.000000Z","updated_at":"2026-02-18T10:37:35.000000Z","normalized_code":"39343DBMA"},{"id":18534368,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","insp_violation_id":"271656132","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211497252","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"OHP981822020520","created_at":"2026-02-10T10:51:11.000000Z","updated_at":"2026-02-18T10:37:35.000000Z","normalized_code":"3922SLLSR"},{"id":18534369,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","insp_violation_id":"271656133","seq_no":"4","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211497252","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:51:11.000000Z","updated_at":"2026-02-18T10:37:36.000000Z","normalized_code":"39378AWS"},{"id":18534370,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","insp_violation_id":"271656134","seq_no":"5","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"211497253","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-10T10:51:11.000000Z","updated_at":"2026-02-18T10:37:36.000000Z","normalized_code":"393100BC"},{"id":18534371,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","insp_violation_id":"271656135","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"211497253","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:51:11.000000Z","updated_at":"2026-02-18T10:37:36.000000Z","normalized_code":"3939ALLPL"},{"id":18534372,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","insp_violation_id":"271656136","seq_no":"7","part_no":"393","part_no_section":"104B-C","insp_viol_unit":"2","insp_unit_id":"211497253","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:51:11.000000Z","updated_at":"2026-02-18T10:37:36.000000Z","normalized_code":"393104BC"},{"id":18534366,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","insp_violation_id":"271656130","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:51:11.000000Z","updated_at":"2026-02-18T10:37:35.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":18881132,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","insp_unit_id":"211497252","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"14","insp_unit_license":"PNR6266","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4HG713307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-10T10:14:29.000000Z","updated_at":"2026-02-18T10:02:43.000000Z"},{"id":18881133,"change_date":"2026-02-07 21:33:00","inspection_id":"86984171","insp_unit_id":"211497253","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJ TRAILER","insp_unit_company":"3","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-10T10:14:29.000000Z","updated_at":"2026-02-18T10:02:43.000000Z"}]},{"id":10621846,"change_date":"2026-01-12 21:38:00","inspection_id":"86762294","dot_number":"3350619","report_state":"OH","report_number":"0926000021","insp_date":"2026-01-08 00:00:00","insp_start_time":"1543","insp_end_time":"1652","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MILAN OH","county_code_state":"OH","county_code":"043","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WELLINGTON ALLOYS LLC","shipping_paper_number":"9357852","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2752887","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2026-01-12 21:38:00","snet_input_date":"2026-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-12 21:38:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-15T10:36:52.000000Z","updated_at":"2026-01-23T10:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17809480,"change_date":"2026-01-12 21:38:00","inspection_id":"86762294","insp_unit_id":"211020460","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"ADVANCE MF","insp_unit_company":"7","insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:08:47.000000Z","updated_at":"2026-01-24T10:00:34.000000Z"},{"id":17809481,"change_date":"2026-01-12 21:38:00","inspection_id":"86762294","insp_unit_id":"211020461","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"8","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:08:47.000000Z","updated_at":"2026-01-24T10:00:34.000000Z"}]},{"id":10449682,"change_date":"2025-12-16 21:38:00","inspection_id":"86582156","dot_number":"3350619","report_state":"PA","report_number":"D406534920","insp_date":"2025-12-15 00:00:00","insp_start_time":"1645","insp_end_time":"1720","registration_date":null,"region":"ET","ci_status_code":"C","location":"076","location_desc":"SR376  CHIPPEWA TWP - CHIPPEWA","county_code_state":"PA","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SQUARE DEAL SHIPPING LLC","shipping_paper_number":"0000","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-12-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2561813","transaction_code":"A","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-12-16 21:38:00","snet_input_date":"2025-12-15 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-12-16 21:38:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-19T10:31:54.000000Z","updated_at":"2025-12-27T10:30:56.000000Z","inspection_violations":[{"id":17527546,"change_date":"2025-12-16 21:38:00","inspection_id":"86582156","insp_violation_id":"270717125","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"210640772","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-19T10:32:46.000000Z","updated_at":"2025-12-27T10:31:24.000000Z","normalized_code":"39311A1LHLM"},{"id":17527547,"change_date":"2025-12-16 21:38:00","inspection_id":"86582156","insp_violation_id":"270717126","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210640772","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA1620708-5","created_at":"2025-12-19T10:32:46.000000Z","updated_at":"2025-12-27T10:31:24.000000Z","normalized_code":"39395A1"},{"id":17527548,"change_date":"2025-12-16 21:38:00","inspection_id":"86582156","insp_violation_id":"270717127","seq_no":"3","part_no":"395","part_no_section":"22H4-ELDBRODS","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-12-19T10:32:46.000000Z","updated_at":"2025-12-27T10:31:24.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":17527549,"change_date":"2025-12-16 21:38:00","inspection_id":"86582156","insp_violation_id":"270717128","seq_no":"4","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"210640773","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-19T10:32:46.000000Z","updated_at":"2025-12-27T10:31:24.000000Z","normalized_code":"3939ALTSI"},{"id":17527550,"change_date":"2025-12-16 21:38:00","inspection_id":"86582156","insp_violation_id":"270717129","seq_no":"5","part_no":"393","part_no_section":"11A1-LSLM","insp_viol_unit":"2","insp_unit_id":"210640773","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA1620709-6","created_at":"2025-12-19T10:32:46.000000Z","updated_at":"2025-12-27T10:31:24.000000Z","normalized_code":"39311A1LSLM"}],"inspection_per_units":[{"id":17486179,"change_date":"2025-12-16 21:38:00","inspection_id":"86582156","insp_unit_id":"210640772","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"0000","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:02:01.000000Z","updated_at":"2025-12-27T10:01:03.000000Z"},{"id":17486180,"change_date":"2025-12-16 21:38:00","inspection_id":"86582156","insp_unit_id":"210640773","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"ADVA","insp_unit_company":"0000","insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:02:01.000000Z","updated_at":"2025-12-27T10:01:03.000000Z"}]},{"id":10258618,"change_date":"2025-11-21 21:38:00","inspection_id":"86382222","dot_number":"3350619","report_state":"MD","report_number":"3211C00684","insp_date":"2025-11-20 00:00:00","insp_start_time":"0633","insp_end_time":"0710","registration_date":null,"region":"ES","ci_status_code":"C","location":"023003","location_desc":"ANNAPOLIS MD","county_code_state":"MD","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INTEGRITY","shipping_paper_number":"2785263","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26500","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":"2570326","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-11-21 21:38:00","snet_input_date":"2025-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-21 21:38:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:41.000000Z","updated_at":"2025-11-25T10:30:29.000000Z","inspection_violations":[{"id":17066874,"change_date":"2025-11-21 21:38:00","inspection_id":"86382222","insp_violation_id":"270118572","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"210167940","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-11-24T10:32:38.000000Z","updated_at":"2025-11-25T10:30:41.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":17102276,"change_date":"2025-11-21 21:38:00","inspection_id":"86382222","insp_unit_id":"210167940","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"14","insp_unit_license":"PNR6266","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4HG713307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-24T10:01:55.000000Z","updated_at":"2025-11-25T10:00:33.000000Z"},{"id":17102277,"change_date":"2025-11-21 21:38:00","inspection_id":"86382222","insp_unit_id":"210167941","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTR","insp_unit_company":"3","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"Y","insp_unit_decal_number":"35706095","created_at":"2025-11-24T10:01:55.000000Z","updated_at":"2025-11-25T10:00:33.000000Z"}]},{"id":10256074,"change_date":"2025-11-21 21:38:00","inspection_id":"86379509","dot_number":"3350619","report_state":"OH","report_number":"3210000069","insp_date":"2025-11-19 00:00:00","insp_start_time":"1436","insp_end_time":"1510","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"COLUMBUS OH","county_code_state":"OH","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FLUOR CORP","shipping_paper_number":"S509325185","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2567668","transaction_code":"A","transaction_date":"2025-11-20 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-11-21 21:38:00","snet_input_date":"2025-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-21 21:38:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:37.000000Z","updated_at":"2025-11-25T10:30:14.000000Z","inspection_violations":[{"id":17062474,"change_date":"2025-11-21 21:38:00","inspection_id":"86379509","insp_violation_id":"270113569","seq_no":"1","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"210163282","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-24T10:32:31.000000Z","updated_at":"2025-11-25T10:30:18.000000Z","normalized_code":"39343DB"},{"id":17062475,"change_date":"2025-11-21 21:38:00","inspection_id":"86379509","insp_violation_id":"270113570","seq_no":"2","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"210163282","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-24T10:32:31.000000Z","updated_at":"2025-11-25T10:30:18.000000Z","normalized_code":"3963A1HCM"}],"inspection_per_units":[{"id":17098052,"change_date":"2025-11-21 21:38:00","inspection_id":"86379509","insp_unit_id":"210163281","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"1","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-24T10:01:51.000000Z","updated_at":"2025-11-25T10:00:15.000000Z"},{"id":17098053,"change_date":"2025-11-21 21:38:00","inspection_id":"86379509","insp_unit_id":"210163282","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADVANCE MF","insp_unit_company":"1A","insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-24T10:01:51.000000Z","updated_at":"2025-11-25T10:00:15.000000Z"}]},{"id":10019255,"change_date":"2025-11-12 21:41:00","inspection_id":"86130414","dot_number":"3350619","report_state":"MI","report_number":"ESCOT03094","insp_date":"2025-10-22 00:00:00","insp_start_time":"1345","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S-C","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":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1247132","transaction_code":"C","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:54.000000Z","updated_at":"2025-11-16T10:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16948976,"change_date":"2025-11-12 21:41:00","inspection_id":"86130414","insp_unit_id":"209979766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"14","insp_unit_license":"PNR6266","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4HG713307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:34.000000Z","updated_at":"2025-11-16T10:00:55.000000Z"},{"id":16948977,"change_date":"2025-11-12 21:41:00","inspection_id":"86130414","insp_unit_id":"209979767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":"003","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:34.000000Z","updated_at":"2025-11-16T10:00:55.000000Z"}]},{"id":9522316,"change_date":"2025-08-27 21:40:00","inspection_id":"85608145","dot_number":"3350619","report_state":"PA","report_number":"D130523845","insp_date":"2025-08-26 00:00:00","insp_start_time":"1135","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":"081","location_desc":"I79 SB MM 109.5 PLAIN GROVE TW","county_code_state":"PA","county_code":"073","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SQUARE DEAL SHIPPING","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-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2539370","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-08-27 21:40:00","snet_input_date":"2025-08-26 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-08-27 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-05T10:47:21.000000Z","updated_at":"2025-09-06T10:41:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15715649,"change_date":"2025-08-27 21:40:00","inspection_id":"85608145","insp_unit_id":"208614159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PMR3574","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGLXMG687309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:39.000000Z","updated_at":"2025-09-09T09:46:00.000000Z"},{"id":15715650,"change_date":"2025-08-27 21:40:00","inspection_id":"85608145","insp_unit_id":"208614160","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"TUA9257","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:39.000000Z","updated_at":"2025-09-09T09:46:00.000000Z"}]},{"id":9113369,"change_date":"2025-07-10 21:39:00","inspection_id":"85178170","dot_number":"3350619","report_state":"KY","report_number":"S190001837","insp_date":"2025-07-10 00:00:00","insp_start_time":"1006","insp_end_time":"1026","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OWINGSVILLE","county_code_state":"KY","county_code":"011","insp_level_id":"2","service_center":"SH","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-07-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2291841","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":"M","census_search_date":"2025-07-10 21:39:00","snet_input_date":"2025-07-10 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-07-10 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:49.000000Z","updated_at":"2025-07-14T10:46:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14961264,"change_date":"2025-07-10 21:39:00","inspection_id":"85178170","insp_unit_id":"207801527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PNR6266","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4HG713307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:56.000000Z","updated_at":"2025-07-14T09:45:37.000000Z"},{"id":14961265,"change_date":"2025-07-10 21:39:00","inspection_id":"85178170","insp_unit_id":"207801528","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:56.000000Z","updated_at":"2025-07-14T09:45:37.000000Z"}]},{"id":8963931,"change_date":"2025-06-23 21:41:00","inspection_id":"85020817","dot_number":"3350619","report_state":"PA","report_number":"C121517139","insp_date":"2025-06-20 00:00:00","insp_start_time":"0715","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":"057","location_desc":"SR 119 NB YOUNG TWP - RUNAWAY","county_code_state":"PA","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NELSON WIRE & STEEL, LLC","shipping_paper_number":"UDPA80166411","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-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2524993","transaction_code":"A","transaction_date":"2025-06-20 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-20 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"107115","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:38.000000Z","updated_at":"2025-06-28T10:00:38.000000Z","inspection_violations":[{"id":14397758,"change_date":"2025-06-23 21:41:00","inspection_id":"85020817","insp_violation_id":"266991366","seq_no":"1","part_no":"395","part_no_section":"30B2-ELDDFC24","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-06-26T10:16:02.000000Z","updated_at":"2025-06-27T10:18:04.000000Z","normalized_code":"39530B2ELDDFC24"},{"id":14397759,"change_date":"2025-06-23 21:41:00","inspection_id":"85020817","insp_violation_id":"266991367","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"207512173","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:02.000000Z","updated_at":"2025-06-27T10:18:04.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":14694638,"change_date":"2025-06-23 21:41:00","inspection_id":"85020817","insp_unit_id":"207512173","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"ZWN1835","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3C63RRJLXEG193638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:16.000000Z"},{"id":14694639,"change_date":"2025-06-23 21:41:00","inspection_id":"85020817","insp_unit_id":"207512174","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURT","insp_unit_company":null,"insp_unit_license":"XPY4922","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"5JW3U3023P3396657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:16.000000Z"}]},{"id":8919536,"change_date":"2025-06-17 21:41:00","inspection_id":"84973561","dot_number":"3350619","report_state":"WV","report_number":"PSC1560182","insp_date":"2025-06-16 00:00:00","insp_start_time":"0915","insp_end_time":"0935","registration_date":null,"region":"ED","ci_status_code":"C","location":"I070EB","location_desc":"WHEELING WV","county_code_state":"WV","county_code":"069","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1876217","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:55.000000Z","updated_at":"2025-06-22T10:00:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14616387,"change_date":"2025-06-17 21:41:00","inspection_id":"84973561","insp_unit_id":"207425493","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"1","insp_unit_license":"PKT5070","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGL2KG580719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:04.000000Z","updated_at":"2025-06-22T09:45:45.000000Z"},{"id":14616388,"change_date":"2025-06-17 21:41:00","inspection_id":"84973561","insp_unit_id":"207425494","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PARMITER,","insp_unit_company":"3","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:04.000000Z","updated_at":"2025-06-22T09:45:45.000000Z"}]},{"id":8632426,"change_date":"2025-05-14 21:42:00","inspection_id":"84669584","dot_number":"3350619","report_state":"PA","report_number":"C305513305","insp_date":"2025-05-13 00:00:00","insp_start_time":"0525","insp_end_time":"0624","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I-80 W 2704 FEET SOUTH OF U","county_code_state":"PA","county_code":"033","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SQUARE DEAL SHIPPING","shipping_paper_number":"81034","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":"Y","pen_cen_match":null,"final_status_date":"2025-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2515438","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-05-14 21:42:00","snet_input_date":"2025-05-13 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:20.000000Z","updated_at":"2025-05-18T10:06:13.000000Z","inspection_violations":[{"id":13727578,"change_date":"2025-05-14 21:42:00","inspection_id":"84669584","insp_violation_id":"266221760","seq_no":"1","part_no":"393","part_no_section":"9A-LPL","insp_viol_unit":"2","insp_unit_id":"206858182","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:17.000000Z","updated_at":"2025-05-18T10:33:48.000000Z","normalized_code":"3939ALPL"},{"id":13727579,"change_date":"2025-05-14 21:42:00","inspection_id":"84669584","insp_violation_id":"266221761","seq_no":"2","part_no":"395","part_no_section":"3A3II","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-05-18T10:27:17.000000Z","updated_at":"2025-05-18T10:33:48.000000Z","normalized_code":"3953A3II"},{"id":13727580,"change_date":"2025-05-14 21:42:00","inspection_id":"84669584","insp_violation_id":"266221762","seq_no":"3","part_no":"391","part_no_section":"15A-LNCDLNSRW","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"TA1198694-0","created_at":"2025-05-18T10:27:17.000000Z","updated_at":"2025-05-18T10:33:48.000000Z","normalized_code":"39115ALNCDLNSRW"}],"inspection_per_units":[{"id":14095967,"change_date":"2025-05-14 21:42:00","inspection_id":"84669584","insp_unit_id":"206858181","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:18.000000Z","updated_at":"2025-05-18T09:51:48.000000Z"},{"id":14095968,"change_date":"2025-05-14 21:42:00","inspection_id":"84669584","insp_unit_id":"206858182","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADVA","insp_unit_company":null,"insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:18.000000Z","updated_at":"2025-05-18T09:51:48.000000Z"}]},{"id":8557734,"change_date":"2025-05-06 21:39:00","inspection_id":"84591221","dot_number":"3350619","report_state":"KY","report_number":"CV41295330","insp_date":"2025-05-05 00:00:00","insp_start_time":"1242","insp_end_time":"1326","registration_date":null,"region":"ET","ci_status_code":"C","location":"9801","location_desc":"SHELBYVILLE","county_code_state":"KY","county_code":"211","insp_level_id":"1","service_center":"SH","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":"2025-05-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"3","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2281998","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":"M","census_search_date":"2025-05-06 21:39:00","snet_input_date":"2025-05-06 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-05-06 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-09T10:25:36.000000Z","updated_at":"2025-05-10T10:51:08.000000Z","inspection_violations":[{"id":13563519,"change_date":"2025-05-06 21:39:00","inspection_id":"84591221","insp_violation_id":"266031781","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"206662831","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-09T10:55:19.000000Z","updated_at":"2025-05-09T11:01:47.000000Z","normalized_code":"39341"},{"id":13563520,"change_date":"2025-05-06 21:39:00","inspection_id":"84591221","insp_violation_id":"266031782","seq_no":"2","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"206662832","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-09T10:55:19.000000Z","updated_at":"2025-05-09T11:01:47.000000Z","normalized_code":"39348A"},{"id":13563521,"change_date":"2025-05-06 21:39:00","inspection_id":"84591221","insp_violation_id":"266031783","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"206662832","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-09T10:55:19.000000Z","updated_at":"2025-05-09T11:01:47.000000Z","normalized_code":"3939TS"},{"id":13563522,"change_date":"2025-05-06 21:39:00","inspection_id":"84591221","insp_violation_id":"266031784","seq_no":"4","part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"2","insp_unit_id":"206662832","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:55:19.000000Z","updated_at":"2025-05-09T11:01:47.000000Z","normalized_code":"3939BRKLAMP"},{"id":13563523,"change_date":"2025-05-06 21:39:00","inspection_id":"84591221","insp_violation_id":"266031785","seq_no":"5","part_no":"395","part_no_section":"24C2III","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:55:19.000000Z","updated_at":"2025-05-09T11:01:47.000000Z","normalized_code":"39524C2III"},{"id":13563524,"change_date":"2025-05-06 21:39:00","inspection_id":"84591221","insp_violation_id":"266031786","seq_no":"6","part_no":"395","part_no_section":"22H4","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-05-09T10:55:19.000000Z","updated_at":"2025-05-09T11:01:47.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":13918275,"change_date":"2025-05-06 21:39:00","inspection_id":"84591221","insp_unit_id":"206662831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"PKT5070","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGL2KG580719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:11:01.000000Z","updated_at":"2025-05-10T09:58:07.000000Z"},{"id":13918276,"change_date":"2025-05-06 21:39:00","inspection_id":"84591221","insp_unit_id":"206662832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PARM","insp_unit_company":"3","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:11:01.000000Z","updated_at":"2025-05-10T09:58:07.000000Z"}]},{"id":8529075,"change_date":"2025-05-02 21:40:00","inspection_id":"84560882","dot_number":"3350619","report_state":"PA","report_number":"C033007023","insp_date":"2025-04-30 00:00:00","insp_start_time":"0925","insp_end_time":"1015","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WEST SPRINGFIELD PA","county_code_state":"PA","county_code":"049","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"US LOGISTICS LLC","shipping_paper_number":"1179802","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1673496","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-05-02 21:40:00","snet_input_date":"2025-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-02 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-05T10:15:22.000000Z","updated_at":"2025-05-06T10:04:20.000000Z","inspection_violations":[{"id":13506220,"change_date":"2025-05-02 21:40:00","inspection_id":"84560882","insp_violation_id":"265965453","seq_no":"1","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"206607083","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:48:46.000000Z","updated_at":"2025-05-06T10:21:18.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":13867222,"change_date":"2025-05-02 21:40:00","inspection_id":"84560882","insp_unit_id":"206607082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"6","insp_unit_license":"PMR3574","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGLXMG687309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T09:59:38.000000Z","updated_at":"2025-05-07T09:51:57.000000Z"},{"id":13867223,"change_date":"2025-05-02 21:40:00","inspection_id":"84560882","insp_unit_id":"206607083","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"30","insp_unit_license":"TTJ7653","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T09:59:38.000000Z","updated_at":"2025-05-07T09:51:58.000000Z"}]},{"id":8409886,"change_date":"2025-04-18 21:39:00","inspection_id":"84435237","dot_number":"3350619","report_state":"OH","report_number":"3220000437","insp_date":"2025-04-16 00:00:00","insp_start_time":"1223","insp_end_time":"1316","registration_date":null,"region":"ED","ci_status_code":"C","location":"12","location_desc":"NEVADA OH","county_code_state":"OH","county_code":"175","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OMCO DBA MIDWEST ROLL FORMING","shipping_paper_number":"511785822","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-04-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1610659","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-04-18 21:39:00","snet_input_date":"2025-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-18 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:25:25.000000Z","updated_at":"2025-04-23T10:02:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13653144,"change_date":"2025-04-18 21:39:00","inspection_id":"84435237","insp_unit_id":"206376990","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"ZWN1835","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3C63RRJLXEG193638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:07:03.000000Z","updated_at":"2025-04-22T09:50:20.000000Z"},{"id":13653145,"change_date":"2025-04-18 21:39:00","inspection_id":"84435237","insp_unit_id":"206376991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"XPY4922","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"5JW3U3023P3396657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:07:03.000000Z","updated_at":"2025-04-22T09:50:20.000000Z"}]},{"id":8387448,"change_date":"2025-04-16 21:40:00","inspection_id":"84411570","dot_number":"3350619","report_state":"OH","report_number":"3298000601","insp_date":"2025-04-14 00:00:00","insp_start_time":"1230","insp_end_time":"1315","registration_date":null,"region":"ED","ci_status_code":"C","location":"04","location_desc":"HUBBARD OH","county_code_state":"OH","county_code":"155","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","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":"1600372","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-04-16 21:40:00","snet_input_date":"2025-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-16 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-19T10:18:45.000000Z","updated_at":"2025-04-20T10:22:58.000000Z","inspection_violations":[{"id":13225162,"change_date":"2025-04-16 21:40:00","inspection_id":"84411570","insp_violation_id":"265647240","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"206334163","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:07:19.000000Z","updated_at":"2025-04-20T10:34:39.000000Z","normalized_code":"39395A1"},{"id":13225163,"change_date":"2025-04-16 21:40:00","inspection_id":"84411570","insp_violation_id":"265647241","seq_no":"2","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"206334164","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-18T11:07:19.000000Z","updated_at":"2025-04-20T10:34:39.000000Z","normalized_code":"39343DB"},{"id":13225164,"change_date":"2025-04-16 21:40:00","inspection_id":"84411570","insp_violation_id":"265647242","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"206334164","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:07:19.000000Z","updated_at":"2025-04-20T10:34:39.000000Z","normalized_code":"3939ALLPL"},{"id":13225165,"change_date":"2025-04-16 21:40:00","inspection_id":"84411570","insp_violation_id":"265647243","seq_no":"4","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"206334164","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:07:19.000000Z","updated_at":"2025-04-20T10:34:39.000000Z","normalized_code":"3939ALSML"},{"id":13225166,"change_date":"2025-04-16 21:40:00","inspection_id":"84411570","insp_violation_id":"265647244","seq_no":"5","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"2","insp_unit_id":"206334164","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:07:19.000000Z","updated_at":"2025-04-20T10:34:39.000000Z","normalized_code":"39311A1LSML"}],"inspection_per_units":[{"id":13613875,"change_date":"2025-04-16 21:40:00","inspection_id":"84411570","insp_unit_id":"206334164","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"146","insp_unit_license":"TTJ2803","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3821N6167012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:02:18.000000Z","updated_at":"2025-04-20T09:50:15.000000Z"},{"id":13613874,"change_date":"2025-04-16 21:40:00","inspection_id":"84411570","insp_unit_id":"206334163","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"8","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"Y","insp_unit_decal_number":"35135628","created_at":"2025-04-19T10:02:18.000000Z","updated_at":"2025-04-20T09:50:15.000000Z"}]},{"id":8155690,"change_date":"2025-03-19 21:41:00","inspection_id":"84167596","dot_number":"3350619","report_state":"PA","report_number":"A302507722","insp_date":"2025-03-18 00:00:00","insp_start_time":"1315","insp_end_time":"1343","registration_date":null,"region":"ET","ci_status_code":"C","location":"413","location_desc":"SR22 WEST WHEATFIELD TOWNSHIP-","county_code_state":"PA","county_code":"063","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2502348","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-18 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-22T10:34:12.000000Z","updated_at":"2025-03-23T10:48:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13175854,"change_date":"2025-03-19 21:41:00","inspection_id":"84167596","insp_unit_id":"205880150","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TK15","insp_unit_license":"ZWZ4893","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FT8W3DT9KEE01236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:06:14.000000Z","updated_at":"2025-03-23T10:02:20.000000Z"},{"id":13175855,"change_date":"2025-03-19 21:41:00","inspection_id":"84167596","insp_unit_id":"205880151","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"RWMX","insp_unit_company":null,"insp_unit_license":"PT309V4","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3EVGF4023R1108244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:06:14.000000Z","updated_at":"2025-03-23T10:02:20.000000Z"}]},{"id":7813891,"change_date":"2025-02-18 21:39:00","inspection_id":"83808528","dot_number":"3350619","report_state":"KY","report_number":"CV42905813","insp_date":"2025-02-06 00:00:00","insp_start_time":"1324","insp_end_time":"1402","registration_date":"2025-02-18 00:00:00","region":"ET","ci_status_code":"C","location":"9811","location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SCTN","shipping_paper_number":"IC\/011\/38563","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:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2268053","transaction_code":"C","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":"M","census_search_date":"2025-02-07 21:40:00","snet_input_date":"2025-02-07 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22 A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:22.000000Z","updated_at":"2025-03-17T21:00:22.000000Z","inspection_violations":[{"id":12211722,"change_date":"2025-02-18 21:39:00","inspection_id":"83808528","insp_violation_id":"264563639","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"205370590","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"39375A3TAOL"},{"id":12211723,"change_date":"2025-02-18 21:39:00","inspection_id":"83808528","insp_violation_id":"264563640","seq_no":"2","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"205370590","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":12610288,"change_date":"2025-02-18 21:39:00","inspection_id":"83808528","insp_unit_id":"205370590","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"PKT5070","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGL2KG580719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"},{"id":12610289,"change_date":"2025-02-18 21:39:00","inspection_id":"83808528","insp_unit_id":"205370591","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"4","insp_unit_license":"TTJ2803","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3821N6167012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"}]},{"id":7194116,"change_date":"2024-11-14 21:41:00","inspection_id":"83156593","dot_number":"3350619","report_state":"IL","report_number":"3998751864","insp_date":"2024-11-13 00:00:00","insp_start_time":"1130","insp_end_time":"1143","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-39 S\/B","county_code_state":"IL","county_code":"103","insp_level_id":"3","service_center":"MW","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-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2371963","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-11-14 21:41:00","snet_input_date":"2024-11-13 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-11-14 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"107115","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:02.000000Z","updated_at":"2025-03-17T20:46:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11604062,"change_date":"2024-11-14 21:41:00","inspection_id":"83156593","insp_unit_id":"203880961","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12","insp_unit_license":"ZWL7594","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FD8X3HT6MED97944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:14.000000Z","updated_at":"2025-03-17T23:43:14.000000Z"},{"id":11604063,"change_date":"2024-11-14 21:41:00","inspection_id":"83156593","insp_unit_id":"203880962","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"LAMA","insp_unit_company":"01","insp_unit_license":"TRL8262","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5RVFS4028LP086642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:14.000000Z","updated_at":"2025-03-17T23:43:14.000000Z"}]},{"id":7252236,"change_date":"2024-11-21 21:41:00","inspection_id":"83218006","dot_number":"3350619","report_state":"PA","report_number":"SPRE431214","insp_date":"2024-11-07 00:00:00","insp_start_time":"1350","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"467","location_desc":"SR 70 EB AT CLASVILLE WELCOME","county_code_state":"PA","county_code":"125","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2478804","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-11-21 21:41:00","snet_input_date":"2024-11-07 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-11-21 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:17.000000Z","updated_at":"2025-03-17T20:47:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11697697,"change_date":"2024-11-21 21:41:00","inspection_id":"83218006","insp_unit_id":"203997284","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"ZWZ4893","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FT8W3DT9KEE01236","insp_unit_decal":"Y","insp_unit_decal_number":"34563897","created_at":"2025-03-17T23:44:14.000000Z","updated_at":"2025-03-17T23:44:14.000000Z"},{"id":11697698,"change_date":"2024-11-21 21:41:00","inspection_id":"83218006","insp_unit_id":"203997285","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADVA","insp_unit_company":null,"insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:14.000000Z","updated_at":"2025-03-17T23:44:14.000000Z"}]},{"id":6294281,"change_date":"2024-07-24 21:41:00","inspection_id":"82198743","dot_number":"3350619","report_state":"VA","report_number":"5284000206","insp_date":"2024-07-23 00:00:00","insp_start_time":"0924","insp_end_time":"0943","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DUMFRIES VA","county_code_state":"VA","county_code":"153","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"681513","transaction_code":"A","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-07-24 21:41:00","snet_input_date":"2024-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-24 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:25.000000Z","updated_at":"2025-03-17T20:27:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10142030,"change_date":"2024-07-24 21:41:00","inspection_id":"82198743","insp_unit_id":"202039339","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"3","insp_unit_license":"PME9360","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4LG206495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:04.000000Z","updated_at":"2025-03-17T23:28:04.000000Z"},{"id":10142031,"change_date":"2024-07-24 21:41:00","inspection_id":"82198743","insp_unit_id":"202039340","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"1","insp_unit_license":"TRL8262","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5RVFS4028LP086642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:04.000000Z","updated_at":"2025-03-17T23:28:04.000000Z"}]},{"id":6242830,"change_date":"2024-07-17 21:41:00","inspection_id":"82143673","dot_number":"3350619","report_state":"OH","report_number":"3298172395","insp_date":"2024-07-17 00:00:00","insp_start_time":"1440","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"15511","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"155","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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":"2024-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1740902","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-07-17 21:41:00","snet_input_date":"2024-07-17 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-07-17 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:35.000000Z","updated_at":"2025-03-17T20:26:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10058560,"change_date":"2024-07-17 21:41:00","inspection_id":"82143673","insp_unit_id":"201934619","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"6","insp_unit_license":"PMR3574","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGLXMG687309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:12.000000Z","updated_at":"2025-03-17T23:27:12.000000Z"},{"id":10058561,"change_date":"2024-07-17 21:41:00","inspection_id":"82143673","insp_unit_id":"201934620","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"30","insp_unit_license":"TTJ7653","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:12.000000Z","updated_at":"2025-03-17T23:27:12.000000Z"}]},{"id":6221252,"change_date":"2024-08-15 21:42:00","inspection_id":"82120492","dot_number":"3350619","report_state":"OH","report_number":"3262002475","insp_date":"2024-07-15 00:00:00","insp_start_time":"0622","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":"101023","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"101","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"STAR EXTRUDED SHAPES","shipping_paper_number":"100169","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":"2024-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1740201","transaction_code":"C","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-15 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:10.000000Z","updated_at":"2025-03-17T20:26:10.000000Z","inspection_violations":[{"id":9662889,"change_date":"2024-08-15 21:42:00","inspection_id":"82120492","insp_violation_id":"261215705","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202415587","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"3939A"},{"id":9662890,"change_date":"2024-08-15 21:42:00","inspection_id":"82120492","insp_violation_id":"261215706","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"202415588","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":10023370,"change_date":"2024-08-15 21:42:00","inspection_id":"82120492","insp_unit_id":"202415587","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"PKT5070","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGL2KG580719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"},{"id":10023371,"change_date":"2024-08-15 21:42:00","inspection_id":"82120492","insp_unit_id":"202415588","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"TTJ2803","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3821N6167012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"}]},{"id":6153120,"change_date":"2024-07-05 21:36:00","inspection_id":"82047217","dot_number":"3350619","report_state":"PA","report_number":"G207418405","insp_date":"2024-07-02 00:00:00","insp_start_time":"1105","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON WEBER LN AT COUNTRY RIDGE R","county_code_state":"PA","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-05 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2454390","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-07-05 21:36:00","snet_input_date":"2024-07-02 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-07-05 21:36:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:37.000000Z","updated_at":"2025-03-17T20:24:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9911643,"change_date":"2024-07-05 21:36:00","inspection_id":"82047217","insp_unit_id":"201748289","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"PKT5070","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGL2KG580719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"},{"id":9911644,"change_date":"2024-07-05 21:36:00","inspection_id":"82047217","insp_unit_id":"201748290","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"4","insp_unit_license":"TTJ2803","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3821N6167012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:45.000000Z","updated_at":"2025-03-17T23:25:45.000000Z"}]},{"id":5986605,"change_date":"2024-06-13 21:42:00","inspection_id":"81868008","dot_number":"3350619","report_state":"PA","report_number":"E968416432","insp_date":"2024-06-12 00:00:00","insp_start_time":"1510","insp_end_time":"1540","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON UNNAMED STREET 462 FEET EAS","county_code_state":"PA","county_code":"033","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"T B LUMBER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2449961","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[{"id":9287372,"change_date":"2024-06-13 21:42:00","inspection_id":"81868008","insp_violation_id":"260074695","seq_no":"1","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":9642869,"change_date":"2024-06-13 21:42:00","inspection_id":"81868008","insp_unit_id":"201385209","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CALB","insp_unit_company":"9","insp_unit_license":"TTQ2296","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"57BGHH401R1082213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"},{"id":9642870,"change_date":"2024-06-13 21:42:00","inspection_id":"81868008","insp_unit_id":"201385210","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"11","insp_unit_license":"PNC8485","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGL0NG377123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":5910433,"change_date":"2024-06-04 21:42:00","inspection_id":"81785090","dot_number":"3350619","report_state":"IL","report_number":"4289110164","insp_date":"2024-05-29 00:00:00","insp_start_time":"1108","insp_end_time":"1118","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I74","county_code_state":"IL","county_code":"113","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SQUARE DEAL SHIPPING","shipping_paper_number":"583102","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-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2328704","transaction_code":"A","transaction_date":"2024-05-29 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-06-04 21:42:00","snet_input_date":"2024-05-29 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-06-04 21:42:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"107115","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:50.000000Z","updated_at":"2025-03-17T20:19:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9519720,"change_date":"2024-06-04 21:42:00","inspection_id":"81785090","insp_unit_id":"201228101","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"8","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:43.000000Z","updated_at":"2025-03-17T23:21:43.000000Z"},{"id":9519721,"change_date":"2024-06-04 21:42:00","inspection_id":"81785090","insp_unit_id":"201228102","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTR","insp_unit_company":"01","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:43.000000Z","updated_at":"2025-03-17T23:21:43.000000Z"}]},{"id":5780092,"change_date":"2024-05-17 21:40:00","inspection_id":"81643621","dot_number":"3350619","report_state":"PA","report_number":"T305413719","insp_date":"2024-05-16 00:00:00","insp_start_time":"1315","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I 76 W NEAR MILE MARKER 114","county_code_state":"PA","county_code":"111","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"LANE-PULASKI","shipping_paper_number":"T265871","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-05-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2443434","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-05-17 21:40:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-05-17 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:27.000000Z","updated_at":"2025-03-17T20:17:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9309709,"change_date":"2024-05-17 21:40:00","inspection_id":"81643621","insp_unit_id":"200957584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PME9360","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4LG206495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:39.000000Z","updated_at":"2025-03-17T23:19:39.000000Z"},{"id":9309710,"change_date":"2024-05-17 21:40:00","inspection_id":"81643621","insp_unit_id":"200957585","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAMR","insp_unit_company":null,"insp_unit_license":"TRL8262","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5RVFS4028LP086642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:39.000000Z","updated_at":"2025-03-17T23:19:39.000000Z"}]},{"id":5769292,"change_date":"2024-05-16 21:41:00","inspection_id":"81632045","dot_number":"3350619","report_state":"PA","report_number":"G141413635","insp_date":"2024-05-15 00:00:00","insp_start_time":"1001","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I99 NB NORTH OF S CARLISLE","county_code_state":"PA","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SQUARE DEAL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2442534","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-15 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:06.000000Z","updated_at":"2025-03-17T20:17:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9292506,"change_date":"2024-05-16 21:41:00","inspection_id":"81632045","insp_unit_id":"200935146","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"ZWN1835","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3C63RRJLXEG193638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"},{"id":9292507,"change_date":"2024-05-16 21:41:00","inspection_id":"81632045","insp_unit_id":"200935147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURT","insp_unit_company":null,"insp_unit_license":"XPY4922","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"5JW3U3023P3396657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"}]},{"id":5711036,"change_date":"2024-05-09 21:42:00","inspection_id":"81568897","dot_number":"3350619","report_state":"OH","report_number":"3239004267","insp_date":"2024-05-07 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"696","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"069","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"ARMSTRONG TRANSPORTATION GROUP","shipping_paper_number":"2852658","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":"2024-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1725012","transaction_code":"A","transaction_date":"2024-05-08 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-05-09 21:42:00","snet_input_date":"2024-05-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:54.000000Z","updated_at":"2025-03-17T20:15:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9198617,"change_date":"2024-05-09 21:42:00","inspection_id":"81568897","insp_unit_id":"200815065","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"6","insp_unit_license":"PMR3574","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGLXMG687309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"},{"id":9198618,"change_date":"2024-05-09 21:42:00","inspection_id":"81568897","insp_unit_id":"200815066","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"30","insp_unit_license":"TTJ7653","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"}]},{"id":5608448,"change_date":"2024-04-26 21:40:00","inspection_id":"81457202","dot_number":"3350619","report_state":"OH","report_number":"3272001181","insp_date":"2024-04-26 00:00:00","insp_start_time":"0743","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":"09380","location_desc":"ROADSIDE INSPECTION","county_code_state":"OH","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2024-04-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1722205","transaction_code":"A","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-04-26 21:40:00","snet_input_date":"2024-04-26 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-04-26 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:52.000000Z","updated_at":"2025-03-17T20:13:52.000000Z","inspection_violations":[{"id":8671294,"change_date":"2024-04-26 21:40:00","inspection_id":"81457202","insp_violation_id":"259169164","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3958E1"},{"id":8671295,"change_date":"2024-04-26 21:40:00","inspection_id":"81457202","insp_violation_id":"259169165","seq_no":"2","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200599840","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":9034139,"change_date":"2024-04-26 21:40:00","inspection_id":"81457202","insp_unit_id":"200599840","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"6","insp_unit_license":"PMR3574","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGLXMG687309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"},{"id":9034140,"change_date":"2024-04-26 21:40:00","inspection_id":"81457202","insp_unit_id":"200599841","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"30","insp_unit_license":"TTJ7653","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"}]},{"id":5391671,"change_date":"2024-03-28 21:41:00","inspection_id":"81220416","dot_number":"3350619","report_state":"PA","report_number":"1003408706","insp_date":"2024-03-27 00:00:00","insp_start_time":"1420","insp_end_time":"1500","registration_date":"2024-03-28 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I70 W","county_code_state":"PA","county_code":"129","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JB FOSTER CO","shipping_paper_number":"46171429L","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"49900","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":"2430318","transaction_code":"A","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-03-28 21:41:00","snet_input_date":"2024-03-27 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-03-28 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:28.000000Z","updated_at":"2025-03-17T20:09:28.000000Z","inspection_violations":[{"id":8320887,"change_date":"2024-03-28 21:41:00","inspection_id":"81220416","insp_violation_id":"258640433","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:46:18.000000Z","updated_at":"2025-03-17T21:46:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8683660,"change_date":"2024-03-28 21:41:00","inspection_id":"81220416","insp_unit_id":"200140419","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"8","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:45.000000Z","updated_at":"2025-03-17T23:13:45.000000Z"},{"id":8683661,"change_date":"2024-03-28 21:41:00","inspection_id":"81220416","insp_unit_id":"200140420","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"4","insp_unit_license":"TTJ2803","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3821N6167012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:45.000000Z","updated_at":"2025-03-17T23:13:45.000000Z"}]},{"id":5275036,"change_date":"2024-03-13 21:41:00","inspection_id":"81093365","dot_number":"3350619","report_state":"MD","report_number":"3245004701","insp_date":"2024-03-13 00:00:00","insp_start_time":"1502","insp_end_time":"1525","registration_date":null,"region":"ET","ci_status_code":"C","location":"024","location_desc":"RT 50 W\/B BAY BRIDGE TOLL FAC","county_code_state":"MD","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS 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":"2024-03-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2704642","transaction_code":"A","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-03-13 21:41:00","snet_input_date":"2024-03-13 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-03-13 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:07.000000Z","updated_at":"2025-03-17T20:07:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8494486,"change_date":"2024-03-13 21:41:00","inspection_id":"81093365","insp_unit_id":"199887715","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"ZWN1835","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3C63RRJLXEG193638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:58.000000Z","updated_at":"2025-03-17T23:11:58.000000Z"},{"id":8494487,"change_date":"2024-03-13 21:41:00","inspection_id":"81093365","insp_unit_id":"199887716","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NOVAE","insp_unit_company":null,"insp_unit_license":"3317679","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5JW3U3023P3396657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:58.000000Z","updated_at":"2025-03-17T23:11:58.000000Z"}]},{"id":5269052,"change_date":"2024-03-14 21:41:00","inspection_id":"81086889","dot_number":"3350619","report_state":"OH","report_number":"3275013517","insp_date":"2024-03-11 00:00:00","insp_start_time":"1030","insp_end_time":"1056","registration_date":null,"region":"ET","ci_status_code":"C","location":"05970","location_desc":"CAMBRIDGE SCALES","county_code_state":"OH","county_code":"059","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"PHILLIPS TANK &STRUCTURE","shipping_paper_number":"112755","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":"2024-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1710703","transaction_code":"C","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-03-12 21:39:00","snet_input_date":"2024-03-12 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-03-12 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:05.000000Z","updated_at":"2025-03-17T20:07:05.000000Z","inspection_violations":[{"id":8125259,"change_date":"2024-03-14 21:41:00","inspection_id":"81086889","insp_violation_id":"258385969","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"199916797","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:17.000000Z","updated_at":"2025-03-17T21:45:17.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":8485022,"change_date":"2024-03-14 21:41:00","inspection_id":"81086889","insp_unit_id":"199916796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PKT5070","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGL2KG580719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:55.000000Z","updated_at":"2025-03-17T23:11:55.000000Z"},{"id":8485023,"change_date":"2024-03-14 21:41:00","inspection_id":"81086889","insp_unit_id":"199916797","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PARM","insp_unit_company":null,"insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:55.000000Z","updated_at":"2025-03-17T23:11:55.000000Z"}]},{"id":5226896,"change_date":"2024-03-06 21:40:00","inspection_id":"81040661","dot_number":"3350619","report_state":"PA","report_number":"C108406541","insp_date":"2024-03-05 00:00:00","insp_start_time":"0810","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON SHAWVILLE HWY 176 FEET SOUT","county_code_state":"PA","county_code":"033","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"REITZEL","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-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"2424902","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-03-06 21:40:00","snet_input_date":"2024-03-05 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-03-06 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:12.000000Z","updated_at":"2025-03-17T20:06:12.000000Z","inspection_violations":[{"id":8057811,"change_date":"2024-03-06 21:40:00","inspection_id":"81040661","insp_violation_id":"258238568","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:44:54.000000Z","updated_at":"2025-03-17T21:44:54.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":8417077,"change_date":"2024-03-06 21:40:00","inspection_id":"81040661","insp_unit_id":"199787027","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PLU1114","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD8X3ET6DEB50024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:16.000000Z","updated_at":"2025-03-17T23:11:16.000000Z"},{"id":8417078,"change_date":"2024-03-06 21:40:00","inspection_id":"81040661","insp_unit_id":"199787028","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"2","insp_unit_license":"TTH4140","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F332XM6014442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:16.000000Z","updated_at":"2025-03-17T23:11:16.000000Z"}]},{"id":5144695,"change_date":"2024-02-27 21:39:00","inspection_id":"80951449","dot_number":"3350619","report_state":"MI","report_number":"PRESR99446","insp_date":"2024-02-26 00:00:00","insp_start_time":"1055","insp_end_time":"1103","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"ROADSIDE","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1166624","transaction_code":"A","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-02-27 21:39:00","snet_input_date":"2024-02-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-27 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:32.000000Z","updated_at":"2025-03-17T20:04:32.000000Z","inspection_violations":[{"id":7933268,"change_date":"2024-02-27 21:39:00","inspection_id":"80951449","insp_violation_id":"258060849","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":"X4335850","created_at":"2025-03-17T21:44:19.000000Z","updated_at":"2025-03-17T21:44:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8283481,"change_date":"2024-02-27 21:39:00","inspection_id":"80951449","insp_unit_id":"199620908","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"8","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:03.000000Z","updated_at":"2025-03-17T23:10:03.000000Z"},{"id":8283482,"change_date":"2024-02-27 21:39:00","inspection_id":"80951449","insp_unit_id":"199620909","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"PARM","insp_unit_company":"1T","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:03.000000Z","updated_at":"2025-03-17T23:10:03.000000Z"}]},{"id":5140786,"change_date":"2024-03-11 21:43:00","inspection_id":"80947205","dot_number":"3350619","report_state":"MD","report_number":"2156005268","insp_date":"2024-02-26 00:00:00","insp_start_time":"1042","insp_end_time":"1105","registration_date":"2024-03-11 00:00:00","region":"ET","ci_status_code":"C","location":"035","location_desc":"ALLEGANY COUNTY","county_code_state":"MD","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WESTERN GLOBAL","shipping_paper_number":"466016206","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"2700115","transaction_code":"C","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-02-27 21:39:00","snet_input_date":"2024-02-26 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-02-27 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","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":7928746,"change_date":"2024-03-11 21:43:00","inspection_id":"80947205","insp_violation_id":"258307480","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8277229,"change_date":"2024-03-11 21:43:00","inspection_id":"80947205","insp_unit_id":"199844299","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PLU1114","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD8X3ET6DEB50024","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":8277230,"change_date":"2024-03-11 21:43:00","inspection_id":"80947205","insp_unit_id":"199844300","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"TTH4140","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F332XM6014442","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":4838959,"change_date":"2024-02-01 21:43:00","inspection_id":"80617197","dot_number":"3350619","report_state":"OH","report_number":"3262001752","insp_date":"2024-01-16 00:00:00","insp_start_time":"0821","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":"101","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"101","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"12538","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":"2024-01-16 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1698901","transaction_code":"C","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-16 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:29.000000Z","updated_at":"2025-03-17T19:58:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7785392,"change_date":"2024-02-01 21:43:00","inspection_id":"80617197","insp_unit_id":"199223954","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:36.000000Z","updated_at":"2025-03-17T23:05:36.000000Z"},{"id":7785393,"change_date":"2024-02-01 21:43:00","inspection_id":"80617197","insp_unit_id":"199223955","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"TTH4140","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F332XM6014442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:36.000000Z","updated_at":"2025-03-17T23:05:36.000000Z"}]},{"id":4256327,"change_date":"2023-10-23 21:41:00","inspection_id":"79976727","dot_number":"3350619","report_state":"IL","report_number":"0093000838","insp_date":"2023-10-19 00:00:00","insp_start_time":"1000","insp_end_time":"1017","registration_date":null,"region":"CT","ci_status_code":"C","location":"SC32","location_desc":"LITCHFIELD - I-55 N\/B","county_code_state":"IL","county_code":"135","insp_level_id":"1","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2287594","transaction_code":"A","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2023-10-23 21:41:00","snet_input_date":"2023-10-23 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-10-23 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:06.000000Z","updated_at":"2025-03-17T19:47:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6844862,"change_date":"2023-10-23 21:41:00","inspection_id":"79976727","insp_unit_id":"197686941","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"02","insp_unit_license":"PLU1105","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD8W3HT1DEA57782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:22.000000Z","updated_at":"2025-03-17T22:57:22.000000Z"},{"id":6844863,"change_date":"2023-10-23 21:41:00","inspection_id":"79976727","insp_unit_id":"197686942","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"PARM","insp_unit_company":"03","insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:22.000000Z","updated_at":"2025-03-17T22:57:22.000000Z"}]},{"id":3706716,"change_date":"2023-08-09 21:42:00","inspection_id":"79366018","dot_number":"3350619","report_state":"OH","report_number":"3262001160","insp_date":"2023-08-09 00:00:00","insp_start_time":"1232","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"13997","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"139","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"ONIMUS WELDING","shipping_paper_number":"40373","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-08-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1671878","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2023-08-09 21:42:00","snet_input_date":"2023-08-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-08-09 21:42:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:06.000000Z","updated_at":"2025-03-17T19:36:06.000000Z","inspection_violations":[{"id":5715254,"change_date":"2023-08-09 21:42:00","inspection_id":"79366018","insp_violation_id":"254559150","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196447387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5959864,"change_date":"2023-08-09 21:42:00","inspection_id":"79366018","insp_unit_id":"196447386","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PME9360","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4LG206495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:04.000000Z","updated_at":"2025-03-17T22:50:04.000000Z"},{"id":5959865,"change_date":"2023-08-09 21:42:00","inspection_id":"79366018","insp_unit_id":"196447387","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:04.000000Z","updated_at":"2025-03-17T22:50:04.000000Z"}]},{"id":3716872,"change_date":"2023-08-10 21:42:00","inspection_id":"79377276","dot_number":"3350619","report_state":"OH","report_number":"1772004369","insp_date":"2023-08-09 00:00:00","insp_start_time":"1610","insp_end_time":"1652","registration_date":null,"region":"ET","ci_status_code":"C","location":"13376","location_desc":"ROADSIDE(67)","county_code_state":"OH","county_code":"133","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CLEAVLAND PRICE INC","shipping_paper_number":"00401732","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-08-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1671931","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2023-08-10 21:42:00","snet_input_date":"2023-08-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-08-10 21:42:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:09.000000Z","updated_at":"2025-03-17T19:36:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5976154,"change_date":"2023-08-10 21:42:00","inspection_id":"79377276","insp_unit_id":"196473767","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2","insp_unit_license":"PLU1105","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD8W3HT1DEA57782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:14.000000Z","updated_at":"2025-03-17T22:50:14.000000Z"},{"id":5976155,"change_date":"2023-08-10 21:42:00","inspection_id":"79377276","insp_unit_id":"196473768","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"2T","insp_unit_license":"TTH4140","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F332XM6014442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:14.000000Z","updated_at":"2025-03-17T22:50:14.000000Z"}]},{"id":3513513,"change_date":"2023-07-14 21:41:00","inspection_id":"79149322","dot_number":"3350619","report_state":"PA","report_number":"C048003489","insp_date":"2023-07-13 00:00:00","insp_start_time":"0916","insp_end_time":"1005","registration_date":null,"region":"TT","ci_status_code":"C","location":null,"location_desc":"BRIDGEVILLE REST AREA","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"MEVA FORMWORK SYSTEMS INC","shipping_paper_number":"24701","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-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2364847","transaction_code":"A","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-13 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:29.000000Z","updated_at":"2025-03-17T19:32:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5649707,"change_date":"2023-07-14 21:41:00","inspection_id":"79149322","insp_unit_id":"196011963","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"6","insp_unit_license":"PMR3574","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGLXMG687309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"},{"id":5649708,"change_date":"2023-07-14 21:41:00","inspection_id":"79149322","insp_unit_id":"196011964","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"30","insp_unit_license":"929517","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"}]},{"id":3404159,"change_date":"2023-06-29 21:43:00","inspection_id":"79026482","dot_number":"3350619","report_state":"IL","report_number":"3998613467","insp_date":"2023-06-29 00:00:00","insp_start_time":"0943","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"OHIO AVE","county_code_state":"IL","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"2157642","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-06-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","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":"2256504","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2023-06-29 21:43:00","snet_input_date":"2023-06-29 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-06-29 21:43:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"107115","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:33.000000Z","updated_at":"2025-03-17T19:30:33.000000Z","inspection_violations":[{"id":5247962,"change_date":"2023-06-29 21:43:00","inspection_id":"79026482","insp_violation_id":"253794673","seq_no":"1","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"195761874","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:31:22.000000Z","updated_at":"2025-03-17T21:31:22.000000Z","normalized_code":"39375A2"}],"inspection_per_units":[{"id":5473120,"change_date":"2023-06-29 21:43:00","inspection_id":"79026482","insp_unit_id":"195761873","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PKT5070","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGL2KG580719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:10.000000Z","updated_at":"2025-03-17T22:46:10.000000Z"},{"id":5473121,"change_date":"2023-06-29 21:43:00","inspection_id":"79026482","insp_unit_id":"195761874","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"TTJ2803","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3821N6167012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:10.000000Z","updated_at":"2025-03-17T22:46:10.000000Z"}]},{"id":3427033,"change_date":"2023-07-13 21:42:00","inspection_id":"79051914","dot_number":"3350619","report_state":"IN","report_number":"4956020625","insp_date":"2023-06-28 00:00:00","insp_start_time":"1156","insp_end_time":"1249","registration_date":null,"region":"ET","ci_status_code":"C","location":"5570W","location_desc":"#55  I-70  WB  WAYNE","county_code_state":"IN","county_code":"177","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-07-04 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2195658","transaction_code":"C","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":"M","census_search_date":"2023-07-04 21:32:00","snet_input_date":"2023-07-03 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-07-04 21:32:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:56.000000Z","updated_at":"2025-03-17T19:30:56.000000Z","inspection_violations":[{"id":5284389,"change_date":"2023-07-13 21:42:00","inspection_id":"79051914","insp_violation_id":"254040072","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:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"39522H4"},{"id":5284390,"change_date":"2023-07-13 21:42:00","inspection_id":"79051914","insp_violation_id":"254040073","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195982125","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"39311"},{"id":5284391,"change_date":"2023-07-13 21:42:00","inspection_id":"79051914","insp_violation_id":"254040074","seq_no":"3","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:33.000000Z","updated_at":"2025-03-17T21:31:33.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":5509975,"change_date":"2023-07-13 21:42:00","inspection_id":"79051914","insp_unit_id":"195982125","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"9","insp_unit_license":"PLU1114","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD8X3ET6DEB50024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:28.000000Z","updated_at":"2025-03-17T22:46:28.000000Z"},{"id":5509976,"change_date":"2023-07-13 21:42:00","inspection_id":"79051914","insp_unit_id":"195982126","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"TRQ8742","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4P5LS3027L1320138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:28.000000Z","updated_at":"2025-03-17T22:46:28.000000Z"}]},{"id":3084157,"change_date":"2023-05-18 21:43:00","inspection_id":"78665619","dot_number":"3350619","report_state":"OH","report_number":"1532002852","insp_date":"2023-05-18 00:00:00","insp_start_time":"1212","insp_end_time":"1242","registration_date":null,"region":"ET","ci_status_code":"C","location":"13380","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"133","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"INTERSTAR INC","shipping_paper_number":"22629","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-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1657435","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2023-05-18 21:43:00","snet_input_date":"2023-05-18 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:09.000000Z","updated_at":"2025-03-17T19:24:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4961085,"change_date":"2023-05-18 21:43:00","inspection_id":"78665619","insp_unit_id":"195016894","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PME9360","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4LG206495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:08.000000Z","updated_at":"2025-03-17T22:42:08.000000Z"},{"id":4961086,"change_date":"2023-05-18 21:43:00","inspection_id":"78665619","insp_unit_id":"195016895","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"TTJ2817","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:08.000000Z","updated_at":"2025-03-17T22:42:08.000000Z"}]},{"id":2586532,"change_date":"2023-03-31 21:41:00","inspection_id":"78101431","dot_number":"3350619","report_state":"OH","report_number":"3288015791","insp_date":"2023-03-14 00:00:00","insp_start_time":"1455","insp_end_time":"1535","registration_date":"2023-03-31 00:00:00","region":"ET","ci_status_code":"C","location":"01775","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"DURO DYNE MIDWEST","shipping_paper_number":"33235","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-03-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1644495","transaction_code":"C","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2023-03-15 21:42:00","snet_input_date":"2023-03-15 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-03-15 21:42:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:27.000000Z","updated_at":"2025-03-17T19:14:27.000000Z","inspection_violations":[{"id":3977832,"change_date":"2023-03-31 21:41:00","inspection_id":"78101431","insp_violation_id":"251989345","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"194172308","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:38.000000Z","updated_at":"2025-03-17T21:25:38.000000Z","normalized_code":"39360D"},{"id":3977833,"change_date":"2023-03-31 21:41:00","inspection_id":"78101431","insp_violation_id":"251989346","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:38.000000Z","updated_at":"2025-03-17T21:25:38.000000Z","normalized_code":"3958E1"},{"id":3977834,"change_date":"2023-03-31 21:41:00","inspection_id":"78101431","insp_violation_id":"251989347","seq_no":"3","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:38.000000Z","updated_at":"2025-03-17T21:25:38.000000Z","normalized_code":"39524C2III"}],"inspection_per_units":[{"id":4163197,"change_date":"2023-03-31 21:41:00","inspection_id":"78101431","insp_unit_id":"194172308","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"PMR3574","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGLXMG687309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"},{"id":4163198,"change_date":"2023-03-31 21:41:00","inspection_id":"78101431","insp_unit_id":"194172309","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"30","insp_unit_license":"929517","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"}]},{"id":2446303,"change_date":"2023-02-24 21:40:00","inspection_id":"77941670","dot_number":"3350619","report_state":"MI","report_number":"MALIK01599","insp_date":"2023-02-23 00:00:00","insp_start_time":"1325","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 23 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"0031097","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1114981","transaction_code":"A","transaction_date":"2023-02-23 00:00:00","upload_date":"2023-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2023-02-24 21:40:00","snet_input_date":"2023-02-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-24 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:46.000000Z","updated_at":"2025-03-17T19:11:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3936653,"change_date":"2023-02-24 21:40:00","inspection_id":"77941670","insp_unit_id":"193571134","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"NONE","insp_unit_license":"PME9360","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4LG206495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:12.000000Z","updated_at":"2025-03-17T22:34:12.000000Z"},{"id":3936654,"change_date":"2023-02-24 21:40:00","inspection_id":"77941670","insp_unit_id":"193571135","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADVA","insp_unit_company":"NONE","insp_unit_license":"Q306987","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1SPGF3522PH000246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:12.000000Z","updated_at":"2025-03-17T22:34:12.000000Z"}]},{"id":2397066,"change_date":"2023-03-14 21:42:00","inspection_id":"77885688","dot_number":"3350619","report_state":"IN","report_number":"9320000630","insp_date":"2023-02-15 00:00:00","insp_start_time":"1453","insp_end_time":"1555","registration_date":"2023-03-08 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"I-65 NB 171 MM","county_code_state":"IN","county_code":"157","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CENTRIA","shipping_paper_number":"050561","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-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2176222","transaction_code":"C","transaction_date":"2023-02-17 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":"M","census_search_date":"2023-02-17 21:39:00","snet_input_date":"2023-02-17 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-02-17 21:39:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:46.000000Z","updated_at":"2025-03-17T19:10:46.000000Z","inspection_violations":[{"id":3690531,"change_date":"2023-03-14 21:42:00","inspection_id":"77885688","insp_violation_id":"251661476","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193871215","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"39617C"},{"id":3690532,"change_date":"2023-03-14 21:42:00","inspection_id":"77885688","insp_violation_id":"251661477","seq_no":"2","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"193871216","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"393104B"},{"id":3690533,"change_date":"2023-03-14 21:42:00","inspection_id":"77885688","insp_violation_id":"251661478","seq_no":"3","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"193871216","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"393104B"}],"inspection_per_units":[{"id":3857343,"change_date":"2023-03-14 21:42:00","inspection_id":"77885688","insp_unit_id":"193871215","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TRUK","insp_unit_company":"8","insp_unit_license":"PLN2570","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL6JG208830","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:38.000000Z","updated_at":"2025-03-17T22:33:38.000000Z"},{"id":3857344,"change_date":"2023-03-14 21:42:00","inspection_id":"77885688","insp_unit_id":"193871216","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"4","insp_unit_license":"PMQ8416","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"16V3F3821N6167012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:38.000000Z","updated_at":"2025-03-17T22:33:38.000000Z"}]},{"id":2316732,"change_date":"2023-02-07 21:41:00","inspection_id":"77793701","dot_number":"3350619","report_state":"MI","report_number":"CHAPP03779","insp_date":"2023-02-06 00:00:00","insp_start_time":"1835","insp_end_time":"1855","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ 19 MM","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"JBHUDCO","shipping_paper_number":"1578455228","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-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1112722","transaction_code":"A","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:17.000000Z","updated_at":"2025-03-17T19:09:17.000000Z","inspection_violations":[{"id":3568436,"change_date":"2023-02-07 21:41:00","inspection_id":"77793701","insp_violation_id":"250996133","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:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3728815,"change_date":"2023-02-07 21:41:00","inspection_id":"77793701","insp_unit_id":"193274645","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PLF2404","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRAL0LG221184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"},{"id":3728816,"change_date":"2023-02-07 21:41:00","inspection_id":"77793701","insp_unit_id":"193274646","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"TRL8262","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5RVFS4028LP086642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"}]},{"id":1996685,"change_date":"2022-12-21 21:40:00","inspection_id":"77428384","dot_number":"3350619","report_state":"OH","report_number":"3290011359","insp_date":"2022-12-21 00:00:00","insp_start_time":"1310","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"DAYTON FORGING","shipping_paper_number":"000005183","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-12-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1631764","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2022-12-21 21:40:00","snet_input_date":"2022-12-21 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-12-21 21:40:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:21.000000Z","updated_at":"2025-03-17T19:03:21.000000Z","inspection_violations":[{"id":3098444,"change_date":"2022-12-21 21:40:00","inspection_id":"77428384","insp_violation_id":"250220452","seq_no":"1","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"192539511","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39375A2"},{"id":3098445,"change_date":"2022-12-21 21:40:00","inspection_id":"77428384","insp_violation_id":"250220453","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"192539511","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":3212367,"change_date":"2022-12-21 21:40:00","inspection_id":"77428384","insp_unit_id":"192539510","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PME9360","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4LG206495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:00.000000Z","updated_at":"2025-03-17T22:29:00.000000Z"},{"id":3212368,"change_date":"2022-12-21 21:40:00","inspection_id":"77428384","insp_unit_id":"192539511","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"TRL8262","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5RVFS4028LP086642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:00.000000Z","updated_at":"2025-03-17T22:29:00.000000Z"}]},{"id":1332961,"change_date":"2022-09-21 21:38:00","inspection_id":"76664867","dot_number":"3350619","report_state":"AR","report_number":"B437004083","insp_date":"2022-09-21 00:00:00","insp_start_time":"0950","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"73","location_desc":"WHITE COUNTY","county_code_state":"AR","county_code":"145","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"HR ROWHEAD MACHINERY","shipping_paper_number":"NO NUMBER","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-09-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1421519","transaction_code":"A","transaction_date":"2022-09-21 00:00:00","upload_date":"2022-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":"M","census_search_date":"2022-09-21 21:38:00","snet_input_date":"2022-09-21 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-09-21 21:38:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:15.000000Z","updated_at":"2025-03-17T18:51:15.000000Z","inspection_violations":[{"id":2109637,"change_date":"2022-09-21 21:38:00","inspection_id":"76664867","insp_violation_id":"248549862","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191014589","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"3939A"},{"id":2109638,"change_date":"2022-09-21 21:38:00","inspection_id":"76664867","insp_violation_id":"248549863","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191014589","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"~W000387","created_at":"2025-03-17T21:16:40.000000Z","updated_at":"2025-03-17T21:16:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2145829,"change_date":"2022-09-21 21:38:00","inspection_id":"76664867","insp_unit_id":"191014589","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"6","insp_unit_license":"PMR3574","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C63RRGLXMG687309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:42.000000Z","updated_at":"2025-03-17T22:21:42.000000Z"},{"id":2145830,"change_date":"2022-09-21 21:38:00","inspection_id":"76664867","insp_unit_id":"191014590","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"6","insp_unit_license":"929517","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F3822M6067404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:42.000000Z","updated_at":"2025-03-17T22:21:42.000000Z"}]},{"id":957585,"change_date":"2022-08-03 21:42:00","inspection_id":"76228173","dot_number":"3350619","report_state":"OH","report_number":"3257051440","insp_date":"2022-08-02 00:00:00","insp_start_time":"1048","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"15580","location_desc":"GIRARD(HUBBARD)SCALES","county_code_state":"OH","county_code":"155","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"ELLWOOD NATIONAL CRANKSHAFT COMPANY","shipping_paper_number":"65967837","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-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1609681","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03350619","upload_search_indicator":null,"census_search_date":"2022-08-03 21:42:00","snet_input_date":"2022-08-03 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"SQUARE DEAL SHIPPING LLC","insp_carrier_street":"3309 COUNTY ROAD 22A","insp_carrier_city":"BLOOMINGDALE","insp_carrier_state":"OH","insp_carrier_zip_code":"43910","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:27.000000Z","updated_at":"2025-03-17T18:44:27.000000Z","inspection_violations":[{"id":1508842,"change_date":"2022-08-03 21:42:00","inspection_id":"76228173","insp_violation_id":"247493870","seq_no":"1","part_no":"393","part_no_section":"40","insp_viol_unit":"2","insp_unit_id":"190118610","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:08.000000Z","updated_at":"2025-03-17T21:14:08.000000Z","normalized_code":"39340"}],"inspection_per_units":[{"id":1540937,"change_date":"2022-08-03 21:42:00","inspection_id":"76228173","insp_unit_id":"190118609","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PME9360","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3C7WRTCL4LG206495","insp_unit_decal":"Y","insp_unit_decal_number":"31612380","created_at":"2025-03-17T22:17:42.000000Z","updated_at":"2025-03-17T22:17:42.000000Z"},{"id":1540938,"change_date":"2022-08-03 21:42:00","inspection_id":"76228173","insp_unit_id":"190118610","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"TRL8262","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5RVFS4028LP086642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:42.000000Z","updated_at":"2025-03-17T22:17:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3350619\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3350619\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3350619\/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\/3350619\/inspections","per_page":100,"prev_page_url":null,"to":62,"total":62}