Boeing 747-400D
PMA parts · 105,720
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 ('A20WE')
AND len(list_intersect(tcds_models, ['747-400D Series'])) > 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 ('A20WE')
AND len(list_intersect(tcds_models, ['747-400D Series'])) > 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.
732-11610-02Modular Assembly, Reservoir Pressurization732-16810-03Actuator, Lateral Trim732-11610-02Modular Assembly, Reservoir Pressurization732-11610-02Modular Assembly, Reservoir Pressurization732-16810-03Actuator, Lateral Trim09-270420-001Lavatory Water Heater09-270420-001Lavatory Water Heater449189LAValve, Safety AssyM123327-1Roller AssemblyMBCTS346-1Bearing4900397-7WEBearing-BallM126327-1Roller Assembly87-05546-001Light, Landing, PAR 64MBCTS346-1Bearing102-00099Sensor, Fuel Temp Resistance Bulb, FuelM123327-1Roller AssemblyP3A1090Bearing Assembly, Slotted EntryP20701Ball422B340LAOverhaul Kit287303-1KMRoller UnitADV-TNK-06Tank, Welded AssyN166471-5WEWasher, Sealing163U6001-1KMMain Landing Gear Hub Cap Assembly33183-001 (M X-54-1)Battery (Nickel-Cadmium163U6001-4KMMain Landing Gear Hub Cap163U6001-5KMMain Landing Gear Hub Cap Assembly401-67779JP-01Switch Assembly4431020JP-005Mic Wire AssemblyM140-00-850-86Support RH (Right Hand)M140-00-850-85Support LH (Left Hand)69002869-001FSHeater Switch AssemblyH999109Gasket2831-3Air Heater2831-2Air Heater2174Gasket Heater2880-( )Innerline HeaterVA-2610-P01-CSmoke Detector Plate-CoverZ270H1000210JAAngleZ270H3000111JAOutlet Unit Amendment BZ270H1000220JAHousingZ270H1000001JACasing447883LAValve, Safety AssyR30M-1ACPulley, Control, Machined PhenolicR30K-3SCPulley, Control, Machined Phenolic LaminateR30K-2SCPulley, Control, Machined Phenolic LaminateR30K-4SCPulley, Control, Machined Phenolic LaminateR30K-1SCPulley, Control, Machined Phenolic LaminateR30K-4SCPulley, Control, Machined Phenolic LaminateR30K-5SCPulley, Control, Machined Phenolic LaminateR30M-2CPulley, Control, Machined Phenolic
Back to Boeing 747-400D