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.
BACB30LJ5U39Bolt, Hex HeadBACB30LJ6-23Bolt, Hex HeadBACB30LJ6HU8Bolt, Hex HeadBACB30LJ5U30Bolt, Hex HeadBACB30LJ6-10Bolt, Hex HeadBACB30LJ6-24Bolt, Hex HeadBACB30LJ5U18Bolt, Hex HeadBACB30LJ5U56Bolt, Hex HeadBACB30LJ6-18Bolt, Hex HeadBACB30LJ6DU21Bolt, Hex HeadBACB30LJ6-26Bolt, Hex HeadBACB30LJ6-21Bolt, Hex HeadBACB30LJ5U15Bolt, Hex HeadBACB30LJ5U35Bolt, Hex HeadBACB30LJ5-24Bolt, Hex HeadBACB30LJ5-18Bolt, Hex HeadBACB30LJ5-20Bolt, Hex HeadBACB30LJ4U2Bolt, Hex HeadBACB30LJ4U3Bolt, Hex HeadBACB30LJ5CD18Bolt, Hex HeadBACB30LJ4U22Bolt, Hex HeadBACB30LJ5-13XBolt, Hex HeadBACB30LJ5-26Bolt, Hex HeadBACB30LJ4U15Bolt, Hex HeadBACB30LJ4D20Bolt, Hex HeadRF4DRoller BearingBACB30LJ4D28Bolt, Hex HeadBACB30LJ4HU5Bolt, Hex Head6373PRWMarker-"Airsick etc."6351VRCMarker-"Exit etc."6352VRCMarker-"Exit etc."27231-037Lower Bearing Assembly - Shock Strut, Main Gear6396VBWMarker-"Cargo etc."6395MMBMarker-"Caution etc."27233-037Housing - Lower Bearing Assembly - Shock Strut, Main GearE500161Full Size Meal/Bev. CartKP33BNGCBearing, ballKP29BSNGCBearing, ballB544DDNGCBearing, ballMB541DDNGCBearing, ballKP21BSNGCBearing, ballMKP37BNGCBearing, ballKP49BNGCBearing, ballKP25BNGCBearing, ballB541DDNGCBearing, ballMKP37BSNGCBearing, ballB538DDNGCBearing, ballKP23BNGCBearing, ballB539DDNGCBearing, ballB543DDNGCBearing, ball
Back to Boeing 727-270