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.
BACC13AP3E1212Cable AssyBACC13Y3A50Cable AssyBACC2C3B05152EECable AssyBACC2C4C04134EFCable AssyBACC13AA3T45-8320Cable AssyBACC2C3D09109EFCable AssyBACC2C3D00400FGCable AssyBACC2C3B03240EFCable AssyBACC2C3D02780FGCable AssyBACC2C3D02752DGCable AssyBACC13Y4120Cable AssyBACC2C3D01095FGCable AssyBACC2C3B04795EFCable AssyBACC2C4C07588EFCable AssyBACC2C4C00652EGCable AssyBACC2C3D01995FGCable AssyBACC13AA3T44-2902Cable AssyBACC2C4A02318EGCable AssyBACC2D3B02015FGCable AssyBACC2C4C09333EFCable AssyBACC2C3B01812DGCable AssyBACC13AP3B623Cable AssyBACC13AP4D283ACable AssyBACC2C3D09884EGCable AssyBACC13AA4T45-3845Cable AssyBACC13AA3T55-3736Cable AssyBACC13AP3C232Cable AssyBACC2C3B08064EGCable AssyBACC2C3B00285EGCable AssyBACC2C3D07464CFCable AssyBACC2D3B03734EECable AssyBACC13AP4E7492Cable AssyBACC2C4A09378FFCable AssyBACC13AA3T47-5447Cable AssyBACC2C4A07845EFCable AssyBACC2C4A00173EGCable AssyBACC2C3B07999EFCable AssyBACC2C4A01506EGCable AssyBACC2C4A03978EFCable AssyBACC2D3B01989EGCable AssyBACC2C3B02695EFCable AssyBACC13AA4T45-4056Cable AssyBACC2C3D02265BFCable AssyBACC2C4A00758EGCable AssyBACC2C3D04382FFCable AssyBACC2C3B02204FGCable AssyBACC13ACH3262-6265ACable AssyBACC2C3B03090EFCable AssyBACC2D3B01762FGCable AssyBACC2C4C01741EFCable Assy
Back to Boeing 747-367