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.
BACC2C3D01378GGCable AssyBACC2C3B01464FGCable AssyBACC2C3D02498FGCable AssyBACC2C3B01391CCCable AssyBACC13AP3D4336Cable AssyBACC13AA4T45-1795Cable AssyBACC2C4A03467FGCable AssyBACC13AP3B806Cable AssyBACC2C3D00681CGCable AssyBACC2C4A00871FGCable AssyBACC13Y3-60Cable AssyBACC2C3B01728EGCable AssyBACC2C3D00142EGCable AssyBACC13AP3E2550Cable AssyBACC2D3B02203FGCable AssyBACC2C3B03409EFCable AssyBACC2C3B08019FGCable AssyBACC13AP4E7653Cable AssyBACC2C3B02028FGCable AssyBACC2C3D10301EFCable AssyBACC2C4A09223FFCable AssyBACC2C3B09840EGCable AssyBACC2C3D05818CFCable AssyBACC13AP3C2955Cable AssyBACC13AA3T45-3805Cable AssyBACC13AA3T45-15167Cable AssyBACC13AP3C1314Cable AssyBACC2C3D00285EGCable AssyBACC13AP4E901Cable AssyBACC13AP3D2120Cable AssyBACC2C3B03112FGCable AssyBACC13AP4E551Cable AssyBACC2A6B00110ABCable AssyBACC13AP3D2192ACable AssyBACC2D3A00100BBCable AssyBACC13AP4D831ACable AssyBACC13AP3E265Cable AssyBACC13AP3D8064Cable AssyBACC2C4A03847EGCable AssyBACC2C4C04262FGCable AssyBACC13AA3T45-5750Cable AssyBACC2C3D06059CECable AssyBACC13AA3T45-10282Cable AssyBACC2C3D03477CECable AssyBACC2C3B03806EFCable AssyBACC13AP3E10591Cable AssyBACC2C3D02814DGCable AssyBACC13AA4T45-4570Cable AssyBACC13AA3T45-7535Cable AssyBACC13AP3D1959Cable Assy
Back to Boeing 747-367