Continental O-470-E
PMA parts · 1,347
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-273')
AND len(list_intersect(tcds_models, ['O-470-E'])) > 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-273')
AND len(list_intersect(tcds_models, ['O-470-E'])) > 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.
SA402129 P007Stud, 1/4-20 x 1/4-28SA402127 P003Stud, 3/8-16 x 3/8-24SA401963 P007Stud, 1/4-20 x 1/4-28SA402129Stud, 1/4-20 x 1/4-28SA652887 -8.88Bolt, Crankcase, ThruSA402129 P012Stud, 1/4-20 x 1/4-28SA401852 P003Stud, 1/4-20 x 1/4-28SA402129 P003Stud, 1/4-20 x 1/4-28SA402127Stud, 3/8-16 x 3/8-24SA641931 -10.75Thrubolt, 1/2-20 x 10.75 LongSA401861 P012Stud, 3/8-16 x 3/8-24SA646140-1Stud, Reduced Shank, .437-14 x .437-20SA401963 P003Stud, 1/4-20 x 1/4-28SA401963Stud, 1/4-20 x 1/4-28SA402127 P012Stud, 3/8-16 x 3/8-24SA401861 P007Stud, 3/8-16 x 3/8-24SA401852Stud, 1/4-20 x 1/4-28SA402127 P007Stud, 3/8-16 x 3/8-24SA401852 P012Stud, 1/4-20 x 1/4-28SA401861Stud, 3/8-16 x 3/8-24SA630943 -10.50Thrubolt, 7/16-20SA630261-37PinSA401852 P007Stud, 1/4-20 x 1/4-28SA641931 -9.81Thrubolt, 1/2-20SA401861 P003Stud, 3/8-16 x 3/8-24SA401963 P012Stud, 1/4-20 x 1/4-28SA646140-2Stud, Reduced Shank, .437-14 x .437-2010-4893-1Carburetor (MA-4-5)10-5284Carburetor (MA-4-5)10-3859-1Carburetor (MA-4-5)SA401861P007Stud, 3/8-16 x 3/8-24SA402129P007Stud, 1/4-20 x 1/4-28SA641931-9.81Thrubolt, 1/2-20SA401852Stud, 1/4-20 x 1/4-28SA402129P003Stud, 1/4-20 x 1/4-28SA402127P007Stud, 3/8-16 x 3/8-24SA641931-10.75Thrubolt, 1/2-20SA402127P003Stud, 3/8-16 x 3/8-24SA401963P003Stud, 1/4-20 x 1/4-28SA401963P012Stud, 1/4-20 x 1/4-28SA401852P012Stud, 1/4-20 x 1/4-28SA402127Stud, 3/8-16 x 3/8-24SA401963Stud, 1/4-20 x 1/4-28SA402129Stud, 1/4-20 x 1/4-28SA401963P007Stud, 1/4-20 x 1/4-28SA401861P012Stud, 3/8-16 x 3/8-24SA630943-10.50Thrubolt, 7/16-20SA401861Stud, 3/8-16 x 3/8-24SA401861P003Stud, 3/8-16 x 3/8-24SA401852P003Stud, 1/4-20 x 1/4-28
Back to Continental O-470-E