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.
3829PRWMarker-"Ashtray etc"1657PRWMarker-"Lavabo etc."4541VBWLMarker-"Hatch etc"2012VWBMarker-"Cabin etc."3952CEBMarker-"Eng etc."1604MSRMarker-"Trays etc."2552PRWLMarker-"Over etc."3428CCBMarker-"Gpws etc."4745MSBLMarker-"Max etc."1634VWBMarker-"Stow etc"1825VRWMarker-"Deactivated"3925CABMarker-"Ignition etc."3170VWGLMarker-"Gpws etc."4547VRWMarker-"L/H etc"1170VWBMarker-"F/O etc."5018MRSLMarker-"Caution etc."4830VBCLMarker- No etc.3081PRWMarker-Life etc."4915PMWLMarker-"Warning etc."2077VRWMarker-"Oil etc."3976PRWLMarker-"Life etc."4896PRWLMarker-"CPR etc."2699VWBMarker-"Omega etc."5006VRCLMarker-"Emergency etc."2378MBSMarker-"Epr etc."4093MSBLMarker-"This etc."4610VRGLMarker-"Fasten etc."2094VWBMarker-"Windshear etc."2597VBCLMarker-"Fasten etc."1263VWBMarker-"Right etc."3434MSBLMarker-"Gpws etc."2006PBWMarker-"Fasten etc."4299VBWMarker-"Mirror etc."2968VBWMarker-"Deact"1715VBWMarker-"Slide etc."4758VBWMarker-"Inflate etc."4803VRWMarker-"Push etc."4716VMWMarker-"Caution etc."4235VBWMarker-"Thrust etc"4053VRWLMarker-"Open etc."1983PBWMarker-"Water etc."2702VWBMarker-"Tas etc."4774PRWMarker-"Pull etc."3100PBWLMarker-"Demo etc."3322MRSLMarker-"R main etc"2996VRWMarker-"Push etc"1656PRWMarker-"Prohibido etc4756VBWMarker-"Thrust etc."4749MSBLMarker-"Max etc."2099VWBMarker-"R20 etc"
Back to Douglas DC-9-11