{"current_page":1,"data":[{"id":12533425,"change_date":"2026-07-23 21:41:00","inspection_id":"88499589","dot_number":"1593500","report_state":"MI","report_number":"BARTT05572","insp_date":"2026-07-23 00:00:00","insp_start_time":"1638","insp_end_time":"1654","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3822946","transaction_code":"A","transaction_date":"2026-07-23 00:00:00","upload_date":"2026-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2026-07-23 21:41:00","snet_input_date":"2026-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-23 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-26T09:42:30.000000Z","updated_at":"2026-07-29T09:37:22.000000Z","inspection_violations":[{"id":21818123,"change_date":"2026-07-23 21:41:00","inspection_id":"88499589","insp_violation_id":"275695764","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-26T10:04:41.000000Z","updated_at":"2026-07-29T09:53:22.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":21764826,"change_date":"2026-07-23 21:41:00","inspection_id":"88499589","insp_unit_id":"214787920","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE09350","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE2SDVL4851","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:27.000000Z","updated_at":"2026-07-29T09:12:40.000000Z"}]},{"id":12298161,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","dot_number":"1593500","report_state":"MI","report_number":"CTPRW00278","insp_date":"2026-06-26 00:00:00","insp_start_time":"1410","insp_end_time":"1448","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"099","insp_level_id":"1","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":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77830","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3632375","transaction_code":"A","transaction_date":"2026-06-27 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2026-06-27 21:41:00","snet_input_date":"2026-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:11.000000Z","updated_at":"2026-07-08T09:30:41.000000Z","inspection_violations":[{"id":21404867,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_violation_id":"275161927","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"214318906","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:16.000000Z","normalized_code":"3963A1BALAC"},{"id":21404868,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_violation_id":"275161928","seq_no":"2","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"214318906","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:16.000000Z","normalized_code":"3963A1BALR"},{"id":21404869,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_violation_id":"275161929","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214318906","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:16.000000Z","normalized_code":"3922SLLSR"},{"id":21404870,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_violation_id":"275161930","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214318906","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:16.000000Z","normalized_code":"39347E"},{"id":21404871,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_violation_id":"275161931","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214318906","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:16.000000Z","normalized_code":"39347E"},{"id":21404872,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_violation_id":"275161932","seq_no":"6","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"214318906","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:16.000000Z","normalized_code":"3963A1BOS"},{"id":21404873,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_violation_id":"275161933","seq_no":"7","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214318907","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:16.000000Z","normalized_code":"3939ALIL"},{"id":21404875,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_violation_id":"275161935","seq_no":"9","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"214318907","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:16.000000Z","normalized_code":"3939ALTSI"},{"id":21404874,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_violation_id":"275161934","seq_no":"8","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"214318907","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:16.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":21361014,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_unit_id":"214318906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"337","insp_unit_license":"BA69519","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMSAARX6H346066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:29.000000Z","updated_at":"2026-07-08T09:01:50.000000Z"},{"id":21361015,"change_date":"2026-06-27 21:41:00","inspection_id":"88255066","insp_unit_id":"214318907","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TOW M","insp_unit_company":"308","insp_unit_license":"E263047","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNUT2029GL161145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:29.000000Z","updated_at":"2026-07-08T09:01:50.000000Z"}]},{"id":12189000,"change_date":"2026-06-15 21:41:00","inspection_id":"88144823","dot_number":"1593500","report_state":"MI","report_number":"BACZM03105","insp_date":"2026-06-15 00:00:00","insp_start_time":"0451","insp_end_time":"0504","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"3543290","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2026-06-15 21:41:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-15 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-18T09:40:57.000000Z","updated_at":"2026-06-26T09:30:43.000000Z","inspection_violations":[{"id":21213548,"change_date":"2026-06-15 21:41:00","inspection_id":"88144823","insp_violation_id":"274912065","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-18T10:00:35.000000Z","updated_at":"2026-06-26T09:41:58.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":21171269,"change_date":"2026-06-15 21:41:00","inspection_id":"88144823","insp_unit_id":"214103828","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BE09414","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4CZC80EF156241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:43.000000Z","updated_at":"2026-06-26T09:01:47.000000Z"}]},{"id":12194019,"change_date":"2026-06-15 21:41:00","inspection_id":"88150123","dot_number":"1593500","report_state":"MI","report_number":"BEAMW04912","insp_date":"2026-06-15 00:00:00","insp_start_time":"1620","insp_end_time":"1636","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","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":"U","pen_cen_match":"I","final_status_date":"2026-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3549670","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2026-06-15 21:41:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-15 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-18T09:41:04.000000Z","updated_at":"2026-06-26T09:31:26.000000Z","inspection_violations":[{"id":21220414,"change_date":"2026-06-15 21:41:00","inspection_id":"88150123","insp_violation_id":"274921719","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-18T10:01:04.000000Z","updated_at":"2026-06-26T09:43:10.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21179668,"change_date":"2026-06-15 21:41:00","inspection_id":"88150123","insp_unit_id":"214113763","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB23513","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXE4FS9GDC48987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:18:00.000000Z","updated_at":"2026-06-26T09:02:52.000000Z"}]},{"id":11973728,"change_date":"2026-05-20 21:41:00","inspection_id":"87910664","dot_number":"1593500","report_state":"MI","report_number":"BARTT05483","insp_date":"2026-05-20 00:00:00","insp_start_time":"1021","insp_end_time":"1043","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"087","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77920","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":"3369682","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2026-05-20 21:41:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:56.000000Z","updated_at":"2026-06-01T09:30:53.000000Z","inspection_violations":[{"id":20829369,"change_date":"2026-05-20 21:41:00","inspection_id":"87910664","insp_violation_id":"274395015","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:06.000000Z","updated_at":"2026-06-01T09:41:38.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":20817644,"change_date":"2026-05-20 21:41:00","inspection_id":"87910664","insp_unit_id":"213665959","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE09350","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE2SDVL4851","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:27.000000Z","updated_at":"2026-06-01T09:03:12.000000Z"},{"id":20817645,"change_date":"2026-05-20 21:41:00","inspection_id":"87910664","insp_unit_id":"213665960","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"E606962","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3525M9002941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:27.000000Z","updated_at":"2026-06-01T09:03:12.000000Z"}]},{"id":11631826,"change_date":"2026-04-13 21:38:00","inspection_id":"87560527","dot_number":"1593500","report_state":"MI","report_number":"FRIZS03502","insp_date":"2026-04-09 00:00:00","insp_start_time":"1405","insp_end_time":"1418","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W ISABELLA RD @ 5 MILE RD","county_code_state":"MI","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1265347","transaction_code":"A","transaction_date":"2026-04-09 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2026-04-13 21:38:00","snet_input_date":"2026-04-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-13 21:38:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-24T09:30:59.000000Z","updated_at":"2026-04-24T09:30:59.000000Z","inspection_violations":[{"id":20188651,"change_date":"2026-04-13 21:38:00","inspection_id":"87560527","insp_violation_id":"273563758","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:43:02.000000Z","updated_at":"2026-04-24T09:43:02.000000Z","normalized_code":"39216AD"},{"id":20188652,"change_date":"2026-04-13 21:38:00","inspection_id":"87560527","insp_violation_id":"273563759","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":"X4663576","created_at":"2026-04-24T09:43:02.000000Z","updated_at":"2026-04-24T09:43:02.000000Z","normalized_code":"39141APC"},{"id":20188653,"change_date":"2026-04-13 21:38:00","inspection_id":"87560527","insp_violation_id":"273563760","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:43:02.000000Z","updated_at":"2026-04-24T09:43:02.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":20231943,"change_date":"2026-04-13 21:38:00","inspection_id":"87560527","insp_unit_id":"212986584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"498","insp_unit_license":"BD36209","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4WRE78PF187123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:03:35.000000Z","updated_at":"2026-04-24T09:03:35.000000Z"}]},{"id":11554814,"change_date":"2026-04-02 21:39:00","inspection_id":"87477914","dot_number":"1593500","report_state":"MI","report_number":"FALAS00624","insp_date":"2026-04-01 00:00:00","insp_start_time":"1715","insp_end_time":"1730","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ MM 115","county_code_state":"MI","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"37310","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":"1264765","transaction_code":"A","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-04-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-05T09:57:00.000000Z","updated_at":"2026-04-13T09:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19801817,"change_date":"2026-04-02 21:39:00","inspection_id":"87477914","insp_unit_id":"212506290","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"476D","insp_unit_license":"BD50017","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HNXNDA07501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:19.000000Z","updated_at":"2026-04-13T09:04:31.000000Z"},{"id":19801818,"change_date":"2026-04-02 21:39:00","inspection_id":"87477914","insp_unit_id":"212506291","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"T-14D","insp_unit_license":"F388437","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2424KL163189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:19.000000Z","updated_at":"2026-04-13T09:04:31.000000Z"}]},{"id":11501212,"change_date":"2026-03-27 21:40:00","inspection_id":"87421320","dot_number":"1593500","report_state":"MI","report_number":"MCKEN00329","insp_date":"2026-03-27 00:00:00","insp_start_time":"0850","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DOVER RD","county_code_state":"MI","county_code":"035","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77920","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":"1264155","transaction_code":"A","transaction_date":"2026-03-27 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:44.000000Z","updated_at":"2026-04-07T09:32:29.000000Z","inspection_violations":[{"id":19420554,"change_date":"2026-03-27 21:40:00","inspection_id":"87421320","insp_violation_id":"272692440","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"212384690","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:07.000000Z","updated_at":"2026-04-07T09:48:47.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":19703076,"change_date":"2026-03-27 21:40:00","inspection_id":"87421320","insp_unit_id":"212384689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"468","insp_unit_license":"BC97902","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE5NDNC5464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:53.000000Z"},{"id":19703077,"change_date":"2026-03-27 21:40:00","inspection_id":"87421320","insp_unit_id":"212384690","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"T64","insp_unit_license":"D290165","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA3120G1001538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:53.000000Z"}]},{"id":11500993,"change_date":"2026-03-27 21:40:00","inspection_id":"87421086","dot_number":"1593500","report_state":"MI","report_number":"SAMOK01771","insp_date":"2026-03-26 00:00:00","insp_start_time":"1525","insp_end_time":"1540","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB","county_code_state":"MI","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37310","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":"1264323","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:44.000000Z","updated_at":"2026-04-07T09:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19702684,"change_date":"2026-03-27 21:40:00","inspection_id":"87421086","insp_unit_id":"212384259","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD50017","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HNXNDA07501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:49.000000Z"},{"id":19702685,"change_date":"2026-03-27 21:40:00","inspection_id":"87421086","insp_unit_id":"212384260","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"F388437","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2424KL163189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:49.000000Z"}]},{"id":10438456,"change_date":"2025-12-15 21:39:00","inspection_id":"86570451","dot_number":"1593500","report_state":"MI","report_number":"CELMS01566","insp_date":"2025-12-12 00:00:00","insp_start_time":"1615","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N I-75 @ M-59","county_code_state":"MI","county_code":"125","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":"N","pen_cen_match":null,"final_status_date":"2025-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"10001","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":"1253737","transaction_code":"A","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-12-15 21:39:00","snet_input_date":"2025-12-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-15 21:39:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:42.000000Z","updated_at":"2025-12-26T10:30:55.000000Z","inspection_violations":[{"id":17505081,"change_date":"2025-12-15 21:39:00","inspection_id":"86570451","insp_violation_id":"270689931","seq_no":"1","part_no":"392","part_no_section":"82DUMT","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-12-18T10:30:56.000000Z","updated_at":"2025-12-26T10:31:37.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":17462674,"change_date":"2025-12-15 21:39:00","inspection_id":"86570451","insp_unit_id":"210614109","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BD41377","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4WREY8PF231260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:36.000000Z","updated_at":"2025-12-26T10:01:03.000000Z"}]},{"id":10200893,"change_date":"2025-12-04 21:38:00","inspection_id":"86321750","dot_number":"1593500","report_state":"MI","report_number":"ESCOT03169","insp_date":"2025-11-13 00:00:00","insp_start_time":"0615","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W M-59@CROOKS RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2025-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1250642","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:29.000000Z","updated_at":"2025-12-08T10:30:33.000000Z","inspection_violations":[{"id":17320346,"change_date":"2025-12-04 21:38:00","inspection_id":"86321750","insp_violation_id":"270460974","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"210413510","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:59.000000Z","normalized_code":"39345B2BAIR"},{"id":17320347,"change_date":"2025-12-04 21:38:00","inspection_id":"86321750","insp_violation_id":"270460975","seq_no":"2","part_no":"393","part_no_section":"28-WS-6","insp_viol_unit":"1","insp_unit_id":"210413510","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:59.000000Z","normalized_code":"39328WS6"},{"id":17320348,"change_date":"2025-12-04 21:38:00","inspection_id":"86321750","insp_violation_id":"270460976","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"210413511","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:59.000000Z","normalized_code":"39617CPI"},{"id":17320349,"change_date":"2025-12-04 21:38:00","inspection_id":"86321750","insp_violation_id":"270460977","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"210413511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:59.000000Z","normalized_code":"3939ALIL"},{"id":17320350,"change_date":"2025-12-04 21:38:00","inspection_id":"86321750","insp_violation_id":"270460978","seq_no":"5","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"210413511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:59.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":17290428,"change_date":"2025-12-04 21:38:00","inspection_id":"86321750","insp_unit_id":"210413510","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"504S","insp_unit_license":"BD50032","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFE0RHUV3884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:41.000000Z"},{"id":17290429,"change_date":"2025-12-04 21:38:00","inspection_id":"86321750","insp_unit_id":"210413511","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"E767502","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3520P1011467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:41.000000Z"}]},{"id":10083424,"change_date":"2025-10-30 21:43:00","inspection_id":"86198137","dot_number":"1593500","report_state":"MI","report_number":"PENNJ01181","insp_date":"2025-10-29 00:00:00","insp_start_time":"1020","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EXTREME CLEAN ST LOUIS","county_code_state":"MI","county_code":"057","insp_level_id":"1","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":"2025-10-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1248609","transaction_code":"A","transaction_date":"2025-10-29 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-10-30 21:43:00","snet_input_date":"2025-10-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-30 21:43:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:23.000000Z","updated_at":"2025-11-03T11:04:11.000000Z","inspection_violations":[{"id":16699170,"change_date":"2025-10-30 21:43:00","inspection_id":"86198137","insp_violation_id":"269627937","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"209751380","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:18:09.000000Z","updated_at":"2025-11-03T11:16:49.000000Z","normalized_code":"3939ALCL"},{"id":16699171,"change_date":"2025-10-30 21:43:00","inspection_id":"86198137","insp_violation_id":"269627938","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"209751380","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:18:09.000000Z","updated_at":"2025-11-03T11:16:49.000000Z","normalized_code":"3922SLLSIV"},{"id":16699172,"change_date":"2025-10-30 21:43:00","inspection_id":"86198137","insp_violation_id":"269627939","seq_no":"3","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"209751381","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4556798","created_at":"2025-11-02T11:18:09.000000Z","updated_at":"2025-11-03T11:16:49.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":16762185,"change_date":"2025-10-30 21:43:00","inspection_id":"86198137","insp_unit_id":"209751380","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"476D","insp_unit_license":"BD50017","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HNXNDA07501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:38.000000Z","updated_at":"2025-11-03T10:46:45.000000Z"},{"id":16762186,"change_date":"2025-10-30 21:43:00","inspection_id":"86198137","insp_unit_id":"209751381","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BBTM","insp_unit_company":null,"insp_unit_license":"E658453","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4L5ST2723NF060758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:38.000000Z","updated_at":"2025-11-03T10:46:45.000000Z"}]},{"id":10019303,"change_date":"2025-11-12 21:41:00","inspection_id":"86130464","dot_number":"1593500","report_state":"MI","report_number":"BACZM02883","insp_date":"2025-10-23 00:00:00","insp_start_time":"0724","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","pen_cen_match":null,"final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1247035","transaction_code":"C","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:54.000000Z","updated_at":"2025-11-16T10:30:47.000000Z","inspection_violations":[{"id":16900900,"change_date":"2025-11-12 21:41:00","inspection_id":"86130464","insp_violation_id":"269895695","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"209979621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:59.000000Z","updated_at":"2025-11-16T10:31:21.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":16949055,"change_date":"2025-11-12 21:41:00","inspection_id":"86130464","insp_unit_id":"209979621","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD93236","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMAAN17H443441","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:34.000000Z","updated_at":"2025-11-16T10:00:56.000000Z"}]},{"id":9972088,"change_date":"2025-10-17 21:39:00","inspection_id":"86080780","dot_number":"1593500","report_state":"MI","report_number":"MALOK00359","insp_date":"2025-10-16 00:00:00","insp_start_time":"0750","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 S\/B @ BIG BEAVER RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SC","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":"N","pen_cen_match":null,"final_status_date":"2025-10-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"1246584","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:55.000000Z","updated_at":"2025-10-21T10:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16557719,"change_date":"2025-10-17 21:39:00","inspection_id":"86080780","insp_unit_id":"209529155","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB23513","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXE4FS9GDC48987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:06.000000Z","updated_at":"2025-10-21T09:46:10.000000Z"}]},{"id":9911236,"change_date":"2025-10-22 21:39:00","inspection_id":"86016127","dot_number":"1593500","report_state":"MI","report_number":"NEGUB02899","insp_date":"2025-10-09 00:00:00","insp_start_time":"0850","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":"145","location_desc":"CAMBRIDGE SCALES","county_code_state":"MI","county_code":"091","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2025-10-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","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":"1245599","transaction_code":"C","transaction_date":"2025-10-09 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-10-10 21:40:00","snet_input_date":"2025-10-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-10 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-13T10:02:09.000000Z","updated_at":"2025-10-26T10:00:22.000000Z","inspection_violations":[{"id":16535186,"change_date":"2025-10-22 21:39:00","inspection_id":"86016127","insp_violation_id":"269452698","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209601581","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4600574","created_at":"2025-10-25T10:17:06.000000Z","updated_at":"2025-10-26T10:15:33.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16614309,"change_date":"2025-10-22 21:39:00","inspection_id":"86016127","insp_unit_id":"209601581","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"440D","insp_unit_license":"BC51992","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXDT4EDFM1728","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:39.000000Z","updated_at":"2025-10-26T09:45:24.000000Z"},{"id":16614310,"change_date":"2025-10-22 21:39:00","inspection_id":"86016127","insp_unit_id":"209601582","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":"T350","insp_unit_license":"E086747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3222K1003271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:39.000000Z","updated_at":"2025-10-26T09:45:24.000000Z"}]},{"id":9888609,"change_date":"2025-10-08 21:40:00","inspection_id":"85992489","dot_number":"1593500","report_state":"MI","report_number":"HOLLM04608","insp_date":"2025-10-07 00:00:00","insp_start_time":"0755","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S US 127 @ SOUTH ST","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"41830","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":"1245275","transaction_code":"A","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-10-08 21:40:00","snet_input_date":"2025-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:49.000000Z","updated_at":"2025-10-12T10:01:06.000000Z","inspection_violations":[{"id":16304727,"change_date":"2025-10-08 21:40:00","inspection_id":"85992489","insp_violation_id":"269178501","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"209365677","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:06.000000Z","updated_at":"2025-10-12T10:16:21.000000Z","normalized_code":"3939ALRLI"},{"id":16304728,"change_date":"2025-10-08 21:40:00","inspection_id":"85992489","insp_violation_id":"269178502","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"209365677","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:06.000000Z","updated_at":"2025-10-12T10:16:21.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":16406986,"change_date":"2025-10-08 21:40:00","inspection_id":"85992489","insp_unit_id":"209365676","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC12403","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMKAANX6H257000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:25.000000Z"},{"id":16406987,"change_date":"2025-10-08 21:40:00","inspection_id":"85992489","insp_unit_id":"209365677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E967784","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2425JL162213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:25.000000Z"}]},{"id":9850584,"change_date":"2025-10-03 21:40:00","inspection_id":"85952370","dot_number":"1593500","report_state":"MI","report_number":"NEGUB02882","insp_date":"2025-10-02 00:00:00","insp_start_time":"0825","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":"145","location_desc":"CAMBRIDGE SCALE","county_code_state":"MI","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","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":"N","pen_cen_match":null,"final_status_date":"2025-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1244708","transaction_code":"A","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-10-03 21:40:00","snet_input_date":"2025-10-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-03 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-05T10:02:24.000000Z","updated_at":"2025-10-08T10:01:03.000000Z","inspection_violations":[{"id":16222924,"change_date":"2025-10-03 21:40:00","inspection_id":"85952370","insp_violation_id":"269085216","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209289216","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:18:17.000000Z","updated_at":"2025-10-08T10:16:42.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":16336593,"change_date":"2025-10-03 21:40:00","inspection_id":"85952370","insp_unit_id":"209289216","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"W80004","insp_unit_license":"BE22386","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X9SM382968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:16.000000Z","updated_at":"2025-10-08T09:46:16.000000Z"}]},{"id":9216944,"change_date":"2025-07-22 21:42:00","inspection_id":"85286886","dot_number":"1593500","report_state":"MI","report_number":"BEAMW04432","insp_date":"2025-07-22 00:00:00","insp_start_time":"0455","insp_end_time":"0510","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"75 S @ BUSCH","county_code_state":"MI","county_code":"145","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-22 21:42: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":"1231527","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-25T10:46:01.000000Z","updated_at":"2025-07-27T10:41:02.000000Z","inspection_violations":[{"id":14907637,"change_date":"2025-07-22 21:42:00","inspection_id":"85286886","insp_violation_id":"267573608","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","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-07-25T10:47:41.000000Z","updated_at":"2025-07-26T10:42:50.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":15158123,"change_date":"2025-07-22 21:42:00","inspection_id":"85286886","insp_unit_id":"208014017","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BC90333","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4WREY8MF246000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:07.000000Z"}]},{"id":9124110,"change_date":"2025-07-11 21:39:00","inspection_id":"85189491","dot_number":"1593500","report_state":"MI","report_number":"PEASS02965","insp_date":"2025-07-09 00:00:00","insp_start_time":"1445","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ BAY CITY REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1230055","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:05.000000Z","updated_at":"2025-07-16T10:44:47.000000Z","inspection_violations":[{"id":14709926,"change_date":"2025-07-11 21:39:00","inspection_id":"85189491","insp_violation_id":"267348577","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"207822674","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:49.000000Z","updated_at":"2025-07-16T10:46:07.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":14980503,"change_date":"2025-07-11 21:39:00","inspection_id":"85189491","insp_unit_id":"207822674","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"468D","insp_unit_license":"BC97902","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE5NDNC5464","insp_unit_decal":"Y","insp_unit_decal_number":"35455500","created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:51.000000Z"}]},{"id":8982316,"change_date":"2025-06-25 21:40:00","inspection_id":"85040189","dot_number":"1593500","report_state":"MI","report_number":"DEJOS01707","insp_date":"2025-06-24 00:00:00","insp_start_time":"1445","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 E\/B @ CONCORD RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","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":"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-06-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","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":"1227219","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-06-25 21:40:00","snet_input_date":"2025-06-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-25 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:01:08.000000Z","updated_at":"2025-06-30T10:00:36.000000Z","inspection_violations":[{"id":14439106,"change_date":"2025-06-25 21:40:00","inspection_id":"85040189","insp_violation_id":"267038682","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:17:01.000000Z","updated_at":"2025-06-29T10:16:02.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":14728452,"change_date":"2025-06-25 21:40:00","inspection_id":"85040189","insp_unit_id":"207549127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BE29734","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3FRXF75X04V684706","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:15.000000Z","updated_at":"2025-06-29T09:45:55.000000Z"}]},{"id":8963225,"change_date":"2025-06-23 21:41:00","inspection_id":"85020058","dot_number":"1593500","report_state":"MI","report_number":"NESBA02165","insp_date":"2025-06-18 00:00:00","insp_start_time":"1710","insp_end_time":"1730","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"W M-59@ N I-75","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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":"33000","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":"1226440","transaction_code":"A","transaction_date":"2025-06-18 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-06-28T10:00:37.000000Z","inspection_violations":[{"id":14396343,"change_date":"2025-06-23 21:41:00","inspection_id":"85020058","insp_violation_id":"266989417","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"207510672","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:58.000000Z","normalized_code":"3922SLLMF"},{"id":14396344,"change_date":"2025-06-23 21:41:00","inspection_id":"85020058","insp_violation_id":"266989418","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207510672","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:58.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":14693455,"change_date":"2025-06-23 21:41:00","inspection_id":"85020058","insp_unit_id":"207510672","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"538D","insp_unit_license":"BE09351","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE0SDVL4850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:12.000000Z"}]},{"id":8702656,"change_date":"2025-05-21 21:42:00","inspection_id":"84743650","dot_number":"1593500","report_state":"MI","report_number":"MALIK03026","insp_date":"2025-05-21 00:00:00","insp_start_time":"0805","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1222349","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:25.000000Z","updated_at":"2025-05-25T10:06:38.000000Z","inspection_violations":[{"id":13871182,"change_date":"2025-05-21 21:42:00","inspection_id":"84743650","insp_violation_id":"266382167","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:27:59.000000Z","updated_at":"2025-05-25T10:25:10.000000Z","normalized_code":"3922SLLS2"},{"id":13871183,"change_date":"2025-05-21 21:42:00","inspection_id":"84743650","insp_violation_id":"266382168","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","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":"2025-05-24T10:27:59.000000Z","updated_at":"2025-05-25T10:25:10.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":14221307,"change_date":"2025-05-21 21:42:00","inspection_id":"84743650","insp_unit_id":"206993098","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"550","insp_unit_license":"BE09536","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4YSE78RF282883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:18.000000Z"}]},{"id":8558888,"change_date":"2025-05-06 21:40:00","inspection_id":"84592341","dot_number":"1593500","report_state":"MI","report_number":"SAMOK01236","insp_date":"2025-05-05 00:00:00","insp_start_time":"1905","insp_end_time":"1915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB","county_code_state":"MI","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-06 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":"1220174","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-05-06 21:40:00","snet_input_date":"2025-05-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-06 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-09T10:26:05.000000Z","updated_at":"2025-05-10T10:51:50.000000Z","inspection_violations":[{"id":13566705,"change_date":"2025-05-06 21:40:00","inspection_id":"84592341","insp_violation_id":"266033370","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:57:19.000000Z","updated_at":"2025-05-09T11:04:59.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":13921350,"change_date":"2025-05-06 21:40:00","inspection_id":"84592341","insp_unit_id":"206665060","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BD50200","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4WREY0PF231138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:13:57.000000Z","updated_at":"2025-05-10T10:01:49.000000Z"}]},{"id":8468623,"change_date":"2025-04-25 21:36:00","inspection_id":"84497177","dot_number":"1593500","report_state":"MI","report_number":"JURKV02987","insp_date":"2025-04-25 00:00:00","insp_start_time":"0750","insp_end_time":"0841","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-25 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1219244","transaction_code":"A","transaction_date":"2025-04-25 00:00:00","upload_date":"2025-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-04-25 21:36:00","snet_input_date":"2025-04-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-25 21:36:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-28T10:14:20.000000Z","updated_at":"2025-04-29T10:02:35.000000Z","inspection_violations":[{"id":13387217,"change_date":"2025-04-25 21:36:00","inspection_id":"84497177","insp_violation_id":"265829132","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"206490050","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4507494","created_at":"2025-04-28T10:35:51.000000Z","updated_at":"2025-04-29T10:23:46.000000Z","normalized_code":"3922SLLEWG3"},{"id":13387218,"change_date":"2025-04-25 21:36:00","inspection_id":"84497177","insp_violation_id":"265829133","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"206490050","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-28T10:35:51.000000Z","updated_at":"2025-04-29T10:23:46.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":13759362,"change_date":"2025-04-25 21:36:00","inspection_id":"84497177","insp_unit_id":"206490050","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"V7","insp_unit_license":"BD85358","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2GR4GC2LM017418","insp_unit_decal":"Y","insp_unit_decal_number":"35168147","created_at":"2025-04-28T10:04:44.000000Z","updated_at":"2025-04-29T09:56:30.000000Z"}]},{"id":8277416,"change_date":"2025-04-02 21:41:00","inspection_id":"84295856","dot_number":"1593500","report_state":"MI","report_number":"SAMOK01157","insp_date":"2025-04-01 00:00:00","insp_start_time":"1625","insp_end_time":"1640","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB","county_code_state":"MI","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27700","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":"1215878","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-04-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[{"id":13009080,"change_date":"2025-04-02 21:41:00","inspection_id":"84295856","insp_violation_id":"265402864","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","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-04-04T11:08:58.000000Z","updated_at":"2025-04-05T10:43:33.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":13398802,"change_date":"2025-04-02 21:41:00","inspection_id":"84295856","insp_unit_id":"206122504","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BC70319","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4YSEY6MF134944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:01:02.000000Z"},{"id":13398803,"change_date":"2025-04-02 21:41:00","inspection_id":"84295856","insp_unit_id":"206122505","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FEELI","insp_unit_company":null,"insp_unit_license":"E049655","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTBE2224L2000635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:01:02.000000Z"}]},{"id":8227701,"change_date":"2025-03-27 21:41:00","inspection_id":"84243379","dot_number":"1593500","report_state":"MI","report_number":"RICKE00527","insp_date":"2025-03-26 00:00:00","insp_start_time":"0900","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W\/B M-115 & 14 MILE RD","county_code_state":"MI","county_code":"133","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11150","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":"1214982","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-03-27 21:41:00","snet_input_date":"2025-03-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-27 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:35.000000Z","updated_at":"2025-03-31T10:30:32.000000Z","inspection_violations":[{"id":12909022,"change_date":"2025-03-27 21:41:00","inspection_id":"84243379","insp_violation_id":"265290390","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4506145","created_at":"2025-03-29T10:51:03.000000Z","updated_at":"2025-03-31T10:51:34.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":13309109,"change_date":"2025-03-27 21:41:00","inspection_id":"84243379","insp_unit_id":"206026114","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"DD41744","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC4YLEY4LF274197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:25:05.000000Z","updated_at":"2025-03-31T10:05:06.000000Z"}]},{"id":8168682,"change_date":"2025-03-20 21:42:00","inspection_id":"84181272","dot_number":"1593500","report_state":"MI","report_number":"MALIK02896","insp_date":"2025-03-19 00:00:00","insp_start_time":"1455","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B M-59 @ ROCHESTER RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","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":"1214042","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2025-03-20 21:42:00","snet_input_date":"2025-03-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-20 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-23T10:52:26.000000Z","updated_at":"2025-03-24T10:26:12.000000Z","inspection_violations":[{"id":12797454,"change_date":"2025-03-20 21:42:00","inspection_id":"84181272","insp_violation_id":"265161814","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:09:07.000000Z","updated_at":"2025-03-23T11:41:28.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":13202417,"change_date":"2025-03-20 21:42:00","inspection_id":"84181272","insp_unit_id":"205908909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NONE","insp_unit_license":"BD50055","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFE4RHUV3886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:16:28.000000Z","updated_at":"2025-03-24T10:05:20.000000Z"},{"id":13202418,"change_date":"2025-03-20 21:42:00","inspection_id":"84181272","insp_unit_id":"205908910","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":"NONE","insp_unit_license":"E307445","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3328M1000019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:16:28.000000Z","updated_at":"2025-03-24T10:05:20.000000Z"}]},{"id":7340409,"change_date":"2024-12-04 21:41:00","inspection_id":"83311057","dot_number":"1593500","report_state":"MI","report_number":"PENNJ01023","insp_date":"2024-12-03 00:00:00","insp_start_time":"1350","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-46 @ OSBORN RD","county_code_state":"MI","county_code":"057","insp_level_id":"2","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-12-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62500","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":"1203346","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-12-04 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-04 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[{"id":11475532,"change_date":"2024-12-04 21:41:00","inspection_id":"83311057","insp_violation_id":"263230080","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"204182383","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11841133,"change_date":"2024-12-04 21:41:00","inspection_id":"83311057","insp_unit_id":"204182382","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD00653","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXCY1EDFK6083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"},{"id":11841134,"change_date":"2024-12-04 21:41:00","inspection_id":"83311057","insp_unit_id":"204182383","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E921372","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3520P1011470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":6933770,"change_date":"2024-10-10 21:42:00","inspection_id":"82880459","dot_number":"1593500","report_state":"MI","report_number":"WARRJ02695","insp_date":"2024-10-10 00:00:00","insp_start_time":"1015","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/A\/C","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1197922","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-10-10 21:42:00","snet_input_date":"2024-10-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-10 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:40.000000Z","updated_at":"2025-03-17T20:40:40.000000Z","inspection_violations":[{"id":10807807,"change_date":"2024-10-10 21:42:00","inspection_id":"82880459","insp_violation_id":"262292183","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11182797,"change_date":"2024-10-10 21:42:00","inspection_id":"82880459","insp_unit_id":"203359527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"468D","insp_unit_license":"BC97902","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE5NDNC5464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:48.000000Z","updated_at":"2025-03-17T23:38:48.000000Z"},{"id":11182798,"change_date":"2024-10-10 21:42:00","inspection_id":"82880459","insp_unit_id":"203359528","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"D071423","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5TFA3021E1003233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:48.000000Z","updated_at":"2025-03-17T23:38:48.000000Z"}]},{"id":6737067,"change_date":"2024-09-16 21:43:00","inspection_id":"82671004","dot_number":"1593500","report_state":"MI","report_number":"PEASS02854","insp_date":"2024-09-16 00:00:00","insp_start_time":"0705","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","pen_cen_match":null,"final_status_date":"2024-09-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1195149","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-09-16 21:43:00","snet_input_date":"2024-09-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-16 21:43:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:33.000000Z","updated_at":"2025-03-17T20:36:33.000000Z","inspection_violations":[{"id":10489254,"change_date":"2024-09-16 21:43:00","inspection_id":"82671004","insp_violation_id":"261827235","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202946681","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"3939A"},{"id":10489255,"change_date":"2024-09-16 21:43:00","inspection_id":"82671004","insp_violation_id":"261827236","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202946681","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":10863521,"change_date":"2024-09-16 21:43:00","inspection_id":"82671004","insp_unit_id":"202946681","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"V7","insp_unit_license":"BD85358","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2GR4GC2LM017418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:31.000000Z","updated_at":"2025-03-17T23:35:31.000000Z"}]},{"id":6658497,"change_date":"2024-09-17 21:45:00","inspection_id":"82587498","dot_number":"1593500","report_state":"MI","report_number":"PATTM04770","insp_date":"2024-09-04 00:00:00","insp_start_time":"1325","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"27200","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1193646","transaction_code":"C","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:54.000000Z","updated_at":"2025-03-17T20:34:54.000000Z","inspection_violations":[{"id":10361114,"change_date":"2024-09-17 21:45:00","inspection_id":"82587498","insp_violation_id":"261869730","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:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3922"},{"id":10361115,"change_date":"2024-09-17 21:45:00","inspection_id":"82587498","insp_violation_id":"261869731","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"39141A"},{"id":10361116,"change_date":"2024-09-17 21:45:00","inspection_id":"82587498","insp_violation_id":"261869732","seq_no":"3","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:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":10735374,"change_date":"2024-09-17 21:45:00","inspection_id":"82587498","insp_unit_id":"202983753","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BC56154","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4YSEYXLF291780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"},{"id":10735375,"change_date":"2024-09-17 21:45:00","inspection_id":"82587498","insp_unit_id":"202983754","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BBCB","insp_unit_company":null,"insp_unit_license":"E658453","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4L5ST2723NF060758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"}]},{"id":6357496,"change_date":"2024-09-17 21:45:00","inspection_id":"82266359","dot_number":"1593500","report_state":"MI","report_number":"BACZM02424","insp_date":"2024-07-29 00:00:00","insp_start_time":"1622","insp_end_time":"1700","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","pen_cen_match":null,"final_status_date":"2024-07-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","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":"1188357","transaction_code":"C","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-07-31 21:43:00","snet_input_date":"2024-07-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:44.000000Z","updated_at":"2025-03-17T20:28:44.000000Z","inspection_violations":[{"id":9870301,"change_date":"2024-09-17 21:45:00","inspection_id":"82266359","insp_violation_id":"261857195","seq_no":"1","part_no":"392","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"202973753","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":10245159,"change_date":"2024-09-17 21:45:00","inspection_id":"82266359","insp_unit_id":"202973752","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5055","insp_unit_license":"BD50031","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFE8RHUV3888","insp_unit_decal":"Y","insp_unit_decal_number":"34301464","created_at":"2025-03-17T23:29:09.000000Z","updated_at":"2025-03-17T23:29:09.000000Z"},{"id":10245160,"change_date":"2024-09-17 21:45:00","inspection_id":"82266359","insp_unit_id":"202973753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"376","insp_unit_license":"E607037","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3321N1009047","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:09.000000Z","updated_at":"2025-03-17T23:29:09.000000Z"}]},{"id":5656628,"change_date":"2024-05-02 21:43:00","inspection_id":"81509655","dot_number":"1593500","report_state":"MI","report_number":"BARTT04360","insp_date":"2024-05-01 00:00:00","insp_start_time":"0835","insp_end_time":"0854","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@RILEY CENTER","county_code_state":"MI","county_code":"147","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":"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":"16000","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":"1176737","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":"01593500","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":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:45.000000Z","updated_at":"2025-03-17T20:14:45.000000Z","inspection_violations":[{"id":8749564,"change_date":"2024-05-02 21:43:00","inspection_id":"81509655","insp_violation_id":"259284804","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:19.000000Z","updated_at":"2025-03-17T21:48:19.000000Z","normalized_code":"39141A"},{"id":8749565,"change_date":"2024-05-02 21:43:00","inspection_id":"81509655","insp_violation_id":"259284805","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":9111025,"change_date":"2024-05-02 21:43:00","inspection_id":"81509655","insp_unit_id":"200700743","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"0","insp_unit_license":"BC41697","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDTF4GT8KDA18238","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":5576072,"change_date":"2024-04-23 21:41:00","inspection_id":"81421884","dot_number":"1593500","report_state":"MI","report_number":"MYERD01089","insp_date":"2024-04-22 00:00:00","insp_start_time":"0735","insp_end_time":"0759","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CEDAR ST @ AURELIUS RD","county_code_state":"MI","county_code":"065","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"90630","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":"1174977","transaction_code":"A","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[{"id":8618146,"change_date":"2024-04-23 21:41:00","inspection_id":"81421884","insp_violation_id":"259082584","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:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8982061,"change_date":"2024-04-23 21:41:00","inspection_id":"81421884","insp_unit_id":"200530580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD63879","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYFE3RDUR8828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"},{"id":8982062,"change_date":"2024-04-23 21:41:00","inspection_id":"81421884","insp_unit_id":"200530581","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E988645","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2828KL162735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"}]},{"id":5460474,"change_date":"2024-04-08 21:44:00","inspection_id":"81295650","dot_number":"1593500","report_state":"MI","report_number":"KOCHJ01515","insp_date":"2024-04-05 00:00:00","insp_start_time":"0715","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ US-10","county_code_state":"MI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-08 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1172405","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-04-08 21:44:00","snet_input_date":"2024-04-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-08 21:44:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:07.000000Z","updated_at":"2025-03-17T20:11:07.000000Z","inspection_violations":[{"id":8428904,"change_date":"2024-04-08 21:44:00","inspection_id":"81295650","insp_violation_id":"258804522","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"39141A"},{"id":8428905,"change_date":"2024-04-08 21:44:00","inspection_id":"81295650","insp_violation_id":"258804523","seq_no":"2","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:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"3922"},{"id":8428906,"change_date":"2024-04-08 21:44:00","inspection_id":"81295650","insp_violation_id":"258804524","seq_no":"3","part_no":"399","part_no_section":"207","insp_viol_unit":"1","insp_unit_id":"200289987","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"399207"},{"id":8428907,"change_date":"2024-04-08 21:44:00","inspection_id":"81295650","insp_violation_id":"258804525","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200289988","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"3922"},{"id":8428908,"change_date":"2024-04-08 21:44:00","inspection_id":"81295650","insp_violation_id":"258804526","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200289988","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4348706","created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8795636,"change_date":"2024-04-08 21:44:00","inspection_id":"81295650","insp_unit_id":"200289987","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"376","insp_unit_license":"BB62999","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMAAN6DH157399","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:49.000000Z","updated_at":"2025-03-17T23:14:49.000000Z"},{"id":8795637,"change_date":"2024-04-08 21:44:00","inspection_id":"81295650","insp_unit_id":"200289988","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"T366","insp_unit_license":"D809654","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3222K1000015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:49.000000Z","updated_at":"2025-03-17T23:14:49.000000Z"}]},{"id":5339094,"change_date":"2024-03-21 21:41:00","inspection_id":"81163381","dot_number":"1593500","report_state":"MI","report_number":"MOREM05123","insp_date":"2024-03-20 00:00:00","insp_start_time":"1518","insp_end_time":"1540","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MILLETT HWY","county_code_state":"MI","county_code":"045","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","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":"1170138","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-03-21 21:41:00","snet_input_date":"2024-03-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:20.000000Z","updated_at":"2025-03-17T20:08:20.000000Z","inspection_violations":[{"id":8238632,"change_date":"2024-03-21 21:41:00","inspection_id":"81163381","insp_violation_id":"258514808","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:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8598411,"change_date":"2024-03-21 21:41:00","inspection_id":"81163381","insp_unit_id":"200026429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"467D","insp_unit_license":"BC97903","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE3NDNC5463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:58.000000Z","updated_at":"2025-03-17T23:12:58.000000Z"},{"id":8598412,"change_date":"2024-03-21 21:41:00","inspection_id":"81163381","insp_unit_id":"200026430","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"52","insp_unit_license":"D009135","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA3021E1003202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:58.000000Z","updated_at":"2025-03-17T23:12:58.000000Z"}]},{"id":5331244,"change_date":"2024-03-20 21:43:00","inspection_id":"81154762","dot_number":"1593500","report_state":"MI","report_number":"JURKV02516","insp_date":"2024-03-19 00:00:00","insp_start_time":"0800","insp_end_time":"0847","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LINWOOD REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1169762","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-03-20 21:43:00","snet_input_date":"2024-03-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-20 21:43:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:17.000000Z","updated_at":"2025-03-17T20:08:17.000000Z","inspection_violations":[{"id":8224911,"change_date":"2024-03-20 21:43:00","inspection_id":"81154762","insp_violation_id":"258493579","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200009378","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3922"},{"id":8224912,"change_date":"2024-03-20 21:43:00","inspection_id":"81154762","insp_violation_id":"258493580","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200009378","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8585586,"change_date":"2024-03-20 21:43:00","inspection_id":"81154762","insp_unit_id":"200009378","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC80718","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2GR4GC2LM017418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:53.000000Z","updated_at":"2025-03-17T23:12:53.000000Z"}]},{"id":5189692,"change_date":"2024-03-01 21:40:00","inspection_id":"81000094","dot_number":"1593500","report_state":"MI","report_number":"BEAMW03665","insp_date":"2024-02-29 00:00:00","insp_start_time":"1650","insp_end_time":"1704","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 N @ CURTIS","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NO BOL","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-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"1167263","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-03-01 21:40:00","snet_input_date":"2024-02-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-01 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[{"id":7998064,"change_date":"2024-03-01 21:40:00","inspection_id":"81000094","insp_violation_id":"258154144","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"},{"id":7998065,"change_date":"2024-03-01 21:40:00","inspection_id":"81000094","insp_violation_id":"258154145","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"199711293","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":8356251,"change_date":"2024-03-01 21:40:00","inspection_id":"81000094","insp_unit_id":"199711292","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"366","insp_unit_license":"BB63500","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4CYCY4HF221123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:43.000000Z","updated_at":"2025-03-17T23:10:43.000000Z"},{"id":8356252,"change_date":"2024-03-01 21:40:00","inspection_id":"81000094","insp_unit_id":"199711293","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"STEAL","insp_unit_company":null,"insp_unit_license":"C518210","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"52LBE1221CE010567","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:43.000000Z","updated_at":"2025-03-17T23:10:43.000000Z"}]},{"id":5154254,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","dot_number":"1593500","report_state":"MI","report_number":"CTPRW00175","insp_date":"2024-02-27 00:00:00","insp_start_time":"0830","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ 23 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"1","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-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60600","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1166812","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-02-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:35.000000Z","updated_at":"2025-03-17T20:04:35.000000Z","inspection_violations":[{"id":7950294,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_violation_id":"258086526","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199641513","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7950295,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_violation_id":"258086527","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199641513","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7950296,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_violation_id":"258086528","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199641513","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7950297,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_violation_id":"258086529","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199641512","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39347E"},{"id":7950298,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_violation_id":"258086530","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199641512","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39347E"},{"id":7950299,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_violation_id":"258086531","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199641512","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39347E"},{"id":7950300,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_violation_id":"258086532","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199641512","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39347E"},{"id":7950301,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_violation_id":"258086533","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199641512","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3963A1"},{"id":7950302,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_violation_id":"258086534","seq_no":"9","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"199641512","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":8299115,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_unit_id":"199641512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"413","insp_unit_license":"BC03150","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTWGAARX3J068087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:12.000000Z","updated_at":"2025-03-17T23:10:12.000000Z"},{"id":8299116,"change_date":"2024-02-28 21:42:00","inspection_id":"80961896","insp_unit_id":"199641513","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TOWMA","insp_unit_company":"T309","insp_unit_license":"D600765","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNUT2027GL161144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:12.000000Z","updated_at":"2025-03-17T23:10:12.000000Z"}]},{"id":5114423,"change_date":"2024-02-22 21:43:00","inspection_id":"80918330","dot_number":"1593500","report_state":"MI","report_number":"NESBA01105","insp_date":"2024-02-22 00:00:00","insp_start_time":"0630","insp_end_time":"0640","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":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1165827","transaction_code":"A","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-02-22 21:43:00","snet_input_date":"2024-02-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:51.000000Z","updated_at":"2025-03-17T20:03:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8234058,"change_date":"2024-02-22 21:43:00","inspection_id":"80918330","insp_unit_id":"199554570","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"348","insp_unit_license":"BB23514","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXE4FS9GDC22423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"}]},{"id":5101888,"change_date":"2024-02-21 21:40:00","inspection_id":"80904643","dot_number":"1593500","report_state":"MI","report_number":"BALLB04505","insp_date":"2024-02-20 00:00:00","insp_start_time":"1615","insp_end_time":"1635","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I94 W @ RICHMOND REST AREA","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44641","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":"1165788","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-02-21 21:40:00","snet_input_date":"2024-02-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-21 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:47.000000Z","updated_at":"2025-03-17T20:03:47.000000Z","inspection_violations":[{"id":7867329,"change_date":"2024-02-21 21:40:00","inspection_id":"80904643","insp_violation_id":"257955314","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4326820","created_at":"2025-03-17T21:44:02.000000Z","updated_at":"2025-03-17T21:44:02.000000Z","normalized_code":"39216A"},{"id":7867330,"change_date":"2024-02-21 21:40:00","inspection_id":"80904643","insp_violation_id":"257955315","seq_no":"2","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:02.000000Z","updated_at":"2025-03-17T21:44:02.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":8213764,"change_date":"2024-02-21 21:40:00","inspection_id":"80904643","insp_unit_id":"199527175","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"378","insp_unit_license":"BB70460","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMSAAR8BL402610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:26.000000Z","updated_at":"2025-03-17T23:09:26.000000Z"},{"id":8213765,"change_date":"2024-02-21 21:40:00","inspection_id":"80904643","insp_unit_id":"199527176","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"T70","insp_unit_license":"D379635","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNUT1829DL160698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:26.000000Z","updated_at":"2025-03-17T23:09:26.000000Z"}]},{"id":4955193,"change_date":"2024-02-01 21:43:00","inspection_id":"80744330","dot_number":"1593500","report_state":"MI","report_number":"MALIK02168","insp_date":"2024-02-01 00:00:00","insp_start_time":"0840","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B M-59 @ NORTH AVE","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33700","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":"1162526","transaction_code":"A","transaction_date":"2024-02-01 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2024-02-01 21:43:00","snet_input_date":"2024-02-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-01 21:43:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:52.000000Z","updated_at":"2025-03-17T20:00:52.000000Z","inspection_violations":[{"id":7631851,"change_date":"2024-02-01 21:43:00","inspection_id":"80744330","insp_violation_id":"257613587","seq_no":"1","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"199222293","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:42:51.000000Z","updated_at":"2025-03-17T21:42:51.000000Z","normalized_code":"39323"},{"id":7631852,"change_date":"2024-02-01 21:43:00","inspection_id":"80744330","insp_violation_id":"257613588","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"199222293","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:51.000000Z","updated_at":"2025-03-17T21:42:51.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":7974740,"change_date":"2024-02-01 21:43:00","inspection_id":"80744330","insp_unit_id":"199222292","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"391D","insp_unit_license":"BB78605","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4GT1HEF22847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"},{"id":7974741,"change_date":"2024-02-01 21:43:00","inspection_id":"80744330","insp_unit_id":"199222293","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":"T69","insp_unit_license":"E746582","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTEE2220F2001220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"}]},{"id":4590229,"change_date":"2023-12-08 21:41:00","inspection_id":"80345172","dot_number":"1593500","report_state":"MI","report_number":"BEAMW03597","insp_date":"2023-12-07 00:00:00","insp_start_time":"2005","insp_end_time":"2019","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"75 N @ HESS","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NO BOL","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-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"57000","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":"1156464","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-12-08 21:41:00","snet_input_date":"2023-12-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-08 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:47.000000Z","updated_at":"2025-03-17T19:53:47.000000Z","inspection_violations":[{"id":7098945,"change_date":"2023-12-08 21:41:00","inspection_id":"80345172","insp_violation_id":"256792821","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198421434","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:16.000000Z","updated_at":"2025-03-17T21:40:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7382836,"change_date":"2023-12-08 21:41:00","inspection_id":"80345172","insp_unit_id":"198421433","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA52657","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBCXDC46HW03954","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:03.000000Z","updated_at":"2025-03-17T23:02:03.000000Z"},{"id":7382837,"change_date":"2023-12-08 21:41:00","inspection_id":"80345172","insp_unit_id":"198421434","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"C531605","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTDA2521D1041781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:03.000000Z","updated_at":"2025-03-17T23:02:03.000000Z"}]},{"id":4528016,"change_date":"2023-11-30 21:38:00","inspection_id":"80276742","dot_number":"1593500","report_state":"MI","report_number":"BARTT04118","insp_date":"2023-11-30 00:00:00","insp_start_time":"0955","insp_end_time":"1014","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@MILLER","county_code_state":"MI","county_code":"147","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","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":"1155202","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:34.000000Z","updated_at":"2025-03-17T19:52:34.000000Z","inspection_violations":[{"id":7006002,"change_date":"2023-11-30 21:38:00","inspection_id":"80276742","insp_violation_id":"256641182","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4299315","created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39216A"},{"id":7006003,"change_date":"2023-11-30 21:38:00","inspection_id":"80276742","insp_violation_id":"256641183","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4299315","created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":7282375,"change_date":"2023-11-30 21:38:00","inspection_id":"80276742","insp_unit_id":"198284846","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0","insp_unit_license":"BC51992","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXDT4EDFM1728","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"},{"id":7282376,"change_date":"2023-11-30 21:38:00","inspection_id":"80276742","insp_unit_id":"198284847","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":"0","insp_unit_license":"E607038","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF332XN1009046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"}]},{"id":4539014,"change_date":"2023-12-01 21:42:00","inspection_id":"80288884","dot_number":"1593500","report_state":"MI","report_number":"KOCHJ01403","insp_date":"2023-11-30 00:00:00","insp_start_time":"1340","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-53 @ SEVERANCE RD","county_code_state":"MI","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-01 21:42: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":"1155600","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-12-01 21:42:00","snet_input_date":"2023-11-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:38.000000Z","updated_at":"2025-03-17T19:52:38.000000Z","inspection_violations":[{"id":7022670,"change_date":"2023-12-01 21:42:00","inspection_id":"80288884","insp_violation_id":"256667475","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:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7300171,"change_date":"2023-12-01 21:42:00","inspection_id":"80288884","insp_unit_id":"198308707","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"NONE","insp_unit_license":"BD41376","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4WREYXPF231096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:20.000000Z","updated_at":"2025-03-17T23:01:20.000000Z"}]},{"id":4391900,"change_date":"2023-11-09 21:41:00","inspection_id":"80127038","dot_number":"1593500","report_state":"MI","report_number":"PATTM04488","insp_date":"2023-11-08 00:00:00","insp_start_time":"0850","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"42000","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":"1152796","transaction_code":"A","transaction_date":"2023-11-08 00:00:00","upload_date":"2023-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-11-09 21:41:00","snet_input_date":"2023-11-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-09 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:53.000000Z","updated_at":"2025-03-17T19:49:53.000000Z","inspection_violations":[{"id":6795679,"change_date":"2023-11-09 21:41:00","inspection_id":"80127038","insp_violation_id":"256313534","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:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7063380,"change_date":"2023-11-09 21:41:00","inspection_id":"80127038","insp_unit_id":"197988562","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BD63929","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GBM7C1C55F508545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:17.000000Z","updated_at":"2025-03-17T22:59:17.000000Z"}]},{"id":4092538,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","dot_number":"1593500","report_state":"MI","report_number":"LARSE03356","insp_date":"2023-09-28 00:00:00","insp_start_time":"1120","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SCHLEGEL SAND & GRAVEL","shipping_paper_number":"5059858","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1148075","transaction_code":"A","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-09-29 21:39:00","snet_input_date":"2023-09-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-29 21:39:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:39.000000Z","updated_at":"2025-03-17T19:43:39.000000Z","inspection_violations":[{"id":6332830,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","insp_violation_id":"255573286","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197321783","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3922"},{"id":6332831,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","insp_violation_id":"255573287","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197321783","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4282383","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3922"},{"id":6332832,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","insp_violation_id":"255573288","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"197321783","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39348A"},{"id":6332833,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","insp_violation_id":"255573289","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197321783","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39347E"},{"id":6332834,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","insp_violation_id":"255573290","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197321783","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39353B"},{"id":6332835,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","insp_violation_id":"255573291","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197321783","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3963A1"},{"id":6332836,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","insp_violation_id":"255573292","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197321783","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3939A"},{"id":6332837,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","insp_violation_id":"255573293","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197321783","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6579622,"change_date":"2023-09-29 21:39:00","inspection_id":"79795777","insp_unit_id":"197321783","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"D149","insp_unit_license":"BC84299","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GBM7C1C55F508545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:12.000000Z","updated_at":"2025-03-17T22:55:12.000000Z"}]},{"id":3353721,"change_date":"2023-06-23 21:40:00","inspection_id":"78969882","dot_number":"1593500","report_state":"MI","report_number":"CELMS00478","insp_date":"2023-06-22 00:00:00","insp_start_time":"1745","insp_end_time":"1800","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N I-75 @ M-15","county_code_state":"MI","county_code":"125","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":"N","pen_cen_match":null,"final_status_date":"2023-06-23 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":"1131891","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-06-23 21:40:00","snet_input_date":"2023-06-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-23 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:22.000000Z","updated_at":"2025-03-17T19:29:22.000000Z","inspection_violations":[{"id":5171275,"change_date":"2023-06-23 21:40:00","inspection_id":"78969882","insp_violation_id":"253672203","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:31:00.000000Z","updated_at":"2025-03-17T21:31:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5391338,"change_date":"2023-06-23 21:40:00","inspection_id":"78969882","insp_unit_id":"195649253","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVY","insp_unit_company":null,"insp_unit_license":"BC86875","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4WREY7MF200464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:32.000000Z","updated_at":"2025-03-17T22:45:32.000000Z"}]},{"id":3083554,"change_date":"2023-05-18 21:43:00","inspection_id":"78664923","dot_number":"1593500","report_state":"MI","report_number":"LINEM00419","insp_date":"2023-05-17 00:00:00","insp_start_time":"0825","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"106442","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1126734","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-05-18 21:43:00","snet_input_date":"2023-05-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:09.000000Z","updated_at":"2025-03-17T19:24:09.000000Z","inspection_violations":[{"id":4738630,"change_date":"2023-05-18 21:43:00","inspection_id":"78664923","insp_violation_id":"252926554","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:03.000000Z","updated_at":"2025-03-17T21:29:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4960053,"change_date":"2023-05-18 21:43:00","inspection_id":"78664923","insp_unit_id":"195015577","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"467D","insp_unit_license":"BC97903","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE3NDNC5463","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":3023551,"change_date":"2023-05-11 21:42:00","inspection_id":"78597351","dot_number":"1593500","report_state":"MI","report_number":"SHEPZ03776","insp_date":"2023-05-09 00:00:00","insp_start_time":"1025","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1125473","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-05-11 21:42:00","snet_input_date":"2023-05-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-11 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:58.000000Z","updated_at":"2025-03-17T19:22:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4864288,"change_date":"2023-05-11 21:42:00","inspection_id":"78597351","insp_unit_id":"194881689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"349","insp_unit_license":"BB23513","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXE4FS9GDC48987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"}]},{"id":2799335,"change_date":"2023-04-13 21:43:00","inspection_id":"78343462","dot_number":"1593500","report_state":"MI","report_number":"MOREM04795","insp_date":"2023-04-12 00:00:00","insp_start_time":"1657","insp_end_time":"1750","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BELLINGAR MEATS","county_code_state":"MI","county_code":"037","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"5056444","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1121752","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-04-13 21:43:00","snet_input_date":"2023-04-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:08.000000Z","updated_at":"2025-03-17T19:18:08.000000Z","inspection_violations":[{"id":4295877,"change_date":"2023-04-13 21:43:00","inspection_id":"78343462","insp_violation_id":"252210237","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194375273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39311"},{"id":4295878,"change_date":"2023-04-13 21:43:00","inspection_id":"78343462","insp_violation_id":"252210238","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194375273","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4203229","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4505377,"change_date":"2023-04-13 21:43:00","inspection_id":"78343462","insp_unit_id":"194375273","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"467D","insp_unit_license":"BC97903","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE3NDNC5463","insp_unit_decal":"Y","insp_unit_decal_number":"32660041","created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"}]},{"id":2553299,"change_date":"2023-03-10 21:41:00","inspection_id":"78063231","dot_number":"1593500","report_state":"MI","report_number":"MALIK01618","insp_date":"2023-03-09 00:00:00","insp_start_time":"0735","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B M-53 @ 32 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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1117042","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-03-10 21:41:00","snet_input_date":"2023-03-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:43.000000Z","updated_at":"2025-03-17T19:13:43.000000Z","inspection_violations":[{"id":3926479,"change_date":"2023-03-10 21:41:00","inspection_id":"78063231","insp_violation_id":"251595949","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193814771","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":4109655,"change_date":"2023-03-10 21:41:00","inspection_id":"78063231","insp_unit_id":"193814771","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-5","insp_unit_license":"BC86874","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX3LJ431075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:27.000000Z","updated_at":"2025-03-17T22:35:27.000000Z"}]},{"id":2532085,"change_date":"2023-03-08 21:40:00","inspection_id":"78039206","dot_number":"1593500","report_state":"MI","report_number":"FOXMA00909","insp_date":"2023-03-07 00:00:00","insp_start_time":"1710","insp_end_time":"1725","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 AT PORTLAND RD","county_code_state":"MI","county_code":"067","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":"2023-03-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","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":"1116663","transaction_code":"A","transaction_date":"2023-03-07 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-03-08 21:40:00","snet_input_date":"2023-03-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-08 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:21.000000Z","updated_at":"2025-03-17T19:13:21.000000Z","inspection_violations":[{"id":3891832,"change_date":"2023-03-08 21:40:00","inspection_id":"78039206","insp_violation_id":"251540764","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39141A"},{"id":3891833,"change_date":"2023-03-08 21:40:00","inspection_id":"78039206","insp_violation_id":"251540765","seq_no":"2","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:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4075510,"change_date":"2023-03-08 21:40:00","inspection_id":"78039206","insp_unit_id":"193767091","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BD13718","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4KZC80DF128604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:13.000000Z","updated_at":"2025-03-17T22:35:13.000000Z"}]},{"id":2513109,"change_date":"2023-03-06 21:40:00","inspection_id":"78017729","dot_number":"1593500","report_state":"MI","report_number":"CELMS00295","insp_date":"2023-03-03 00:00:00","insp_start_time":"1350","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N I-75 @ SASHABAW RD","county_code_state":"MI","county_code":"125","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":"N","pen_cen_match":null,"final_status_date":"2023-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"1116117","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-03-06 21:40:00","snet_input_date":"2023-03-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:57.000000Z","updated_at":"2025-03-17T19:12:57.000000Z","inspection_violations":[{"id":3864047,"change_date":"2023-03-06 21:40:00","inspection_id":"78017729","insp_violation_id":"251494234","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39216A"},{"id":3864048,"change_date":"2023-03-06 21:40:00","inspection_id":"78017729","insp_violation_id":"251494235","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":4044792,"change_date":"2023-03-06 21:40:00","inspection_id":"78017729","insp_unit_id":"193723735","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"357","insp_unit_license":"BD05242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4GT5GEC87657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:59.000000Z","updated_at":"2025-03-17T22:34:59.000000Z"}]},{"id":2435962,"change_date":"2023-02-23 21:40:00","inspection_id":"77930155","dot_number":"1593500","report_state":"MI","report_number":"NESBA00224","insp_date":"2023-02-22 00:00:00","insp_start_time":"0630","insp_end_time":"0645","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":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1114790","transaction_code":"A","transaction_date":"2023-02-22 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-02-23 21:40:00","snet_input_date":"2023-02-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-23 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:28.000000Z","updated_at":"2025-03-17T19:11:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3920362,"change_date":"2023-02-23 21:40:00","inspection_id":"77930155","insp_unit_id":"193548864","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"342","insp_unit_license":"BC08606","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXE4FS4GDC28081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:05.000000Z","updated_at":"2025-03-17T22:34:05.000000Z"}]},{"id":2304254,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","dot_number":"1593500","report_state":"MI","report_number":"CELMS00260","insp_date":"2023-02-03 00:00:00","insp_start_time":"1635","insp_end_time":"1740","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":"1","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":"2023-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"49600","viol_total":"11","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1112304","transaction_code":"A","transaction_date":"2023-02-03 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2023-02-06 21:41:00","snet_input_date":"2023-02-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-06 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:13.000000Z","updated_at":"2025-03-17T19:09:13.000000Z","inspection_violations":[{"id":3550779,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967727","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39141A"},{"id":3550780,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967728","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193245374","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39617C"},{"id":3550781,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967729","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193245374","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3939A"},{"id":3550782,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967730","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193245374","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4172110","created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3939A"},{"id":3550783,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967731","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193245374","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39347E"},{"id":3550784,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967732","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"193245374","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39353B"},{"id":3550785,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967733","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193245374","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3963A1"},{"id":3550786,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967734","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193245375","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3939A"},{"id":3550787,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967735","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193245375","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39617C"},{"id":3550788,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967736","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193245375","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3939A"},{"id":3550789,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_violation_id":"250967737","seq_no":"11","part_no":"393","part_no_section":"70(d)(8)","insp_viol_unit":"2","insp_unit_id":"193245375","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39370D8"}],"inspection_per_units":[{"id":3709085,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_unit_id":"193245374","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"321","insp_unit_license":"BC97904","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBCXDC36HW03962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:33.000000Z","updated_at":"2025-03-17T22:32:33.000000Z"},{"id":3709086,"change_date":"2023-02-06 21:41:00","inspection_id":"77779760","insp_unit_id":"193245375","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"NONE","insp_unit_license":"E308563","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTEE292XE2002265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:33.000000Z","updated_at":"2025-03-17T22:32:33.000000Z"}]},{"id":1961597,"change_date":"2022-12-16 21:40:00","inspection_id":"77388362","dot_number":"1593500","report_state":"MI","report_number":"PEASS02530","insp_date":"2022-12-15 00:00:00","insp_start_time":"0910","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ DIXIE HWY","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"731497","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1106068","transaction_code":"A","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-12-16 21:40:00","snet_input_date":"2022-12-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-16 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:54.000000Z","updated_at":"2025-03-17T19:02:54.000000Z","inspection_violations":[{"id":3045858,"change_date":"2022-12-16 21:40:00","inspection_id":"77388362","insp_violation_id":"250135791","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192460853","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3156331,"change_date":"2022-12-16 21:40:00","inspection_id":"77388362","insp_unit_id":"192460853","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"468","insp_unit_license":"BC97902","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"PC FOR STOP WAS I","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:37.000000Z","updated_at":"2025-03-17T22:28:37.000000Z"}]},{"id":1939482,"change_date":"2022-12-13 21:40:00","inspection_id":"77363016","dot_number":"1593500","report_state":"MI","report_number":"MALIK01462","insp_date":"2022-12-12 00:00:00","insp_start_time":"1410","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56420","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":"1105269","transaction_code":"A","transaction_date":"2022-12-12 00:00:00","upload_date":"2022-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-12-13 21:40:00","snet_input_date":"2022-12-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-13 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:16.000000Z","updated_at":"2025-03-17T19:02:16.000000Z","inspection_violations":[{"id":3013636,"change_date":"2022-12-13 21:40:00","inspection_id":"77363016","insp_violation_id":"250082351","seq_no":"1","part_no":"393","part_no_section":"70(d)(8)","insp_viol_unit":"2","insp_unit_id":"192410263","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"39370D8"}],"inspection_per_units":[{"id":3120795,"change_date":"2022-12-13 21:40:00","inspection_id":"77363016","insp_unit_id":"192410262","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"323","insp_unit_license":"BA52656","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBCXDC86HW03956","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:23.000000Z","updated_at":"2025-03-17T22:28:23.000000Z"},{"id":3120796,"change_date":"2022-12-13 21:40:00","inspection_id":"77363016","insp_unit_id":"192410263","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"NONE","insp_unit_license":"D444772","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA3629H1000382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:23.000000Z","updated_at":"2025-03-17T22:28:23.000000Z"}]},{"id":1572584,"change_date":"2022-10-21 21:39:00","inspection_id":"76942371","dot_number":"1593500","report_state":"MI","report_number":"ECSEH00201","insp_date":"2022-10-20 00:00:00","insp_start_time":"0956","insp_end_time":"1027","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANAL RD \/ WESTSHIRE AVE","county_code_state":"MI","county_code":"045","insp_level_id":"1","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"375","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1099021","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:36.000000Z","updated_at":"2025-03-17T18:55:36.000000Z","inspection_violations":[{"id":2472369,"change_date":"2022-10-21 21:39:00","inspection_id":"76942371","insp_violation_id":"249178291","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:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3922"},{"id":2472370,"change_date":"2022-10-21 21:39:00","inspection_id":"76942371","insp_violation_id":"249178292","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191576163","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3963A1"},{"id":2472371,"change_date":"2022-10-21 21:39:00","inspection_id":"76942371","insp_violation_id":"249178293","seq_no":"3","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"191576163","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"42394","created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39355D3"},{"id":2472372,"change_date":"2022-10-21 21:39:00","inspection_id":"76942371","insp_violation_id":"249178294","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191576163","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2530893,"change_date":"2022-10-21 21:39:00","inspection_id":"76942371","insp_unit_id":"191576163","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"33000","insp_unit_license":"BB63062","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMKAAN3DH326414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"}]},{"id":1239292,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","dot_number":"1593500","report_state":"MI","report_number":"MALIK01309","insp_date":"2022-09-07 00:00:00","insp_start_time":"0843","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B VAN DYKE AVE @ 15 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26350","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1093601","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-09-08 21:38:00","snet_input_date":"2022-09-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-08 21:38:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:23.000000Z","updated_at":"2025-03-17T18:49:23.000000Z","inspection_violations":[{"id":1961988,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","insp_violation_id":"248283438","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190788046","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"39395F"},{"id":1961989,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","insp_violation_id":"248283439","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190788047","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4105320","created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"3939A"},{"id":1961990,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","insp_violation_id":"248283440","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190788047","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"3939A"},{"id":1961991,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","insp_violation_id":"248283441","seq_no":"4","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"39141A"},{"id":1961992,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","insp_violation_id":"248283442","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190788046","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"3922"},{"id":1961993,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","insp_violation_id":"248283443","seq_no":"6","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"190788047","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4105320","created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"39375A"},{"id":1961994,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","insp_violation_id":"248283444","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190788046","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1994326,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","insp_unit_id":"190788046","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"398D","insp_unit_license":"BB93596","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAF4GT9HEF23053","insp_unit_decal":"Y","insp_unit_decal_number":"31656780","created_at":"2025-03-17T22:20:42.000000Z","updated_at":"2025-03-17T22:20:42.000000Z"},{"id":1994327,"change_date":"2022-09-08 21:38:00","inspection_id":"76556051","insp_unit_id":"190788047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMEM","insp_unit_company":"T318","insp_unit_license":"D654373","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"593200D28H1058382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:42.000000Z","updated_at":"2025-03-17T22:20:42.000000Z"}]},{"id":934192,"change_date":"2022-08-01 21:39:00","inspection_id":"76200852","dot_number":"1593500","report_state":"MI","report_number":"STUDM00536","insp_date":"2022-07-28 00:00:00","insp_start_time":"1150","insp_end_time":"1225","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOWELL RD\/HAGADORN RD","county_code_state":"MI","county_code":"065","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"KALTZ EXCAVATING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","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":"1086437","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-08-01 21:39:00","snet_input_date":"2022-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-01 21:39:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:05.000000Z","updated_at":"2025-03-17T18:44:05.000000Z","inspection_violations":[{"id":1473865,"change_date":"2022-08-01 21:39:00","inspection_id":"76200852","insp_violation_id":"247431259","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:13:58.000000Z","updated_at":"2025-03-17T21:13:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1503746,"change_date":"2022-08-01 21:39:00","inspection_id":"76200852","insp_unit_id":"190063730","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"467D","insp_unit_license":"BC97903","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE3NDNC5463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"},{"id":1503747,"change_date":"2022-08-01 21:39:00","inspection_id":"76200852","insp_unit_id":"190063731","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"7353","insp_unit_license":"E086745","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3725J1003773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"}]},{"id":895019,"change_date":"2022-07-26 21:42:00","inspection_id":"76154640","dot_number":"1593500","report_state":"MI","report_number":"DETGT03897","insp_date":"2022-07-26 00:00:00","insp_start_time":"1050","insp_end_time":"1111","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ANN ARBOR RD @ SARGENT RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","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":"1085520","transaction_code":"A","transaction_date":"2022-07-26 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-07-26 21:42:00","snet_input_date":"2022-07-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-26 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:25.000000Z","updated_at":"2025-03-17T18:43:25.000000Z","inspection_violations":[{"id":1409932,"change_date":"2022-07-26 21:42:00","inspection_id":"76154640","insp_violation_id":"247318752","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4092514","created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1440590,"change_date":"2022-07-26 21:42:00","inspection_id":"76154640","insp_unit_id":"189969970","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"467D","insp_unit_license":"BC97903","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE3NDNC5463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"}]},{"id":748444,"change_date":"2022-07-05 21:42:00","inspection_id":"75983609","dot_number":"1593500","report_state":"MI","report_number":"BARTT03339","insp_date":"2022-06-28 00:00:00","insp_start_time":"1135","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@BRISTOL","county_code_state":"MI","county_code":"087","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"180000","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":"1082092","transaction_code":"A","transaction_date":"2022-06-28 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-07-05 21:42:00","snet_input_date":"2022-06-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:53.000000Z","updated_at":"2025-03-17T18:40:53.000000Z","inspection_violations":[{"id":1177910,"change_date":"2022-07-05 21:42:00","inspection_id":"75983609","insp_violation_id":"246884478","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189600215","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1203399,"change_date":"2022-07-05 21:42:00","inspection_id":"75983609","insp_unit_id":"189600215","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"0","insp_unit_license":"BC75818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0ND770333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"},{"id":1203400,"change_date":"2022-07-05 21:42:00","inspection_id":"75983609","insp_unit_id":"189600216","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ETNY","insp_unit_company":"0","insp_unit_license":"E042457","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9321676HE111037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"}]},{"id":593450,"change_date":"2022-06-13 21:41:00","inspection_id":"75799936","dot_number":"1593500","report_state":"MI","report_number":"MALIK01107","insp_date":"2022-06-10 00:00:00","insp_start_time":"0810","insp_end_time":"0819","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B M-59 @ GARFIELD 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":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-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"59250","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":"1079457","transaction_code":"A","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-06-13 21:41:00","snet_input_date":"2022-06-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-13 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:06.000000Z","updated_at":"2025-03-17T18:38:06.000000Z","inspection_violations":[{"id":929842,"change_date":"2022-06-13 21:41:00","inspection_id":"75799936","insp_violation_id":"246408016","seq_no":"1","part_no":"393","part_no_section":"70(d)(8)","insp_viol_unit":"2","insp_unit_id":"189204324","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39370D8"}],"inspection_per_units":[{"id":953708,"change_date":"2022-06-13 21:41:00","inspection_id":"75799936","insp_unit_id":"189204323","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"267","insp_unit_license":"BC80651","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GBP8E1C33F51922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:04.000000Z","updated_at":"2025-03-17T22:14:04.000000Z"},{"id":953709,"change_date":"2022-06-13 21:41:00","inspection_id":"75799936","insp_unit_id":"189204324","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"T-66","insp_unit_license":"D336201","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTFA3124G1002398","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:04.000000Z","updated_at":"2025-03-17T22:14:04.000000Z"}]},{"id":551062,"change_date":"2022-06-09 21:42:00","inspection_id":"75749917","dot_number":"1593500","report_state":"MI","report_number":"HICKG01694","insp_date":"2022-06-03 00:00:00","insp_start_time":"1140","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I-96 @ WILLIAMSTON RD","county_code_state":"MI","county_code":"065","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1078452","transaction_code":"C","transaction_date":"2022-06-03 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-06-06 21:41:00","snet_input_date":"2022-06-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-06 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:27.000000Z","updated_at":"2025-03-17T18:37:27.000000Z","inspection_violations":[{"id":867128,"change_date":"2022-06-09 21:42:00","inspection_id":"75749917","insp_violation_id":"246334561","seq_no":"1","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189146123","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":886587,"change_date":"2022-06-09 21:42:00","inspection_id":"75749917","insp_unit_id":"189146123","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB63062","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMKAAN3DH326414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:40.000000Z","updated_at":"2025-03-17T22:13:40.000000Z"}]},{"id":445355,"change_date":"2022-06-09 21:42:00","inspection_id":"75623979","dot_number":"1593500","report_state":"MI","report_number":"MANIJ01090","insp_date":"2022-05-17 00:00:00","insp_start_time":"1015","insp_end_time":"1118","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1075984","transaction_code":"C","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-05-20 21:41:00","snet_input_date":"2022-05-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-20 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:36.000000Z","updated_at":"2025-03-17T18:35:36.000000Z","inspection_violations":[{"id":703117,"change_date":"2022-06-09 21:42:00","inspection_id":"75623979","insp_violation_id":"246338624","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189149688","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4047837","created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3922"},{"id":703118,"change_date":"2022-06-09 21:42:00","inspection_id":"75623979","insp_violation_id":"246338625","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"189149688","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39375G"},{"id":703119,"change_date":"2022-06-09 21:42:00","inspection_id":"75623979","insp_violation_id":"246338626","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"189149688","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":717749,"change_date":"2022-06-09 21:42:00","inspection_id":"75623979","insp_unit_id":"189149688","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC80718","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2GR4GC2LM017418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:37.000000Z","updated_at":"2025-03-17T22:12:37.000000Z"}]},{"id":445438,"change_date":"2022-06-09 21:42:00","inspection_id":"75624077","dot_number":"1593500","report_state":"MI","report_number":"PEASS02417","insp_date":"2022-05-17 00:00:00","insp_start_time":"1310","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ BAY CITY REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","pen_cen_match":null,"final_status_date":"2022-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1075964","transaction_code":"C","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-05-20 21:41:00","snet_input_date":"2022-05-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-20 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:36.000000Z","updated_at":"2025-03-17T18:35:36.000000Z","inspection_violations":[{"id":703315,"change_date":"2022-06-09 21:42:00","inspection_id":"75624077","insp_violation_id":"246339952","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189150988","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3922"},{"id":703316,"change_date":"2022-06-09 21:42:00","inspection_id":"75624077","insp_violation_id":"246339953","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189150988","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4051234","created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":717885,"change_date":"2022-06-09 21:42:00","inspection_id":"75624077","insp_unit_id":"189150988","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"0","insp_unit_license":"BB99073","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ9XXKM307910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:37.000000Z","updated_at":"2025-03-17T22:12:37.000000Z"}]},{"id":385806,"change_date":"2022-06-09 21:42:00","inspection_id":"75552966","dot_number":"1593500","report_state":"MI","report_number":"COPEK01370","insp_date":"2022-05-12 00:00:00","insp_start_time":"1310","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB M59 @ DEQUINDER","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1075419","transaction_code":"C","transaction_date":"2022-05-12 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-05-13 21:40:00","snet_input_date":"2022-05-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-13 21:40:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:24.000000Z","updated_at":"2025-03-17T18:34:24.000000Z","inspection_violations":[{"id":603554,"change_date":"2022-06-09 21:42:00","inspection_id":"75552966","insp_violation_id":"246330712","seq_no":"1","part_no":"393","part_no_section":"102(a)","insp_viol_unit":"1","insp_unit_id":"189143499","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:53.000000Z","updated_at":"2025-03-17T21:09:53.000000Z","normalized_code":"393102A"}],"inspection_per_units":[{"id":623637,"change_date":"2022-06-09 21:42:00","inspection_id":"75552966","insp_unit_id":"189143499","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"292","insp_unit_license":"AC99660","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMAAN27H443366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:01.000000Z","updated_at":"2025-03-17T22:12:01.000000Z"}]},{"id":377412,"change_date":"2022-06-09 21:42:00","inspection_id":"75543024","dot_number":"1593500","report_state":"MI","report_number":"PEASS02405","insp_date":"2022-05-11 00:00:00","insp_start_time":"0715","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-69 EB @ ELBA RD","county_code_state":"MI","county_code":"087","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","pen_cen_match":null,"final_status_date":"2022-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77850","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":"1075232","transaction_code":"C","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-05-12 21:41:00","snet_input_date":"2022-05-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-12 21:41:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:02.000000Z","updated_at":"2025-03-17T18:34:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":610239,"change_date":"2022-06-09 21:42:00","inspection_id":"75543024","insp_unit_id":"189150934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"337","insp_unit_license":"BA69519","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMSAARX6G346066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:57.000000Z","updated_at":"2025-03-17T22:11:57.000000Z"},{"id":610240,"change_date":"2022-06-09 21:42:00","inspection_id":"75543024","insp_unit_id":"189150935","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"308","insp_unit_license":"E263047","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNUT2029GL161145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:57.000000Z","updated_at":"2025-03-17T22:11:57.000000Z"}]},{"id":278327,"change_date":"2022-06-09 21:42:00","inspection_id":"75425115","dot_number":"1593500","report_state":"MI","report_number":"MALIK01034","insp_date":"2022-04-27 00:00:00","insp_start_time":"0820","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B MOUND RD @ 15 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"47800","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1073710","transaction_code":"C","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-04-28 21:39:00","snet_input_date":"2022-04-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:17.000000Z","updated_at":"2025-03-17T18:32:17.000000Z","inspection_violations":[{"id":431180,"change_date":"2022-06-09 21:42:00","inspection_id":"75425115","insp_violation_id":"246338614","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189149675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3939A"},{"id":431181,"change_date":"2022-06-09 21:42:00","inspection_id":"75425115","insp_violation_id":"246338615","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"189149676","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39343"},{"id":431182,"change_date":"2022-06-09 21:42:00","inspection_id":"75425115","insp_violation_id":"246338616","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189149676","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4043164","created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3939A"},{"id":431183,"change_date":"2022-06-09 21:42:00","inspection_id":"75425115","insp_violation_id":"246338617","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189149676","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":450675,"change_date":"2022-06-09 21:42:00","inspection_id":"75425115","insp_unit_id":"189149675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"222","insp_unit_license":"BA77272","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3FRXF75X04V684706","insp_unit_decal":"Y","insp_unit_decal_number":"31293186","created_at":"2025-03-17T22:10:59.000000Z","updated_at":"2025-03-17T22:10:59.000000Z"},{"id":450676,"change_date":"2022-06-09 21:42:00","inspection_id":"75425115","insp_unit_id":"189149676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DITC","insp_unit_company":"T-140D","insp_unit_license":"E638780","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2424ML160036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:59.000000Z","updated_at":"2025-03-17T22:10:59.000000Z"}]},{"id":62162,"change_date":"2022-03-29 21:42:00","inspection_id":"75164384","dot_number":"1593500","report_state":"MI","report_number":"PEASS02349","insp_date":"2022-03-28 00:00:00","insp_start_time":"1130","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M 90 @ M 24","county_code_state":"MI","county_code":"087","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","pen_cen_match":null,"final_status_date":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1069415","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-03-29 21:42:00","snet_input_date":"2022-03-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:45.000000Z","updated_at":"2025-03-17T18:28:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":100968,"change_date":"2022-03-29 21:42:00","inspection_id":"75164384","insp_unit_id":"187873019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"468","insp_unit_license":"BC97902","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"PC FOR STOP WAS I","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"}]},{"id":4151,"change_date":"2022-03-18 21:31:00","inspection_id":"75082770","dot_number":"1593500","report_state":"MI","report_number":"JURKV01644","insp_date":"2022-03-17 00:00:00","insp_start_time":"0830","insp_end_time":"0851","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"049","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-18 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"58900","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":"1068185","transaction_code":"A","transaction_date":"2022-03-17 00:00:00","upload_date":"2022-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01593500","upload_search_indicator":null,"census_search_date":"2022-03-18 21:31:00","snet_input_date":"2022-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-18 21:31:00","insp_carrier_name":"KALTZ EXCAVATING COMPANY INCORPORATED","insp_carrier_street":"1030 FEATHERSTONE","insp_carrier_city":"PONTIAC","insp_carrier_state":"MI","insp_carrier_zip_code":"48342","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:43.000000Z","updated_at":"2025-03-17T18:27:43.000000Z","inspection_violations":[{"id":5441,"change_date":"2022-03-18 21:31:00","inspection_id":"75082770","insp_violation_id":"244648874","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:07:09.000000Z","updated_at":"2025-03-17T21:07:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6725,"change_date":"2022-03-18 21:31:00","inspection_id":"75082770","insp_unit_id":"187704050","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"373","insp_unit_license":"BB53752","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMKAAN9DH326269","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:18.000000Z","updated_at":"2025-03-17T22:08:18.000000Z"},{"id":6726,"change_date":"2022-03-18 21:31:00","inspection_id":"75082770","insp_unit_id":"187704051","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"T363","insp_unit_license":"E357935","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3228M1001141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:18.000000Z","updated_at":"2025-03-17T22:08:18.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1593500\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1593500\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1593500\/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\/1593500\/inspections","per_page":100,"prev_page_url":null,"to":72,"total":72}