Boeing 727-294
PMA parts · 19,401
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 ('A3WE')
AND len(list_intersect(tcds_models, ['727-200 Series'])) > 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 ('A3WE')
AND len(list_intersect(tcds_models, ['727-200 Series'])) > 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.
7021-33-1Roller, Clutch7021-22-1Seal7021-21-1Bearing7021-29-1Spring, Cam7021-36-1Washer7021-32-1Cam, Clutch7021-24-1Washer, Spring7021-40-1Rivet7021-23-1Ring7021-39-1Washer7021-31-1Retainer, Pin7021-25-1Switch7021-35-1Spring, Clutch7021-30-1Pin7021-38-1Ring, Retainer202906BTISpace Sleeve203118-3BTIWasher, Thrust-Turbine WheelCM4004C9-9-10Roller sets, 10 ea.CM4004C9-9-14Roller sets, 14 ea.CM4004-6-6-28Roller sets, 28 ea.CM4004C8-8RollerCM4004C7-7-14Roller sets, 14 ea.CM4004C7-7-22Roller sets, 22 ea.CM4004-6-6-14Roller sets, 14 ea.CM4004C7-7-8Roller sets, 8 ea.JA728638PISTON-SLIPPER Assembly (GA, GC, GD, GH)CM4004C9-9RollerCM4004C7-7-26Roller sets, 26 ea.CM4004C7-7RollerCM4004C8-8-10Roller sets, 10 ea.CM4004-6-6-30Roller sets, 30 ea.CM4004C8-12-12Roller sets, 12 ea.CM4004-6-6-18Roller sets, 18 ea.CM4004C8-8-20Roller sets, 20 ea.CM4004C8-12-8Roller sets, 8 ea.CM4004-6-6-22Roller sets, 22 ea.CM4004-6-6RollerCM4004C8-8-18Roller sets, 18 ea.CM27648RollerCM4004-6-6-12Roller sets, 12 ea.CM4004C7-7-48Roller sets, 48 ea.CM4004C7-7-18Roller sets, 18 ea.CM4004C5-5-6Roller sets, 6 ea.CM4004C7-7-24Roller sets, 24 ea.CM4004C8-8-16Roller sets, 16 ea.CM4004-6-6-32Roller sets, 32 ea.CM4004-6-6-25Roller sets, 25 ea.CM4004C8-8-8Roller sets, 8 ea.CM4004C8-12RollerJASD1334PISTON-SLIPPER Assembly (GJ, GL)
Back to Boeing 727-294