Lycoming O-235-P2A
PMA parts · 1,596
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-P2A'])) > 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-P2A'])) > 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.
SL31CD-15Stud, 5/16 IN DIA, Coarse ThreadSL38-32-P07Stud 3/8 Dia. Fine ThreadSL44-32Stud, 7/16 Dia. Fine ThreadSL44-31-P07Stud, 7/16 Dia. Fine ThreadSL38-45Stud 3/8 Dia. Fine ThreadSL31C-45 P12Stud, 5/16 IN DIA, Coarse ThreadSL31CD-33 P07Stud, 5/16 IN DIA, Coarse ThreadSL44-24-P07Stud, 7/16 Dia. Fine ThreadSL38-16-P07Stud 3/8 Dia. Fine ThreadSL31CD-38 P12Stud, 5/16 IN DIA, Coarse ThreadSL44-23-P12Stud, 7/16 Dia. Fine ThreadSL38-50Stud 3/8 Dia. Fine ThreadSL31CD-35 P07Stud, 5/16 IN DIA, Coarse ThreadSL38-25-P07Stud 3/8 Dia. Fine ThreadSL31CD-10 P03Stud, 5/16 IN DIA, Coarse ThreadSL38-12Stud 3/8 Dia. Fine ThreadSL31CD-38 P07Stud, 5/16 IN DIA, Coarse ThreadSL38-42-P12Stud 3/8 Dia. Fine ThreadSL44-13-P12Stud, 7/16 Dia. Fine ThreadSL38-27-P12Stud 3/8 Dia. Fine ThreadSL31CD-26 P03Stud, 5/16 IN DIA, Coarse ThreadSL38-61-P12Stud 3/8 Dia. Fine ThreadSL38-44-P03Stud 3/8 Dia. Fine ThreadSL44-64-P07Stud, 7/16 Dia. Fine ThreadSL31CD-41 P03Stud, 5/16 IN DIA, Coarse ThreadSL38-11Stud 3/8 Dia. Fine ThreadSL44-34-P12Stud, 7/16 Dia. Fine ThreadSL31CD-38 P03Stud, 5/16 IN DIA, Coarse ThreadSL44-50-P07Stud, 7/16 Dia. Fine ThreadSL38-24-P03Stud 3/8 Dia. Fine ThreadSL38-52-P07Stud 3/8 Dia. Fine ThreadSL38-31-P03Stud 3/8 Dia. Fine ThreadSL44-29-P07Stud, 7/16 Dia. Fine ThreadSL44-54-P12Stud, 7/16 Dia. Fine ThreadSL31CD-25 P12Stud, 5/16 IN DIA, Coarse ThreadSL31CD-13 P07Stud, 5/16 IN DIA, Coarse ThreadSL31CD-26 P12Stud, 5/16 IN DIA, Coarse ThreadSL31C-49Stud, 5/16 IN DIA, Coarse ThreadSL31C-51 P03Stud, 5/16 IN DIA, Coarse ThreadSL44-17-P12Stud, 7/16 Dia. Fine ThreadSL38-46Stud 3/8 Dia. Fine ThreadSL31C-47 P12Stud, 5/16 IN DIA, Coarse ThreadSL31C-50 P03Stud, 5/16 IN DIA, Coarse ThreadSL44-45Stud, 7/16 Dia. Fine ThreadSL38-31-P12Stud 3/8 Dia. Fine ThreadSL44-20-P03Stud, 7/16 Dia. Fine ThreadSL44-18-P12Stud, 7/16 Dia. Fine ThreadSL44-53-P03Stud, 7/16 Dia. Fine ThreadSL38-37-P12Stud 3/8 Dia. Fine ThreadSL44-45-P03Stud, 7/16 Dia. Fine Thread
Back to Lycoming O-235-P2A