Mcdonnell Douglas DC-8-71
PMA parts · 5,011
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-71'])) > 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-71'])) > 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.
SP2510-00-1020ECup Assy, BrewSP2510-00-1025ECup, Brew (Upper)SP2510-00-1020FCup Assy, BrewSP2510-00-1020FCup Assy, Brew27648WERoller, Bearing3163268-7WERing-Piston308487WESeal-Boot3231392-5WESeal Assembly27080-5WERing, PistonSP2510-11-5010ASolenoidSP2510-11-5005BPlate Assembly, Adapter04320073-0005BLCD DISPLAY MODULE04320073-0005BLCD DISPLAY MODULE3177737-1JARing Set3177770-1JARing Set, GuideVA-2530-H01Immersion Stick Heater AssyB101001-503Coffee MakerB101001-503Coffee MakerADV-3575-1251-07Heater AssyE693473-1, -2, -3, -4, -5BushingE3846484-3, -4, -7, -8Nozzle, TurbineE663017-4Body, ValveE693472-1, -2, -3, -4, -5, -8, -11, -25BushingE3611904-1Turbine Shroud1140-4291-2Magna Stick1140-4291-4Magna Stick1140-4282-9Magna Stick1140-4282-10Magna Stick8731Nipple Assembly-Water Fill1140-4291-21Magna Stick1022-16CNipple Assembly-Lav. Water1140-4282-7Magna Stick1140-4291-24Magna Stick1140-4291-14Magna Stick1140-4282-6Magna Stick0031-1007Oxygen Coupling1140-4291-3Magna Stick1140-4291-8Magna Stick1140-4282-24Magna StickIndex List 497445Video Entertainment System1140-4291-5Magna Stick1140-4291-13Magna Stick4259-31Plug Assembly-Lav. Drain1140-4282-26Magna Stick1140-4282-8Magna Stick1140-4282-27Magna Stick4259-20Plug Assembly-Lav. Drain1140-4282-3Magna Stick1140-4291-1Magna Stick1140-4282-25Magna Stick
Back to Mcdonnell Douglas DC-8-71