{"current_page":1,"data":[{"id":11127336,"change_date":"2026-02-13 21:38:00","inspection_id":"87040588","dot_number":"3787034","report_state":"IN","report_number":"1008801072","insp_date":"2026-02-09 00:00:00","insp_start_time":"1521","insp_end_time":"1605","registration_date":null,"region":"ES","ci_status_code":"C","location":"4274W","location_desc":"WEST HARRISON IN","county_code_state":"IN","county_code":"029","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ONE CHOICE RECOVERY","shipping_paper_number":"75883","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-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"2883429","transaction_code":"A","transaction_date":"2026-02-13 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2026-02-13 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-13 21:38:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-16T10:38:32.000000Z","updated_at":"2026-02-24T10:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18978527,"change_date":"2026-02-13 21:38:00","inspection_id":"87040588","insp_unit_id":"211610476","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK512OQI","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DT2KED17517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:14:59.000000Z","updated_at":"2026-02-24T10:02:44.000000Z"},{"id":18978528,"change_date":"2026-02-13 21:38:00","inspection_id":"87040588","insp_unit_id":"211610477","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APPALACHIA","insp_unit_company":null,"insp_unit_license":"SP792MWP","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3626NS000982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:14:59.000000Z","updated_at":"2026-02-24T10:02:44.000000Z"}]},{"id":9492377,"change_date":"2025-08-24 21:33:00","inspection_id":"85576623","dot_number":"3787034","report_state":"IN","report_number":"9938001307","insp_date":"2025-08-22 00:00:00","insp_start_time":"0707","insp_end_time":"0816","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GREENFIELD IN","county_code_state":"IN","county_code":"059","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"READY LOGISTICS","shipping_paper_number":"10452189834","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-08-24 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"2170966","transaction_code":"A","transaction_date":"2025-08-24 00:00:00","upload_date":"2025-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2025-08-24 21:33:00","snet_input_date":"2025-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-24 21:33:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-27T10:43:54.000000Z","updated_at":"2025-08-29T10:42:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15659126,"change_date":"2025-08-24 21:33:00","inspection_id":"85576623","insp_unit_id":"208553629","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2","insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-27T09:45:26.000000Z","updated_at":"2025-08-28T09:45:21.000000Z"},{"id":15659127,"change_date":"2025-08-24 21:33:00","inspection_id":"85576623","insp_unit_id":"208553630","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APPALACHIA","insp_unit_company":"2","insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-27T09:45:26.000000Z","updated_at":"2025-08-28T09:45:21.000000Z"}]},{"id":9273503,"change_date":"2025-07-29 21:39:00","inspection_id":"85346434","dot_number":"3787034","report_state":"OH","report_number":"3290000589","insp_date":"2025-07-28 00:00:00","insp_start_time":"0730","insp_end_time":"0810","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SPRINGFIELD OH","county_code_state":"OH","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"10437880583","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-07-29 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":"2056833","transaction_code":"A","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2025-07-29 21:39:00","snet_input_date":"2025-07-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-29 21:39:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-01T10:42:03.000000Z","updated_at":"2025-08-04T10:00:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15266039,"change_date":"2025-07-29 21:39:00","inspection_id":"85346434","insp_unit_id":"208130030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"3820452","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W4DT7LED91636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:43.000000Z","updated_at":"2025-08-02T09:45:32.000000Z"},{"id":15266040,"change_date":"2025-07-29 21:39:00","inspection_id":"85346434","insp_unit_id":"208130031","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":"6","insp_unit_license":"PE67927","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5VGFW5029FL006122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:43.000000Z","updated_at":"2025-08-02T09:45:32.000000Z"}]},{"id":9222213,"change_date":"2025-07-23 21:41:00","inspection_id":"85292429","dot_number":"3787034","report_state":"IN","report_number":"9938001219","insp_date":"2025-07-22 00:00:00","insp_start_time":"0620","insp_end_time":"0656","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GREENFIELD IN","county_code_state":"IN","county_code":"059","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LENDERS RECOVERY","shipping_paper_number":"10436102956","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-07-23 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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2029236","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2025-07-23 21:41:00","snet_input_date":"2025-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-23 21:41:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:26.000000Z","updated_at":"2025-07-27T10:41:26.000000Z","inspection_violations":[{"id":14920933,"change_date":"2025-07-23 21:41:00","inspection_id":"85292429","insp_violation_id":"267585336","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":"2025-07-26T10:43:20.000000Z","updated_at":"2025-07-27T10:42:44.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":15170460,"change_date":"2025-07-23 21:41:00","inspection_id":"85292429","insp_unit_id":"208023811","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"5","insp_unit_license":"T40365","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W4DT7LED91636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:25.000000Z","updated_at":"2025-07-27T09:45:38.000000Z"},{"id":15170461,"change_date":"2025-07-23 21:41:00","inspection_id":"85292429","insp_unit_id":"208023812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":"6","insp_unit_license":"PE67927","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5VGFW5029FL006122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:25.000000Z","updated_at":"2025-07-27T09:45:38.000000Z"}]},{"id":8624565,"change_date":"2025-05-14 21:41:00","inspection_id":"84661451","dot_number":"3787034","report_state":"OH","report_number":"3290000445","insp_date":"2025-05-12 00:00:00","insp_start_time":"0835","insp_end_time":"0915","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SPRINGFIELD OH","county_code_state":"OH","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"10400651788","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"1723717","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:45.000000Z","updated_at":"2025-05-18T10:04:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14082925,"change_date":"2025-05-14 21:41:00","inspection_id":"84661451","insp_unit_id":"206843586","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK8460KT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:48:39.000000Z","updated_at":"2025-05-18T09:49:11.000000Z"},{"id":14082926,"change_date":"2025-05-14 21:41:00","inspection_id":"84661451","insp_unit_id":"206843587","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APACHE COA","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:48:39.000000Z","updated_at":"2025-05-18T09:49:11.000000Z"}]},{"id":8507682,"change_date":"2025-04-30 21:52:00","inspection_id":"84538421","dot_number":"3787034","report_state":"OH","report_number":"3290000416","insp_date":"2025-04-28 00:00:00","insp_start_time":"0916","insp_end_time":"0955","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SOUTH CHARLESTON OH","county_code_state":"OH","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MANHEIM","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":"2025-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"1654865","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:50:48.000000Z","updated_at":"2025-05-04T10:37:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13830346,"change_date":"2025-04-30 21:52:00","inspection_id":"84538421","insp_unit_id":"206564383","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:20:36.000000Z","updated_at":"2025-05-04T10:04:55.000000Z"},{"id":13830347,"change_date":"2025-04-30 21:52:00","inspection_id":"84538421","insp_unit_id":"206564384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APACHE COA","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:20:36.000000Z","updated_at":"2025-05-04T10:04:55.000000Z"}]},{"id":6321123,"change_date":"2024-07-26 21:39:00","inspection_id":"82227430","dot_number":"3787034","report_state":"OH","report_number":"3245016421","insp_date":"2024-07-26 00:00:00","insp_start_time":"1220","insp_end_time":"1244","registration_date":null,"region":"ET","ci_status_code":"C","location":"16130","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MANHIEM","shipping_paper_number":"ELECTRONIC","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-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"1742992","transaction_code":"A","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-07-26 21:39:00","snet_input_date":"2024-07-26 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-07-26 21:39:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"1545 PARK RIDGE WAY","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46229","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:13.000000Z","updated_at":"2025-03-17T20:28:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10185345,"change_date":"2024-07-26 21:39:00","inspection_id":"82227430","insp_unit_id":"202095052","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:31.000000Z","updated_at":"2025-03-17T23:28:31.000000Z"},{"id":10185346,"change_date":"2024-07-26 21:39:00","inspection_id":"82227430","insp_unit_id":"202095053","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APAC","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:31.000000Z","updated_at":"2025-03-17T23:28:31.000000Z"}]},{"id":6230803,"change_date":"2024-09-17 21:45:00","inspection_id":"82130777","dot_number":"3787034","report_state":"MI","report_number":"SAMOK00631","insp_date":"2024-07-15 00:00:00","insp_start_time":"1225","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"COLDWATER SCALE","county_code_state":"MI","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"YES","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-07-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"1186278","transaction_code":"C","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-07-16 21:44:00","snet_input_date":"2024-07-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-16 21:44:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:13.000000Z","updated_at":"2025-03-17T20:26:13.000000Z","inspection_violations":[{"id":9679089,"change_date":"2024-09-17 21:45:00","inspection_id":"82130777","insp_violation_id":"261870757","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202984666","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10039181,"change_date":"2024-09-17 21:45:00","inspection_id":"82130777","insp_unit_id":"202984665","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:00.000000Z","updated_at":"2025-03-17T23:27:00.000000Z"},{"id":10039182,"change_date":"2024-09-17 21:45:00","inspection_id":"82130777","insp_unit_id":"202984666","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APAC","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:00.000000Z","updated_at":"2025-03-17T23:27:00.000000Z"}]},{"id":5855762,"change_date":"2024-05-31 21:39:00","inspection_id":"81725714","dot_number":"3787034","report_state":"OH","report_number":"3239004330","insp_date":"2024-05-22 00:00:00","insp_start_time":"1014","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":"6924","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":"ACV AUCTIONS INC","shipping_paper_number":"77079609","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-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"1729192","transaction_code":"C","transaction_date":"2024-05-24 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-05-28 21:43:00","snet_input_date":"2024-05-28 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-28 21:43:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"1545 PARK RIDGE WAY","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46229","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:42.000000Z","updated_at":"2025-03-17T20:18:42.000000Z","inspection_violations":[{"id":9075193,"change_date":"2024-05-31 21:39:00","inspection_id":"81725714","insp_violation_id":"259836684","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"201176826","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:50.000000Z","updated_at":"2025-03-17T21:49:50.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":9431298,"change_date":"2024-05-31 21:39:00","inspection_id":"81725714","insp_unit_id":"201176825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:52.000000Z","updated_at":"2025-03-17T23:20:52.000000Z"},{"id":9431299,"change_date":"2024-05-31 21:39:00","inspection_id":"81725714","insp_unit_id":"201176826","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APAC","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:52.000000Z","updated_at":"2025-03-17T23:20:52.000000Z"}]},{"id":5656743,"change_date":"2024-05-02 21:43:00","inspection_id":"81509777","dot_number":"3787034","report_state":"MI","report_number":"DELMT01154","insp_date":"2024-05-01 00:00:00","insp_start_time":"1425","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I94 NEAR DANCER RD","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"10209470667","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-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1176835","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-05-02 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-02 21:43:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:45.000000Z","updated_at":"2025-03-17T20:14:45.000000Z","inspection_violations":[{"id":8749777,"change_date":"2024-05-02 21:43:00","inspection_id":"81509777","insp_violation_id":"259285050","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:19.000000Z","updated_at":"2025-03-17T21:48:19.000000Z","normalized_code":"39282A1"},{"id":8749778,"change_date":"2024-05-02 21:43:00","inspection_id":"81509777","insp_violation_id":"259285051","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:19.000000Z","updated_at":"2025-03-17T21:48:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9111225,"change_date":"2024-05-02 21:43:00","inspection_id":"81509777","insp_unit_id":"200700970","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:47.000000Z","updated_at":"2025-03-17T23:17:47.000000Z"},{"id":9111226,"change_date":"2024-05-02 21:43:00","inspection_id":"81509777","insp_unit_id":"200700971","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APAC","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:47.000000Z","updated_at":"2025-03-17T23:17:47.000000Z"}]},{"id":5624162,"change_date":"2024-05-13 21:42:00","inspection_id":"81474525","dot_number":"3787034","report_state":"OH","report_number":"9478400053","insp_date":"2024-04-26 00:00:00","insp_start_time":"0906","insp_end_time":"1021","registration_date":"2024-05-13 00:00:00","region":"ET","ci_status_code":"C","location":"13570","location_desc":"PREBLE SCALES","county_code_state":"OH","county_code":"135","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"ACV AUCTION","shipping_paper_number":"36388999","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-29 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1722391","transaction_code":"C","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-04-29 21:44:00","snet_input_date":"2024-04-29 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-04-29 21:44:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"1545 PARK RIDGE WAY","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46229","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:16.000000Z","updated_at":"2025-03-17T20:14:16.000000Z","inspection_violations":[{"id":8697274,"change_date":"2024-05-13 21:42:00","inspection_id":"81474525","insp_violation_id":"259464960","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:04.000000Z","updated_at":"2025-03-17T21:48:04.000000Z","normalized_code":"38323A2"},{"id":8697275,"change_date":"2024-05-13 21:42:00","inspection_id":"81474525","insp_violation_id":"259464961","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:48:04.000000Z","updated_at":"2025-03-17T21:48:04.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":9059738,"change_date":"2024-05-13 21:42:00","inspection_id":"81474525","insp_unit_id":"200857694","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"Y","insp_unit_decal_number":"33939441","created_at":"2025-03-17T23:17:17.000000Z","updated_at":"2025-03-17T23:17:17.000000Z"},{"id":9059739,"change_date":"2024-05-13 21:42:00","inspection_id":"81474525","insp_unit_id":"200857695","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APAC","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"Y","insp_unit_decal_number":"33939442","created_at":"2025-03-17T23:17:17.000000Z","updated_at":"2025-03-17T23:17:17.000000Z"}]},{"id":5447667,"change_date":"2024-04-05 21:40:00","inspection_id":"81281634","dot_number":"3787034","report_state":"MI","report_number":"OMILJ04652","insp_date":"2024-04-04 00:00:00","insp_start_time":"1035","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ MM 23","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MULTI","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"1172121","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-04-05 21:40:00","snet_input_date":"2024-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-05 21:40:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:40.000000Z","updated_at":"2025-03-17T20:10:40.000000Z","inspection_violations":[{"id":8408475,"change_date":"2024-04-05 21:40:00","inspection_id":"81281634","insp_violation_id":"258774569","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:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8774784,"change_date":"2024-04-05 21:40:00","inspection_id":"81281634","insp_unit_id":"200262666","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:36.000000Z","updated_at":"2025-03-17T23:14:36.000000Z"},{"id":8774785,"change_date":"2024-04-05 21:40:00","inspection_id":"81281634","insp_unit_id":"200262667","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APAC","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:36.000000Z","updated_at":"2025-03-17T23:14:36.000000Z"}]},{"id":5301616,"change_date":"2024-03-16 21:32:00","inspection_id":"81122390","dot_number":"3787034","report_state":"IN","report_number":"7799005546","insp_date":"2024-03-14 00:00:00","insp_start_time":"1723","insp_end_time":"1753","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CARMEL IN","county_code_state":"IN","county_code":"057","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-16 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"322169","transaction_code":"A","transaction_date":"2024-03-16 00:00:00","upload_date":"2024-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-03-16 21:32:00","snet_input_date":"2024-03-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-16 21:32:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:51.000000Z","updated_at":"2025-03-17T20:07:51.000000Z","inspection_violations":[{"id":8176694,"change_date":"2024-03-16 21:32:00","inspection_id":"81122390","insp_violation_id":"258421918","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"199947571","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":8537976,"change_date":"2024-03-16 21:32:00","inspection_id":"81122390","insp_unit_id":"199947571","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK198OGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DT2KED17517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:22.000000Z","updated_at":"2025-03-17T23:12:22.000000Z"},{"id":8537977,"change_date":"2024-03-16 21:32:00","inspection_id":"81122390","insp_unit_id":"199947572","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"SP792MWP","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3626NS000982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:22.000000Z","updated_at":"2025-03-17T23:12:22.000000Z"}]},{"id":5137708,"change_date":"2024-02-26 21:42:00","inspection_id":"80943870","dot_number":"3787034","report_state":"OH","report_number":"3221302059","insp_date":"2024-02-26 00:00:00","insp_start_time":"0920","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"089070","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"089","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1707411","transaction_code":"A","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-02-26 21:42:00","snet_input_date":"2024-02-26 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"1545 PARK RIDGE WAY","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46229","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:15.000000Z","updated_at":"2025-03-17T20:04:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8272014,"change_date":"2024-02-26 21:42:00","inspection_id":"80943870","insp_unit_id":"199604093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1980GD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DT2KED17517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:58.000000Z","updated_at":"2025-03-17T23:09:58.000000Z"},{"id":8272015,"change_date":"2024-02-26 21:42:00","inspection_id":"80943870","insp_unit_id":"199604094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"SP792MWP","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3626NS000982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:58.000000Z","updated_at":"2025-03-17T23:09:58.000000Z"}]},{"id":5137129,"change_date":"2024-02-26 21:42:00","inspection_id":"80943229","dot_number":"3787034","report_state":"MI","report_number":"SILKS03898","insp_date":"2024-02-21 00:00:00","insp_start_time":"1030","insp_end_time":"1059","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"COLDWATER SCALE","county_code_state":"MI","county_code":"023","insp_level_id":"2","service_center":"MW","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-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"39500","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":"1166490","transaction_code":"A","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-02-26 21:42:00","snet_input_date":"2024-02-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:15.000000Z","updated_at":"2025-03-17T20:04:15.000000Z","inspection_violations":[{"id":7920455,"change_date":"2024-02-26 21:42:00","inspection_id":"80943229","insp_violation_id":"258038599","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"199602922","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:17.000000Z","updated_at":"2025-03-17T21:44:17.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":8271020,"change_date":"2024-02-26 21:42:00","inspection_id":"80943229","insp_unit_id":"199602922","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK198OGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DT2KED17517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:58.000000Z","updated_at":"2025-03-17T23:09:58.000000Z"},{"id":8271021,"change_date":"2024-02-26 21:42:00","inspection_id":"80943229","insp_unit_id":"199602923","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"SP792MWP","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3626NS000982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:58.000000Z","updated_at":"2025-03-17T23:09:58.000000Z"}]},{"id":4943590,"change_date":"2024-01-31 21:42:00","inspection_id":"80731504","dot_number":"3787034","report_state":"OH","report_number":"3272000890","insp_date":"2024-01-31 00:00:00","insp_start_time":"1356","insp_end_time":"1440","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":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"ACV AUCTIONS INC","shipping_paper_number":"75508626","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-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"1702031","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2024-01-31 21:42:00","snet_input_date":"2024-01-31 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-01-31 21:42:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"1545 PARK RIDGE WAY","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46229","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:48.000000Z","updated_at":"2025-03-17T20:00:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7955844,"change_date":"2024-01-31 21:42:00","inspection_id":"80731504","insp_unit_id":"199196855","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"},{"id":7955845,"change_date":"2024-01-31 21:42:00","inspection_id":"80731504","insp_unit_id":"199196856","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APAC","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"}]},{"id":4383915,"change_date":"2023-11-08 21:41:00","inspection_id":"80118176","dot_number":"3787034","report_state":"MI","report_number":"WALKB02673","insp_date":"2023-11-07 00:00:00","insp_start_time":"1347","insp_end_time":"1408","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARITE OF INDY NORTH","shipping_paper_number":"AHXM3872","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-11-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"1152653","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2023-11-08 21:41:00","snet_input_date":"2023-11-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-08 21:41:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"4600 E 16TH ST STE H","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:50.000000Z","updated_at":"2025-03-17T19:49:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7050411,"change_date":"2023-11-08 21:41:00","inspection_id":"80118176","insp_unit_id":"197970660","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"},{"id":7050412,"change_date":"2023-11-08 21:41:00","inspection_id":"80118176","insp_unit_id":"197970661","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APAC","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"}]},{"id":3802513,"change_date":"2023-08-30 21:44:00","inspection_id":"79472760","dot_number":"3787034","report_state":"MI","report_number":"DIUBJ02677","insp_date":"2023-08-21 00:00:00","insp_start_time":"1715","insp_end_time":"1756","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-23 SB AT MM 17","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON AND SONS LLC","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1141370","transaction_code":"C","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2023-08-22 21:43:00","snet_input_date":"2023-08-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-22 21:43:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"1545 PARK RIDGE WAY","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46229","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:01.000000Z","updated_at":"2025-03-17T19:38:01.000000Z","inspection_violations":[{"id":5865079,"change_date":"2023-08-30 21:44:00","inspection_id":"79472760","insp_violation_id":"254983754","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196813363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:17.000000Z","updated_at":"2025-03-17T21:34:17.000000Z","normalized_code":"39021TB"},{"id":5865080,"change_date":"2023-08-30 21:44:00","inspection_id":"79472760","insp_violation_id":"254983755","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196813364","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:17.000000Z","updated_at":"2025-03-17T21:34:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6113830,"change_date":"2023-08-30 21:44:00","inspection_id":"79472760","insp_unit_id":"196813363","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK846OKT","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DTXKEG59619","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"},{"id":6113831,"change_date":"2023-08-30 21:44:00","inspection_id":"79472760","insp_unit_id":"196813364","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"SP890NGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3623PS000554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"}]},{"id":3755479,"change_date":"2023-08-16 21:39:00","inspection_id":"79420066","dot_number":"3787034","report_state":"IL","report_number":"4069900199","insp_date":"2023-08-15 00:00:00","insp_start_time":"1448","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-70","county_code_state":"IL","county_code":"005","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAMILTON AND SONS TRANSPORT","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"2268719","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2023-08-16 21:39:00","snet_input_date":"2023-08-15 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-08-16 21:39:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"1545 PARK RIDGE WAY","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46229","insp_colonia":null,"docket_number":"135781","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:56.000000Z","updated_at":"2025-03-17T19:36:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6038541,"change_date":"2023-08-16 21:39:00","inspection_id":"79420066","insp_unit_id":"196559913","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"TK1980GD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DT2KED17517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:45.000000Z","updated_at":"2025-03-17T22:50:45.000000Z"},{"id":6038542,"change_date":"2023-08-16 21:39:00","inspection_id":"79420066","insp_unit_id":"196559914","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"APPA","insp_unit_company":"1","insp_unit_license":"SP792MWP","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3626NS000982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:45.000000Z","updated_at":"2025-03-17T22:50:45.000000Z"}]},{"id":1706984,"change_date":"2022-11-09 21:40:00","inspection_id":"77096477","dot_number":"3787034","report_state":"TN","report_number":"TFEB000042","insp_date":"2022-11-08 00:00:00","insp_start_time":"1225","insp_end_time":"1317","registration_date":null,"region":"CT","ci_status_code":"C","location":"I-24","location_desc":"I-24 WEST","county_code_state":"TN","county_code":"147","insp_level_id":"1","service_center":"SH","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1610594","transaction_code":"A","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"13919 N MAY AVE 204","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73134","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[{"id":2674993,"change_date":"2022-11-09 21:40:00","inspection_id":"77096477","insp_violation_id":"249517135","seq_no":"2","part_no":"395","part_no_section":"15(b)","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:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"39515B"}],"inspection_per_units":[{"id":2745994,"change_date":"2022-11-09 21:40:00","inspection_id":"77096477","insp_unit_id":"191881577","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"37","insp_unit_license":"TK1980GD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DT2KED17517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"},{"id":2745995,"change_date":"2022-11-09 21:40:00","inspection_id":"77096477","insp_unit_id":"191881578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"SP792MWP","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3626NS000982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":453100,"change_date":"2022-05-22 21:30:00","inspection_id":"75633212","dot_number":"3787034","report_state":"IN","report_number":"5796006571","insp_date":"2022-05-20 00:00:00","insp_start_time":"1200","insp_end_time":"1238","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I69NB","county_code_state":"IN","county_code":"057","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"HAMILTON & SONS LLC","shipping_paper_number":"32141225","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-05-22 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"31000","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":"2130076","transaction_code":"A","transaction_date":"2022-05-22 00:00:00","upload_date":"2022-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":"M","census_search_date":"2022-05-22 21:30:00","snet_input_date":"2022-05-22 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-05-22 21:30:00","insp_carrier_name":"HAMILTON AND SONS LLC","insp_carrier_street":"13919 N MAY AVE 204","insp_carrier_city":"OKLAHOMA CITY","insp_carrier_state":"OK","insp_carrier_zip_code":"73134","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:39.000000Z","updated_at":"2025-03-17T18:35:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":730359,"change_date":"2022-05-22 21:30:00","inspection_id":"75633212","insp_unit_id":"188836917","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TK198OGD","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FT8W3DT2KED17517","insp_unit_decal":"Y","insp_unit_decal_number":"31396368","created_at":"2025-03-17T22:12:42.000000Z","updated_at":"2025-03-17T22:12:42.000000Z"},{"id":730360,"change_date":"2022-05-22 21:30:00","inspection_id":"75633212","insp_unit_id":"188836918","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"SP401LJHA","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"7SGGC3626NS000982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:42.000000Z","updated_at":"2025-03-17T22:12:42.000000Z"}]},{"id":322942,"change_date":"2022-05-04 21:41:00","inspection_id":"75478218","dot_number":"3787034","report_state":"TX","report_number":"6AGA0XDU09","insp_date":"2022-04-27 00:00:00","insp_start_time":"1046","insp_end_time":"1057","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH 45 NORTHBOUND NEW WAVERLY","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33900","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":"8644467","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03787034","upload_search_indicator":null,"census_search_date":"2022-05-04 21:41:00","snet_input_date":"2022-04-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-04 21:41:00","insp_carrier_name":"JESUS SIERRA-RAMIREZ","insp_carrier_street":"273 STOCKADE RANCH RD","insp_carrier_city":"PAIGE","insp_carrier_state":"TX","insp_carrier_zip_code":"78659","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:17.000000Z","updated_at":"2025-03-17T18:33:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":522550,"change_date":"2022-05-04 21:41:00","inspection_id":"75478218","insp_unit_id":"188511775","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1901","insp_unit_license":"PRS6574","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5CJ2KG590961","insp_unit_decal":"Y","insp_unit_decal_number":"31243478","created_at":"2025-03-17T22:11:24.000000Z","updated_at":"2025-03-17T22:11:24.000000Z"},{"id":522551,"change_date":"2022-05-04 21:41:00","inspection_id":"75478218","insp_unit_id":"188511776","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"MCCL","insp_unit_company":"1","insp_unit_license":"109199M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4LYBA1719NH003138","insp_unit_decal":"Y","insp_unit_decal_number":"31243479","created_at":"2025-03-17T22:11:24.000000Z","updated_at":"2025-03-17T22:11:24.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3787034\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3787034\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3787034\/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\/3787034\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}