Home / Companies / AUTOMOTIVE STEERING COLUMN LLC

AUTOMOTIVE STEERING COLUMN LLC H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
AUTOMOTIVE STEERING COLUMN LLC AUTOMOTIVE STEERING COLUMN LLC	13	8	3	FY2019 to FY2023 Latest decision 2023-04-25	8	Process Engineer 3 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	13
Certified LCAs	13
Denied LCAs	0
Role titles	8
Worksites	3
Latest decision	2023-04-25
USCIS approvals	8
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
AUTOMOTIVE STEERING COLUMN LLC	AUTOMOTIVE STEERING COLUMN LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
Process Engineer	17-2141.00 Mechanical Engineers	3	$73,611	$75,109
COLUMN DESIGN ENGINEER	17-2141 MECHANICAL ENGINEERS	2	$75,000	$75,000
ASSOCIATE QUALITY ENGINEER	17-2141 MECHANICAL ENGINEERS	1	$67,000	$67,000
ASSOCIATE QUALITY ENGINEER	17-2141.00 Mechanical Engineers	1	$72,904	$72,904
COLUMN ENGINEERING MANAGER	11-9041 ARCHITECTURAL AND ENGINEERING MANAGERS	1	$124,500	$124,500
ECR COORDINATOR	17-2141.00 Mechanical Engineers	1	$72,904	$72,904
Process Engineer	17-2199.05 Mechatronics Engineers	1	$78,270	$78,270
PROJECT MANAGER	17-2112 INDUSTRIAL ENGINEERS	1	$71,553	$71,553
QUALITY ENGINEER	17-2141.00 Mechanical Engineers	1	$89,640	$89,640
SENIOR DESIGN ENGINEER	17-2141 MECHANICAL ENGINEERS	1	$89,564	$89,564

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Florence	KY	41042	8	4	67,000	78,270	2,019	2,023
Plymouth	MI	48170	4	3	75,000	124,500	2,019	2,019
Florence	OH	45220	1	1	89,640	89,640	2,023	2,023

Full company payload

Company ID	company:automotive steering column
Name	AUTOMOTIVE STEERING COLUMN LLC
Normalized Name	automotive steering column
Source Company Ids	company_dol_oflc_lca_automotive_steering_column_llc, company_uscis_h1b_datahub_automotive_steering_column_llc_tax_4662, company_uscis_h1b_datahub_automotive_steering_column_llc_tax_5662
Source Names	AUTOMOTIVE STEERING COLUMN LLC
Aliases	AUTOMOTIVE STEERING COLUMN LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "AUTOMOTIVE STEERING COLUMN LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "AUTOMOTIVE STEERING COLUMN LLC",
      "filing_count": 13,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "AUTOMOTIVE STEERING COLUMN LLC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "AUTOMOTIVE STEERING COLUMN LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4662",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5662",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 13,
  "case_count": 13,
  "role_title_count": 8,
  "worksite_count": 3,
  "total_workers": 13,
  "first_fiscal_year": 2019,
  "first_received_date": "2019-03-04",
  "latest_fiscal_year": 2023,
  "latest_decision_date": "2023-04-25",
  "certified_count": 13,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 7,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 6,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 13,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 13,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 8,
  "total_denial": 0,
  "fiscal_years": [
    "2019",
    "2020",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Farmington",
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48331"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_steering_column_llc_tax_4662_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_053632",
        "sr_uscis_h1b_datahub_2019_row_053633"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48331"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_steering_column_llc_tax_4662_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_005030"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48331"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_steering_column_llc_tax_4662_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_003159"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48331"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_steering_column_llc_tax_5662_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_053634"
      ],
      "continuing_approval": 1
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "FARMINGTON HILLS MI 48331",
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48331",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-04-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "PLYMOUTH MI 48170",
      "city": "Plymouth",
      "state": "MI",
      "postal_code": "48170",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-06-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "FLORENCE KY 41042",
      "city": "Florence",
      "state": "KY",
      "postal_code": "41042",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "FLORENCE KY 41042",
      "city": "Florence",
      "county": "Boone",
      "state": "KY",
      "postal_code": "41042",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-01-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FLORENCE OH 45220",
      "city": "Florence",
      "county": "Hamilton",
      "state": "OH",
      "postal_code": "45220",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-04-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "PLYMOUTH MI 48170",
      "city": "Plymouth",
      "county": "Wayne",
      "state": "MI",
      "postal_code": "48170",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-06-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "worksite_address_count": 3,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}

Geography

{
  "states": [
    "KY",
    "MI",
    "OH"
  ],
  "cities": [
    "Florence",
    "Plymouth",
    "Farmington",
    "Farmington Hills"
  ],
  "postal_codes": [
    "41042",
    "48170",
    "45220",
    "48331"
  ],
  "top_markets": [
    {
      "city": "Florence",
      "state": "KY",
      "postal_code": "41042",
      "lca_count": 8,
      "role_title_count": 4,
      "wage_low_min": 67000,
      "wage_high_max": 78270,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Plymouth",
      "state": "MI",
      "postal_code": "48170",
      "lca_count": 4,
      "role_title_count": 3,
      "wage_low_min": 75000,
      "wage_high_max": 124500,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Florence",
      "state": "OH",
      "postal_code": "45220",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 89640,
      "wage_high_max": 89640,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023
    }
  ]
}

Industry

{
  "naics_codes": [
    "336111",
    "33"
  ],
  "naics_breakdown": [
    {
      "value": "336111",
      "filing_count": 11,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "3361",
      "filing_count": 2,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 67000,
  "annualized_high_max": 124500,
  "annualized_low_avg": 79897.3846153846
}

Trend

[
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 67000,
    "wage_high_max": 124500,
    "wage_low_avg": 83769.5
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 72904,
    "wage_high_max": 72904,
    "wage_low_avg": 72904
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 72904,
    "wage_high_max": 72904,
    "wage_low_avg": 72904
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 73611,
    "wage_high_max": 73611,
    "wage_low_avg": 73611
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 73611,
    "wage_high_max": 73611,
    "wage_low_avg": 73611
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 75109,
    "wage_high_max": 75109,
    "wage_low_avg": 75109
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 78270,
    "wage_high_max": 78270,
    "wage_low_avg": 78270
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 89640,
    "wage_high_max": 89640,
    "wage_low_avg": 89640
  }
]

Links

{
  "roles": "/v1/roles?company=AUTOMOTIVE%20STEERING%20COLUMN%20LLC",
  "wages": "/v1/wages?company=AUTOMOTIVE%20STEERING%20COLUMN%20LLC",
  "trends": "/v1/trends?company=AUTOMOTIVE%20STEERING%20COLUMN%20LLC"
}

Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=automotive+steering+column+llc&limit=5JSON

Docs · Get an API key