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.
0896CEBMarker-"AC etc."0919MBSMarker-"Conversion Chart etc."0451VBCMarker-"Engine etc."0313ADMarker-"Mobil jet etc."0416ADMarker-"Stripe"0992CEBMarker-"Main etc."5765CEBMarker-"Transponder etc."0450ADMarker-"Nose gear etc."0442ADMarker-"Load etc."5268MSBMarker-"This etc."1010MSBMarker-"Max etc."5727VRWMarker-"Caution etc."0452VBCMarker-"Constant speed etc."5726VBWMarker-"Evacuation etc."1235MBSMarker-"Beer etc."1039MBSMarker-"Both etc."5621VWRMarker-"Do not etc."0995CEBMarker-"Bleed etc."5702VBWMarker-"Water etc."0756ADMarker-"Not etc."5560CEBMarker- Spoiler etc.0857CEBMarker-"L ice etc."1241MBSMarker-"Serving etc."0737ADMarker-"Aircraft etc."0484VBWLMarker-"Flushing etc."3870PBBMarker-"Stripe"1234MBSMarker-"Cokes"0929PRWMarker-"Pull etc.5701VBWMarker-"Water etc."1236MBSMarker-"Coffee"1340VRWMarker-"Sortie"5559CEBMarker-"Aids etc."1041MRSLMarker- Install etc.5517PBWLMarker-"Stow etc."5724VBYMarker-"American etc."0989CEBMarker-"Smoke etc."5445MBSLMarker-"Coffee etc."5705VRWLMarker-"Deactivated"5607CEBMarker-"AOA off"0592ADMarker-"Emergency etc."1342VBCMarker- return etc.5694MSBLMarker- Fueling etc.0754ADMarker-"Demonstration etc."1367VRWMarker-"Lavatory etc."1227MBSMarker-"Meals"1042MRSLMarker-"Life etc."5725VBYMarker-"Evacuation etc."5558CEBMarker-"Lavatory etc."1338VRWMarker-"Arrow etc."0473ADMarker-"Ground etc."
Back to Douglas DC-9-11