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.
F1PL39237Cap Assembly, Light Assembly318-630-1003-142Indicator Light Assembly, Light Assembly318-630-1001-274Indicator Light Assembly, Indicator054-1011-029Base Assembly, Light Assembly318-630-1001-235Indicator Light Assembly, Indicator515-1011-087Cap Assembly, Light AssemblyF1WL19004Cap Assembly, Light Assembly042-1008-009Base Assembly, Light Assembly318-630-1001-390Indicator Light Assembly, Indicator318-630-1001-190Indicator Light Assembly, Indicator318-630-1001-179Indicator Light Assembly, Indicator318-630-1001-342Indicator Light Assembly, Indicator318-630-1001-058Indicator Light Assembly, Indicator318-630-1001-283Indicator Light Assembly, Indicator318-630-1001-137Indicator Light Assembly, Indicator318-630-1001-296Indicator Light Assembly, Indicator515-1031-021Cap Assembly, Light Assembly319-619-1002-006Indicator Light Assembly, Light Assembly319-619-1001-145Indicator Light Assembly, Light Assembly318-630-1003-072Indicator Light Assembly, Light Assembly318-630-1002-088Indicator Light Assembly, Indicator318-630-1001-250Indicator Light Assembly, Indicator314-614-1001-002Indicator Light Assembly, Light318-630-1003-003Indicator Light Assembly, Light Assembly318-630-1001-259Indicator Light Assembly, Indicator318-630-1001-123Indicator Light Assembly, Indicator318-630-1002-034Indicator Light Assembly, Indicator515-1011-029Cap Assembly, Light Assembly318-630-1003-004Indicator Light Assembly, Light Assembly317-631-1001-025Indicator Light Assembly, Indicator318-630-8571-020Indicator Light Assembly, Light Assembly318-630-1001-063Indicator Light Assembly, Indicator318-630-1003-155Indicator Light Assembly, Light Assembly515-1011-013Cap Assembly, Light Assembly211-1010-002Base Assembly318-630-1003-019Indicator Light Assembly, Light Assembly054-515-1011-036Indicator Light Assembly, Light Assembly318-630-4951-041Indicator Light Assembly, Light Assembly054-1011-028Base Assembly, Light Assembly318-630-1001-054Indicator Light Assembly, Indicator318-630-1001-420Indicator Light Assembly, Indicator318-630-1001-117Indicator Light Assembly, Indicator318-630-4951-085Indicator Light Assembly318-630-1001-326Indicator Light Assembly, Indicator318-630-1001-345Indicator Light Assembly, Indicator318-630-1001-051Indicator Light Assembly, Indicator318-630-1001-306Indicator Light Assembly, Indicator318-630-8571-019Indicator Light Assembly, Light Assembly054-515-1011-074Indicator Light Assembly, Light Assembly318-630-4951-039Indicator Light Assembly, Light Assembly
Back to Boeing 727-270