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.
318-630-1001-430Indicator Light Assembly, Indicator318-630-1001-432Indicator Light Assembly, IndicatorSCPCap Assembly, Light Assembly319-619-1001-061Indicator Light Assembly, Light Assembly211-611-1891-05Indicator Light Assembly, Light Assembly319-619-1001-115Indicator Light Assembly, Light Assembly318-630-1001-436Indicator Light Assembly, Indicator318-630-1001-319Indicator Light Assembly, Indicator318-630-1001-348Indicator Light Assembly, Indicator318-630-1001-155Indicator Light Assembly, Indicator319-619-1001-007Indicator Light Assembly, Light Assembly318-630-1001-056Indicator Light Assembly, Indicator318-630-1001-038Indicator Light Assembly, Indicator318-630-1001-092Indicator Light Assembly, Indicator318-630-1001-397Indicator Light Assembly, Indicator318-630-1001-129Indicator Light Assembly, Indicator318-630-1002-050Indicator Light Assembly, Indicator318-630-1001-114Indicator Light Assembly, Indicator318-630-1001-411Indicator Light Assembly, Indicator318-630-1001-320Indicator Light Assembly, Indicator317-631-1001-022Indicator Light Assembly, Indicator318-630-1001-073Indicator Light Assembly, Indicator515-1011-052Cap Assembly, Light Assembly318-630-1001-030Indicator Light Assembly, Indicator372-7451-002Switch, Light Assembly211-611-1891-01Indicator Light Assembly, Light Assembly372-7451-001Switch318-630-1001-037Indicator Light Assembly, Indicator088-1031-020Base Assembly133-533-1011-001Indicator Light Handle Assembly, Fire Switch Assy054-1011-007Base Assembly, Light Assembly318-630-1002-015Indicator Light Assembly, Indicator319-619-1001-119Indicator Light Assembly, Light Assembly318-630-1003-141Indicator Light Assembly, Light Assembly515-1031-005Cap Assembly, Light Assembly319-619-1001-053Indicator Light Assembly, Light AssemblyST260-HL6-22Indicator, Light Assembly318-630-1002-046Indicator Light Assembly, IndicatorSTB260Warning Light Assembly318-630-1002-052Indicator Light Assembly, Indicator318-630-1001-358Indicator Light Assembly, Indicator054-515-1011-097Indicator Light Assembly, Light Assembly318-630-4951-050Indicator Light Assembly, Light Assembly318-630-1002-047Indicator Light Assembly, Indicator11-6Cap Assembly, Light Assembly318-630-1001-413Indicator Light Assembly, Indicator319-619-1001-004Indicator Light Assembly, Light Assembly318-630-1001-017Indicator Light Assembly, Indicator318-630-2921-002Indicator Light Assembly, Light Assembly318-630-2921-001Indicator Light Assembly, Light Assembly
Back to Boeing 727-270