Boeing 747-367
PMA parts · 58,851
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-300 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-300 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.
BACC2C3D02980DGCable AssyBACC2C3D04633EECable AssyBACC2C3B00341EGCable AssyBACC2C3D08303EFCable AssyBACC2C3B04770EFCable AssyBACC13AP3E2758Cable AssyBACC2C4C04781EFCable AssyBACC2C3D04687EFCable AssyBACC13AA3T45-8784Cable AssyBACC2C3B01774DGCable AssyBACC2C3B10283EFCable AssyBACC13AP3B610Cable AssyBACC13Y4-280Cable AssyBACC13G470-303TACable AssyBACC13AP3D9887Cable AssyBACC2C4A08320FGCable AssyBACC13AP3D130Cable AssyBACC2C4C01506EGCable AssyBACC13AA3T45-5081Cable AssyBACC2C3D04672EGCable AssyBACC2C3B05456EFCable AssyBACC13AP3D1791Cable AssyBACC13AP3E1867Cable AssyBACC13AP4D670Cable AssyBACC13AP4D7675Cable AssyBACC2C3D05473DECable AssyBACC2C4C00831EGCable AssyBACC2C4C07782EFCable AssyBACC2C3B01521BECable AssyBACC13AP3E2216Cable AssyBACC13AP3C2963Cable AssyBACC2C4C12163EFCable AssyBACC13AP4E1689Cable AssyBACC13AP4E4478Cable AssyBACC13AP3C2228Cable AssyBACC2C4C00630EGCable AssyBACC2C3D05079EFCable AssyBACC2C4A09670EFCable AssyBACC13AP3E260Cable AssyBACC13AP3E2367Cable AssyBACC13AP3E204Cable AssyBACC13ACK3508-6770ACable AssyBACC13Y3-50Cable AssyBACC13AA3T45-4057Cable AssyBACC2C3D02579DGCable AssyBACC13AA3T45-14765Cable AssyBACC13AA4T84-7441Cable AssyBACC2C4C03803EFCable AssyBACC2C4C07531FFCable AssyBACC13AA3T45-3870Cable Assy
Back to Boeing 747-367