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.
BACC2C4C07776EFCable AssyBACC2C3D01210FGCable AssyBACC2D3B02102EGCable AssyBACC13AA3T35-1917Cable AssyBACC2C3D04380FFCable AssyBACC2C3B01210FGCable AssyBACC13AA3T45-5455Cable AssyBACC2C3D07504CFCable AssyBACC2C3B03168FGCable AssyBACC13AP3D9840Cable AssyBACC2C4C04624EFCable AssyBACC2C4A07653FGCable AssyBACC13AP3D1341Cable AssyBACC2C3D01649EGCable AssyBACC13AP3E2773Cable AssyBACC13AP4E7647Cable AssyBACC2C4A00258EGCable AssyBACC2C3D10588FGCable AssyBACC13AA4T84-7370Cable AssyBACC13AA3T57-2634Cable AssyBACC2C3B03663EFCable AssyBACC2C3D02185EGCable AssyBACC2C3D05549EECable AssyBACC13AP3E303Cable AssyBACC13AP4D122ACable AssyBACC13AP3D184Cable AssyBACC2C3B01867FGCable AssyBACC13AA4T45-9507Cable AssyBACC13AP3B174Cable AssyBACC13AA3T45-10090Cable AssyBACC13AP3E2204Cable AssyBACC2C3B00176DGCable AssyBACC13AP3D1336Cable AssyBACC2C3D02741FGCable AssyBACC2C3B04688EFCable AssyBACC13AP3D1643Cable AssyBACC2C3D00130EGCable AssyBACC13ACJ3104-6150ACable AssyBACC2C3D10086EFCable AssyBACC13AP3D1625Cable AssyBACC13AP4E2510Cable AssyBACC13Y3B291Cable AssyBACC2C3D03938EFCable AssyBACC2C4C01663FGCable AssyBACC13AP3C1265Cable AssyBACC13AA4T45-7630Cable AssyBACC13AP4D740Cable AssyBACC2C4C08729FGCable AssyBACC2C3D03417EGCable AssyBACC2C3D00300DGCable Assy
Back to Boeing 747-367