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.
5956511-51Spacer5956511-33Trim5956563-133Panel5916092-56Lining5921273-25Waist Trim5956552-221Spacer5956538-219Panel Assembly5956503-5Cover3921919-3Bracket5956538-265Panel Assembly5913250-19Clip3914001-513Retainer Assembly5913250-88Clip4956649-3Link5919177-163Panel Assembly5956503-7Trim5956552-239Panel5956552-155Panel Assembly5919177-83Bracket5919177-169Bracket Assembly5956552-137Panel5956552-175Spacer5956503-3Panel5955930-8Angle5956538-267Door5932339-3Blocking5916092-11Angle5920874-41Cup5956538-251Panel Assembly5956538-91Trim Assembly3914575-3Bracket5919177-111Bracket3913850-515Retainer Assembly5914514-109Blocking3913850-75Plate5920874-37Cup5916092-41Lining3914001-1Retainer Assembly5956563-155Support5956503-43Washer3914582-5Support5956552-153Panel5914514-13PlateL8601155Valve GuideL8602298Air Heat Exchanger9928109 thru 9928110Light Panel2917321-1Light Panel9933905 thru 9933939Light Panel9958250 thru 9958299Panel A9933900 thru 9933904Light Panel
Back to Douglas DC-9-11