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.
PR071118F14S8-200Connector, Electrical, Receptacle, Flange Mount, Threaded Coupling, Vibr. Res.PR071028D42P7-200Connector, ElectricPR071016D10PN-200Connector, Electrical, Plug, Straight, Threaded Coupling, Self-LockingPR070014G07SN-200Connector, ElectricPR071020G39SN-200Connector, CircularPR071708B03SN-000Connector, Electrical, Receptacle, Flange Mount, Bayonet CouplingPR070020B41S6-200Connector, Electrical, Plug, Straight, Bayonet Coupling, Vibration ResistantPR071020G39P6-200Connector, ElectricPR071112J12PN-200Connector, ElectricPR071214B15SN-200Connector, ElectricPR071020G39P6-200Connector, Electrical, Plug, Straight, Threaded Coupling, Self-LockingPR071018G31P6-200Connector, ElectricPR070118G14PN-200Connector, Electrical, Receptacle, Straight, Bayonet Coupling, Vibration ResistantPR071012D03S10-200Connector, Electrical, Plug, Straight, Threaded Coupling, Self-LockingPR071118A14S7-200Connector, Electrical, Recpt, Flange Mount, Threaded Coupling, Vib ResistantPR070020B28SN-200Connector, ElectricPR071120G41PN-200Connector, ReceptPR071912B12PN-000Connector, Electrical, Receptacle, Flange Mount, Threaded CouplingPR071114A07PN-200Connector, Electrical, Recpt, Flange Mount, Threaded Coupling, Vib ResistantPR071216B24SN-200Connector, Electrical, Plug, Straight, Bayonet Coupling, Vibration ResistantPR071112B03S7-200Connector, Electrical, Receptacle, Flange Mount, Threaded Coupling, Vibr. Res.PR071618B31S7-200Connector, ElectricPR071022A19SN-200Connector, ElectPR071018E31P6-200Connector, ElectPR071122B19P8-200Connector, ElectricPR071014H15SN-200Connector, Electrical, Plug, Straight, Threaded Coupling, Self-LockingPR071024G43P7-200Connector, Electrical, Plug, Straight, Threaded Coupling, Self-LockingPR071128A42SN-200Connector, ReceptPR071122J55SN-000Connector, Electrical, Receptacle, Flange Mount, Threaded Coupling, Vibr. Res.PR071122F12PN-200Connector, ReceptPR071118J31S7-200Connector, Electrical, Receptacle, Flange Mount, Threaded Coupling, Vibr. Res.PR071014G15PN-200Connector, Electrical, Plug, Straight, Threaded Coupling, Self-LockingPR071124J43S6-200Connector, ElectricPR071720B41S6-000Connector, Electrical, Receptacle, Flange Mount, Bayonet CouplingPR071124J43S8-200Connector, ElectricPR071022A12P6-200Connector, ElectPR071012A03S9-200Connector, ElectPR070122B32S9-200Connector, Electrical, Receptacle, Straight, Bayonet Coupling, Vibration ResistantPR071020G39SN-200Connector, Electrical, Plug, Straight, Threaded Coupling, Self-LockingPR071114F04PN-200Connector, Electrical, Receptacle, Flange Mount, Threaded Coupling, Vibr. Res.PR071018C14P6-200Connector, Electrical, Plug, Straight, Threaded Coupling, Self-LockingPR071114F04S9-200Connector, ElectricPR070120G16S9-200Connector, Electrical, Receptacle, Straight, Bayonet Coupling, Vibration ResistantPR070024G30P6-200Connector, Electrical, Plug, Straight, Bayonet Coupling, Vibration ResistantPR071120J39S6-200Connector, ElectricPR070022B55S8-200Connector, ElectricPR073922SE19PN-000Connector, Circular, ReceptaclePR071016D10SN-200Connector, ElectricPR071116G24P7-200Connector, ReceptPR071018G31P7-200Connector, Electric
Back to Boeing 747-400D