Lycoming O-235-J2A
PMA parts · 1,980
Current parts manufacturer approvals (PMA): parts the FAA has approved companies to make as replacements or modifications. Each record lists its models as free text; OpenAirDocs matched them to this engine model on its data sheet, so check the FAA record before relying on it. Newest first.
Query with SQL
duckdb -csv -c "SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('E-223')
AND len(list_intersect(tcds_models, ['O-235-J2A'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('E-223')
AND len(list_intersect(tcds_models, ['O-235-J2A'])) > 0
ORDER BY supplement_date DESC, drs_guid DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SL25C-13-STDStud, 1/4 Dia. Coarse ThreadSL25C-54-STDStud, 1/4 Dia. Coarse ThreadSL31C-44 P12Stud, 5/16 IN DIA, Coarse ThreadSL44-36-P12Stud, 7/16 Dia. Fine ThreadSL38-63-P12Stud 3/8 Dia. Fine ThreadSL25C-46-P07Stud, 1/4 Dia. Coarse ThreadSL25C-23-STDStud, 1/4 Dia. Coarse ThreadSL25C-13-P12Stud, 1/4 Dia. Coarse ThreadSL31C-60 P03Stud, 5/16 IN DIA, Coarse ThreadSL25C-50-STDStud, 1/4 Dia. Coarse ThreadSL44-49-P03Stud, 7/16 Dia. Fine ThreadSL31CD-23 P03Stud, 5/16 IN DIA, Coarse ThreadSL25C-12-P07Stud, 1/4 Dia. Coarse ThreadSL38-64-P07Stud 3/8 Dia. Fine ThreadSL44-57-P07Stud, 7/16 Dia. Fine ThreadSL31CD-30 P03Stud, 5/16 IN DIA, Coarse ThreadSL38-41-P12Stud 3/8 Dia. Fine ThreadSL38-60Stud 3/8 Dia. Fine ThreadSL44-61-P03Stud, 7/16 Dia. Fine ThreadSL44-61-P07Stud, 7/16 Dia. Fine ThreadSL31C-55 P12Stud, 5/16 IN DIA, Coarse ThreadSL31C-46 P12Stud, 5/16 IN DIA, Coarse ThreadSL25C-19-P12Stud, 1/4 Dia. Coarse ThreadSL44-41-P03Stud, 7/16 Dia. Fine ThreadSL31CD-43 P03Stud, 5/16 IN DIA, Coarse ThreadSL44-19-P12Stud, 7/16 Dia. Fine ThreadSL31C-52Stud, 5/16 IN DIA, Coarse ThreadSL44-26-P03Stud, 7/16 Dia. Fine ThreadSL44-24-P03Stud, 7/16 Dia. Fine ThreadSL25C-41-P07Stud, 1/4 Dia. Coarse ThreadSL25C-49-P07Stud, 1/4 Dia. Coarse ThreadSL31CD-29Stud, 5/16 IN DIA, Coarse ThreadSL38-30-P12Stud 3/8 Dia. Fine ThreadSL44-18Stud, 7/16 Dia. Fine ThreadSL31CD-41Stud, 5/16 IN DIA, Coarse ThreadSL44-40-P12Stud, 7/16 Dia. Fine ThreadSL25C-40-STDStud, 1/4 Dia. Coarse ThreadSL31C-45 P03Stud, 5/16 IN DIA, Coarse ThreadSL25C-62-STDStud, 1/4 Dia. Coarse ThreadSL25C-61-P12Stud, 1/4 Dia. Coarse ThreadSL38-13-P03Stud 3/8 Dia. Fine ThreadSL44-59-P12Stud, 7/16 Dia. Fine ThreadSL25C-50-P07Stud, 1/4 Dia. Coarse ThreadSL38-41-P03Stud 3/8 Dia. Fine ThreadSL25C-31-P03Stud, 1/4 Dia. Coarse ThreadSL44-48-P07Stud, 7/16 Dia. Fine ThreadSL38-62-P07Stud 3/8 Dia. Fine ThreadSL38-49Stud 3/8 Dia. Fine ThreadSL38-14Stud 3/8 Dia. Fine ThreadSL38-49-P07Stud 3/8 Dia. Fine Thread
Back to Lycoming O-235-J2A