{"current_page":1,"data":[{"id":10839628,"change_date":"2026-01-22 21:40:00","inspection_id":"86868057","dot_number":"1233854","report_state":"TX","report_number":"V262197876","insp_date":"2026-01-20 00:00:00","insp_start_time":"0929","insp_end_time":"0949","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 277 MM 586 NB","county_code_state":"TX","county_code":"323","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRAVO DIESEL SERVICES","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"9826666","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2026-01-22 21:40:00","snet_input_date":"2026-01-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-22 21:40:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2026-01-25T10:37:06.000000Z","updated_at":"2026-02-02T10:31:03.000000Z","inspection_violations":[{"id":18128939,"change_date":"2026-01-22 21:40:00","inspection_id":"86868057","insp_violation_id":"271378147","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211246983","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:43:02.000000Z","updated_at":"2026-02-02T10:37:57.000000Z","normalized_code":"3939"},{"id":18128937,"change_date":"2026-01-22 21:40:00","inspection_id":"86868057","insp_violation_id":"271378145","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"211246983","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:43:02.000000Z","updated_at":"2026-02-02T10:37:57.000000Z","normalized_code":"393209E"},{"id":18128938,"change_date":"2026-01-22 21:40:00","inspection_id":"86868057","insp_violation_id":"271378146","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211246983","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:43:02.000000Z","updated_at":"2026-02-02T10:37:57.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":18211254,"change_date":"2026-01-22 21:40:00","inspection_id":"86868057","insp_unit_id":"211246983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"WKL2171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:24.000000Z","updated_at":"2026-02-02T10:03:40.000000Z"}]},{"id":10600285,"change_date":"2026-01-08 21:40:00","inspection_id":"86739618","dot_number":"1233854","report_state":"TX","report_number":"7BZB9DUN2H","insp_date":"2026-01-07 00:00:00","insp_start_time":"1104","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-0130 IN TRAVIS CO. (426-461","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"9810563","transaction_code":"A","transaction_date":"2026-01-08 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2026-01-08 21:40:00","snet_input_date":"2026-01-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2026-01-11T10:34:45.000000Z","updated_at":"2026-01-19T10:30:49.000000Z","inspection_violations":[{"id":17820267,"change_date":"2026-01-08 21:40:00","inspection_id":"86739618","insp_violation_id":"271089164","seq_no":"1","part_no":"393","part_no_section":"207A","insp_viol_unit":"2","insp_unit_id":"210979914","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:22.000000Z","updated_at":"2026-01-19T10:31:31.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":17771272,"change_date":"2026-01-08 21:40:00","inspection_id":"86739618","insp_unit_id":"210979913","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1L05493","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X97D672663","insp_unit_decal":"Y","insp_unit_decal_number":"35976367","created_at":"2026-01-11T10:06:14.000000Z","updated_at":"2026-01-19T10:00:59.000000Z"},{"id":17771273,"change_date":"2026-01-08 21:40:00","inspection_id":"86739618","insp_unit_id":"210979914","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"X54190","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432881032857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:14.000000Z","updated_at":"2026-01-19T10:00:59.000000Z"}]},{"id":10318377,"change_date":"2025-12-01 21:39:00","inspection_id":"86445033","dot_number":"1233854","report_state":"TX","report_number":"V252122894","insp_date":"2025-11-26 00:00:00","insp_start_time":"0800","insp_end_time":"0846","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH35 NB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BIG STAR TRUCKING","shipping_paper_number":"159479","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":"Y","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9771367","transaction_code":"A","transaction_date":"2025-12-01 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-12-04T10:30:37.000000Z","updated_at":"2025-12-05T10:31:10.000000Z","inspection_violations":[{"id":17261215,"change_date":"2025-12-01 21:39:00","inspection_id":"86445033","insp_violation_id":"270371751","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210332454","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:31:01.000000Z","updated_at":"2025-12-05T10:31:46.000000Z","normalized_code":"39347E"},{"id":17261216,"change_date":"2025-12-01 21:39:00","inspection_id":"86445033","insp_violation_id":"270371752","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"210332454","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:31:01.000000Z","updated_at":"2025-12-05T10:31:46.000000Z","normalized_code":"39353B"},{"id":17261217,"change_date":"2025-12-01 21:39:00","inspection_id":"86445033","insp_violation_id":"270371753","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"210332454","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-12-04T10:31:01.000000Z","updated_at":"2025-12-05T10:31:46.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":17232265,"change_date":"2025-12-01 21:39:00","inspection_id":"86445033","insp_unit_id":"210332454","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"112","insp_unit_license":"PLB6940","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X1MM767030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:38.000000Z","updated_at":"2025-12-05T10:01:26.000000Z"}]},{"id":10298364,"change_date":"2025-11-26 21:38:00","inspection_id":"86423960","dot_number":"1233854","report_state":"TX","report_number":"V252080369","insp_date":"2025-11-24 00:00:00","insp_start_time":"0740","insp_end_time":"0808","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"634M TX16","county_code_state":"TX","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COMPANY YARD","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":"Y","pen_cen_match":null,"final_status_date":"2025-11-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9770234","transaction_code":"A","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2025-11-26 21:38:00","snet_input_date":"2025-11-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-26 21:38:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-11-29T10:31:41.000000Z","updated_at":"2025-11-30T10:31:08.000000Z","inspection_violations":[{"id":17224658,"change_date":"2025-11-26 21:38:00","inspection_id":"86423960","insp_violation_id":"270323391","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"210288617","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-11-29T10:32:43.000000Z","updated_at":"2025-11-30T10:31:44.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":17196452,"change_date":"2025-11-26 21:38:00","inspection_id":"86423960","insp_unit_id":"210288617","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"119","insp_unit_license":"NLH1912","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NP3LJ0X9MD708634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-29T10:01:44.000000Z","updated_at":"2025-11-30T10:01:20.000000Z"}]},{"id":10108349,"change_date":"2025-11-03 21:39:00","inspection_id":"86224291","dot_number":"1233854","report_state":"TX","report_number":"7A179DNBKY","insp_date":"2025-10-29 00:00:00","insp_start_time":"0737","insp_end_time":"0817","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN WILLIAMSON CO. (252","county_code_state":"TX","county_code":"491","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APPROVED OIL","shipping_paper_number":"16355","cargo_tank":"407","hazmat_placard_req":"Y","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":"Y","pen_cen_match":null,"final_status_date":"2025-11-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"9744320","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2025-11-03 21:39:00","snet_input_date":"2025-10-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-11-06T10:30:44.000000Z","updated_at":"2025-11-07T10:30:54.000000Z","inspection_violations":[{"id":16752027,"change_date":"2025-11-03 21:39:00","inspection_id":"86224291","insp_violation_id":"269696626","seq_no":"1","part_no":"172","part_no_section":"519","insp_viol_unit":"2","insp_unit_id":"209809418","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"172519"},{"id":16752028,"change_date":"2025-11-03 21:39:00","inspection_id":"86224291","insp_violation_id":"269696627","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"209809417","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"3965B"},{"id":16752029,"change_date":"2025-11-03 21:39:00","inspection_id":"86224291","insp_violation_id":"269696628","seq_no":"3","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"209809418","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":16810390,"change_date":"2025-11-03 21:39:00","inspection_id":"86224291","insp_unit_id":"209809417","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1L05493","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X97D672663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:39.000000Z","updated_at":"2025-11-07T10:01:10.000000Z"},{"id":16810391,"change_date":"2025-11-03 21:39:00","inspection_id":"86224291","insp_unit_id":"209809418","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"X54190","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432881032857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:39.000000Z","updated_at":"2025-11-07T10:01:10.000000Z"}]},{"id":9655897,"change_date":"2025-09-11 21:41:00","inspection_id":"85749768","dot_number":"1233854","report_state":"TX","report_number":"V252014522","insp_date":"2025-09-08 00:00:00","insp_start_time":"0946","insp_end_time":"0958","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1138 US281","county_code_state":"TX","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APPROVED OIL SERVICES","shipping_paper_number":"17303","cargo_tank":"412","hazmat_placard_req":"Y","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":"Y","pen_cen_match":null,"final_status_date":"2025-09-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100500","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":"9693438","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2025-09-11 21:41:00","snet_input_date":"2025-09-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-11 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-09-13T10:48:02.000000Z","updated_at":"2025-09-16T10:47:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15956353,"change_date":"2025-09-11 21:41:00","inspection_id":"85749768","insp_unit_id":"208878886","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"102","insp_unit_license":"1L05493","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X97D672663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:40.000000Z","updated_at":"2025-09-15T09:53:33.000000Z"},{"id":15956354,"change_date":"2025-09-11 21:41:00","inspection_id":"85749768","insp_unit_id":"208878887","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"X54190","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432881032857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:40.000000Z","updated_at":"2025-09-15T09:53:33.000000Z"}]},{"id":8933564,"change_date":"2025-06-18 21:41:00","inspection_id":"84988867","dot_number":"1233854","report_state":"TX","report_number":"V251916755","insp_date":"2025-06-16 00:00:00","insp_start_time":"0515","insp_end_time":"0536","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600 US281","county_code_state":"TX","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APAC","shipping_paper_number":"NONE","cargo_tank":"406","hazmat_placard_req":"Y","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":"Y","pen_cen_match":null,"final_status_date":"2025-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"9610561","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":"01233854","upload_search_indicator":"M","census_search_date":"2025-06-18 21:41:00","snet_input_date":"2025-06-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-18 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-06-22T10:01:07.000000Z","updated_at":"2025-06-22T10:01:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14641038,"change_date":"2025-06-18 21:41:00","inspection_id":"84988867","insp_unit_id":"207454258","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"103","insp_unit_license":"1L06100","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPWD49X3ED241099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:22.000000Z","updated_at":"2025-06-22T09:46:22.000000Z"},{"id":14641039,"change_date":"2025-06-18 21:41:00","inspection_id":"84988867","insp_unit_id":"207454259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"602","insp_unit_license":"X52195","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432681032985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-22T09:46:22.000000Z","updated_at":"2025-06-22T09:46:22.000000Z"}]},{"id":8760504,"change_date":"2025-05-28 21:44:00","inspection_id":"84804843","dot_number":"1233854","report_state":"TX","report_number":"V251890315","insp_date":"2025-05-21 00:00:00","insp_start_time":"0700","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"UPPER VALLEY MATERIALS","shipping_paper_number":"17053","cargo_tank":"407","hazmat_placard_req":"Y","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":"Y","pen_cen_match":null,"final_status_date":"2025-05-28 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"9592063","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2025-05-28 21:44:00","snet_input_date":"2025-05-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-28 21:44:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-05-31T10:01:40.000000Z","updated_at":"2025-06-01T10:01:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14329310,"change_date":"2025-05-28 21:44:00","inspection_id":"84804843","insp_unit_id":"207113714","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"602","insp_unit_license":"X52195","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432681032985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:55.000000Z","updated_at":"2025-06-01T09:47:55.000000Z"},{"id":14329311,"change_date":"2025-05-28 21:44:00","inspection_id":"84804843","insp_unit_id":"207113715","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"103","insp_unit_license":"1L06100","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPWD49X3ED241099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:55.000000Z","updated_at":"2025-06-01T09:47:55.000000Z"}]},{"id":8715860,"change_date":"2025-05-22 21:43:00","inspection_id":"84757601","dot_number":"1233854","report_state":"TX","report_number":"V251888657","insp_date":"2025-05-20 00:00:00","insp_start_time":"0619","insp_end_time":"0651","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10603  US281","county_code_state":"TX","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","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":"Y","pen_cen_match":null,"final_status_date":"2025-05-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9587610","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2025-05-22 21:43:00","snet_input_date":"2025-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-22 21:43:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-05-25T10:06:08.000000Z","updated_at":"2025-05-26T10:06:49.000000Z","inspection_violations":[{"id":13902732,"change_date":"2025-05-22 21:43:00","inspection_id":"84757601","insp_violation_id":"266427581","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"207024170","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:28:41.000000Z","updated_at":"2025-05-26T10:28:08.000000Z","normalized_code":"3965B"},{"id":13902733,"change_date":"2025-05-22 21:43:00","inspection_id":"84757601","insp_violation_id":"266427582","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"207024170","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:28:41.000000Z","updated_at":"2025-05-26T10:28:08.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":14246803,"change_date":"2025-05-22 21:43:00","inspection_id":"84757601","insp_unit_id":"207024170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BZ73722","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LN0X1CM172228","insp_unit_decal":"Y","insp_unit_decal_number":"35126783","created_at":"2025-05-25T09:51:05.000000Z","updated_at":"2025-05-26T09:52:08.000000Z"}]},{"id":8632986,"change_date":"2025-05-14 21:42:00","inspection_id":"84670177","dot_number":"1233854","report_state":"TX","report_number":"V251796308","insp_date":"2025-05-13 00:00:00","insp_start_time":"0603","insp_end_time":"0655","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH10 EB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":"407","hazmat_placard_req":"Y","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":"Y","pen_cen_match":null,"final_status_date":"2025-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2","hazmat_oos_total":"0","snet_sequence_id":"9578418","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2025-05-14 21:42:00","snet_input_date":"2025-05-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-05-17T10:05:23.000000Z","updated_at":"2025-05-18T10:06:21.000000Z","inspection_violations":[{"id":13728891,"change_date":"2025-05-14 21:42:00","inspection_id":"84670177","insp_violation_id":"266223833","seq_no":"1","part_no":"172","part_no_section":"519","insp_viol_unit":"2","insp_unit_id":"206859278","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:28.000000Z","updated_at":"2025-05-18T10:34:06.000000Z","normalized_code":"172519"},{"id":13728892,"change_date":"2025-05-14 21:42:00","inspection_id":"84670177","insp_violation_id":"266223834","seq_no":"2","part_no":"178","part_no_section":"345-7D4","insp_viol_unit":"2","insp_unit_id":"206859278","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:28.000000Z","updated_at":"2025-05-18T10:34:06.000000Z","normalized_code":"1783457D4"}],"inspection_per_units":[{"id":14096796,"change_date":"2025-05-14 21:42:00","inspection_id":"84670177","insp_unit_id":"206859278","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"613","insp_unit_license":"X54190","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432881032857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:19.000000Z","updated_at":"2025-05-18T09:51:57.000000Z"},{"id":14096795,"change_date":"2025-05-14 21:42:00","inspection_id":"84670177","insp_unit_id":"206859277","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"102","insp_unit_license":"1L05493","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X97D672663","insp_unit_decal":"Y","insp_unit_decal_number":"35123577","created_at":"2025-05-17T09:49:19.000000Z","updated_at":"2025-05-18T09:51:57.000000Z"}]},{"id":8242606,"change_date":"2025-03-28 21:41:00","inspection_id":"84259142","dot_number":"1233854","report_state":"TX","report_number":"V251810182","insp_date":"2025-03-11 00:00:00","insp_start_time":"1120","insp_end_time":"1214","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH35 SB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ASPHALT INC","shipping_paper_number":"16925","cargo_tank":"407","hazmat_placard_req":"Y","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":"Y","pen_cen_match":null,"final_status_date":"2025-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9535637","transaction_code":"A","transaction_date":"2025-03-28 00:00:00","upload_date":"2025-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2025-03-28 21:41:00","snet_input_date":"2025-03-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-28 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-31T10:32:59.000000Z","updated_at":"2025-04-01T10:14:32.000000Z","inspection_violations":[{"id":12941111,"change_date":"2025-03-28 21:41:00","inspection_id":"84259142","insp_violation_id":"265326568","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"206055065","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-31T11:16:32.000000Z","updated_at":"2025-03-31T11:25:46.000000Z","normalized_code":"39345"},{"id":12941112,"change_date":"2025-03-28 21:41:00","inspection_id":"84259142","insp_violation_id":"265326569","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"206055065","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:16:32.000000Z","updated_at":"2025-03-31T11:25:46.000000Z","normalized_code":"39345B2UV"},{"id":12941113,"change_date":"2025-03-28 21:41:00","inspection_id":"84259142","insp_violation_id":"265326570","seq_no":"3","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"2","insp_unit_id":"206055065","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:16:32.000000Z","updated_at":"2025-03-31T11:25:46.000000Z","normalized_code":"3963A1B"},{"id":12941114,"change_date":"2025-03-28 21:41:00","inspection_id":"84259142","insp_violation_id":"265326571","seq_no":"4","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"206055064","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:16:32.000000Z","updated_at":"2025-03-31T11:25:46.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":13335768,"change_date":"2025-03-28 21:41:00","inspection_id":"84259142","insp_unit_id":"206055064","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"105","insp_unit_license":"1L06102","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X15D826036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-31T10:24:05.000000Z","updated_at":"2025-04-01T10:04:41.000000Z"},{"id":13335769,"change_date":"2025-03-28 21:41:00","inspection_id":"84259142","insp_unit_id":"206055065","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"609","insp_unit_license":"W19608","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432251028072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-31T10:24:05.000000Z","updated_at":"2025-04-01T10:04:41.000000Z"}]},{"id":8137867,"change_date":"2025-03-17 21:41:00","inspection_id":"84149094","dot_number":"1233854","report_state":"TX","report_number":"V251765361","insp_date":"2025-03-10 00:00:00","insp_start_time":"1124","insp_end_time":"1231","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A401","location_desc":"IH35 SB SAN MARCOS SCALE","county_code_state":"TX","county_code":"209","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"APPRAVED OIL SERVICE","shipping_paper_number":"16126","cargo_tank":"407","hazmat_placard_req":"Y","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":"Y","pen_cen_match":null,"final_status_date":"2025-03-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"9525038","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2025-03-17 21:41:00","snet_input_date":"2025-03-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-17 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-21T10:23:44.000000Z","updated_at":"2025-03-21T10:23:44.000000Z","inspection_violations":[{"id":12731513,"change_date":"2025-03-17 21:41:00","inspection_id":"84149094","insp_violation_id":"265087846","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205843823","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:48:23.000000Z","updated_at":"2025-03-21T10:57:32.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":13141841,"change_date":"2025-03-17 21:41:00","inspection_id":"84149094","insp_unit_id":"205843823","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"102","insp_unit_license":"1L05493","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X97D672663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:58:11.000000Z","updated_at":"2025-03-21T10:08:56.000000Z"},{"id":13141842,"change_date":"2025-03-17 21:41:00","inspection_id":"84149094","insp_unit_id":"205843824","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"613","insp_unit_license":"X54190","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432881032857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:58:11.000000Z","updated_at":"2025-03-21T10:08:56.000000Z"}]},{"id":7004564,"change_date":"2024-10-21 21:41:00","inspection_id":"82955742","dot_number":"1233854","report_state":"TX","report_number":"V241645862","insp_date":"2024-10-17 00:00:00","insp_start_time":"0804","insp_end_time":"0833","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US281 NB","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"STANDARD ENVIORNMENTAL","shipping_paper_number":"152322","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":"Y","pen_cen_match":null,"final_status_date":"2024-10-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9407371","transaction_code":"A","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2024-10-21 21:41:00","snet_input_date":"2024-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-21 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T20:42:14.000000Z","updated_at":"2025-03-17T20:42:14.000000Z","inspection_violations":[{"id":10929795,"change_date":"2024-10-21 21:41:00","inspection_id":"82955742","insp_violation_id":"262463641","seq_no":"1","part_no":"393","part_no_section":"207A","insp_viol_unit":"2","insp_unit_id":"203505629","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"393207A"},{"id":10929796,"change_date":"2024-10-21 21:41:00","inspection_id":"82955742","insp_violation_id":"262463642","seq_no":"2","part_no":"393","part_no_section":"43A","insp_viol_unit":"1","insp_unit_id":"203505628","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"39343A"},{"id":10929797,"change_date":"2024-10-21 21:41:00","inspection_id":"82955742","insp_violation_id":"262463643","seq_no":"3","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"203505628","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11298246,"change_date":"2024-10-21 21:41:00","inspection_id":"82955742","insp_unit_id":"203505628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"103","insp_unit_license":"1L06100","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPWD49X3ED241099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:58.000000Z","updated_at":"2025-03-17T23:39:58.000000Z"},{"id":11298247,"change_date":"2024-10-21 21:41:00","inspection_id":"82955742","insp_unit_id":"203505629","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"602","insp_unit_license":"X52195","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432681032985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:58.000000Z","updated_at":"2025-03-17T23:39:58.000000Z"}]},{"id":7040166,"change_date":"2024-10-24 21:42:00","inspection_id":"82993477","dot_number":"1233854","report_state":"TX","report_number":"V241640862","insp_date":"2024-10-17 00:00:00","insp_start_time":"1259","insp_end_time":"1329","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 MM 59","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"153717","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":"Y","pen_cen_match":null,"final_status_date":"2024-10-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"9411149","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2024-10-24 21:42:00","snet_input_date":"2024-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-24 21:42:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T20:42:58.000000Z","updated_at":"2025-03-17T20:42:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11354230,"change_date":"2024-10-24 21:42:00","inspection_id":"82993477","insp_unit_id":"203576493","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"}]},{"id":6854665,"change_date":"2024-09-30 21:41:00","inspection_id":"82796284","dot_number":"1233854","report_state":"TX","report_number":"V241559100","insp_date":"2024-09-27 00:00:00","insp_start_time":"1122","insp_end_time":"1156","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH35 NB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUPER LUBE OF PEARSALL","shipping_paper_number":"152641","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":"Y","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9389628","transaction_code":"A","transaction_date":"2024-09-30 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T20:39:01.000000Z","updated_at":"2025-03-17T20:39:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11054271,"change_date":"2024-09-30 21:41:00","inspection_id":"82796284","insp_unit_id":"203199211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"}]},{"id":6738615,"change_date":"2024-09-16 21:43:00","inspection_id":"82672647","dot_number":"1233854","report_state":"TX","report_number":"V241527859","insp_date":"2024-09-13 00:00:00","insp_start_time":"1118","insp_end_time":"1139","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 281 NB IN ENCINO","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"STANDARD ENVIRONMENTAL SERVIC","shipping_paper_number":"153503","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":"Y","pen_cen_match":null,"final_status_date":"2024-09-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9378201","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2024-09-16 21:43:00","snet_input_date":"2024-09-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-16 21:43:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T20:36:34.000000Z","updated_at":"2025-03-17T20:36:34.000000Z","inspection_violations":[{"id":10493052,"change_date":"2024-09-16 21:43:00","inspection_id":"82672647","insp_violation_id":"261833366","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"202950899","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"39375A"},{"id":10493053,"change_date":"2024-09-16 21:43:00","inspection_id":"82672647","insp_violation_id":"261833367","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202950898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"3939A"},{"id":10493054,"change_date":"2024-09-16 21:43:00","inspection_id":"82672647","insp_violation_id":"261833368","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202950898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10866241,"change_date":"2024-09-16 21:43:00","inspection_id":"82672647","insp_unit_id":"202950898","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"105","insp_unit_license":"1L06102","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X15D826036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:34.000000Z","updated_at":"2025-03-17T23:35:34.000000Z"},{"id":10866242,"change_date":"2024-09-16 21:43:00","inspection_id":"82672647","insp_unit_id":"202950899","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"-","insp_unit_license":"W19608","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432251028072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:34.000000Z","updated_at":"2025-03-17T23:35:34.000000Z"}]},{"id":6505500,"change_date":"2024-08-19 21:42:00","inspection_id":"82424564","dot_number":"1233854","report_state":"TX","report_number":"V241509439","insp_date":"2024-08-14 00:00:00","insp_start_time":"1035","insp_end_time":"1104","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A305","location_desc":"US59 NB FANNIN SCALE","county_code_state":"TX","county_code":"175","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUPERIOR AUTO SALES","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":"Y","pen_cen_match":null,"final_status_date":"2024-08-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"9353561","transaction_code":"A","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2024-08-19 21:42:00","snet_input_date":"2024-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-19 21:42:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T20:31:57.000000Z","updated_at":"2025-03-17T20:31:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10486718,"change_date":"2024-08-19 21:42:00","inspection_id":"82424564","insp_unit_id":"202468462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:38.000000Z","updated_at":"2025-03-17T23:31:38.000000Z"}]},{"id":6432979,"change_date":"2024-08-09 21:38:00","inspection_id":"82347131","dot_number":"1233854","report_state":"TX","report_number":"V241502463","insp_date":"2024-08-08 00:00:00","insp_start_time":"1333","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 MM 59","county_code_state":"TX","county_code":"283","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APPROVED OIL SERVICES","shipping_paper_number":"151261","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":"Y","pen_cen_match":null,"final_status_date":"2024-08-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9346524","transaction_code":"A","transaction_date":"2024-08-09 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2024-08-09 21:38:00","snet_input_date":"2024-08-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T20:30:19.000000Z","updated_at":"2025-03-17T20:30:19.000000Z","inspection_violations":[{"id":9990287,"change_date":"2024-08-09 21:38:00","inspection_id":"82347131","insp_violation_id":"261115685","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202322450","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39345B2"},{"id":9990288,"change_date":"2024-08-09 21:38:00","inspection_id":"82347131","insp_violation_id":"261115686","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"202322450","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39348A"},{"id":9990289,"change_date":"2024-08-09 21:38:00","inspection_id":"82347131","insp_violation_id":"261115687","seq_no":"3","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"202322450","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39383G"},{"id":9990290,"change_date":"2024-08-09 21:38:00","inspection_id":"82347131","insp_violation_id":"261115688","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"202322450","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":10367974,"change_date":"2024-08-09 21:38:00","inspection_id":"82347131","insp_unit_id":"202322450","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:27.000000Z","updated_at":"2025-03-17T23:30:27.000000Z"}]},{"id":5976249,"change_date":"2024-06-12 21:42:00","inspection_id":"81856734","dot_number":"1233854","report_state":"TX","report_number":"V241415304","insp_date":"2024-06-07 00:00:00","insp_start_time":"0943","insp_end_time":"0953","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"220 MCFARLAND N ST","county_code_state":"TX","county_code":"265","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"EMPTY","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":"Y","pen_cen_match":null,"final_status_date":"2024-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9298643","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2024-06-12 21:42:00","snet_input_date":"2024-06-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-12 21:42:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[{"id":9270942,"change_date":"2024-06-12 21:42:00","inspection_id":"81856734","insp_violation_id":"260051987","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201364274","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:51.000000Z","updated_at":"2025-03-17T21:50:51.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9626115,"change_date":"2024-06-12 21:42:00","inspection_id":"81856734","insp_unit_id":"201364274","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BZ73722","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LN0X1CM172228","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:47.000000Z","updated_at":"2025-03-17T23:22:47.000000Z"}]},{"id":5820919,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","dot_number":"1233854","report_state":"TX","report_number":"V241394951","insp_date":"2024-05-21 00:00:00","insp_start_time":"0857","insp_end_time":"1003","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:29   46' 36.97N","county_code_state":"TX","county_code":"473","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APPROVED OIL SERVICES","shipping_paper_number":"16369","cargo_tank":"407","hazmat_placard_req":"Y","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":"Y","pen_cen_match":null,"final_status_date":"2024-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"7","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"9281421","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2024-05-22 21:41:00","snet_input_date":"2024-05-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-22 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T20:18:13.000000Z","updated_at":"2025-03-17T20:18:13.000000Z","inspection_violations":[{"id":9018189,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","insp_violation_id":"259677747","seq_no":"1","part_no":"172","part_no_section":"201(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:34.000000Z","updated_at":"2025-03-17T21:49:34.000000Z","normalized_code":"172201D"},{"id":9018190,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","insp_violation_id":"259677748","seq_no":"2","part_no":"172","part_no_section":"328(d)","insp_viol_unit":"2","insp_unit_id":"201041149","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:34.000000Z","updated_at":"2025-03-17T21:49:34.000000Z","normalized_code":"172328D"},{"id":9018191,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","insp_violation_id":"259677749","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201041148","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:34.000000Z","updated_at":"2025-03-17T21:49:34.000000Z","normalized_code":"39347E"},{"id":9018192,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","insp_violation_id":"259677750","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201041148","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:34.000000Z","updated_at":"2025-03-17T21:49:34.000000Z","normalized_code":"3939A"},{"id":9018193,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","insp_violation_id":"259677751","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201041149","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:34.000000Z","updated_at":"2025-03-17T21:49:34.000000Z","normalized_code":"3939A"},{"id":9018194,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","insp_violation_id":"259677752","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201041148","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:34.000000Z","updated_at":"2025-03-17T21:49:34.000000Z","normalized_code":"3965B"},{"id":9018195,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","insp_violation_id":"259677753","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201041148","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:34.000000Z","updated_at":"2025-03-17T21:49:34.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9374933,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","insp_unit_id":"201041148","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"102","insp_unit_license":"1L05493","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X97D672663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:19.000000Z","updated_at":"2025-03-17T23:20:19.000000Z"},{"id":9374934,"change_date":"2024-05-22 21:41:00","inspection_id":"81688147","insp_unit_id":"201041149","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"613","insp_unit_license":"X54190","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA3432881032857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:19.000000Z","updated_at":"2025-03-17T23:20:19.000000Z"}]},{"id":4127913,"change_date":"2023-10-04 21:41:00","inspection_id":"79835046","dot_number":"1233854","report_state":"TX","report_number":"V231176024","insp_date":"2023-09-28 00:00:00","insp_start_time":"1345","insp_end_time":"1409","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 MM 59 NB","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APPROVED OIL SERVICES","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":"Y","pen_cen_match":null,"final_status_date":"2023-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"9091927","transaction_code":"A","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2023-10-04 21:41:00","snet_input_date":"2023-09-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-04 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T19:44:26.000000Z","updated_at":"2025-03-17T19:44:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6637222,"change_date":"2023-10-04 21:41:00","inspection_id":"79835046","insp_unit_id":"197403299","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:41.000000Z","updated_at":"2025-03-17T22:55:41.000000Z"}]},{"id":4007487,"change_date":"2023-09-19 21:40:00","inspection_id":"79701055","dot_number":"1233854","report_state":"TX","report_number":"V231165173","insp_date":"2023-09-18 00:00:00","insp_start_time":"0729","insp_end_time":"0822","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US90 WB US90 WB","county_code_state":"TX","county_code":"271","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APPROVED OIL SERVICES","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":"Y","pen_cen_match":null,"final_status_date":"2023-09-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"9079468","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2023-09-19 21:40:00","snet_input_date":"2023-09-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-19 21:40:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T19:42:01.000000Z","updated_at":"2025-03-17T19:42:01.000000Z","inspection_violations":[{"id":6201790,"change_date":"2023-09-19 21:40:00","inspection_id":"79701055","insp_violation_id":"255361297","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197132702","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":6444185,"change_date":"2023-09-19 21:40:00","inspection_id":"79701055","insp_unit_id":"197132702","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:05.000000Z","updated_at":"2025-03-17T22:54:05.000000Z"}]},{"id":3995865,"change_date":"2023-09-18 21:39:00","inspection_id":"79688223","dot_number":"1233854","report_state":"TX","report_number":"V231160597","insp_date":"2023-09-14 00:00:00","insp_start_time":"0748","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US 281 SOUTHBOUND FALFURRIAS","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"9077375","transaction_code":"A","transaction_date":"2023-09-18 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2023-09-18 21:39:00","snet_input_date":"2023-09-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-18 21:39:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T19:41:40.000000Z","updated_at":"2025-03-17T19:41:40.000000Z","inspection_violations":[{"id":6183418,"change_date":"2023-09-18 21:39:00","inspection_id":"79688223","insp_violation_id":"255332488","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197107482","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:53.000000Z","updated_at":"2025-03-17T21:35:53.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":6425574,"change_date":"2023-09-18 21:39:00","inspection_id":"79688223","insp_unit_id":"197107482","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"115","insp_unit_license":"FCZ3269","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9XX7M659752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:58.000000Z","updated_at":"2025-03-17T22:53:58.000000Z"}]},{"id":3726185,"change_date":"2023-08-11 21:39:00","inspection_id":"79387655","dot_number":"1233854","report_state":"TX","report_number":"6NIB9DEKNB","insp_date":"2023-08-10 00:00:00","insp_start_time":"1140","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-1604 IN BEXAR CO. (488-582)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9050387","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T19:36:29.000000Z","updated_at":"2025-03-17T19:36:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5991441,"change_date":"2023-08-11 21:39:00","inspection_id":"79387655","insp_unit_id":"196495068","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"119","insp_unit_license":"NLH1912","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NP3LJ0X9MD708634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"}]},{"id":3666140,"change_date":"2023-08-03 21:41:00","inspection_id":"79320737","dot_number":"1233854","report_state":"TX","report_number":"V231084970","insp_date":"2023-08-01 00:00:00","insp_start_time":"1325","insp_end_time":"1346","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 MM 59 NB","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APPROVED OIL SERVICES","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":"Y","pen_cen_match":null,"final_status_date":"2023-08-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"9044021","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2023-08-03 21:41:00","snet_input_date":"2023-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-03 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T19:35:16.000000Z","updated_at":"2025-03-17T19:35:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5894662,"change_date":"2023-08-03 21:41:00","inspection_id":"79320737","insp_unit_id":"196355357","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"112","insp_unit_license":"PLB6940","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X1MM767030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:32.000000Z","updated_at":"2025-03-17T22:49:32.000000Z"}]},{"id":3416210,"change_date":"2023-06-30 21:41:00","inspection_id":"79039986","dot_number":"1233854","report_state":"TX","report_number":"6M960AKIC7","insp_date":"2023-06-26 00:00:00","insp_start_time":"0550","insp_end_time":"0635","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH 10 EASTBOUND KINGSBURY","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","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":"2023-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"9017308","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2023-06-30 21:41:00","snet_input_date":"2023-06-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-30 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T19:30:37.000000Z","updated_at":"2025-03-17T19:30:37.000000Z","inspection_violations":[{"id":5266228,"change_date":"2023-06-30 21:41:00","inspection_id":"79039986","insp_violation_id":"253826367","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195789870","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:27.000000Z","updated_at":"2025-03-17T21:31:27.000000Z","normalized_code":"39345B2"},{"id":5266229,"change_date":"2023-06-30 21:41:00","inspection_id":"79039986","insp_violation_id":"253826368","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"195789870","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:27.000000Z","updated_at":"2025-03-17T21:31:27.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":5492605,"change_date":"2023-06-30 21:41:00","inspection_id":"79039986","insp_unit_id":"195789870","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:20.000000Z","updated_at":"2025-03-17T22:46:20.000000Z"}]},{"id":2877130,"change_date":"2023-06-05 21:43:00","inspection_id":"78431628","dot_number":"1233854","report_state":"TX","report_number":"V231017271","insp_date":"2023-04-21 00:00:00","insp_start_time":"1430","insp_end_time":"1448","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APPROVED OIL SERVICES LLC","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":"Y","pen_cen_match":null,"final_status_date":"2023-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"8961888","transaction_code":"C","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2023-04-24 21:41:00","snet_input_date":"2023-04-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-24 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T19:19:43.000000Z","updated_at":"2025-03-17T19:19:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4629680,"change_date":"2023-06-05 21:43:00","inspection_id":"78431628","insp_unit_id":"195327070","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"112","insp_unit_license":"PLB6940","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X1MM767030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:30.000000Z","updated_at":"2025-03-17T22:39:30.000000Z"}]},{"id":2470684,"change_date":"2023-03-01 21:42:00","inspection_id":"77969367","dot_number":"1233854","report_state":"TX","report_number":"6ITE0XQY81","insp_date":"2023-02-22 00:00:00","insp_start_time":"1425","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0085 IN DIMMIT CO. (408-438","county_code_state":"TX","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8916675","transaction_code":"C","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2023-02-28 21:41:00","snet_input_date":"2023-02-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-28 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T19:12:08.000000Z","updated_at":"2025-03-17T19:12:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3976512,"change_date":"2023-03-01 21:42:00","inspection_id":"77969367","insp_unit_id":"193658861","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:29.000000Z","updated_at":"2025-03-17T22:34:29.000000Z"}]},{"id":1801640,"change_date":"2022-11-22 21:41:00","inspection_id":"77205189","dot_number":"1233854","report_state":"TX","report_number":"6G5C0VKVBY","insp_date":"2022-11-18 00:00:00","insp_start_time":"1216","insp_end_time":"1233","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C199","location_desc":"SA-035A IN ARANSAS CO. (644-67","county_code_state":"TX","county_code":"007","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"35200","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":"8834612","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2022-11-22 21:41:00","snet_input_date":"2022-11-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T18:59:57.000000Z","updated_at":"2025-03-17T18:59:57.000000Z","inspection_violations":[{"id":2819458,"change_date":"2022-11-22 21:41:00","inspection_id":"77205189","insp_violation_id":"249757778","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192098920","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:17.000000Z","updated_at":"2025-03-17T21:20:17.000000Z","normalized_code":"39375A3"},{"id":2819459,"change_date":"2022-11-22 21:41:00","inspection_id":"77205189","insp_violation_id":"249757779","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192098920","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:17.000000Z","updated_at":"2025-03-17T21:20:17.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":2898326,"change_date":"2022-11-22 21:41:00","inspection_id":"77205189","insp_unit_id":"192098920","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"115","insp_unit_license":"FCZ3269","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9XX7M659752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:50.000000Z","updated_at":"2025-03-17T22:26:50.000000Z"}]},{"id":1233139,"change_date":"2022-09-07 21:41:00","inspection_id":"76548934","dot_number":"1233854","report_state":"TX","report_number":"6DZ50AKPBM","insp_date":"2022-09-01 00:00:00","insp_start_time":"0525","insp_end_time":"0556","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"APPROVED OIL SERVICES","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"8765159","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2022-09-07 21:41:00","snet_input_date":"2022-09-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-07 21:41:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T18:49:21.000000Z","updated_at":"2025-03-17T18:49:21.000000Z","inspection_violations":[{"id":1953164,"change_date":"2022-09-07 21:41:00","inspection_id":"76548934","insp_violation_id":"248268844","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190773764","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:59.000000Z","updated_at":"2025-03-17T21:15:59.000000Z","normalized_code":"39378"},{"id":1953165,"change_date":"2022-09-07 21:41:00","inspection_id":"76548934","insp_violation_id":"248268845","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190773764","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:59.000000Z","updated_at":"2025-03-17T21:15:59.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1984509,"change_date":"2022-09-07 21:41:00","inspection_id":"76548934","insp_unit_id":"190773764","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"115","insp_unit_license":"FCZ3269","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9XX7M659752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:38.000000Z","updated_at":"2025-03-17T22:20:38.000000Z"}]},{"id":1208011,"change_date":"2022-09-02 21:39:00","inspection_id":"76519925","dot_number":"1233854","report_state":"TX","report_number":"6DYB9DADNX","insp_date":"2022-08-31 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2600 E SH 71 HWY","county_code_state":"TX","county_code":"453","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8762144","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2022-09-02 21:39:00","snet_input_date":"2022-08-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[{"id":1916292,"change_date":"2022-09-02 21:39:00","inspection_id":"76519925","insp_violation_id":"248205143","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190714545","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3939A"},{"id":1916293,"change_date":"2022-09-02 21:39:00","inspection_id":"76519925","insp_violation_id":"248205144","seq_no":"3","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"190714545","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"39395B"},{"id":1916294,"change_date":"2022-09-02 21:39:00","inspection_id":"76519925","insp_violation_id":"248205145","seq_no":"1","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"190714545","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"39351"}],"inspection_per_units":[{"id":1942888,"change_date":"2022-09-02 21:39:00","inspection_id":"76519925","insp_unit_id":"190714545","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"106","insp_unit_license":"AM54260","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPNLZ9X44M814235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]},{"id":988748,"change_date":"2022-08-08 21:40:00","inspection_id":"76264489","dot_number":"1233854","report_state":"TX","report_number":"6D8A0VLO2M","insp_date":"2022-08-05 00:00:00","insp_start_time":"1046","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"APPROVED OIL SERVICES","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"8737378","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-08-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T18:45:05.000000Z","updated_at":"2025-03-17T18:45:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1591778,"change_date":"2022-08-08 21:40:00","inspection_id":"76264489","insp_unit_id":"190195715","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"119","insp_unit_license":"NLH1912","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NP3LJ0X9MD708634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:02.000000Z","updated_at":"2025-03-17T22:18:02.000000Z"}]},{"id":988646,"change_date":"2022-08-08 21:40:00","inspection_id":"76264375","dot_number":"1233854","report_state":"TX","report_number":"6D7E0AHMF4","insp_date":"2022-08-04 00:00:00","insp_start_time":"1350","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN LA SALLE CO. (38-82","county_code_state":"TX","county_code":"283","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RIO GRANDE CARTHAGE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8737168","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-08-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T18:45:05.000000Z","updated_at":"2025-03-17T18:45:05.000000Z","inspection_violations":[{"id":1560675,"change_date":"2022-08-08 21:40:00","inspection_id":"76264375","insp_violation_id":"247586721","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"190195509","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"393209D"},{"id":1560676,"change_date":"2022-08-08 21:40:00","inspection_id":"76264375","insp_violation_id":"247586722","seq_no":"2","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"190195509","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"393207A"},{"id":1560677,"change_date":"2022-08-08 21:40:00","inspection_id":"76264375","insp_violation_id":"247586723","seq_no":"3","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"190195509","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"39383G"},{"id":1560678,"change_date":"2022-08-08 21:40:00","inspection_id":"76264375","insp_violation_id":"247586724","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190195509","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"39345B2"},{"id":1560679,"change_date":"2022-08-08 21:40:00","inspection_id":"76264375","insp_violation_id":"247586725","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190195509","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":1591603,"change_date":"2022-08-08 21:40:00","inspection_id":"76264375","insp_unit_id":"190195509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:02.000000Z","updated_at":"2025-03-17T22:18:02.000000Z"}]},{"id":946430,"change_date":"2022-08-08 21:40:00","inspection_id":"76215076","dot_number":"1233854","report_state":"TX","report_number":"6CYC0XVD5V","insp_date":"2022-07-26 00:00:00","insp_start_time":"1158","insp_end_time":"1226","registration_date":"2022-08-05 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN VAL VERDE CO. (348-","county_code_state":"TX","county_code":"465","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"THOMPSON TIRE","shipping_paper_number":"139807","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-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"8730411","transaction_code":"C","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2022-08-02 21:40:00","snet_input_date":"2022-07-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-02 21:40:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T18:44:23.000000Z","updated_at":"2025-03-17T18:44:23.000000Z","inspection_violations":[{"id":1493051,"change_date":"2022-08-08 21:40:00","inspection_id":"76215076","insp_violation_id":"247579365","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190191279","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1524065,"change_date":"2022-08-08 21:40:00","inspection_id":"76215076","insp_unit_id":"190191279","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"115","insp_unit_license":"FCZ3269","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9XX7M659752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:35.000000Z","updated_at":"2025-03-17T22:17:35.000000Z"}]},{"id":609907,"change_date":"2022-06-16 21:43:00","inspection_id":"75820042","dot_number":"1233854","report_state":"TX","report_number":"6BH70XQYDE","insp_date":"2022-06-03 00:00:00","insp_start_time":"0702","insp_end_time":"0720","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C199","location_desc":"SA-035A IN ARANSAS CO. (644-67","county_code_state":"TX","county_code":"007","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"8679418","transaction_code":"C","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01233854","upload_search_indicator":"M","census_search_date":"2022-06-14 21:43:00","snet_input_date":"2022-06-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-14 21:43:00","insp_carrier_name":"APPROVED OIL SERVICES LLC","insp_carrier_street":"4485 SMITH RD","insp_carrier_city":"VONORMY","insp_carrier_state":"TX","insp_carrier_zip_code":"78073","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0140433","created_at":"2025-03-17T18:38:27.000000Z","updated_at":"2025-03-17T18:38:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":981100,"change_date":"2022-06-16 21:43:00","inspection_id":"75820042","insp_unit_id":"189303905","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"113","insp_unit_license":"BY24829","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NPLLZ9X66M630098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:14.000000Z","updated_at":"2025-03-17T22:14:14.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1233854\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1233854\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1233854\/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\/1233854\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}