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.
C221-1StanchionC221-41StanchionC221-53StanchionC221-36StanchionC221-61StanchionC221-48StanchionC221-43StanchionC221-60StanchionC221-44StanchionC221-37StanchionC221-25StanchionC221-55StanchionC221-15StanchionC221-59StanchionC221-30StanchionC221-29StanchionC221-33StanchionC221-52StanchionC221-51StanchionC221-4StanchionC221-40StanchionC221-46StanchionC221-45StanchionC221-35StanchionC221-3StanchionC264-4NetC762-4StanchionC220-43NetC220-36NetC263-96NetC263-71NetC216-8NetC665-9NetC762-6StanchionC762-1StanchionC471-4NetC263-59NetC263-72NetC263-51NetC216-3NetC264-5NetC752-1NetC471-1NetC665-3NetC665-7NetC471-7NetC753-28NetC263-91NetC752-2NetC263-48Net
Back to Boeing 727-270