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.
BACC13AP4E7120Cable AssyBACC13AA4T45-4471Cable AssyBACC13AP4E8049Cable AssyBACC2C4C04058EFCable AssyBACC2C4A08090FGCable AssyBACC13AA4T44-7596Cable AssyBACC13AP3C1028Cable AssyBACC2C4C00309FGCable AssyBACC2D3B02025FGCable AssyBACC13AP3E3610Cable AssyBACC2C3D02537FGCable AssyBACC13AP3D2192Cable AssyBACC2C4A02564EGCable AssyBACC13AP3E10620Cable AssyBACC2C4C07540EGCable AssyBACC2C3B01775EGCable AssyBACC2C4A07520FGCable AssyBACC2C3B04375FFCable AssyBACC13AP3E1992Cable AssyBACC2C3D03773FGCable AssyBACC2C4C04943FGCable AssyBACC2C3B06070CECable AssyBACC2C3B03064BFCable AssyBACC2C3B01443FGCable AssyBACC13AP3C2228ACable AssyBACC13AA3T45-10384Cable AssyBACC13AA3T47-3491Cable AssyBACC13AP4E8324Cable AssyBACC13AA3T45-9702Cable AssyBACC2C4C11736EFCable AssyBACC2C3B01242EGCable AssyBACC2C3B01379GGCable AssyBACC2C4C00665EGCable AssyBACC13AP4E7880Cable AssyBACC2C4A00831GGCable AssyBACC13AA3T47-2653Cable AssyBACC13AA3T45-6364Cable AssyBACC2C4A02700EGCable AssyBACC2C3B07495FFCable AssyBACC2C3B00130EGCable AssyBACC2C3D04125EFCable AssyBACC13AP4D2700Cable AssyBACC2C3B05830EFCable AssyBACC13AP4E7812Cable AssyBACC2C4A08043FGCable AssyBACC13AP3E2386Cable AssyBACC2C3D05183EFCable AssyBACC13AP3D2122Cable AssyBACC2C3B00303FGCable AssyBACC2C4A02257FGCable Assy
Back to Boeing 747-367