Douglas DC-9-11
PMA parts · 9,789
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 ('A6WE')
AND len(list_intersect(tcds_models, ['DC-9-11'])) > 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 ('A6WE')
AND len(list_intersect(tcds_models, ['DC-9-11'])) > 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.
9934503-588Edge Panel Lighting Systems9934503-590Edge Panel Lighting Systems9934504-514Edge Panel Lighting Systems9934503-587Edge Panel Lighting Systems9934503-592Edge Panel Lighting Systems7578137-101Filter Element, Fluid, Disposable734524WEGearshaft, Spur8050917-0003WEPaper, Roll700348WEGearshaft,Spur7690PRWMarker-As etc.7649MSPMarker-Brake etc.7724MSBMarker-Pump etc.7685PXWMarker-PBE etc.7705PRWMarker-Symbol7692VWRMarker-Mobil etc.2061VBWMarker-To etc702412WERetainer, Set SlipperP00019Mating Ring716009WERetainer702442WEGlass Sight356929-140WECarrier SetC3495100009Overspeed Warning SwitchB3668910021Indicator, Dual Cabin Altitude and Differential PressureC3495110051Overspeed Warning Sensor8311-012Shroud Assembly Upper Center R/H4251-010AEShroud, Lower Aisle R/H4278-017AEShroud, Upper Center8311-011Shroud Assembly Upper Center L/H4024-001AEShroud, Center Console8311-012EOShroud Assembly Upper Center R/H8311-011HShroud Assembly Upper Center L/H4251-009AEShroud, Lower Aisle L/H8311-011EOShroud Assembly Upper Center L/H8311-012HShroud Assembly Upper Center R/H0932501-WShade Assembly Window Cabin Sidewall7579117Filter Element51335-311Ashtray63040-603-950GAshtray7607VSRMarker-"Emergency etc"7609VMWMarker-"Pull etc."7616MSPMarker-"Use etc."6431VRWLMarker-"Cargo etc."7613MSRMarker-"Danger etc."7608VSRMarker-"Emergency etc."5101MBSMarker- Rescue etc7605VBYMarker-"This etc."7232VRWMarker-"Danger etc."7615MSPMarker-"Valve etc."7602PMWLMarker-"Life etc."7624CEBMarker- Aoa etc.
Back to Douglas DC-9-11