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.
BACC2C4C02975EFCable AssyBACC2C3B04380FFCable AssyBACC13AP3B1027Cable AssyBACC2C3B05734EFCable AssyBACC13AA3T47-7483Cable AssyBACC13AP4E1336Cable AssyBACC2C4C01683FGCable AssyBACC2C3B01390CDCable AssyBACC13AP3E400Cable AssyBACC13AA3T45-3213Cable AssyBACC2C3B02903FFCable AssyBACC13AP3D2166Cable AssyBACC13AA3T45-13300Cable AssyBACC2C3D04066EFCable AssyBACC2C3B03138EECable AssyBACC2C3D03063BFCable AssyBACC13AP3D9980Cable AssyBACC2C3D03339EFCable AssyBACC2C3D03089EFCable AssyBACC13AP4E7116Cable AssyBACC2C3D02851EFCable AssyBACC2C3D02952FFCable AssyBACC2C3D08772EFCable AssyBACC2C3B10724EFCable AssyBACC13AA3T47-5262Cable AssyBACC2D3B02027FGCable AssyBACC2A2C00090BBCable AssyBACC13Y4-60Cable AssyBACC13AP3D1624ACable AssyBACC13AP3B93ACable AssyBACC2C3D08684EGCable AssyBACC2C3D02196FGCable AssyBACC2C3B01864FGCable AssyBACC2C3D04381FFCable AssyBACC2C3B00298FGCable AssyBACC13AA3T45-14443Cable AssyBACC2C3B02462FGCable AssyBACC2C4C02302EGCable AssyBACC2C3B09980EGCable AssyBACC13AA3T44-4911Cable AssyBACC13AP3D265ACable AssyBACC13AA3T47-5126Cable AssyBACC2C4C02896EGCable AssyBACC2C4C09374FFCable AssyBACC13AA3T67-1390Cable AssyBACC2C3B01095FGCable AssyBACC2C3B02979CECable AssyBACC2C3B04059EFCable AssyBACC2C4A02455FGCable AssyBACC13Y4A120Cable Assy
Back to Boeing 747-367