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.
31BM700CushionKP3-PBEARINGP00762Ring, PistonA-881-FRToilet SeatSP3810-09-1A050Gasket, FaucetSP2510-05-8160AHeater AssemblyA830800-55EXTINGUISHER, 530 CU IN DUAL OUTLET24E507040G01Lavatory Water Heater8921560G4Duct Heater24E506700G1Drain Mast8921560G5Duct Heater8921340G1Lavatory Water Heater8921867G1Fuel Drain Mast8921560G1Duct Heater24E507589G02Drain Mast8921270G2Drain Mast8921560G2Duct Heater8921560G3Duct Heater80220044WDBearing, Ball1090148Gear, SegmentFL3C6-4PULLEYR1419M14Cargo Steering ActuatorFL3C3-4PULLEY1212LT-1B1-01BEARING1202LT-1B1-01BEARING1203FF-1C1-02BEARING1211LLT-1C1-01BEARING1208LT-1B1-01BEARING1215LLT-1C1-01BEARING1172-1FSLight In Use1201FF-1C1-01BEARINGCPD403501FSResistor, Potentiometer1202FF-1C1-02BEARING1200LT-1B1-01BEARING1211-1B1-01BEARING1210LLT-1C1-01BEARING1207LT-1B1-01BEARING1213LT-1B1-01BEARING1204LT-1B1-01BEARING1209FF-1C1-01BEARING1201LT-1B1-01BEARING1209-1B1-01BEARING1213FF-1C1-01BEARINGCPD115622FSConnector, Telephone Jack1207-1B1-01BEARING1207LLT-1C1-01BEARING1204FF-1C1-04BEARING1207FF-1C1-02BEARING1214LT-1B1-01BEARING1215FF-1C1-01BEARING
Back to Boeing 747-400D