# Service difficulty reports: Aero Commander 500 S

A list on [Aero Commander 500 S](https://openairdocs.org/model/aero-commander-500-s.md).

Newest first. General aviation reporting is voluntary.

Page 1 of 3 · 107 reports

- [SDR 2022FA0000287](https://openairdocs.org/sdr/2022FA0000287.md): Trunnion · broken · Mar 2, 2022 · N202JH · Gulstm 500S · Landing Gear System
  > RIGHT MAIN LANDING GEAR FAILED TO EXTEND. LANDING GEAR CASTING FAILURE AT ACTUATOR ATTACHMENT
- [SDR 2013FA0000406](https://openairdocs.org/sdr/2013FA0000406.md): Drive Assy · activated · Jul 12, 2013 · N503AP · Gulstm 500S · Cabin Cooling System
  > DURING FLIGHT, ACFT HAD STRONG BURNING ODOR IN CABIN. INVESTIGATION AND INSPECTION FOUND AIR CONDITIONING COOLING SYSTEM COMPRESSOR DRIVE MOTOR FAILED. UPON REMOVAL FOUND LARGE HOLE WITH BURNED AND MELTED METAL ADJACENT TO BRUSHES. NO CB TRIPPING. AREA THAT
- [SDR 2013F00003](https://openairdocs.org/sdr/2013F00003.md): Line · leaking · Jul 23, 2012 · Gulstm 500S · Hydraulic System, Main
  > HYDRAULIC FAILURE OCCURRED DUE TO THE HOSE FOR HYD PRESSURE GAUGE BEING DAMAGED, RESULTING IN LEAKAGE OF HYD FLUID AND SUBSEQUENTLY THE INDICATION OF SYS PRESSURE COULD NOT BE ASCERTAINED BY POC. OPERATOR COMPANY PROCEDURES WERE FOLLOWED TO DIVERT FOR SAFE LA
- [SDR V8Z2011F00000](https://openairdocs.org/sdr/V8Z2011F00000.md): O-Ring · damaged · Jun 22, 2011 · N531SA · Gulstm 500S · Main Landing Gear Strut/Axle/Truck
  > O-RING IN THE LT MLG RETRACT CYLINDER FAILED WHICH ALLOWED THE HYD SYS OIL TO DRAIN. O-RING WAS MOST LIKELY DAMAGED DURING INSTALLATION. DURING INSTALLATION OF THIS PART O-RING LUBE OR HYDRAULIC OIL MUST BE USED TO KEEP UNIT FROM BEING DAMAGED.
- [SDR CA100127016](https://openairdocs.org/sdr/CA100127016.md): Spar Cap · corroded · Jan 5, 2010 · Gulstm 500S · Wing Spar
  > (CAN) AFTER ACCOMPLISHING AD 94-04-14 IT WAS NOTED THAT THE WING LOWER SPAR CAP WAS CORRODED BEYOND THE SAFE LIMIT ACCORDING TO SB 208A. THE ACFT WAS GROUNDED.
- [SDR 2009FA0000306](https://openairdocs.org/sdr/2009FA0000306.md): Pin · worn · Apr 1, 2009 · N900DT · Gulstm 500S · Nose/Tail Landing Gear Strut/Axle
  > PIN IS WORN AND STOP NOSE WHEEL FROM CANTERING, WHEN GEAR WAS RETRACTED, NOSE WHEEL GOT JAMMED IN THE WHEEL WELL AND WOULD NOT EXTEND OR RETRACT. ACFT LANDED WITH NOSE WHEEL NOT FULLY EXTENDED. (K)
- [SDR CA090226003](https://openairdocs.org/sdr/CA090226003.md): Bracket · loose · Feb 24, 2009 · Gulstm 500S · Nose/Tail Landing Gear
  > (CAN) DURING GEAR SWING INSP, IT WAS NOTED THAT ON THE NOSE GEAR DOWN AND LOCKED CYCLE THERE WAS CONSIDERABLE MOVEMENT ON THE ACFT STRUCTURE THAT ATTACHES TO THE NOSE GEAR ACTUATOR. ON CLOSER EXAMINATION, IT WAS DISCOVERED THAT THE RIVETS HOLDING THE BRACKET
- [SDR CA090129015](https://openairdocs.org/sdr/CA090129015.md): Shaft · cracked · Jan 26, 2009 · Gulstm 500S · Nose/Tail Landing Gear
  > ON VISUAL INSPECTION OF THE NOSE LANDING GEAR DRAG BRACE AND BUNGEE SYSTEM, IT WAS FOUND THAT THE SHAFT LINKING THE DRAG BRACE TO THE BUNGEE WAS CRACKED AT THE BOLT HOLES. THE BOLT HOLES WERE FOUND TO ALSO BE ELONGATED. THE SHAFT WAS REMOVED AND THE HIDDEN PAR
- [SDR EHS2008F00001](https://openairdocs.org/sdr/EHS2008F00001.md): O-Ring · leaking · Aug 11, 2008 · N519WA · Gulstm 500S · Main Landing Gear Strut/Axle/Truck
  > WHILE FLYING A FIRE MISSION IN SUPPORT OF USFS, THE PILOT NOTICED THE RT GEAR START TO EXTEND FOLLOWED BY A LOSS OF HYDRAULIC PRESSURE. PILOT RETURNED TO THE AIRPORT AND LANDED. THE PROBLEM WAS TRACED TO THE RT MAIN GEAR RETRACT CYLINDER. UPON DISASSEMBLY O
- [SDR EHS2008F00000](https://openairdocs.org/sdr/EHS2008F00000.md): Piston · burned · Jul 2, 2008 · N4QS · Gulstm 500S · Reciprocating Engine Power Section
  > WHILE FLYING A FIRE MISSION IN SUPPORT OF USFS, THE PILOT NOTICED THE RT ENG OIL PRESSURE FLOWLY STARTING TO DECREASE. THE DECISION WAS MADE TO RETURN TO THE AIRPORT. AS OIL PRESSURE CONTINUED TO DECREASE, THE DECISION WAS MADE TO SHUTDOWN, FEATHER, AND SECU
- [SDR 2008FA0000167](https://openairdocs.org/sdr/2008FA0000167.md): Magneto · worn · Feb 26, 2008 · N51RF · Gulstm 500S · Magneto/Distributor
  > ENGINE WAS GETTING HARD TO START, CHECKED MAG TIMING AND FOUND LT MAG TIMING OUT OF LIMITS, DISASSEMBLED MAG AND FOUND THE CAM WORN OUT. 81.1 HRS SINCE NEW.
- [SDR 2008FA0000164](https://openairdocs.org/sdr/2008FA0000164.md): Magneto · worn · Jan 10, 2008 · N51RF · Gulstm 500S · Magneto/Distributor
  > ENGINE WAS GETTING HARD TO START, CHECKED MAG TIMING AND FOUND LT MAG TIMING OUT OF LIMITS, DISASSEMBLED MAG AND FOUND THE CAM WORN OUT. 100.3 HRS SINCE NEW
- [SDR 2008FA0000013](https://openairdocs.org/sdr/2008FA0000013.md): Magneto · worn · Jan 2, 2008 · N51RF · Gulstm 500S · Magneto/Distributor
  > CAM LOBE INSIDE MAG THAT OPENS AND CLOSES POINTS WORN OUT.
- [SDR CA070517007](https://openairdocs.org/sdr/CA070517007.md): Winglet · separated · May 8, 2007 · Gulstm 500S · Wing, Plate/Skin
  > (CAN) IT WAS FOUND THAT THE SHEET METAL SCREWS HOLDING THE TIP ON THE WING HAD ALL COME LOOSE. THE WING TIP THEN VIBRATED FOR A PERIOD OF TIME,ELONGATING THE SCREW HOLES IN THE WING UNTIL ALL OF THE SCREWS FELL OUT AND THE WING TIP DEPARTED THE WING IN FLIGHT
- [SDR 2007FA0000268](https://openairdocs.org/sdr/2007FA0000268.md): B-Nut · loose · Mar 8, 2007 · N280MB · Gulstm 500S · Hydraulic System, Main
  > PILOT NOTICED A FLUCTUATION AND LOSS OF HYDRAULIC PRESSURE IN FLIGHT, AFTER INSPECTION THE FORWARD HYDRAULIC HOSE B-NUT ON THE LT GEAR ACTUATOR WAS FOUND TO BE LOOSE. THE B-NUT WAS TIGHTENED AND TORQUE SEAL WAS PUT ON THE B-NUT. SERVICED HYDRAULIC RESERVOIR
- [SDR CA070201009](https://openairdocs.org/sdr/CA070201009.md): Bracket · worn · Feb 1, 2007 · Gulstm 500S · Alternator-Generator Drive
  > (CAN) THE ALTERNATOR ADJUSTING BRACKET BOLT HOLE THAT ATTACHES THE BRACKET TO THE ENGINE WAS FOUND CRACKED ALL THE WAY THROUGH. THE BRACKET WAS ONLY BEING HELD IN PLACE BY THE TENSION OF THE BELT. THERE IS SEVERAL OTHER REPORTS OF CRACKS IN THE BOLT HOLE OF TH
- [SDR K512006F00000](https://openairdocs.org/sdr/K512006F00000.md): Bearing · failed · Aug 1, 2006 · N2BZ · Gulstm 500S · Heating System
  > FWD BEARING FAILED IN CUMBUSTION AIR BLOWER LACK OF COMBUSTION AIR PRESSURIZE SHUT DOWN THE HEATER, BUT SMOKE FROM THE BLOWER MOTOR CAME INTO THE COCKPIT AREA. (K)
- [SDR 2006FA0000466](https://openairdocs.org/sdr/2006FA0000466.md): Connecting Rod · broken · Apr 10, 2006 · N90JP · Gulstm 500S · Reciprocating Engine Power Section
  > CUSTOMER WAS ENROUTE TO MAINTENANCE SHOP TO GET ANNUAL INSPECTION, BOTH ENGINES OVERHAULED. RT ENGINE CYLINDER NR 2 CONNECTING ROD BROKE AT THE CRANKSHAFT ATTACHMENT CAUSING MAJOR DAMAGE TO THE CAMSHAFT, AND CRANKCASE BREAKING OPEN IN SEVERAL PLACES AROUND TH
- [SDR AU510002170](https://openairdocs.org/sdr/AU510002170.md): Seal · worn · Dec 12, 2005 · Gulstm 500S · Main Landing Gear Strut/Axle/Truck
  > RT MAIN LANDING GEAR RAM SEALS WORN AND LEAKING. LOSS OF HYDRAULIC FLUID.
- [SDR CA050724001](https://openairdocs.org/sdr/CA050724001.md): Crankshaft · sheared · Jul 8, 2005 · Gulstm 500S · Reciprocating Engine Power Section
  > CRANKSHAFT SPLIT NEXT TO THE NR 3 MAIN BEARING JOURNAL. FAILURE NEXT TO THE NR 4 CONNECTING ROD. CRANKSHAFT THEN BROKE INTO 3 PIECES AND PUNCTURED THE CRANKCASE ABOVE THE SUMP. ENGINE TEARDOWN RESULTS: A SCRAP CRANKCASE AND NR 3 CYLINDER ALSO SCRAP DUE TO D
- [SDR AU510001503](https://openairdocs.org/sdr/AU510001503.md): Line · broken · Jun 6, 2005 · Gulstm 500S · Engine Fuel Distribution
  > (AUS) RT ENGINE NR 2 CYLINDER FUEL INJECTOR LINE BROKEN AT NIPPLE. (CASA NR 510001503).
- [SDR AUS20031276](https://openairdocs.org/sdr/AUS20031276.md): Seal · damaged · Dec 18, 2003 · Gulstm 500S · Reciprocating Engine Oil System
  > (AUS) RT ENGINE OIL FILTER SEAL DAMAGED AND LEAKING. SUSPECT SEAL DAMAGED DURING INSTALLATION. PERSONNEL/MAINTENANCE ERROR.
- [SDR 2003FA0001271](https://openairdocs.org/sdr/2003FA0001271.md): Crankcase · failed · Dec 2, 2003 · N57062 · Gulstm 500S · Engine (Reciprocating)
  > DURING ROUTINE FLIGHT, LOUD NOISE WAS HEARD. RT ENGINE WAS SHUT DOWN AND SECURED. AFTER AN UNEVENTFUL LANDING, AN INSPECTION REVEALED A CATASTROPHIC CRANKCASE FAILURE AT THE NR 3 CYLINDER LOCATION HAD OCCURRED. CYLINDER WAS COMPLETELY SEPARATE FROM CASE. C
- [SDR AUS20031077](https://openairdocs.org/sdr/AUS20031077.md): Rib · cracked · Oct 22, 2003 · Gulstm 500S · Elevator, Spar/Rib
  > (AUS) RT ELEVATOR FORWARD RIB CRACKED AT TORQUE TUBE OUTBOARD MOUNTING FLANGE. RIB CONTAINS TWO CRACKS FROM TOP AND BOTTOM ATTACHMENT RIVETS.
- [SDR AUS20031298](https://openairdocs.org/sdr/AUS20031298.md): Clevis · cracked · Sep 26, 2003 · Gulstm 500S · Main Landing Gear Strut/Axle/Truck
  > (AUS) MAIN LANDING GEAR CLEVIS CRACKED. FOUND USING MAGNETIC PARTICLE INSPECTION AND VISUAL TECHNIQUES.
- [SDR AUS20030955](https://openairdocs.org/sdr/AUS20030955.md): Magneto · out of adjust · Sep 19, 2003 · Gulstm 500S · Magneto/Distributor
  > (AUS) LT ENGINE LOST OIL PRESSURE. INSPECTION FOUND NR 4 PISTON FAILED DUE TO DETONATION. FURTHER INVESTIGATION FOUND THE LT MAGNETO TIMING HAD MOVED FROM 20 DEGREES BTDC TO 35 DEGREES BTDC. MAGNETO GASKET HAD BEEN REPLACED AT PREVIOUS PERIODIC INSPECTION.
- [SDR AUS20030975](https://openairdocs.org/sdr/AUS20030975.md): Pin · cracked · Sep 16, 2003 · Gulstm 500S · Landing Gear Actuator
  > (AUS) LT AND RT MAIN LANDING GEAR ACTUATOR CLEVIS PINS CRACKED.
- [SDR AUS20031078](https://openairdocs.org/sdr/AUS20031078.md): Rib · cracked · Sep 12, 2003 · Gulstm 500S · Elevator, Spar/Rib
  > (AUS) RT ELEVATOR FORWARD RIB CRACKED AT TORQUE TUBE OUTBOARD MOUNTING FLANGE. RIB IS CRACKED IN TWO PLACES FROM TOP AND BOTTOM ATTACHMENT RIVETS.
- [SDR AUS20030976](https://openairdocs.org/sdr/AUS20030976.md): Pin · cracked · Sep 3, 2003 · Gulstm 500S · Landing Gear Actuator
  > (AUS) LT AND RT MAIN LANDING GEAR ACTUATOR CLEVIS PINS CRACKED.
- [SDR AUS20030974](https://openairdocs.org/sdr/AUS20030974.md): Pin · cracked · Aug 15, 2003 · Gulstm 500S · Landing Gear Actuator
  > (AUS) LT AND RT MAIN LANDING GEAR ACTUATOR CLEVIS PINS CRACKED.
- [SDR 2003FA0000754](https://openairdocs.org/sdr/2003FA0000754.md): Propeller · inoperative · Jul 14, 2003 · N47RF · Gulstm 500S · Propeller Assembly
  > PROPELLER ASSY, AIRCRAFT CREW REPORTED RT PROPELLER GOES TO FEATHER ON TAXI WITH HOT OIL. ENGINE AND PROP GOVERNOR CHANGED. PROPELLER SWAPPED. PROBLEM FOUND TO BE PROPELLER AIR CHARGE PROCEDURE WAS CHANGED IAW MFG LS. C/W THIS SL FIXED PROBLEM.
- [SDR 03IN170035](https://openairdocs.org/sdr/03IN170035.md): Cylinder Head · departed · Jun 21, 2003 · N507JP · Gulstm 500S · Reciprocating Engine Cylinder Section
  > A/C EXPERIENCED ENG PROBLEMS APPROX 2 MINUTES AFTER INITIATING DESCENT FROM 11,500. PILOT NOTICED VIBRATION, OBSERVED RT ENG FUEL FLOW FLUCTUATING. ENRICHED FUEL MIXTURES AND TURNED ON FUEL PUMPS. VIBR CONTINUED, PILOT MOVED RT THROTTLE BACK, THEN UP TO CO
- [SDR AUS20030792](https://openairdocs.org/sdr/AUS20030792.md): Clevis · fractured · May 28, 2003 · Gulstm 500S · Landing Gear Actuator
  > (AUS) LT MAIN LANDING GEAR ACTUATOR CLEVIS FRACTURED.
- [SDR AUS20030549](https://openairdocs.org/sdr/AUS20030549.md): Separator · contaminated · May 16, 2003 · Gulstm 500S · Engine Fuel Distribution
  > (AUS) RT ENGINE FUEL VAPOUR SEPARATOR BLOCKED BY PARTICLES OF UNKNOWN TYPE.
- [SDR AUS20030571](https://openairdocs.org/sdr/AUS20030571.md): Engine · failed · Apr 26, 2003 · Gulstm 500S · Engine (Reciprocating)
  > (AUS) LT ENGINE FAILED TO RESTART IN FLIGHT AFTER AN INTENTIONAL SHUTDOWN. INVESTIGATION COULD FIND NO PROBLEMS WITH THE ENGINE. SUSPECT CAUSED BY OVERPRIMING OF THE FUEL SYSTEM.
- [SDR FTU2003F00006](https://openairdocs.org/sdr/FTU2003F00006.md): Engine · contaminated · Apr 14, 2003 · N9038N · Gulstm 500S · Engine (Reciprocating)
  > DURING A ROUTINE OIL CHANGE WHEN OIL FILTER WAS CUT OPEN FOR INSPECTION, A LARGE AMOUNT OF SILVER PARTICILES WERE FOUND. OIL SUMP SCREEN WAS REMOVED FOR INSPECTION AND LARGE PIECES OF SILVER MATERIAL WAS FOUND. ALL CYLINDERS WERE REMOVED FOR INTERNAL INSPECT
- [SDR FTU2003F00000](https://openairdocs.org/sdr/FTU2003F00000.md): Bracket · broken · Dec 19, 2002 · N1938S · Gulstm 500S · Reciprocating Engine Front Section
  > DURING ANNUAL INSPECTION AND REMOVAL OF ENGINE FOR OVERHAUL, ALTERNATOR BELT TENSION BRACKET WAS FOUND BROKEN AT THE END THAT IS BOLTED TO THE ENGINE NOSE CASE. ON THIS INSTALLATION A VIEW OF THAT TEND OF THE BRACKET IS VERY DIFFICULT TO SEE, WHEN THE BRACKET
- [SDR AUS20021333](https://openairdocs.org/sdr/AUS20021333.md): Cable · worn · Nov 15, 2002 · Gulstm 500S · Aileron Control System
  > (AUS) AILERON CABLE FRAYED IN AREA OF FAIRLEAD LOCATED OUTBOARD OF LH NACELLE.
- [SDR AUS20020874](https://openairdocs.org/sdr/AUS20020874.md): Restrictor Valve · blocked · Aug 9, 2002 · Gulstm 500S · Aircraft Fuel Distribution System
  > (AUS) FUEL VAPOR SEPARATOR / FILTER ASSEMBLY RESTRICTOR BLOCKED. THE RESTRICTOR IS LOCATED IN THE RETURN LINE FROM THE FUEL DISTRIBUTOR VALVE.
- [SDR AUS20020686](https://openairdocs.org/sdr/AUS20020686.md): Engine · malfunctioned · Jul 14, 2002 · Gulstm 500S · Engine (Reciprocating)
  > (AUS) LT ENGINE VIBRATING AND LOSING POWER. LIMITED INFORMATION PROVIDED.
- [SDR CA020507021](https://openairdocs.org/sdr/CA020507021.md): Stud · sheared · Apr 26, 2002 · Gulstm 500S · Landing Gear Steering System
  > (CAN) WHEN THE PILOT SELECTED GEAR DOWN, DID NOT RECEIVE A GREEN NOSE GEAR LIGHT. PILOT DID FLY BYS AND IT WAS NOTED NOSE GEAR WAS NOT IN LOCKED POSITION. PILOT LANDED & NOSE GEAR COLLAPSED WITH MINIMUM DAMAGE. INSPECTION REVEALED THAT P/N 750080-1 SPACER, (TH
- [SDR AUS20020295](https://openairdocs.org/sdr/AUS20020295.md): Diaphragm · damaged · Mar 20, 2002 · Gulstm 500S · Engine Fuel Distribution
  > (AUS) LH ENGINE MANIFOLD VALVE DIAPHRAGM TORN. LENGTH OF TEAR APPROXIMATELY 12.7MM (0.5IN).
- [SDR DO32002F00000](https://openairdocs.org/sdr/DO32002F00000.md): Line · chafed · Dec 13, 2001 · N621TJ · Gulstm 500S · Hydraulic System, Main
  > HYDRAULIC PUMP PRESSURE LINE (PN790246-167) AND HYDRAULIC SUPPLY LINE (PN 790246-167). HYDRAULIC LINES ARE LOCATED FORWARD OF EACH MAIN LANDING GEAR ASSEMBLY ON LOWER REAR F/W. LINES COME FROM ENGINE DRIVEN HYDRAULIC PUMP AND GO TO HYDRAULIC PRESSURE REGULAT
- [SDR AUS20011017](https://openairdocs.org/sdr/AUS20011017.md): Plate · corroded · Sep 21, 2001 · Gulstm 500S · Wing, Plate/Skin
  > (AUS) EXTERNAL SPAR CAP SUPPORT PLATE RH SIDE CORRODED IN AREA OF JOINT BETWEEN TWO PLATES. EVIDENCE OF CORROSION IN SIMILAR AREA ON LH SIDE.
- [SDR AUS20010904](https://openairdocs.org/sdr/AUS20010904.md): Stud · sheared · Aug 14, 2001 · Gulstm 500S · Reciprocating Engine Power Section
  > (AUS) LH ENGINE NO4 CYLINDER HOLDDOWN STUDS (3OFF) SHEARED. FOLLOWING REMOVAL OF THE CYLINDER THE CRANKCASE WAS FOUND TO BE CRACKED THROUGH THE AREA OF THE HOLDDOWN STUDS.
- [SDR AUS20010875](https://openairdocs.org/sdr/AUS20010875.md): Bearing · delaminated · Aug 13, 2001 · Gulstm 500S · Reciprocating Engine Power Section
  > (AUS) ENGINE FRONT MAIN BEARING DEFECTIVE. BEARING MATERIAL APPEARS TOBE DELAMINATED FROM BEARING SHELL. METAL CONTAMINATION OF OIL SYSTEM. SUSPECT MANUFACTURING FAULT.
- [SDR CA010628039](https://openairdocs.org/sdr/CA010628039.md): Camshaft · worn · Jun 28, 2001 · Gulstm 500S · Reciprocating Engine Cylinder Section
  > (CAN) ENGINE HAD BEEN HARD TO START, LOW STATIC RPM AND HIGH MANIFOLD PRESSURE. ENGINE INSP. REVEALED THAT THE CAMSHAFT LOBE THAT DRIVES NR 5&6 CYL INTAKE VALVES WERE WORN. FURTHER TEAR DOWN OF ENGINE REVEALED NO FURTHER ABNORMAL WEAR OR CORROSION.
- [SDR AUS20010689](https://openairdocs.org/sdr/AUS20010689.md): Cylinder · damaged · Jun 22, 2001 · Gulstm 500S · Reciprocating Engine Cylinder Section
  > (AUS) ENGINE CYLINDER HOLED IN AREA ADJACENT TO TOP SPARK PLUG HOLE.
- [SDR AUS20010556](https://openairdocs.org/sdr/AUS20010556.md): Pin · cracked · May 28, 2001 · Gulstm 500S · Main Landing Gear Strut/Axle/Truck
  > (AUS) MAIN LANDING GEAR CLEVIS PIN CRACKED FROM BOLT HOLE. FOUND DURING INSPECTION IAW SL 376.
- [SDR AUS20010451](https://openairdocs.org/sdr/AUS20010451.md): Washer · failed · Apr 20, 2001 · Gulstm 500S · Reciprocating Engine Power Section
  > (AUS) RH ENGINE COUNTERWEIGHT RETAINING WASHER PNO 71907 HAD FAILED ALLOWING THE COUNTERWEIGHT ROLLER PNO 72797 TO MIGRATE ANDCONTACT NO5 CYLINDER CONNECTING ROD AND CAUSING IT TO FAIL WHICHCAUSED SEVERE DAMAGE TO THE CRANKCASE. THE RETAINING CIRCLIPPNO LW148

Next page: https://openairdocs.org/model/aero-commander-500-s/reports.md?page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy
FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet'
WHERE aircraft_model_key = '500S'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/model/aero-commander-500-s/reports

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
