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.
6860VBCMarker-Coat etc6881VBCMarker-Life etc6888VBCMarker-Seat etc6904VYYStencil-Interphone etc6866PRWMarker-Fire etc6899VYYStencil-For etc6919VYYStencil-Pneumatic etc6764CRBMarker-Lwr etc6897VYYStencil-Engine etc6927VYYStencil-Starter etc6923VYYStencil-Water etc6926VYYStencil-Warning etc6885VWCMarker-Head etc6889VWCMarker-Table etc6887VWCMarker-Seat etc6858VBCMarker-Floor etc6876VBYMarker-Close etc6861VBCMarker-Seat etc6877VBCMarker-No 1 etc6853VBCMarker-Telephone etc6916VYYStencil-Thrust etc6924VYYStencil-Warning etc6898VYYStencil-Constant etc6928VYYStencil-Unlocked6909VYYStencil-Elevator etc6880VBCMarker-60 etcAD-43B034LB03Battery6706CCBMarker-Hdg etc6596PMWMarker-Symbol0104ADMarker-Open6620MSPMarker-1 Full etc1029MBSMarker-Use etc0334ADMarker-Engine etc6623MSBMarker-Pointer etc0297VRWMarker-External etc6763MSBMarker-Mlg etc0333ADMarker-Constant etc0106VRWMarker-Arrow0101ADMarker-Exit etc6700CCBMarker-Spd etc0105VRWMarker-Arrow0121VRWMarker-Arrow0207ADMarker-Arrow6599VMWMarker-Caution etc6598VRWMarker-This etc0102ADMarker-Emergency etcRPS1-BBattery Power Supply9D34-36107-501TCAS Antenna Coax Kit9D34-36107-502Mode S Antenna Coax Kit40405-16WEGerotor Set
Back to Douglas DC-9-11