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.
AG723000-40Gasket - RAD ALT AntennaAG723000-03Gasket - Radio Altimeter AntennaAG723000-03Gasket - Radio Altimeter AntennaGM10708Force Sensor Control Rod-Elevator L.H.GM10709Force Sensor Control Rod - RudderGM10706Force Sensor Control Rod-AileronGA10710Invertor BoxGM10707Force Sensor Control Rod-Elevator L.H.AG282000-03Gasket - ATC/DME AntennaAG822000-01Gasket - TCAS AntennaAG723000-02Gasket - Radio Altimeter Antenna08090021-6Digital To Discrete Adapter107STC-140EVAS(r)107STC-139EVAS(r)GM10709Force Sensor Control Rod - RudderGA10710Invertor BoxGM10708Force Sensor Control Rod-Elevator L.H.GM10706Force Sensor Control Rod-AileronGM10707Force Sensor Control Rod-Elevator L.H.LSM-SCD-009-1LampLSM-500-420-15BracketLSM-500-415-52ReflectorLSM-500-415-51Reflector3077KGasketLSM-SCD-038-7PAR 36 Light HousingLSM-500-431-7TPAR 36 Light AssemblyLSM-SCD-038-37PAR 36 Light HousingLSM-SCD-004-1PAR 36 ReflectorLSM-SCD-005-1ReflectorLSM-500-420-1Landing Light AssemblyLSM-SCD-008-120WCable AssemblyLSM-500-420-5Bracket AssemblyLSM-500-421-5StudLSM-500-421-17Template, BondingLSM-SCD-007-1Ballast to Power WireLSM-500-421-3Grounding StrapLSM-500-421-2Ballast Assy RHLSM-500-420-1Landing Light AssyLSM-500-315-31Stud RetainerLSM-500-421-13Template, Stud MarkingLSM-SCD-007-1Ballast to Poer WireLSM-500-421-15Template, GrindingLSM-500-370-20RH Light HousingLSM-501-103-5Finish Removal GardLSM-500-103Installation Instructions, Wing Landing LightsLSM-501-103-3Ballast Mounting GuideLSM-500-421-1Ballast Assy LHLSM-SCD-019-585W Ballast 28 VoltLSM-SCD-007-19Ballast to Power Wire, LHLSM-500-370-19LH Light Housing
Back to Gulfstream Aerospace GULFSTREAM 200