Boeing 747-221F
PMA parts · 57,567
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-200F 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-200F 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.
AC8818E1FilterAC9008E1Filter ElementADB6718Y1FilterADB6718Hydraulic Filter AssemblyAC9008E1FilterAC9233F2015FilterAC4638E31Filter ElementC48-10R12Y12S-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING10101000M-AValve Assy, Waste Drain325-0147-01Heater Gasket & Thermostat KitC48-10R14Y15S6-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING86-4102-2Cover Assembly, Pressure OilerC48-10R18-14P8-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R14Y15P-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R12Y12S6-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING580-116Valve, Lavatory Rinse/Fill, Frangible, 2-Piece86-4252-1Adapter, Pressure Oiler86-4101-2Cover, Pressure Oiler87-5023-1Adapter, Pressure Oil580-082-1Valve, Fill, Frangible, Potable WaterC48-10R14Y12P6-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R12Y12P9-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R14-7P-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R16Y24P7-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R18-8P6-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R16Y24P-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING580-116-1Valve, Lavatory Rinse/Refill, Frangible, 2-pieceC48-10R16Y24P6-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R16Y24P8-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING86-4101-2Cover, Pressure Oiler86-4102-2Cover Assembly, Pressure Oiler86-4102-2Cover Assembly Pressure Oiler86-4253-1Adaptor, Pressure OilerC48-10R14-7S8-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R16Y24S-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING488-252Cap, Pressure Fuel Servicing, 2 1/2 DIA, Non-FlushC48-10R18Y31P-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R14Y15S-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R14Y15P6-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING86-4101-2Cover, Pressure OilerC48-10R12Y12P6-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R12Y12P8-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING580-099Valve, Lavatory Rinse/Fill, FrangibleC48-10R18Y31P6-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING86-4252-1Adapter, Pressure OilerC48-10R12Y12P7-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING10101C758Valve, Waste Drain (Posi-Lift(tm))C48-10R18-14P-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R18Y31P7-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING86-4102-2Cover Assembly, Pressure Oiler
Back to Boeing 747-221F