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.
BACC13Y3A35Cable AssyBACC2C4C00345FGCable AssyBACC2C3D01384FGCable AssyBACC2C3D08397EFCable AssyBACC2C3B11443EFCable AssyBACC2C3D03275CFCable AssyBACC13Y3B103Cable AssyBACC13AP3E2894Cable AssyBACC2C3D06581EFCable AssyBACC2C4A04130EFCable AssyBACC13AP4D8488Cable AssyBACC13Y3B60Cable AssyBACC2C4C01364FGCable AssyBACC2C3D11566EFCable AssyBACC2C4A04478FGCable AssyBACC2C3B03890EFCable AssyBACC13AP3B77Cable AssyBACC2C3D02444EGCable AssyBACC13AP3E2026Cable AssyBACC2C3D00201BECable AssyBACC2C4C00799EGCable AssyBACC2C4A00312EGCable AssyBACC2C3D03598FGCable AssyBACC2C3B03339EECable AssyBACC2C4C03922EFCable AssyBACC2C4C03466FGCable AssyBACC2D3B02215FGCable AssyBACC13AP3E1087Cable AssyBACC2C4A02988EFCable AssyBACC13AA3T55-3345Cable AssyBACC2C4C07627EFCable AssyBACC2C3D01247DGCable AssyBACC2C4C07661EFCable AssyBACC13AP3D8554Cable AssyBACC13AP4D7543Cable AssyBACC13AP4D312Cable AssyBACC2C3D05892FFCable AssyBACC13AP3B77ACable AssyBACC13AA3T45-5194Cable AssyBACC2C3D05114EFCable AssyBACC13AP3B364Cable AssyBACC2C4A03241EFCable AssyBACC2C3D07537EFCable AssyBACC13AP4E1045ACable AssyBACC2C4A07516FGCable AssyBACC2A2C00110BBCable AssyBACC2C3B01385FGCable AssyBACC2C4A07647FGCable AssyBACC2C4C04238EFCable AssyBACC13AA3T45-15074Cable Assy
Back to Boeing 747-367