Gulfstream Aerospace GULFSTREAM 200
PMA parts · 1,536
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 ('A53NM')
AND len(list_intersect(tcds_models, ['Gulfstream 200'])) > 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 ('A53NM')
AND len(list_intersect(tcds_models, ['Gulfstream 200'])) > 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.
AG844000-23Gasket – UHF/VHF AntennaAG844000-15Gasket – UHF/VHF AntennaAG627000-23Gasket – Marker BeaconAG358000-08Gasket – ELT AntennaAG627000-12Gasket – Marker Beacon AntennaM2005-71Brush, Electrical ContactN1495XLED LIGHT BULBL1309XL1309 LED LIGHT BULBAG843000-17Gasket- UHF/VHF Antenna5008314-1WEPlug-Pressure ReleaseSP3558-51-1E001AOxygen Mask AssyAG358000-07Gasket – ELT AntennaAG843000-79Gasket - UHF / AM / IFF AntennaAG477000-35Gasket - GPS ANTENNAN1245XXXXFluorescent LampR1245XXXXLED LampAG822000-09Gasket - TCAS AntennaDWG-008307-4.0.0Duncan Aviation Fabricated PartsDWG-008307-2.0.0Avance L5 Parts KitDWG-008307-3.0.0Avance L5 Standard Parts KitAG247000-05Gasket - Security System AntennaAG843000-19Gasket - VHF AntennaL1245XXXX KITLED Lamp and Adapter KitAG846000-31Gasket - VHF AntennaAG822000-03Gasket - TCAS AntennaAG843000-17Gasket - UHF/VHF Antenna17-012-334KLED LightsAG843000-15Gasket - VHF AntennaSJ8665 FP-324-1Radome BootSJ8665 FP-324Radome BootSJ8663 FP-324Radome Boot405622B-THR2-Wire Handset (Black)405624B-THWWireless Handset (White)405040A-826Configuration Module405040ASwift Broadband Unit405040A-806Configuration Module405016AHigh Power Low Noise Device405040A-817Configuration Module405040A-816Configuration Module405040A-838Configuration Module405040A-825Configuration Module405622B-THW2-Wire Handset (White)405040A-828Configuration Module405626B-THWWireless Handset Cradle (White)405040A-835Configuration Module405626B-THRWireless Handset Cradle (Black)405040A-805Configuration Module405040A-808Configuration Module405040A-818Configuration Module405624B-THRWireless Handset (Black)
Back to Gulfstream Aerospace GULFSTREAM 200