{"current_page":1,"data":[{"id":11118411,"change_date":"2026-02-12 21:40:00","inspection_id":"87031318","dot_number":"1275828","report_state":"IA","report_number":"000P169C0H","insp_date":"2026-02-11 00:00:00","insp_start_time":"1051","insp_end_time":"1111","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 SB\/290TH ST","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MISC","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-02-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1390029","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01275828","upload_search_indicator":"M","census_search_date":"2026-02-12 21:40:00","snet_input_date":"2026-02-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-02-12 21:40:00","insp_carrier_name":"BOB BROWN CHEVROLET INC","insp_carrier_street":"3600 111TH ST","insp_carrier_city":"URBANDALE","insp_carrier_state":"IA","insp_carrier_zip_code":"50322","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-15T10:38:47.000000Z","updated_at":"2026-02-23T10:30:52.000000Z","inspection_violations":[{"id":18619250,"change_date":"2026-02-12 21:40:00","inspection_id":"87031318","insp_violation_id":"271760931","seq_no":"1","part_no":"392","part_no_section":"2P","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1WIN26021110585","created_at":"2026-02-15T10:55:15.000000Z","updated_at":"2026-02-23T10:39:24.000000Z","normalized_code":"3922P"},{"id":18619251,"change_date":"2026-02-12 21:40:00","inspection_id":"87031318","insp_violation_id":"271760932","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"211592196","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:15.000000Z","updated_at":"2026-02-23T10:39:24.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":18962876,"change_date":"2026-02-12 21:40:00","inspection_id":"87031318","insp_unit_id":"211592196","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"08","insp_unit_license":"BROWNO8","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GB3G3CG7F1179616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:07.000000Z","updated_at":"2026-02-23T10:03:16.000000Z"}]},{"id":9888039,"change_date":"2025-10-08 21:40:00","inspection_id":"85991883","dot_number":"1275828","report_state":"IA","report_number":"000P13NDBC","insp_date":"2025-10-07 00:00:00","insp_start_time":"0840","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169SB\/WEST SUMMIT ST","county_code_state":"IA","county_code":"121","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BOB BROWN","shipping_paper_number":"PARTS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1377197","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01275828","upload_search_indicator":"M","census_search_date":"2025-10-08 21:40:00","snet_input_date":"2025-10-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"BOB BROWN CHEVROLET INC","insp_carrier_street":"3600 111TH ST","insp_carrier_city":"URBANDALE","insp_carrier_state":"IA","insp_carrier_zip_code":"50322","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:48.000000Z","updated_at":"2025-10-12T10:01:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16406004,"change_date":"2025-10-08 21:40:00","inspection_id":"85991883","insp_unit_id":"209364523","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"03","insp_unit_license":"BROWNO3","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HA3GTC76PN018188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:13.000000Z","updated_at":"2025-10-12T09:46:19.000000Z"}]},{"id":9141178,"change_date":"2025-07-14 21:40:00","inspection_id":"85207521","dot_number":"1275828","report_state":"IA","report_number":"000P16D932","insp_date":"2025-07-11 00:00:00","insp_start_time":"1036","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"KENYON RD TRITON","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BOB BROWN","shipping_paper_number":"PARTS","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-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1367325","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01275828","upload_search_indicator":"M","census_search_date":"2025-07-14 21:40:00","snet_input_date":"2025-07-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-07-14 21:40:00","insp_carrier_name":"BOB BROWN CHEVROLET INC","insp_carrier_street":"3600 111TH ST","insp_carrier_city":"URBANDALE","insp_carrier_state":"IA","insp_carrier_zip_code":"50322","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:45.000000Z","updated_at":"2025-07-18T10:45:45.000000Z","inspection_violations":[{"id":14745445,"change_date":"2025-07-14 21:40:00","inspection_id":"85207521","insp_violation_id":"267389140","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-07-17T10:47:10.000000Z","updated_at":"2025-07-18T10:47:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":15010673,"change_date":"2025-07-14 21:40:00","inspection_id":"85207521","insp_unit_id":"207855450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BROWNO3","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HA3GTC76PN018188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:30.000000Z","updated_at":"2025-07-18T09:45:49.000000Z"}]},{"id":8932081,"change_date":"2025-06-18 21:41:00","inspection_id":"84986908","dot_number":"1275828","report_state":"IA","report_number":"000P13B1FL","insp_date":"2025-06-17 00:00:00","insp_start_time":"0958","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 34 AND 25","county_code_state":"IA","county_code":"175","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OWN","shipping_paper_number":"474601","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-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1364449","transaction_code":"A","transaction_date":"2025-06-18 00:00:00","upload_date":"2025-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01275828","upload_search_indicator":"M","census_search_date":"2025-06-18 21:41:00","snet_input_date":"2025-06-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-18 21:41:00","insp_carrier_name":"BOB BROWN CHEVROLET INC","insp_carrier_street":"3600 111TH ST","insp_carrier_city":"URBANDALE","insp_carrier_state":"IA","insp_carrier_zip_code":"50322","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-22T10:01:06.000000Z","updated_at":"2025-06-22T10:01:06.000000Z","inspection_violations":[{"id":14333057,"change_date":"2025-06-18 21:41:00","inspection_id":"84986908","insp_violation_id":"266917715","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207450392","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-21T10:17:06.000000Z","updated_at":"2025-06-22T10:17:42.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":14638599,"change_date":"2025-06-18 21:41:00","inspection_id":"84986908","insp_unit_id":"207450392","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1","insp_unit_license":"BROWNO3","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HA3GTC76PN018188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:21.000000Z","updated_at":"2025-06-22T09:46:21.000000Z"}]},{"id":5793072,"change_date":"2024-05-20 21:42:00","inspection_id":"81657575","dot_number":"1275828","report_state":"IA","report_number":"000P10C3MR","insp_date":"2024-05-17 00:00:00","insp_start_time":"0610","insp_end_time":"0626","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"91 MM 35 NB","county_code_state":"IA","county_code":"153","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BOB BROWN","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-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1313820","transaction_code":"A","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01275828","upload_search_indicator":"M","census_search_date":"2024-05-20 21:42:00","snet_input_date":"2024-05-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-05-20 21:42:00","insp_carrier_name":"BOB BROWN CHEVROLET INC","insp_carrier_street":"3600 111TH ST","insp_carrier_city":"URBANDALE","insp_carrier_state":"IA","insp_carrier_zip_code":"50322","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:31.000000Z","updated_at":"2025-03-17T20:17:31.000000Z","inspection_violations":[{"id":8971258,"change_date":"2024-05-20 21:42:00","inspection_id":"81657575","insp_violation_id":"259608533","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200983097","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:22.000000Z","updated_at":"2025-03-17T21:49:22.000000Z","normalized_code":"3939A"},{"id":8971259,"change_date":"2024-05-20 21:42:00","inspection_id":"81657575","insp_violation_id":"259608534","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"200983097","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:22.000000Z","updated_at":"2025-03-17T21:49:22.000000Z","normalized_code":"39319"},{"id":8971260,"change_date":"2024-05-20 21:42:00","inspection_id":"81657575","insp_violation_id":"259608535","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200983097","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:22.000000Z","updated_at":"2025-03-17T21:49:22.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9330693,"change_date":"2024-05-20 21:42:00","inspection_id":"81657575","insp_unit_id":"200983097","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"08","insp_unit_license":"BROWNO8","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GB3G3CG7F1179616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:53.000000Z","updated_at":"2025-03-17T23:19:53.000000Z"}]},{"id":5719037,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","dot_number":"1275828","report_state":"IA","report_number":"000P13J96R","insp_date":"2024-05-09 00:00:00","insp_start_time":"1900","insp_end_time":"2030","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY218 NB MM29","county_code_state":"IA","county_code":"111","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"DGZCZW","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"10","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1312344","transaction_code":"A","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01275828","upload_search_indicator":"M","census_search_date":"2024-05-10 21:38:00","snet_input_date":"2024-05-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-05-10 21:38:00","insp_carrier_name":"BOB BROWN CHEVROLET INC","insp_carrier_street":"3600 111TH ST","insp_carrier_city":"URBANDALE","insp_carrier_state":"IA","insp_carrier_zip_code":"50322","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:57.000000Z","updated_at":"2025-03-17T20:15:57.000000Z","inspection_violations":[{"id":8849035,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431605","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7RAM24050920193","created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3922"},{"id":8849036,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431606","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200830992","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"39021TB"},{"id":8849037,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431607","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200830992","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"39311"},{"id":8849038,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431608","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200830993","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"39617C"},{"id":8849039,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431609","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200830992","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"39395A"},{"id":8849040,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431610","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200830992","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"39395F"},{"id":8849041,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431611","seq_no":"7","part_no":"392","part_no_section":"7(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3927A"},{"id":8849042,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431612","seq_no":"8","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"200830993","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"39348A"},{"id":8849043,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431613","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200830993","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3963A1"},{"id":8849044,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_violation_id":"259431614","seq_no":"10","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":9211361,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_unit_id":"200830992","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"01","insp_unit_license":"KEA277","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GC2YLE77LF209018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:44.000000Z","updated_at":"2025-03-17T23:18:44.000000Z"},{"id":9211362,"change_date":"2024-05-10 21:38:00","inspection_id":"81577477","insp_unit_id":"200830993","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"01","insp_unit_license":"GS9215","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5JWGX2629LN529009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:44.000000Z","updated_at":"2025-03-17T23:18:44.000000Z"}]},{"id":2644694,"change_date":"2023-03-23 21:43:00","inspection_id":"78167188","dot_number":"1275828","report_state":"IA","report_number":"000TT6CX86","insp_date":"2023-03-22 00:00:00","insp_start_time":"1001","insp_end_time":"1042","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 4 SB\/7 WEST","county_code_state":"IA","county_code":"151","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MISC","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-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1267913","transaction_code":"A","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01275828","upload_search_indicator":"M","census_search_date":"2023-03-23 21:43:00","snet_input_date":"2023-03-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-23 21:43:00","insp_carrier_name":"BOB BROWN CHEVROLET INC","insp_carrier_street":"3600 111TH ST","insp_carrier_city":"URBANDALE","insp_carrier_state":"IA","insp_carrier_zip_code":"50322","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:30.000000Z","updated_at":"2025-03-17T19:15:30.000000Z","inspection_violations":[{"id":4065254,"change_date":"2023-03-23 21:43:00","inspection_id":"78167188","insp_violation_id":"251828715","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194026333","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4257396,"change_date":"2023-03-23 21:43:00","inspection_id":"78167188","insp_unit_id":"194026333","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"09","insp_unit_license":"BROWNO9","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HA3GTCG2KN014003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:32.000000Z","updated_at":"2025-03-17T22:36:32.000000Z"}]},{"id":1284196,"change_date":"2022-09-14 21:40:00","inspection_id":"76607885","dot_number":"1275828","report_state":"IA","report_number":"000TT6CWS5","insp_date":"2022-09-13 00:00:00","insp_start_time":"1001","insp_end_time":"1026","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 SB\/9TH AVE SW","county_code_state":"IA","county_code":"091","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MISC","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-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1241988","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01275828","upload_search_indicator":"M","census_search_date":"2022-09-14 21:40:00","snet_input_date":"2022-09-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-14 21:40:00","insp_carrier_name":"BOB BROWN CHEVROLET INC","insp_carrier_street":"3600 111TH ST","insp_carrier_city":"URBANDALE","insp_carrier_state":"IA","insp_carrier_zip_code":"50322","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:26.000000Z","updated_at":"2025-03-17T18:50:26.000000Z","inspection_violations":[{"id":2031541,"change_date":"2022-09-14 21:40:00","inspection_id":"76607885","insp_violation_id":"248407083","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"190895399","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2067047,"change_date":"2022-09-14 21:40:00","inspection_id":"76607885","insp_unit_id":"190895399","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"08","insp_unit_license":"BROWNO8","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GB3G3CG7F1179616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:11.000000Z","updated_at":"2025-03-17T22:21:11.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1275828\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1275828\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1275828\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1275828\/inspections","per_page":100,"prev_page_url":null,"to":8,"total":8}