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.
BACC13AP4E7506Cable AssyBACC2C4C00288EGCable AssyBACC13AP3E2023Cable AssyBACC2D3B03806EFCable AssyBACC2C4A00551FGCable AssyBACC13AP3E2372Cable AssyBACC13AP4E8094Cable AssyBACC2C4A01518EECable AssyBACC13AA4T84-7580Cable AssyBACC2C3B11573EFCable AssyBACC2C3B04637EECable AssyBACC13AP4D2302Cable AssyBACC2C4C02451FGCable AssyBACC2C3D05479DECable AssyBACC2C3D11568EFCable AssyBACC13AP3E2540Cable AssyBACC13AA3T45-10766Cable AssyBACC2C3B00260EGCable AssyBACC13AP3D2610Cable AssyBACC2C3D07498FFCable AssyBACC2C3D05822CFCable AssyBACC2C4A03924EFCable AssyBACC2C3B06231EECable AssyBACC13AP3C4336Cable AssyBACC13AA3T45-9250Cable AssyBACC13AP4D630Cable AssyBACC13AP4D3839Cable AssyBACC13AP4E312ACable AssyBACC2C3D01387FGCable AssyBACC2C4C08268FGCable AssyBACC13AA3T35-1521Cable AssyBACC2C3D07540EFCable AssyBACC2C3B02540FGCable AssyBACC2C3D05846EFCable AssyBACC2C3D10580FGCable AssyBACC13Y3-72Cable AssyBACC13AP3D1635Cable AssyBACC13AA3T47-4122Cable AssyBACC2C3B03734EECable AssyBACC2D3B03214EFCable AssyBACC13AA3T56-6304Cable AssyBACC13Y3-177Cable AssyBACC13AP4D654Cable AssyBACC13AP3D2190Cable AssyBACC13AP4E1045Cable AssyBACC13Y3B282Cable AssyBACC2C4A00799EGCable AssyBACC13AP3D1643ACable AssyBACC13AP4E8735Cable AssyBACC13AA3T47-2991Cable Assy
Back to Boeing 747-367