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.
MDL-1064EACBrush Plate AssemblyMCL-1005PS-1ACField CoilMFX-1064SACBrush Plate AssemblyES646351ACField Coil90-726ACKit - Thru Stud PackageMDL-1005FSACField CoilMHD-2012SACKit Brush AssemblyMDL-1064ESACBrush Plate AssemblyES646376ACField CoilMDL-2012ESACKit Brush AssemblyES3496RotorSA1007 P005Ring, PistonSA2106 P030Insert-Exhaust Valve SeatSA1007 P015Ring, PistonSA2106 P002Insert-Exhaust Valve SeatSA2106 P020Insert-Exhaust Valve SeatSA2106 P010Insert-Exhaust Valve SeatSA2000 P015Piston RingSA2000 P005Piston RingSA22949 P005Bushing, Rocker Shaft BossSA22949 M005Bushing, Rocker Shaft BossSA1000 P005Piston RingSA36171 M010Bearing, MainSA36170 M005Bearing, MainSA1000 P015Piston RingSA539800 M015Spring, ClutchSA36171 M005Bearing, MainSA22949 P020Bushing, Rocker Shaft BossSA36170 M010Bearing, MainX13041ACBearing - Ball641368ACBearing - Needle630680ACBearing - Roller646328ACOil SealPL13484Starter Motor 24 VoltPL13459Starter Motor 12 Volt55276Starter Adapter Assembly252511Ring, Oil Control252511NIRing, Oil ControlAEC649632PL (and oversize .005, .010, .015, appending the letter P, followed by the 3 digit oversize measurement to the part number)Piston Ring, Compression252511CCRing, Oil Control2209-1.31Stud, 5/16-18 x 5/16-24, 1-5/16 Long2259-1Plug, Machine Thread, 5/8-182209-1.25Stud, 5/16-18 x 5/16-24, 1-1/4 Long2201-1.00Stud, 1/4-20 x 1/4-28, 1 Long2209-1.31Stud, 5/16-18 x 5/16-24, 1-5/16 Long2208-1.63Stud, 3/8-16 x 3/8-24, 1-5/8 Long2201-1.19Stud, 1/4-20 x 1/4-28, 1-3/16 Long2201-1.19Stud, 1/4-20 x 1/4-28, 1-3/16 Long2208-1.53Stud, 3/8-16 x 3/8-24, 1-17/32 Long2209-1.38Stud, 5/16-18 x 5/16-24, 1-3/8 Long
Back to Rolls-Royce 0-300 series