{"current_page":1,"data":[{"id":12299706,"change_date":"2026-06-27 21:41:00","inspection_id":"88256679","dot_number":"738849","report_state":"IA","report_number":"519C000108","insp_date":"2026-06-26 00:00:00","insp_start_time":"0834","insp_end_time":"0900","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"IA","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL CHEVY","shipping_paper_number":"NORTHWEST RYDEL","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-27 21:41: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":"3630929","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":"00738849","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":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:15.000000Z","updated_at":"2026-07-08T09:30:53.000000Z","inspection_violations":[{"id":21407339,"change_date":"2026-06-27 21:41:00","inspection_id":"88256679","insp_violation_id":"275165194","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-06-30T09:58:42.000000Z","updated_at":"2026-07-08T09:41:34.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":21363641,"change_date":"2026-06-27 21:41:00","inspection_id":"88256679","insp_unit_id":"214321981","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"PAY243","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"7GZ37TCG7KN009550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:33.000000Z","updated_at":"2026-07-08T09:02:11.000000Z"}]},{"id":9204826,"change_date":"2025-07-21 21:41:00","inspection_id":"85274243","dot_number":"738849","report_state":"IA","report_number":"000P169B77","insp_date":"2025-07-18 00:00:00","insp_start_time":"0728","insp_end_time":"0741","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 SB\/250TH 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":"2025-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1368082","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2025-07-21 21:41:00","snet_input_date":"2025-07-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:31.000000Z","updated_at":"2025-07-25T10:45:31.000000Z","inspection_violations":[{"id":14877245,"change_date":"2025-07-21 21:41:00","inspection_id":"85274243","insp_violation_id":"267538700","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-07-25T10:46:54.000000Z","updated_at":"2025-07-25T10:46:54.000000Z","normalized_code":"3922SLLS2"},{"id":14877246,"change_date":"2025-07-21 21:41:00","inspection_id":"85274243","insp_violation_id":"267538701","seq_no":"2","part_no":"392","part_no_section":"2Y","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:46:54.000000Z","updated_at":"2025-07-25T10:46:54.000000Z","normalized_code":"3922Y"}],"inspection_per_units":[{"id":15132529,"change_date":"2025-07-21 21:41:00","inspection_id":"85274243","insp_unit_id":"207986057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"407","insp_unit_license":"MRC407","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD37TCGXH1903437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:35.000000Z","updated_at":"2025-07-25T09:46:03.000000Z"}]},{"id":9103833,"change_date":"2025-07-09 21:43:00","inspection_id":"85168009","dot_number":"738849","report_state":"IA","report_number":"000P15CTP0","insp_date":"2025-07-08 00:00:00","insp_start_time":"1038","insp_end_time":"1107","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-380 NB MM 49 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL","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-07-09 21:43: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":"1366718","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2025-07-09 21:43:00","snet_input_date":"2025-07-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:29.000000Z","updated_at":"2025-07-14T10:46:21.000000Z","inspection_violations":[{"id":14669997,"change_date":"2025-07-09 21:43:00","inspection_id":"85168009","insp_violation_id":"267301220","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"207782334","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-13T10:49:14.000000Z","updated_at":"2025-07-13T10:49:14.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":14944245,"change_date":"2025-07-09 21:43:00","inspection_id":"85168009","insp_unit_id":"207782334","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"1","insp_unit_license":"PME326","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"7GZ37TCG6LN006401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:56.000000Z","updated_at":"2025-07-13T09:46:28.000000Z"}]},{"id":8910192,"change_date":"2025-06-16 21:39:00","inspection_id":"84963733","dot_number":"738849","report_state":"IA","report_number":"000P15NDXG","insp_date":"2025-06-13 00:00:00","insp_start_time":"0744","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I 380","county_code_state":"IA","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL","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-06-16 21:39: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":"1364026","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:23.000000Z","updated_at":"2025-06-20T10:00:26.000000Z","inspection_violations":[{"id":14287505,"change_date":"2025-06-16 21:39:00","inspection_id":"84963733","insp_violation_id":"266866217","seq_no":"1","part_no":"392","part_no_section":"80A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0LEE25061307525","created_at":"2025-06-19T10:15:33.000000Z","updated_at":"2025-06-20T10:15:47.000000Z","normalized_code":"39280A"}],"inspection_per_units":[{"id":14598792,"change_date":"2025-06-16 21:39:00","inspection_id":"84963733","insp_unit_id":"207407241","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"1","insp_unit_license":"LIR127","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD374CG9F1167271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:35.000000Z"}]},{"id":8569065,"change_date":"2025-05-07 21:46:00","inspection_id":"84603068","dot_number":"738849","report_state":"IA","report_number":"000P14X5Q1","insp_date":"2025-05-05 00:00:00","insp_start_time":"0855","insp_end_time":"0912","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"SE DELAWARE AVE BY KARLS CHEVR","county_code_state":"IA","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL MOTOR COMPANY","shipping_paper_number":"918844P","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-07 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"10001","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":"1359180","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2025-05-07 21:46:00","snet_input_date":"2025-05-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-07 21:46:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T11:03:01.000000Z","updated_at":"2025-05-11T10:20:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13984595,"change_date":"2025-05-07 21:46:00","inspection_id":"84603068","insp_unit_id":"206738356","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"1","insp_unit_license":"PME846","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"7GZ37TCG6KN008664","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T15:26:50.000000Z","updated_at":"2025-05-11T03:54:36.000000Z"}]},{"id":8311186,"change_date":"2025-04-07 21:40:00","inspection_id":"84331372","dot_number":"738849","report_state":"IA","report_number":"000P15NDLG","insp_date":"2025-04-04 00:00:00","insp_start_time":"0755","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20","county_code_state":"IA","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL","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-04-07 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":"1355527","transaction_code":"A","transaction_date":"2025-04-07 00:00:00","upload_date":"2025-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2025-04-07 21:40:00","snet_input_date":"2025-04-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-07 21:40:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:11:21.000000Z","updated_at":"2025-04-11T10:11:21.000000Z","inspection_violations":[{"id":13075454,"change_date":"2025-04-07 21:40:00","inspection_id":"84331372","insp_violation_id":"265477039","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-04-10T10:26:49.000000Z","updated_at":"2025-04-11T10:31:21.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":13478002,"change_date":"2025-04-07 21:40:00","inspection_id":"84331372","insp_unit_id":"206186523","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"1","insp_unit_license":"LIR127","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD374CG9F1167271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-10T09:55:01.000000Z","updated_at":"2025-04-11T09:58:17.000000Z"}]},{"id":8311273,"change_date":"2025-04-07 21:40:00","inspection_id":"84331462","dot_number":"738849","report_state":"IA","report_number":"000P15NDLF","insp_date":"2025-04-04 00:00:00","insp_start_time":"0738","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20\/","county_code_state":"IA","county_code":"013","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL","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-04-07 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":"1355765","transaction_code":"A","transaction_date":"2025-04-07 00:00:00","upload_date":"2025-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2025-04-07 21:40:00","snet_input_date":"2025-04-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-07 21:40:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:11:21.000000Z","updated_at":"2025-04-11T10:11:21.000000Z","inspection_violations":[{"id":13075772,"change_date":"2025-04-07 21:40:00","inspection_id":"84331462","insp_violation_id":"265477387","seq_no":"1","part_no":"392","part_no_section":"2FC","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-10T10:27:09.000000Z","updated_at":"2025-04-11T10:31:26.000000Z","normalized_code":"3922FC"}],"inspection_per_units":[{"id":13478164,"change_date":"2025-04-07 21:40:00","inspection_id":"84331462","insp_unit_id":"206186690","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"12","insp_unit_license":"FKJ074","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD374CG1C1906581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-10T09:55:01.000000Z","updated_at":"2025-04-11T09:58:19.000000Z"}]},{"id":7759108,"change_date":"2025-01-31 21:40:00","inspection_id":"83750865","dot_number":"738849","report_state":"IA","report_number":"000P12Q7VQ","insp_date":"2025-01-30 00:00:00","insp_start_time":"0900","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 150 AND HWY 281 OELWEIN","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL CHEVROLET","shipping_paper_number":"100815W","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-01-31 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":"1347958","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2025-01-31 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-31 21:40:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:11.000000Z","updated_at":"2025-03-17T20:59:11.000000Z","inspection_violations":[{"id":12123202,"change_date":"2025-01-31 21:40:00","inspection_id":"83750865","insp_violation_id":"264280218","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-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3922SLLS2"},{"id":12123203,"change_date":"2025-01-31 21:40:00","inspection_id":"83750865","insp_violation_id":"264280219","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"205104271","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":12521387,"change_date":"2025-01-31 21:40:00","inspection_id":"83750865","insp_unit_id":"205104271","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"19","insp_unit_license":"LIR127","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD374CG9F1167271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:14.000000Z","updated_at":"2025-03-17T23:53:14.000000Z"}]},{"id":7250243,"change_date":"2024-11-22 21:41:00","inspection_id":"83215867","dot_number":"738849","report_state":"IA","report_number":"000P12Q7LC","insp_date":"2024-11-19 00:00:00","insp_start_time":"1310","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 175 AND SYCAMORE ST MORRIS","county_code_state":"IA","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL CHEVROLET","shipping_paper_number":"PATRS","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-11-21 21:41: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":"1338267","transaction_code":"C","transaction_date":"2024-11-21 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2024-11-21 21:41:00","snet_input_date":"2024-11-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-21 21:41:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:16.000000Z","updated_at":"2025-03-17T20:47:16.000000Z","inspection_violations":[{"id":11332958,"change_date":"2024-11-22 21:41:00","inspection_id":"83215867","insp_violation_id":"263044957","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-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"3922SLLS2"},{"id":11332959,"change_date":"2024-11-22 21:41:00","inspection_id":"83215867","insp_violation_id":"263044958","seq_no":"2","part_no":"392","part_no_section":"2IN","insp_viol_unit":"1","insp_unit_id":"204013837","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"3922IN"}],"inspection_per_units":[{"id":11694594,"change_date":"2024-11-22 21:41:00","inspection_id":"83215867","insp_unit_id":"204013837","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"18","insp_unit_license":"KUC548","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD37TCG6H1905573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:11.000000Z","updated_at":"2025-03-17T23:44:11.000000Z"}]},{"id":6891534,"change_date":"2024-10-04 21:40:00","inspection_id":"82835454","dot_number":"738849","report_state":"IA","report_number":"000P12Q7BP","insp_date":"2024-10-03 00:00:00","insp_start_time":"1130","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 AND BENSON SHADY JESUP","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL","shipping_paper_number":"RETURNS","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-10-04 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":"1332245","transaction_code":"A","transaction_date":"2024-10-04 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2024-10-04 21:40:00","snet_input_date":"2024-10-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-04 21:40:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:49.000000Z","updated_at":"2025-03-17T20:39:49.000000Z","inspection_violations":[{"id":10736132,"change_date":"2024-10-04 21:40:00","inspection_id":"82835454","insp_violation_id":"262193391","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":null,"created_at":"2025-03-17T21:57:59.000000Z","updated_at":"2025-03-17T21:57:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11114367,"change_date":"2024-10-04 21:40:00","inspection_id":"82835454","insp_unit_id":"203274328","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"21","insp_unit_license":"MRE367","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"7GZ37TCG8JN900669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:04.000000Z","updated_at":"2025-03-17T23:38:04.000000Z"}]},{"id":6538536,"change_date":"2024-08-22 21:42:00","inspection_id":"82459599","dot_number":"738849","report_state":"IA","report_number":"000P11H5SP","insp_date":"2024-08-22 00:00:00","insp_start_time":"0541","insp_end_time":"0545","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 AND","county_code_state":"IA","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL MOTOR","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-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1326211","transaction_code":"A","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2024-08-22 21:42:00","snet_input_date":"2024-08-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-22 21:42:00","insp_carrier_name":"RYDELL MOTOR COMPANY LLC","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:24.000000Z","updated_at":"2025-03-17T20:32:24.000000Z","inspection_violations":[{"id":10157263,"change_date":"2024-08-22 21:42:00","inspection_id":"82459599","insp_violation_id":"261349083","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202534611","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"3939A"},{"id":10157264,"change_date":"2024-08-22 21:42:00","inspection_id":"82459599","insp_violation_id":"261349084","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202534611","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"39617C"},{"id":10157265,"change_date":"2024-08-22 21:42:00","inspection_id":"82459599","insp_violation_id":"261349085","seq_no":"3","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:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"3927A"},{"id":10157266,"change_date":"2024-08-22 21:42:00","inspection_id":"82459599","insp_violation_id":"261349086","seq_no":"4","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"202534611","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":10540547,"change_date":"2024-08-22 21:42:00","inspection_id":"82459599","insp_unit_id":"202534611","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"16","insp_unit_license":"JZA564","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD37TCG8G1289969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"}]},{"id":5963433,"change_date":"2024-06-11 21:42:00","inspection_id":"81842674","dot_number":"738849","report_state":"IA","report_number":"000P1698MG","insp_date":"2024-06-07 00:00:00","insp_start_time":"0654","insp_end_time":"0717","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 SB\/250TH 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":"2024-06-11 21:42: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":"1316354","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2024-06-11 21:42:00","snet_input_date":"2024-06-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-11 21:42:00","insp_carrier_name":"RYDELL MOTOR COMPANY LLC","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:02.000000Z","updated_at":"2025-03-17T20:21:02.000000Z","inspection_violations":[{"id":9251175,"change_date":"2024-06-11 21:42:00","inspection_id":"81842674","insp_violation_id":"260021395","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":null,"created_at":"2025-03-17T21:50:45.000000Z","updated_at":"2025-03-17T21:50:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9605576,"change_date":"2024-06-11 21:42:00","inspection_id":"81842674","insp_unit_id":"201336948","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"407","insp_unit_license":"MRC407","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD37TCGXH1903437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:37.000000Z","updated_at":"2025-03-17T23:22:37.000000Z"}]},{"id":5710000,"change_date":"2024-05-09 21:42:00","inspection_id":"81567700","dot_number":"738849","report_state":"IA","report_number":"000P12Q723","insp_date":"2024-05-08 00:00:00","insp_start_time":"0940","insp_end_time":"1005","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 AND EAGLE DR MARQUETTE","county_code_state":"IA","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL CHEVROLET","shipping_paper_number":"881705P","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-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"1312137","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2024-05-09 21:42:00","snet_input_date":"2024-05-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:53.000000Z","updated_at":"2025-03-17T20:15:53.000000Z","inspection_violations":[{"id":8833705,"change_date":"2024-05-09 21:42:00","inspection_id":"81567700","insp_violation_id":"259409227","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200812569","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"39021TB"},{"id":8833706,"change_date":"2024-05-09 21:42:00","inspection_id":"81567700","insp_violation_id":"259409228","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200812569","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9196916,"change_date":"2024-05-09 21:42:00","inspection_id":"81567700","insp_unit_id":"200812569","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"21","insp_unit_license":"MRE367","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"7GZ37TCG8JN900669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"}]},{"id":5586977,"change_date":"2024-04-24 21:41:00","inspection_id":"81433729","dot_number":"738849","report_state":"IA","report_number":"000P1698H3","insp_date":"2024-04-23 00:00:00","insp_start_time":"0835","insp_end_time":"0906","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 69 NB\/280TH ST","county_code_state":"IA","county_code":"197","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":"2024-04-24 21:41: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":"1310494","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2024-04-24 21:41:00","snet_input_date":"2024-04-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"RYDELL MOTOR COMPANY LLC","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:29.000000Z","updated_at":"2025-03-17T20:13:29.000000Z","inspection_violations":[{"id":8636603,"change_date":"2024-04-24 21:41:00","inspection_id":"81433729","insp_violation_id":"259108504","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":null,"created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8999285,"change_date":"2024-04-24 21:41:00","inspection_id":"81433729","insp_unit_id":"200552041","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"548","insp_unit_license":"KUC548","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD37TCG6H1905573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:43.000000Z","updated_at":"2025-03-17T23:16:43.000000Z"}]},{"id":4942536,"change_date":"2024-01-31 21:42:00","inspection_id":"80730344","dot_number":"738849","report_state":"IA","report_number":"000P14WRG9","insp_date":"2024-01-30 00:00:00","insp_start_time":"0904","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 69 NB 155 MM","county_code_state":"IA","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL CHEVROLET INC","shipping_paper_number":"84620W","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-01-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1301255","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2024-01-31 21:42:00","snet_input_date":"2024-01-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-01-31 21:42:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:47.000000Z","updated_at":"2025-03-17T20:00:47.000000Z","inspection_violations":[{"id":7611974,"change_date":"2024-01-31 21:42:00","inspection_id":"80730344","insp_violation_id":"257583592","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199194718","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"3939A"},{"id":7611975,"change_date":"2024-01-31 21:42:00","inspection_id":"80730344","insp_violation_id":"257583593","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199194718","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7954028,"change_date":"2024-01-31 21:42:00","inspection_id":"80730344","insp_unit_id":"199194718","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"18","insp_unit_license":"KUC548","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD37TCG6H1905573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:05.000000Z","updated_at":"2025-03-17T23:07:05.000000Z"}]},{"id":4770558,"change_date":"2024-01-05 21:45:00","inspection_id":"80542247","dot_number":"738849","report_state":"WI","report_number":"2690002646","insp_date":"2024-01-05 00:00:00","insp_start_time":"0817","insp_end_time":"0837","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"PRAIRIE DU CHIEN WI","county_code_state":"WI","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-05 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"2","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":"159731","transaction_code":"A","transaction_date":"2024-01-05 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":null,"census_search_date":"2024-01-05 21:45:00","snet_input_date":"2024-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-05 21:45:00","insp_carrier_name":"RYDELL MOTOR COMPANY LLC","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:16.000000Z","updated_at":"2025-03-17T19:57:16.000000Z","inspection_violations":[{"id":7361964,"change_date":"2024-01-05 21:45:00","inspection_id":"80542247","insp_violation_id":"257202055","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"198828345","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"39021TB2DOT"},{"id":7361965,"change_date":"2024-01-05 21:45:00","inspection_id":"80542247","insp_violation_id":"257202056","seq_no":"2","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:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7674420,"change_date":"2024-01-05 21:45:00","inspection_id":"80542247","insp_unit_id":"198828345","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"MRE367","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"7GZ37TCG8JN900669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:35.000000Z","updated_at":"2025-03-17T23:04:35.000000Z"}]},{"id":4685208,"change_date":"2023-12-21 21:39:00","inspection_id":"80449425","dot_number":"738849","report_state":"IA","report_number":"000P16983X","insp_date":"2023-12-12 00:00:00","insp_start_time":"0851","insp_end_time":"0907","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 69 NB\/305TH ST","county_code_state":"IA","county_code":"197","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":"2023-12-21 21:39: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":"1297078","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2023-12-21 21:39:00","snet_input_date":"2023-12-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-21 21:39:00","insp_carrier_name":"RYDELL MOTOR COMPANY LLC","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:45.000000Z","updated_at":"2025-03-17T19:55:45.000000Z","inspection_violations":[{"id":7239731,"change_date":"2023-12-21 21:39:00","inspection_id":"80449425","insp_violation_id":"257012161","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:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"3922"},{"id":7239732,"change_date":"2023-12-21 21:39:00","inspection_id":"80449425","insp_violation_id":"257012162","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198623733","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7535800,"change_date":"2023-12-21 21:39:00","inspection_id":"80449425","insp_unit_id":"198623733","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"548","insp_unit_license":"KUC548","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD37TCG6H1905573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:23.000000Z","updated_at":"2025-03-17T23:03:23.000000Z"}]},{"id":4351457,"change_date":"2023-11-03 21:41:00","inspection_id":"80081942","dot_number":"738849","report_state":"IA","report_number":"000TT5MLZC","insp_date":"2023-11-01 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US65S-MM84","county_code_state":"IA","county_code":"153","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-03 21:41: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":"1293069","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2023-11-03 21:41:00","snet_input_date":"2023-11-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-11-03 21:41:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:08.000000Z","updated_at":"2025-03-17T19:49:08.000000Z","inspection_violations":[{"id":6730480,"change_date":"2023-11-03 21:41:00","inspection_id":"80081942","insp_violation_id":"256210542","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197899616","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3922"},{"id":6730481,"change_date":"2023-11-03 21:41:00","inspection_id":"80081942","insp_violation_id":"256210543","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197899616","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3922"},{"id":6730482,"change_date":"2023-11-03 21:41:00","inspection_id":"80081942","insp_violation_id":"256210544","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197899616","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6998081,"change_date":"2023-11-03 21:41:00","inspection_id":"80081942","insp_unit_id":"197899616","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"GTC213","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD374CG1C1900389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:44.000000Z","updated_at":"2025-03-17T22:58:44.000000Z"}]},{"id":2512074,"change_date":"2023-03-06 21:40:00","inspection_id":"78016544","dot_number":"738849","report_state":"IA","report_number":"000TT66VDX","insp_date":"2023-03-02 00:00:00","insp_start_time":"1006","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 65 NB 176 MM SHEFFIELD","county_code_state":"IA","county_code":"069","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RYDELL CHEVROLET INC","shipping_paper_number":"66715W","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-06 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":"1265181","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2023-03-06 21:40:00","snet_input_date":"2023-03-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:57.000000Z","updated_at":"2025-03-17T19:12:57.000000Z","inspection_violations":[{"id":3862789,"change_date":"2023-03-06 21:40:00","inspection_id":"78016544","insp_violation_id":"251492423","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:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4043067,"change_date":"2023-03-06 21:40:00","inspection_id":"78016544","insp_unit_id":"193721652","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"18","insp_unit_license":"KUC548","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD37TCG6H1905573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:58.000000Z","updated_at":"2025-03-17T22:34:58.000000Z"}]},{"id":1995968,"change_date":"2022-12-21 21:39:00","inspection_id":"77427545","dot_number":"738849","report_state":"IA","report_number":"000TT88HZL","insp_date":"2022-12-20 00:00:00","insp_start_time":"1441","insp_end_time":"1453","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY218 SB\/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":"KAHLER COLLISION CENTER","shipping_paper_number":"822966P","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-12-21 21:39: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":"1255812","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2022-12-21 21:39:00","snet_input_date":"2022-12-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-12-21 21:39:00","insp_carrier_name":"RYDELL MOTOR COMPANY LLC","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:21.000000Z","updated_at":"2025-03-17T19:03:21.000000Z","inspection_violations":[{"id":3097389,"change_date":"2022-12-21 21:39:00","inspection_id":"77427545","insp_violation_id":"250218902","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T28722122014523","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":3211099,"change_date":"2022-12-21 21:39:00","inspection_id":"77427545","insp_unit_id":"192537860","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"01","insp_unit_license":"HWL591","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GDJG31K881903967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:00.000000Z","updated_at":"2025-03-17T22:29:00.000000Z"}]},{"id":1344170,"change_date":"2022-09-22 21:40:00","inspection_id":"76678109","dot_number":"738849","report_state":"IA","report_number":"000TT6CWSF","insp_date":"2022-09-19 00:00:00","insp_start_time":"1044","insp_end_time":"1117","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 69 SB\/230TH ST","county_code_state":"IA","county_code":"197","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-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1243333","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2022-09-22 21:40:00","snet_input_date":"2022-09-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-22 21:40:00","insp_carrier_name":"RYDELL MOTOR COMPANY LLC","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:36.000000Z","updated_at":"2025-03-17T18:51:36.000000Z","inspection_violations":[{"id":2128948,"change_date":"2022-09-22 21:40:00","inspection_id":"76678109","insp_violation_id":"248584967","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191042966","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"39395A"},{"id":2128949,"change_date":"2022-09-22 21:40:00","inspection_id":"76678109","insp_violation_id":"248584968","seq_no":"2","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"191042966","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":2164265,"change_date":"2022-09-22 21:40:00","inspection_id":"76678109","insp_unit_id":"191042966","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"48","insp_unit_license":"KUC548","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD37TCG6H1905573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:48.000000Z","updated_at":"2025-03-17T22:21:48.000000Z"}]},{"id":670121,"change_date":"2022-06-22 21:40:00","inspection_id":"75891307","dot_number":"738849","report_state":"IA","report_number":"000TT6JGNB","insp_date":"2022-06-21 00:00:00","insp_start_time":"0755","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"22ND AVE TRAIL","county_code_state":"IA","county_code":"011","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"802002P","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-06-22 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":"1230295","transaction_code":"A","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00738849","upload_search_indicator":"M","census_search_date":"2022-06-22 21:40:00","snet_input_date":"2022-06-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-22 21:40:00","insp_carrier_name":"RYDELL CHEVROLET","insp_carrier_street":"1325 E SAN MARNAN DR","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50702","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:31.000000Z","updated_at":"2025-03-17T18:39:31.000000Z","inspection_violations":[{"id":1054766,"change_date":"2022-06-22 21:40:00","inspection_id":"75891307","insp_violation_id":"246647792","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":"T31622062108001","created_at":"2025-03-17T21:11:56.000000Z","updated_at":"2025-03-17T21:11:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1076912,"change_date":"2022-06-22 21:40:00","inspection_id":"75891307","insp_unit_id":"189402734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"6","insp_unit_license":"HCX323","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GD374CG4C1905196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:49.000000Z","updated_at":"2025-03-17T22:14:49.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/738849\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/738849\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/738849\/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\/738849\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}