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.
BACC2C3B00278CGCable AssyBACC2C3B01992FGCable AssyBACC13AP3E10583Cable AssyBACC2C3D10676FGCable AssyBACC13AP4D1506Cable AssyBACC2C3D01812DGCable AssyBACC2C4A04524EGCable AssyBACC2D3B02009EGCable AssyBACC13AA3T57-2792Cable AssyBACC13AA3T45-8411Cable AssyBACC2C3B03214EFCable AssyBACC2C3D02157EGCable AssyBACC2C3D02461FGCable AssyBACC2C3D01401CGCable AssyBACC13AP3C176ACable AssyBACC2C4A07591EGCable AssyBACC2C4C02102EFCable AssyBACC13AP4D665Cable AssyBACC13AP3E8019Cable AssyBACC2C4C12177EFCable AssyBACC2C4A09329EFCable AssyBACC13AA3T57-3484Cable AssyBACC2C4C05277FGCable AssyBACC2C3D07104EECable AssyBACC13Y3A88Cable AssyBACC13AP4E2257Cable AssyBACC13AP3E1210Cable AssyBACC13AA3T57-2980Cable AssyBACC13AP4E1364Cable AssyBACC2C4C03973EFCable AssyBACC2C3D02265EECable AssyBACC13AA3T45-4686Cable AssyBACC13Y3A120Cable AssyBACC13Y3A095Cable AssyBACC13AA3T35-1535Cable AssyBACC2C3B05848EFCable AssyBACC2C3D02634CECable AssyBACC13AP3C2596ACable AssyBACC2C4A00755EGCable AssyBACC2C3D02623EGCable AssyBACC2A2A00125BBCable AssyBACC2C3B02593DGCable AssyBACC2C3B00685DGCable AssyBACC2C4C00670EGCable AssyBACC2D3B03201EFCable AssyBACC13AA3T47A7483ACable AssyBACC2C4C02728FGCable AssyBACC2C4C01499EGCable AssyBACC2C3B03422EGCable AssyBACC13AP3C176Cable Assy
Back to Boeing 747-367