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.
66-19379-2PLATE ASSY66-19379Y2PLATE ASSYA1650-13Hose AssemblyA1650-89Hose AssemblyA1650-41Hose AssemblyA1650-94Hose AssemblyA1650-85Hose Assembly3112001-34Potable Water Hose AssemblyA1650-82Hose AssemblyA1650-92Hose AssemblyA1650-96Hose AssemblyA1650-62Hose AssemblyA1650-73Hose Assembly3112001-42Potable Water Hose AssemblyA1650-20Hose AssemblyA1650-69Hose AssemblyA1650-76Hose AssemblyA1650-49Hose AssemblyA1650-8Hose Assembly3112002-23Hose AssemblyA1650-109Hose Assembly3112001-37Potable Water Hose Assembly3112001-179Hose AssemblyA1650-42Hose AssemblyA1650-77Hose AssemblyA1650-43Hose Assembly3112500-30Potable Water Hose Assembly3112003-5Potable Water Hose AssemblyA1650-9Hose AssemblyA1650-51Hose AssemblyA1650-84Hose AssemblyA1650-54Hose AssemblyB108-8Hose AssemblyA1650-112Hose Assembly3112003-161Hose Assembly3112001-46Hose AssemblyA1650-52Hose Assembly3112001-22Hose Assembly3112003-36Potable Water Hose AssemblyA1650-130Hose Assembly3112006-20Hose AssemblyA1650-111Hose AssemblyA1650-87Hose Assembly3112004-268Hose AssemblyA1650-205Hose AssemblyA1650-114Hose Assembly3112004-28Potable Water Hose Assembly3112002-29Potable Water Hose AssemblyA1650-113Hose AssemblyA1650-75Hose Assembly
Back to Boeing 727-270