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.
BACC13AA3T45-5617Cable AssyBACC13AP3B278Cable AssyBACC2C3D01727EGCable AssyBACC2C4C03845EGCable AssyBACC13AP4E5371Cable AssyBACC2C4A02231FGCable AssyBACC13AP3B1402Cable AssyBACC13AA4T44-9376Cable AssyBACC2C4A08735FGCable AssyBACC13AP3B128ACable AssyBACC2C3D04865EFCable AssyBACC2C4C07588EGCable AssyBACC2C3D09242EFCable AssyBACC2C4C01558EGCable AssyBACC13Y3-65Cable AssyBACC2C3B05124CFCable AssyBACC2C3B02167EGCable AssyBACC2C4A07492FGCable AssyBACC13AP4D5145Cable AssyBACC2C3B04090EFCable AssyBACC2C4C01517EECable AssyBACC2C4C08319FGCable AssyBACC2C4C00173EGCable AssyBACC2C3B02196FGCable AssyBACC2C3D05081EFCable AssyBACC2C3D11440EFCable AssyBACC2C3D01771EGCable AssyBACC2C3B06624EFCable AssyBACC2C3B00260FGCable AssyBACC13Y3A085Cable AssyBACC2A5D00162BFCable AssyBACC13AP4E340Cable AssyBACC13AP3D184ACable AssyBACC13AA4T45-9670Cable AssyBACC13Y4B60Cable AssyBACC2C4A00288EGCable AssyBACC13AA4T45-3923Cable AssyBACC13AP4E8043Cable AssyBACC13AP3D3773Cable AssyBACC13AP3B361Cable AssyBACC2C3B06026EFCable AssyBACC13Y4-080Cable AssyBACC13AA3T45-3821Cable AssyBACC13Y3A30Cable AssyBACC2C3D04991EGCable AssyBACC2A2C00050HHCable AssyBACC2C4C03428EFCable AssyBACC2C4C04358EFCable AssyBACC2D3B02180FGCable AssyBACC13AP4E3467Cable Assy
Back to Boeing 747-367