Douglas DC-8-41
PMA parts · 4,554
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 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 ('4A25')
AND len(list_intersect(tcds_models, ['DC-8-41'])) > 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 ('4A25')
AND len(list_intersect(tcds_models, ['DC-8-41'])) > 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.
25633750-09Valve-Inline Air (2.5", Latching)25633750-11Valve-Inline Air (2.5", Latching)25633750-06Valve-Inline Air (2.5", On-Off)26230074-01Valve, Shut-Off (1.5")25633750-04Valve-Air (2.5") (On-Off)3754703-1Light Plates3753423-1Light Plates4758061-1Light Plates5893026-1Light Plates4760805-1Light Panel4775299-1Light Plates3750406-1Light Panel3888798-1Light Plates4892583-1Light Panel3759103-1Light Panel3755300-1Light Plates3887787-1Light Panel3753579-501Light Plates4751345-1Light Plates3895756-1Light Plates4761054-1Light Plates3753423-501Light Plates3891505-1Light Plates4756184-1Light Plates4897287-1Light Panel4897184-1Light Panel3889007-1Light Panel3893707-1Light Plates3753579-1Light Plates2710645-501Light Panel3761711-501Light Plates3761482Light Plates3804128-1Light Plates3889182-1Light Plates3896237-1Light Plates4646577Light Panel4888753-1Light Panel4757440-1Light Plates2704413Light Plates3767749Light Plates4614428-501Light Plates3712567Light Plates5707635Light Panel3712765-501Light Panel4887295-1Light Plates3778170-1Light Panel4768890-1Light Plates4765081-501Light Plates3757443-1Light Plates3757443-505Light Plates
Back to Douglas DC-8-41