{"current_page":1,"data":[{"id":9546448,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","dot_number":"1995237","report_state":"IA","report_number":"000P14HZ68","insp_date":"2025-08-25 00:00:00","insp_start_time":"1042","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HIGHWAY 1 AND RIVERSIDE DRIVE","county_code_state":"IA","county_code":"103","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DBA ADVANCED BORETEK AND ADVANCED E","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-08-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39500","viol_total":"14","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"10","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1371957","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01995237","upload_search_indicator":"M","census_search_date":"2025-08-29 21:40:00","snet_input_date":"2025-08-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"DBA ADVANCED BORETEK AND ADVANCED ELECTRICAL SERVICES","insp_carrier_street":"1233 GILBERT CT","insp_carrier_city":"IOWA CITY","insp_carrier_state":"IA","insp_carrier_zip_code":"52240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:31.000000Z","updated_at":"2025-09-06T10:42:31.000000Z","inspection_violations":[{"id":15584704,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345485","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7GEH25082511022","created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"39216"},{"id":15584705,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345486","seq_no":"2","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"7GEH25082511023","created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"38323A2"},{"id":15584706,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345487","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"208659891","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3922RG"},{"id":15584707,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345488","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208659890","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3922RG"},{"id":15584708,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345489","seq_no":"5","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"208659890","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"39381"},{"id":15584709,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345490","seq_no":"6","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"208659890","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"393205C"},{"id":15584710,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345491","seq_no":"7","part_no":"393","part_no_section":"9T","insp_viol_unit":"2","insp_unit_id":"208659891","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3939T"},{"id":15584711,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345492","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"208659891","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3939"},{"id":15584712,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345493","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"208659891","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3922RG"},{"id":15584713,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345494","seq_no":"10","part_no":"396","part_no_section":"5B-HWSLOW","insp_viol_unit":"2","insp_unit_id":"208659891","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3965BHWSLOW"},{"id":15584714,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345495","seq_no":"11","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208659890","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"39395F"},{"id":15584715,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345496","seq_no":"12","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"208659890","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"39395A"},{"id":15584716,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345497","seq_no":"13","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-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3922"},{"id":15584717,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_violation_id":"268345498","seq_no":"14","part_no":"392","part_no_section":"7A","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-09-06T10:46:18.000000Z","updated_at":"2025-09-06T10:46:18.000000Z","normalized_code":"3927A"}],"inspection_per_units":[{"id":15756715,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_unit_id":"208659890","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"196","insp_unit_license":"IXN815","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FD0W5HY5KEE27701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:52.000000Z","updated_at":"2025-09-09T09:46:52.000000Z"},{"id":15756716,"change_date":"2025-08-29 21:40:00","inspection_id":"85633858","insp_unit_id":"208659891","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCELRATH","insp_unit_company":"NA","insp_unit_license":"LC7248","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1G91A1927RC615206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:52.000000Z","updated_at":"2025-09-09T09:46:52.000000Z"}]},{"id":35360,"change_date":"2022-03-24 21:31:00","inspection_id":"75130690","dot_number":"1995237","report_state":"IA","report_number":"000TT6P6W4","insp_date":"2022-03-23 00:00:00","insp_start_time":"1007","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"MELROSE AVE","county_code_state":"IA","county_code":"103","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-24 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1216857","transaction_code":"A","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01995237","upload_search_indicator":"M","census_search_date":"2022-03-24 21:31:00","snet_input_date":"2022-03-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-03-24 21:31:00","insp_carrier_name":"DBA ADVANCED BORETEK AND ADVANCED ELECTRICAL SERVICES","insp_carrier_street":"1233 GILBERT CT","insp_carrier_city":"IOWA CITY","insp_carrier_state":"IA","insp_carrier_zip_code":"52240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:08.000000Z","updated_at":"2025-03-17T18:28:08.000000Z","inspection_violations":[{"id":50369,"change_date":"2022-03-24 21:31:00","inspection_id":"75130690","insp_violation_id":"244759903","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"48","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":56946,"change_date":"2022-03-24 21:31:00","inspection_id":"75130690","insp_unit_id":"187803251","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"196","insp_unit_license":"IXN815","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FD0W5HY5KEE27701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:37.000000Z","updated_at":"2025-03-17T22:08:37.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1995237\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1995237\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1995237\/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\/1995237\/inspections","per_page":100,"prev_page_url":null,"to":2,"total":2}