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.
BACC13AP3D1651Cable AssyBACC13AP3D1624Cable AssyBACC2C4C07113FGCable AssyBACC13AA3T57-2634ACable AssyBACC2C3D01912BECable AssyBACC2C3B02752DGCable AssyBACC2C4C09219FFCable AssyBACC2C4C08487FGCable AssyBACC2C4A01336FGCable AssyBACC2C3B02610EGCable AssyBACC2C4A03610EFCable AssyBACC2C3B05488CFCable AssyBACC13AA3T47-3275Cable AssyBACC13AA3T55-6231Cable AssyBACC13AP3X638ACable AssyBACC2C3B00142EGCable AssyBACC2C3D03314FGCable AssyBACC2C3D03493CFCable AssyBACC13AA4T45-2967Cable AssyBACC2C4A08488EGCable AssyBACC2C3D01482FGCable AssyBACC2C3D00405CGCable AssyBACC2C3B01763FGCable AssyBACC13AP3E660Cable AssyBACC13AA3T45-8013Cable AssyBACC2C4C09653FGCable AssyBACC2C4C04568EFCable AssyBACC2C4C00313EGCable AssyBACC2C3B02103EGCable AssyBACC2C3B01314DGCable AssyBACC2C4C07842EFCable AssyBACC2C3D04089EFCable AssyBACC13AA3T57-3476Cable AssyBACC2C3B10738EFCable AssyBACC13Y3B110Cable AssyBACC2C3D06196EFCable AssyBACC2C3D07372CFCable AssyBACC2C4C02485EFCable AssyBACC2D3B02124EGCable AssyBACC2C4A00182FGCable AssyBACC13AA3T45-14094Cable AssyBACC2C4C02295EFCable AssyBACC2C4C04471EFCable AssyBACC2C4C03093EFCable AssyBACC2C4C00742EGCable AssyBACC13AP3D1728Cable AssyBACC2C3B01990EGCable AssyBACC2C4A01748EFCable AssyBACC2C4C00654EGCable AssyBACC2C4A07812FGCable Assy
Back to Boeing 747-367