Boeing 727-270
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.
2732VBWMarker-"Pounds etc."ADNE4-202BearingADNEL8-201Bearing0749ADMarker-"Lbs. etc."ADSB25-201Bearing2729PBWMarker-"Curtain etc."ADBY8V7BearingASB8-54DUBearingADNE8-203BearingAD63-201ABearingADW40AAV5BearingADF24-201ABushingADSB6-201BearingADF08-203ABushingAD14-202ABearingADNE4-204BearingAGB16V5BearingADSB20-12BearingASB4-54DUBearingARB6E76BearingAD38-201ABushingAB10E30BearingADL50-201BearingAD44-201ABearingADSB40-203BearingADNE5-211BearingAGB10V5Bearing2726PRWMarker-"Emergency etc."AFDU20-9-3BushingADSB4V8BearingADNE10-202BearingAD60-201ABearingADF44-201ABearingADW40AAV4BearingADNE4-203BearingARBL6E76BearingAD10-202ABearingAFDU8-17-11BushingADNE4-207BearingADNE5-210BearingADN5-206Bearing1640PRWMarker-"Extinguisher etc."AFDU20-8-2BushingASB12-54DUBearingADF08-201ABushingASB6-55DUBearingADSB6-61Bearing1662VRWMarker-"Exit etc."AD05-301BushingADU8-10-9Bushing
Back to Boeing 727-270