Rolls-Royce 0-300 series
PMA parts · 1,447
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 engine 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 ('E-253')
AND len(list_intersect(tcds_models, ['O-300-A', 'O-300-D', 'O-300-C', 'O-300-B', 'O-300-E'])) > 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 ('E-253')
AND len(list_intersect(tcds_models, ['O-300-A', 'O-300-D', 'O-300-C', 'O-300-B', 'O-300-E'])) > 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.
SA1007P015Ring, PistonSA1007P005Ring, PistonSA1007Ring, PistonES10-400551-7Housing, DistributorES10-25788Bearing, SleeveES10-56513Pin, StopES1553Screw, Harness CapES-4024LPAlternator AssemblyES-4001Alternator AssemblyES-4024LP-2Alternator AssemblyES-4024LP-3Alternator AssemblyES10-357165-20Coil, MagnetoMHJ‐4003SStarter AssemblyES646238‐3Starter AssemblyES646238‐2Starter AssemblyES646275-1Starter Assembly55276Starter Adapter AssemblyMC402151P003StudMC402151P007StudMC402151P012StudES6364MagnetoES3520Clamp KitES10-52947Magnet, Rotating (Rotor)SA401870 P003StudSA402044 P003StudSA401870 P012StudSA402044 P012StudSA401885 P003StudSA402044 P007StudSA401885 P012StudSA401870 P007StudSA401885 P007StudMDL-2012ES-ACKit Brush AssemblyES646376-ACField CoilML-18A-ACBushing, Drive End BearingMDL-1005FS-ACField CoilMDL-1064E-ACBrush Plate AssemblyMHD-2012S-ACKit Brush Assembly630680ACBearing, RollerEBB-142A-ACBendix Drive90-726-ACKit, Thru Stud Package646328ACOil SealMFX-1064S-ACBrush Plate AssemblyMDL-1064ES-ACBrush Plate AssemblyES646351-ACField CoilX13041ACBearing, Ball641368ACBearing, NeedleMDC-0034-ACC.E. BushingML-18AACBushing- Drive End BearingMDC-0034ACC.E. Bushing
Back to Rolls-Royce 0-300 series