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.
5374CDispensor, CoffeePMA 50226OvenPMA 50049ACoffee MakerPMA 50074OvenPMA5423OvenPMA 50303Oven5420ACoffee MakerPMA 5141OvenPMA 5316OvenPMA5443Coffee MakerRD-AM6822Cable Assembly0140ADMarker - "Fasten Seat Belts . . . ."0110ADMarker - "Emergency Exit..."0141ADMarker - "Life Vest Under Seat"0162ADMarker - "Fire Extinguisher"0169ADMarker - "Towel Disposal . . ."0139ADMarker - "This Exit Inoperative"0143ADPMarker - "Toilet Flush"0117ADMarker - "Life Raft"DAC 5932558GalleyDAC 5931816Galley1-607, -608, -609, -610, -611, -614, -615, -616, -617, -618, -619GalleyDAC 5930237Galley5918610Galley5951701GalleyDAC 5930388GalleyDAC 5935379Galley5952595GalleyDAC 5934748Galley1-699, -700, -701, -702GalleyDAC 5930322Galley5918379GalleyDAC 5932895Galley5925654Galley5923517GalleyDAC 5934393GalleyDAC 5932378Galley1-527C, -574, -575GalleyDAC 5935241Galley1-657, -658, -659, -660, -661Galleys5928800Galley1-662, -663, -664, -665Galleys5925081GalleyDAC 5925125Galley5920236Galley5924571Galley5756234GalleyDAC 5934628Galley5932558Galley5932752Galley
Back to Douglas DC-9-11