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.
1635VWBMarker-"Ground etc."4585VXWLMarker-"Key etc."4883VBWMarker-"Your etc."5974VMWLMarker-"Passenger etc"4808MSBLMarker-"Max etc."4298VRWMarker-"Warning etc."0109ADMarker-"Push"4759MBSMarker-"To etc."3071VWBMarker-"Omega etc."4777VBWMarker-"Toilet etc."3353PRWLMarker-"Balsa etc."4753VBWMarker-"Capacity etc."1669VRWMarker-"Maximum etc."3143VRWMarker-"Push etc."4890VRWMarker- No etc.1968VWBMarker-"Landing etc."4778VBWMarker-"Toilet etc."4747MSBLMarker-"Max etc."4797VRWMarker-"Warning etc."2054MBSMarker-"Service etc."3805VBWMarker-"Minimum etc"3745VBWLMarker-"Use etc."2511VBWMarker-"Emergency etc."2043VWBLMarker-"Windshear etc."4821PRWLMarker-"Emergency etc."4955VRCLMarker-"Exit"2959VBWMarker-"Use etc."3423VBWMarker-"Use etc."4237VBWMarker-"Tailcone etc"3049VWBMarker-"Wind etc."4806VWBLMarker-"Cockpit etc."1175VWBMarker- Capt etc.5015VBWLMarker-"Tie etc."2119VBWMarker-"Crew etc."2040VBWMarker-"Fasten etc."4065MBSMarker-"Coffee etc."3142VRWMarker-"Barra etc"3648PBWLMarker-"As etc."2097VWBMarker-"115 etc"1644VRWMarker-"Demo etc."3889VRCLMarker-"This etc."4546VRWMarker-"NLG etc."4209VRWLMarker-"Service etc"4629VBWLMarker-"Air etc."3718VRWLMarker-"Open etc"1771VWBMarker-"Cabin etc."4714VXWMarker-"Do etc."1262VWBMarker-"Left etc."3409VBWLMarker-"Max etc"3899CEBMarker-"Tail etc."
Back to Douglas DC-9-11