Pratt & Whitney JT3D-3B
PMA parts · 263
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 ('1E8')
AND len(list_intersect(tcds_models, ['JT3D-3B'])) > 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 ('1E8')
AND len(list_intersect(tcds_models, ['JT3D-3B'])) > 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.
CR2162-6-6Rivet-blind2LS426-T6-4WPin-rivetR3001-T6-1OWPin-rivetCR2249-5-5Rivet-blindCR2249-6-9Rivet-blindCR2163-4-2Rivet-blindR3002-T8-9WPin-rivetCR2162-5-5Rivet-blind2LP-EU6-3Pin-rivetCR863-4-6Rivet-blindCR6626-4-14Rivet-blindCR2248-4-3Rivet-blindCR2163-5-3'sRivet-blindCR2163-6-3Rivet-blindCR2249-6-5Rivet-blind42701Cable (Lead, Ignition)42285Cable (Lead, Ignition)42723Exciter, Ignition42286Cable (Lead, Ignition)40911Cable (Lead, Ignition)44388Exciter, Ignition42289Cable (Lead, Ignition)40942Cable (Lead, Ignition)42284Cable (Lead, Ignition)40913Cable (Lead, Ignition)42287Cable (Lead, Ignition)40914Cable (Lead, Ignition)40692Exciter, Ignition42562Exciter, Ignition42700Cable (Lead, Ignition)41540Exciter, Ignition235242WENut - plain, hex 0.3125-32 x 0.135234343WEWasherPT100002Gear Cover SealR3001-T6-llWPin-rivetCR2163-5-3'sRivet-blindCR2249-6-4Rivet-blindCR2162-5-3Rivet-blindCR2248-4-3Rivet-blindCR6626-4-14Rivet-blindCR2163-6-3Rivet-blindR3001-T6-1OWPin-rivetCR2162-5-5Rivet-blindCR2249-5-5Rivet-blindCR2249-6-9Rivet-blind2LSP-T6-4WPin-rivetCR2162-6-6Rivet-blind2LP-EU6-3Pin-rivetCR2163-4-2Rivet-blindCR2653-5-2Rivet-blind
Back to Pratt & Whitney JT3D-3B