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.
2654330Spring2649752SpringSR07800001-17Door AssemblyV2651D516C0AWaste Drain Valve055916-09Filter Element Fluid19940305-1Pressure Gauge1040-12, 1040-15Trash Compactor50604Fitting Assembly/ Pallet Restraint50362Cross Track - Screw Lock50044Fitting Assembly/ End Restraint50781Rail Assembly/ Side75B1-629Condenser Fan75B1-294Prewhirler75B1-214Condenser75B1-523Receiver75B1-179Freon Compressor75B1-A-528Receiver-Drier75B2-639Condenser Fan75B2-849Freon Compressor75B2-714Freon Compressor75B2-619Condenser Fan75B1-583Receiver75B2-567Filter Dryer75B2-839Freon Compressor75B1-609Condenser Fan75B2-524Receiver-Drier75B1-138Shut-off Valve75B1-318Evaporator75B1-A-538Receiver-Drier75B1-533Receiver75B2-829Freon Compressor75B1-169Freon Compressor75B2-339Evaporator75B2-209Sub-Cooler75B1-339Evaporator75B1-654Shut-off Valve75B2-349Evaporator75B1-329Evaporator75B1-159Freon Compressor75B1-148Oil Pump and AC Motor75B2-534Receiver-Drier75B1-379Evaporator75B1-573Receiver75B2-507Filter Dryer75B1-587Receiver75B1-577Receiver75B1-513Receiver75B2-318Evaporator75B1-557Receiver75B2-734Freon Compressor
Back to Douglas DC-8-41