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.
BACC2C3D00215DGCable AssyBACC2C3B00265EGCable AssyBACC2C3B09279EFCable AssyBACC13AP3X1379Cable AssyBACC2C3D05193EFCable AssyBACC13AP3C2974ACable AssyBACC2C3D05828EFCable AssyBACC13AA3T47-5123Cable AssyBACC2D3B02189FGCable AssyBACC13AP4E8271Cable AssyBACC2D3B06068CECable AssyBACC13AP3B811Cable AssyBACC2C4C00621FGCable AssyBACC2C3D01991FGCable AssyBACC13AA4T45-4130Cable AssyBACC2C3B02479FGCable AssyBACC2D3B02164FGCable AssyBACC2C3B09753EFCable AssyBACC13AA3T47-5823Cable AssyBACC2C3D03421EGCable AssyBACC2C4C08730FGCable AssyBACC13AP4D3830Cable AssyBACC2C3B01635EGCable AssyBACC2C3B02026FGCable AssyBACC2C3D09837EGCable AssyBACC13AA3T44-4376Cable AssyBACC2C3B02963DGCable AssyBACC2C4C00309EGCable AssyBACC13AP3E2196Cable AssyBACC2C3B03478CECable AssyBACC2C3B07416CFCable AssyBACC2C3D01985FGCable AssyBACC2C3D03662EFCable AssyBACC13AP4E451Cable AssyBACC13AA3T45-10712Cable AssyBACC2C3D04375FFCable AssyBACC13AA4T84-7336Cable AssyBACC13AP3E10620ACable AssyBACC2C3D02142EGCable AssyBACC2C3B01016FGCable AssyBACC2C3D06575EFCable AssyBACC2C3D02609EGCable AssyBACC2C3D02653CFCable AssyBACC13Y3A80Cable AssyBACC2C4A08324FGCable AssyBACC13AP4E182Cable AssyBACC13AP4E2729Cable AssyBACC2C3D07455CFCable AssyBACC13AA3T45-11977Cable AssyBACC2C4C00300EGCable Assy
Back to Boeing 747-367