Mcdonnell Douglas DC-9-15F
PMA parts · 9,945
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-15F'])) > 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-15F'])) > 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.
SP3558-50-1020BSleeveS8990-215JAPacking, Preformed – Silicone Rubber High Temperature, Low Compression SetM911020-001Speed Bug-Pointer734524WEGearshaft, Spur717832WEWasher-Thrust742687-2WEWasher, Machined759278WEPump Housing756368WEBushing, Flanged756367WEBushing, Flanged75281-2WEPlate, Gasket Seal, Oil Pump731222WEShaft, Shouldered758350WESeal, Stationary757649WERetainer Seal713328WESpring Seat716727WEShaft, Spline711917WEShaft Segment759259WEHousing, Pump710801WEBushing, Sleeve75281-1WEPlate, Gasket Seal, Oil Pump756361WERetainer Assembly756372WEShaft, Shouldered711150WEHousing, Pump716009WERetainer75281-6WEPlate, Gasket Seal, Oil Pump728638GHWEPiston andSlipperAssy.713806-1WEPaper Roll750351WESeal Mating Ring728638GAWEPiston andSlipperAssy.728638GDWEPiston andSlipperAssy.728638GCWEPiston andSlipperAssy.216630WEPacking, Preformed6667621Filter Element, Non-Cleanable7513983Filter Element, OilAG247000-05Gasket - Security System AntennaAG843000-19Gasket - VHF Antenna112-12 CPIndicator Light AssemblyAG477000-01SDGasketAG723000-02SDGasketL8602298Air Heat ExchangerL8601155Valve GuideL8601156SpringLB18D18CSD Oil Cooler AssemblyL8601157Valve PoppetLB22D31Core and Tank AssyL8602344-1Secondary Heat ExchangerL8602298Air Heat ExchangerL8601154Valve HousingM8050917-0006Paper RollM31Y1000-1Paper Roll AssemblyAG822000-03Gasket - TCAS Antenna
Back to Mcdonnell Douglas DC-9-15F