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.
BACC13AP4D506Cable AssyBACC2C4A04286EFCable AssyBACC13AP3E2194Cable AssyBACC2C3B02372FGCable AssyBACC13AA4T45-9290Cable AssyBACC2C4C00663EGCable AssyBACC13AA3T45-14746Cable AssyBACC13AA3T45-14445Cable AssyBACC2C3B01247DGCable AssyBACC2C3B04084CECable AssyBACC2C3B02537FGCable AssyBACC2C3D09361EFCable AssyBACC2C4C02230FGCable AssyBACC13AA4T45-5237Cable AssyBACC13AP3C2980Cable AssyBACC2C3D05481DECable AssyBACC13AP3D1791ACable AssyBACC2C4C09632FFCable AssyBACC13AP3E1763Cable AssyBACC13Y3B100Cable AssyBACC13AA3T47-5116Cable AssyBACC13AP4D312ACable AssyBACC13AP3B681Cable AssyBACC13AA4T44-1777Cable AssyBACC2C4C00908FGCable AssyBACC13AA3T47-5453Cable AssyBACC13AP3B405Cable AssyBACC2C3D01536BECable AssyBACC2C3B02055EGCable AssyBACC2C3D00278CGCable Assy7593446-705Kit, Filter ElementBACC2C4C00182EGCable AssyBACC2C3B11223EFCable AssyBACC2C3B05483DECable AssyBACC13AP4D755ACable AssyBACC2C3D05885FFCable AssyBACC13AP3E2504Cable AssyBACC13AA3T45-5114Cable AssyBACC2C3B02122EGCable AssyBACC2C4A07124FGCable AssyBACC13AP3C688Cable AssyBACC2C3D01335EGCable AssyBACC2A6B00429AECable AssyBACC2C3D00610CGCable AssyBACC2C4A00451FGCable AssyBACC2C3B00225DGCable AssyBACC2C3B03111FGCable AssyBACC2C3B07449CFCable AssyBACC2C3B01651EGCable AssyBACC2C3D02765DGCable Assy
Back to Boeing 747-367