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.
BACC2C3B02635CECable AssyBACC2C4A01689FGCable AssyBACC2D3B01991EGCable AssyBACC2C3D09246EFCable AssyBACC2C3B02442EGCable AssyBACC2C3D02995CFCable AssyBACC2C4C02095EFCable AssyBACC13AA3T47-5486Cable AssyBACC13AA3T45-5830Cable AssyBACC2C4C01795EFCable AssyBACC2C3D04775EFCable AssyBACC13AA3T45-14860Cable AssyBACC2C3D01463FGCable AssyBACC13ACH3262-6265Cable AssyBACC2C3B08305EFCable AssyBACC2C3B00218DGCable AssyBACC13AA3T57-4866Cable AssyBACC13AP4D1938Cable AssyBACC2C3B06584EFCable AssyBACC2C4A00122EGCable AssyBACC2C3D01016FGCable AssyBACC13AA3T57-2977ACable AssyBACC13AP3C683Cable AssyBACC13AA4T84-7434Cable AssyBACC13AA3T45-14143Cable AssyBACC2C3D01132CGCable AssyBACC2C4A09509EFCable AssyBACC2C3D05614EFCable AssyBACC2C4A04783EFCable AssyBACC2D38EECable AssyBACC13AA4T84-7236Cable AssyBACC2C3D02184EGCable AssyBACC13AP3D1636Cable AssyBACC13AP3C685Cable AssyBACC13AP3E3172Cable AssyBACC2C3D07491CFCable AssyBACC13AA4T45-3976Cable AssyBACC13AA3T55-3714Cable AssyBACC2C3D03864EFCable AssyBACC13AA3T45-5115Cable AssyBACC2C4C04136EFCable AssyBACC13AP3B1147ACable AssyBACC2C3D00640GGCable AssyBACC13AA3T47-2802Cable AssyBACC2C3B04516EFCable AssyBACC13AP4D258ACable AssyBACC2C3D00341EGCable AssyBACC2C4A07598FFCable AssyBACC2C3D06365EFCable AssyBACC13AA3T55-4633Cable Assy
Back to Boeing 747-367