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.
BACC2A3A03000AFCable AssyBACC13AP4E125ACable AssyBACC13AP4E864ACable AssyBACC13AP4D382Cable AssyBACC13AP3E859Cable AssyBACC13AP4B319ACable AssyBACC13AP3D4757ACable AssyBACC13AP6D5680ACable AssyBACC13G321-518TACable AssyBACC13AP3E695TCable AssyBACC2A4B00382EGCable AssyBACC13AP4D1406ACable AssyBACC2A3A00518GGCable AssyBACC13AA3T44-8067Cable AssyBACC2A4B03323FGCable AssyBACC13AA4T34-8380Cable AssyBACC13AE319-643TACable AssyBACC13AP4E492ACable AssyBACC13AP3D1766Cable AssyBACC2A3A08065FFCable AssyBACC13G328-2367TCable AssyBACC13AP4E3323ACable AssyBACC13ACF2230T4658ACable AssyBACC2A3A07686EECable AssyBACC2A4B04392FGCable AssyBACC13AA3T36-105Cable AssyBACC13AP3C854Cable AssyBACC13AP3D 652ACable AssyBACC13AP3E3254Cable AssyBACC2A4B00293FGCable AssyBACC13AP3B393TACable AssyBACC13AP6D2398ACable AssyBACC13AA3T27A472Cable AssyBACC13AP4D1232ACable AssyBACC2A3A00680BCCable AssyBACC13AP3D6738ACable AssyBACC13AP6E1932Cable AssyBACC2A4B25210BGCable AssyBACC2A4B00238EGCable AssyBACC13AA3T27A501Cable AssyBACC13ACH2526T4810ACable AssyBACC13AP4E4890ACable AssyBACC13AA3T44A800Cable AssyBACC13G321-1332TACable AssyBACC2A4B02805FGCable AssyBACC2A3A05700EGCable AssyBACC13AP6E538Cable AssyBACC13ACF427T870ACable AssyBACC13AP3E695TACable AssyBACC2A4B00280EGCable Assy
Back to Boeing 727-270