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.
VTA09980Rod EndVTB08200Bearing AssemblyVPB0005BoltVTC00840BushingVTA05590Rod EndVTC00810BushingAA0758-4000Window, Dust Cover, DC9/MD-80910C605-1WEAdapter-SplineA-483-FRToilet SeatA-483 MOD-FRToilet Seat9207-10296RelayL20191-9Emergency Flood LightL18429-1Cargo Compartment LightL18429-2Cargo CompartmentDEC71-014-501Nozzle Assembly - Rain Repellent SystemDEC71-015-501Spring - Helical Extension, Center, Fwd Cabin Attendant Seat9002D14-1Transformer, Current947F945-3Generator Control Unit947F946-3AC Bus Control PanelA7532Chip DetectorA7532KChip Detector56-3Clamp9-1975Switch, Rotary9-1976SwitchVl1053SS3GasketABYK3-16LScrew-KeyABYK3-15LScrew-KeyABYK5-10MScrew-KeyABYK5-10MScrew-KeyABYK3-15LScrew-Key3500774-3AFIStarter Pawl51290-311Ashtray Assembly911020-001GSpeed Bug-Pointer1010GA2-521Packing, Performed1010GA2-520Packing, Performed1010GA2-012Packing, Performed1010GA2-604Packing, Performed1010GA2-580Packing, Performed116404BBearing1010GA2-161Packing, Performed1010GA2-018Packing, Performed1010GA2-115Packing, Performed1010GA2-016Packing, Performed4-FABBearing1010GA2-581Packing, Performed1010GA2-903Packing, Performed1010GA2-133Packing, Performed1010GA2-036Packing, Performed1010GA2-014Packing, Performed1010GA2-215Packing, Performed
Back to Douglas DC-9-11