Douglas DC-8-43
PMA parts · 4,688
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-43'])) > 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-43'])) > 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.
AA695904-1APIN, PUMP DRIVEAA707334ASCAVENGE PUMP ASSEMBLYAA759278-1AHOUSING, PUMPAA708025-1AHOUSING, PUMP44600-106Restraint Assembly44600-107Restraint Assembly44600-108Restraint Assembly2152Seal Assembly0302VBWMarker- Fire etc.0121-Marker- Arrow0105-Marker-"Arrow"0287-Marker-"Arrow"0106-Marker-"Arrow"100C0321Box, Skid Control Monitor100C0322Box, Lamp Control700D10200-1ADF/Loran Coupler1101244-10Crotch Strap W/Clip1101244-04Crotch Strap W/Clip1101244-13Crotch Strap W/Clip8501-459DAPanel, Endbay Assembly., L/HFW8301-919AAShroud, Arm8110-403DAFood Tray Assembly8102-447SA2Food Tray Assembly, Std.8301-916SAShroud, Upper Arm, R/H4404-302AAShroud, Upper Arm8411-301AAShroud, Upper Arm4501-921Panel, Lower Endbay L/H4403-321AAShroud, Upper Arm4404-303AA2Shroud, Upper ArmFW4404-303shroud, upper arm, l/h8614-311Panel, Endbay Assembly4101-401DAFood Tray Assembly., STD8501-409AAPanel, Endbay Assembly., L/H4101-449Food Tray Assembly., STD8401-351AAPanel, Wall, L/H8102-447SAFood Tray Assembly, Std.FW8102-401AAFood TrayFW8501-410AAEndbay Assembly. L/HFW4403-303shroud, upper arm, l/hFW4403-301shroud, upper arm, l/h8110-401DAFood Tray Assembly8301-917AAShroud, Arm, L/H8102-411Food Tray Assembly4404-322AAShroud, Upper Arm8301-915SAshroud, upper arm, l/h4403-304AAShroud, Upper Arm8401-352AAPanel, Wall, R/H4608-308Panel, Lower Endbay Assembly., R/H8401-156AAPanel, Wall, R/H4511-361AAFood Tray Assembly. Sliding
Back to Douglas DC-8-43