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.
BACC2C3D04874CECable AssyBACC13AP3C2816ACable AssyBACC13AP3C736Cable AssyBACC2C3D06229EECable AssyBACC2C3D00303FGCable AssyBACC2C3D07493FFCable AssyBACC13AA3T45-2694Cable AssyBACC2C3D03946EFCable AssyBACC2C4C03173EFCable AssyBACC13AP3D1956Cable AssyBACC13AP3C2742Cable AssyBACC13ACE600-1290Cable AssyBACC2C4C02968EFCable AssyBACC2C4C08317FGCable AssyBACC13AP3C2579Cable AssyBACC13AP3D1775Cable AssyBACC2C4C05140EGCable AssyBACC2C4A01779FFCable AssyBACC2C3D03319FGCable AssyBACC2C4A00782EGCable AssyBACC2C4C07877FGCable AssyBACC2C3B01624EGCable AssyBACC13AA4T84-6872Cable AssyBACC13AA3T77-1391Cable AssyBACC2C4A00654EGCable AssyBACC2C4A00617FGCable AssyBACC2C3D03075BFCable AssyBACC13AA3T45-4794Cable AssyBACC2C3B00300DGCable AssyBACC2C3B01163CGCable AssyBACC13AP3D1223Cable AssyBACC2C4C03241EFCable AssyBACC13AP4E8324ACable AssyBACC2C3D01521BECable AssyBACC2C3B02773FGCable AssyBACC13AP3E9390Cable AssyBACC13AP3D1628Cable AssyBACC2C3D05732EFCable AssyBACC2C4C08261FGCable AssyBACC13AA3T55-5166ACable AssyBACC13AA3T45-8400Cable AssyBACC13AP3C762Cable AssyBACC13Y3B060Cable AssyBACC2C3D00265EGCable AssyBACC13AA3T57-5494Cable AssyBACC2C4A04058EFCable AssyBACC2C3D02982CECable AssyBACC13AP4D283Cable AssyBACC13AP4E8272Cable AssyBACC2D3B01790EGCable Assy
Back to Boeing 747-367