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.
5889199-1Lightplates3707689-1Light Panel4751596-1Light Panel4614428-501Light Panel4772349-1Light Panel5887477-1Light Panel3777644-1Light Panel4778820-501Light Panel3706720Light Panel3895137Light Panel3891424-1Lightplates4753580-501Light Panel3895097-1Light Panel3890321-1Light Panel3612187-501Light Panel4619287Light Panel4888484Light Panel4645617-501Light Panel3613834-501Light Panel4802653-1Light Panel5891752-1Light Panel3753579-501Light Panel3778091-501Light Panel5892774-1Light Panel3888383-1Light Panel3761711-1Light Panel5778067-1Light Panel5889199-1Light Panel4889488-1Light Panel3714756-501Light Panel3891615-1Light Panel4715703Light Panel4715826Light Panel3759203-1Light Panel3895642-1Light Panel3893393-1Light Panel4889598-1Light Panel3778080-1Light Panel3889064-1Light Panel3776074-1Lightplates3896468-1Light Panel3612188-501Light Panel5778148-1Lightplates4764274Light Panel5892690-1Light Panel3892135-1Light Panel3890856-1Light Panel4756184-1Light Panel4890025-1Lightplates3897792-1Light Panel
Back to Douglas DC-8-41