# Service difficulty reports: N957CA, cancelled Apr 18, 2018

A list on [N957CA, cancelled Apr 18, 2018](https://openairdocs.org/deregistered/N957CA-2018-04-18.md).

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

Page 1 of 2 · 97 reports

- [SDR COMA2012021350007](https://openairdocs.org/sdr/COMA2012021350007.md): Bracket · bent · Feb 10, 2012 · N957CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > ON T/O FROM ATL RECEIVED GEAR DISAGREE ALONG WITH NOSE DOOR WARNING MSG. PERFORMED QRH. EMERGENCY DECLARED, A/C RETURNED TO ATL LANDED SAFELY. INSPECTED A/C AND FOUND NLG OLEO CENTER CAM PROXS SWITCH BRACKET BENT. REMOVED AND REPLACED PROX SWITCH BRACKET.
- [SDR COMA2011062250041](https://openairdocs.org/sdr/COMA2011062250041.md): Brake · smoke · Jun 21, 2011 · N957CA · Cndair CL6002B19 · Brake
  > RAMP REPORTED SMOKE COMING FROM RIGHT MAIN BRAKE, TEMP 8/9 ON RIGHT SIDE, LEFT NORMAL. EMERGENCY DECLARED. BLED RIGHT I/B AND O/B BRAKES. NO FURTHER DEFECTS NOTED.
- [SDR COMA2010030150051](https://openairdocs.org/sdr/COMA2010030150051.md): Post · cracked · Feb 27, 2010 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FOUND CRACK AT TOP OF VERTICAL POST AT FS 409.00 RBL 9.00. REPAIRED POST AT FS 409.00 RBL 9.00 IAW REO 601R-53-41-889.
- [SDR COMA2010030150050](https://openairdocs.org/sdr/COMA2010030150050.md): Pressure Panel · cracked · Feb 27, 2010 · N957CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > FOUND CRACK AT FS 461.00 PRESSURE FLOOR SKIN BL 0.00 (UNDER A/C DUCT). REPAIRED PRESSURE FLOOR SKIN AT FS 461.00 BL 0.00 IAW REO 601R-53-41-103.
- [SDR COMA2010030150049](https://openairdocs.org/sdr/COMA2010030150049.md): Frame · cracked · Feb 27, 2010 · N957CA · Cndair CL6002B19 · Fuselage Main, Frame
  > FOUND CRACK IN FRAME AT FS 333.00 BL 1R. REPLACED FRAME AT FS 333.00 BL 1R IAW SRM 51-42-06.
- [SDR COMA2010030150048](https://openairdocs.org/sdr/COMA2010030150048.md): Floor Skin · cracked · Feb 27, 2010 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FOUND CRACK AT FS 461.00 PRESSURE FLOOR SKIN BETWEEN BL 0.00 AND BL 9.00. REPAIRED PRESSURE FLOOR SKIN AT FS 461.00 BETWEEN BL 0.00 AND BL 9.00 IAW REO 601R-53-41-103.
- [SDR COMA2010022250044](https://openairdocs.org/sdr/COMA2010022250044.md): Bulkhead · cracked · Feb 20, 2010 · N957CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > FOUND CRACK AT FS 621.00 BULKHEAD ABOVE AFT CARGO DOOR TRACK. REPAIRED AFT PRESSURE BULKHEAD AT FS 621.00 ABOVE AFT CARGO DOOR TRACK IAW REO 601R-53-61-1541.
- [SDR COMA2009032450104](https://openairdocs.org/sdr/COMA2009032450104.md): Pump · faulty · Mar 24, 2009 · N957CA · Cndair CL6002B19 · Turbine Engine Oil System
  > EN ROUTE FROM LGA TO SAV RECEIVED LEFT ENGINE OIL PRESSURE MSG. EMERGENCY DECLARED, A/C DIVERTED TO RDU LANDED SAFELY. REMOVED AND REPLACED LEFT ENGINE LUBE AND SCAVENGE PUMP.
- [SDR COMA086369](https://openairdocs.org/sdr/COMA086369.md): Carbon Seal · worn · Aug 22, 2008 · N957CA · Cndair CL6002B19 · Turbine Engine Oil System
  > ENROUTE FROM CLE TO JFK RECEIVED RT ENGINE OIL PRESS WARNING MSG. FOLLOWED QRH, EMERGENCY DECLARED PERFORMED IFSD OF RT ENGINE. ACFT DIVERTED TO AVP AND LANDED SAFELY. CORRECTIVE ACTION: FOUND IDG CARBON SEAL (AGB AXIS BB) LEAKING. R&R CARBON SEAL.
- [SDR COMA0860225](https://openairdocs.org/sdr/COMA0860225.md): Computer · malfunctioned · Apr 13, 2008 · N957CA · Cndair CL6002B19 · Fuel Indicating System
  > FLIGHT 5404 - ON CLIMBOUT FROM BWI LOST ALL FUEL INDICATIONS. A/C RETURNED BACK TO BWI AND LANDED SAFELY. UPON ARRIVAL AT BWI ALL FUEL INDICATION OPS NORMAL. RESET FUEL COMPUTER, OPS CHECK GOOD.
- [SDR COMA0860217](https://openairdocs.org/sdr/COMA0860217.md): Web · cracked · Apr 7, 2008 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > DURING HMV NR 6 INSPECTION, VISUAL INSPECTION FOUND FS 202.75 PRESSURE WEB CRACKED AT PARKING BRAKE CABLE CUTOUT. ENLARGED CUTOUT TO REMOVE DAMAGE AND INSTALLED A DOUBLER PER CRJ REO 601R-53-11-563.
- [SDR COMA0860216](https://openairdocs.org/sdr/COMA0860216.md): Web · cracked · Apr 7, 2008 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > DURING HMV - NR 6 INSPECTION, NDT INSPECTION FOUND A CRACK ON THE FS 559 WEB. CUT OUT DAMAGE AND INSTALLED DOUBLERS IAW REO 601R-53-41-260.
- [SDR COMA0860215](https://openairdocs.org/sdr/COMA0860215.md): Floorbeam · cracked · Apr 7, 2008 · N957CA · Cndair CL6002B19 · Fuselage Main, Floor Beam
  > DURING HMV - NR 6 INSPECTION, NDT INSPECTION FOUND CRACKS ON THE FS 559 RBL 18, LBL 18 LOWER CAP ANGLES. CUT OUT DAMAGE AND INSTALLED DOUBLERS IAW REO 601R-53-41-260.
- [SDR COMA0860214](https://openairdocs.org/sdr/COMA0860214.md): Skin · cracked · Apr 7, 2008 · N957CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > DURING HMV - NR 6 INSPECTION, NDT INSPECTION FOUND CRACKS AT AFT RADIUS LEFT AND RIGHT FOR NLG SPADE DOOR CUTOUT. CUT OUT DAMAGE AND INSTALLED DOUBLERS IAW REO 601R-53-11-010.
- [SDR COMA0860173](https://openairdocs.org/sdr/COMA0860173.md): Stiffener · cracked · Mar 12, 2008 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > DURING HMV-6 INSPECTION, NDT (HK) FOUND CRACK AT LOWER END OF VERTICAL STIFFENER, FS 409+128, LBL 27. CUT OUT DAMAGE AND INSTALLED DOUBLER IAW BOMBARDIER REO 601R-53-41-056.
- [SDR COMA0860172](https://openairdocs.org/sdr/COMA0860172.md): Stiffener · cracked · Mar 12, 2008 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > DURING HMV-6 INSPECTION, NDT (HK) FOUND CRACK AT LOWER END OF VERTICAL STIFFENER, FS 409+128, LBL 18. CUT OUT DAMAGE AND INSTALLED DOUBLER IAW BOMBARDIER REO 601R-53-41-056.
- [SDR COMA0860166](https://openairdocs.org/sdr/COMA0860166.md): Channel · cracked · Mar 10, 2008 · N957CA · Cndair CL6002B19 · Wing Miscellaneous Structure
  > DURING HMV NR 6 INSPECTION, NDT INSPECTION FOUND A CRACK ON THE 540 DB FUEL TANK CUTOUT, BETWEEN WS 85.5 AND 106.4. DAMAGE WAS BLENDED OUT PER REO 601R-57-21-030.
- [SDR COMA0860169](https://openairdocs.org/sdr/COMA0860169.md): Beam · cracked · Mar 10, 2008 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CRACK FOUND ON RBL 27 AT FS 409+128 ON INBOARD SIDE OF VERTICAL BEAM LOWER. REPAIRED CRACK IAW REO 601R-53-41-056.
- [SDR COMA0860168](https://openairdocs.org/sdr/COMA0860168.md): Beam · cracked · Mar 10, 2008 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CRACK FOUND ON RBL 18 AT FS 409+128 ON OUTBOARD SIDE OF VERTICAL BEAM LOWER. REPAIRED IAW REO 601R-53-41-056.
- [SDR COMA0860165](https://openairdocs.org/sdr/COMA0860165.md): Web · corroded · Mar 10, 2008 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > DURING HMV INSPECTION, VISUAL INSPECTION FOUND UPPER EDGE OF FLOOR DECK SUPPORT WEB CORRODED AT FS 280. CUT OUT CORRODED EDGE AND INSTALLED FILLER AND DOUBLER PER EA 10-5310-02124.
- [SDR COMA0860164](https://openairdocs.org/sdr/COMA0860164.md): Support Angle · cracked · Mar 10, 2008 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > DURING HMV NR 6 INSPECTION, VISUAL INSPECTION FOUND FLOOR DECK SUPPORT ANGLE CRACKED AT FS 280. REMOVED AND REPLACED SUPPORT ANGLE PER CRJ SRM 51-42-21 AND SRM 51-42-06.
- [SDR COMA0760598](https://openairdocs.org/sdr/COMA0760598.md): Flap System · malfunctioned · Oct 9, 2007 · N957CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 4961 - FLAPS FAIL MESSAGE AT 30 DEGREES ON DESCENT. AIRCRAFT LANDED SAFELY. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3 (A, B, C). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTION MESSAGE
- [SDR COMA0760597](https://openairdocs.org/sdr/COMA0760597.md): Bpsu · faulty · Oct 9, 2007 · N957CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 4961 - RECEIVED FLAP FAIL INDICATION. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED RIGHT BPSU. NO FURTHER DEFECTS.
- [SDR COMA0760596](https://openairdocs.org/sdr/COMA0760596.md): Flap System · malfunctioned · Oct 8, 2007 · N957CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 4961- RECEIVED FLAP FAIL MESSAGE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3, (A, B, C) FLAP SYSTEM WAS RESET WITH NO FURTHER MESSAGES.
- [SDR COMA0760586](https://openairdocs.org/sdr/COMA0760586.md): Flap System · failed · Sep 29, 2007 · N957CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5646 - FLAPS FAILED AFTER PUSHBACK. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3 (A, B, C). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTION MESSAGES.
- [SDR COMA0760528](https://openairdocs.org/sdr/COMA0760528.md): Flap · malfunctioned · Aug 15, 2007 · N957CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 4946 - RECEIVED FLAP FAIL MESSAGE DURING RETRACTION AFTER TAKEOFF. DECLARED EMERGENCY UPON LANDING AT CVG. LANDED WITHOUT INCIDENT. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3 (A,B,C) FLAP
- [SDR COMA0660708](https://openairdocs.org/sdr/COMA0660708.md): Target · loose · Dec 13, 2006 · N957CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > FLIGHT 5290 - DURING CLIMBOUT OF CVG RECEIVED A LANDING GEAR DISAGREE WARNING MESSAGE DURING GEAR RETRACTION. GEAR WAS EXTENDED MANUALLY AND FLIGHT RETURNED TO CVG. RE-GAPPED THE MLG UPLOCK PROXIMITY SENSOR AND TIGHTENED THE TARGET.
- [SDR COMA0660231](https://openairdocs.org/sdr/COMA0660231.md): Skin · corroded · Mar 6, 2006 · N957CA · Cndair CL6002B19 · Passenger/Crew Doors
  > FOUND PAX DOOR INNER SKIN TO BE CORRODED IN SEVERAL AREAS. REMOVED AND REPLACED SKIN IAW SRM 51-42-06, 51-42-13 AND 51-25-16.
- [SDR COMA0660230](https://openairdocs.org/sdr/COMA0660230.md): Door Frame · corroded · Mar 6, 2006 · N957CA · Cndair CL6002B19 · Passenger/Crew Doors
  > FOUND CORROSION ON LOWER CORNERS OF PAX DOOR. REMOVED AND REPLACED BOTH LOWER CORNERS IAW SRM 51-42-06.
- [SDR COMA0660205](https://openairdocs.org/sdr/COMA0660205.md): Seat Track · corroded · Feb 28, 2006 · N957CA · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > SEAT TRACK CORRODED ON RIGHT SIDE IN FRONT OF LAV DOOR. REMOVED CORRODED MATERIAL, PRIMED, PAINTED AND REINSTALLED SEAT TRACK IAW CRJ AMM 53-01-11-400-801.
- [SDR COMA0660204](https://openairdocs.org/sdr/COMA0660204.md): Sill · corroded · Feb 28, 2006 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > SERVICE DOOR LOWER THRESHOLD CORRODED. REMOVED AND REPLACED SERVICE DOOR LOWER THRESHOLD ANGLE IAW DRAWING 601R38303, CRJ SRM 51-42-21, 51-42-13, 51-42-34, APPLIED PRIMER AND TOPCOAT IAW CRJ SRM 51-42-06 AND 51-42-16.
- [SDR COMA0660184](https://openairdocs.org/sdr/COMA0660184.md): Beam · corroded · Feb 26, 2006 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > LATERAL BEAM LOCATED AT FS 559+112.0 WHERE LAV AFT WALL MEETS FLOOR IS CORRODED. TREATED CORROSION IAW SRM 51-20-06.
- [SDR COMA0660183](https://openairdocs.org/sdr/COMA0660183.md): Sill · corroded · Feb 26, 2006 · N957CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > PAX DOOR SILL HAS CORROSION NEAR DRAINS. REMOVED CORROSION ON PAX DOOR THRESHOLD IAW SRM 51-21-06, 51-42-20, 51-25-06 AND 51-25-16.
- [SDR COMA0660114](https://openairdocs.org/sdr/COMA0660114.md): Selector Valve · faulty · Feb 6, 2006 · N957CA · Cndair CL6002B19 · Landing Gear Selector
  > FLIGHT 5763 - DURING CVG APPROACH RECEIVED A RED GEAR DISAGREE MESSAGE, CREW DECLARED AN EMERGENCY, PERFORMED MANUAL GEAR EXTENSION PROCEDURE AND FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE MAIN LANDING GEAR SELECTOR VALVE.
- [SDR COMA0660144](https://openairdocs.org/sdr/COMA0660144.md): Selector Valve · faulty · Feb 6, 2006 · N957CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > FLIGHT 5763 - DURING CVG APPROACH RECEIVED A RED GEAR DISAGREE MESSAGE, CREW DECLARED AN EMERGENCY, PERFORMED MANUAL GEAR EXTENSION PROCEDURE AND FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE MAIN LANDING GEAR SELECTOR VALVE.
- [SDR COMA0560664](https://openairdocs.org/sdr/COMA0560664.md): Wire Harness · unknown · Dec 2, 2005 · N957CA · Cndair CL6002B19 · Flight Control System Wiring
  > FLIGHT 4996 - UNCOMMANDED RIGHT ROLL, RT FLIGHT SPOILER DEPLOYED. SPOILER FAULT MESSAGE. NO FAULT CODES IN SECU. REPLACED THE RT OUTBD FLIGHT SPOILER WIRE HARNESS FOR TROUBLESHOOTING.
- [SDR COMA0560657](https://openairdocs.org/sdr/COMA0560657.md): Spoiler · deployed · Nov 30, 2005 · N957CA · Cndair CL6002B19 · Drag Control System
  > UNCOMMANDED ROLL, RT FLIGHT SPOILER DEPLOYED. CND, NO FAULTS FOUND, REPLACED SECU AND SYSTEM 2A PRESSURE SWITCH FOR TROUBLESHOOTING.
- [SDR COMA0560601](https://openairdocs.org/sdr/COMA0560601.md): Pcu · malfunctioned · Nov 11, 2005 · N957CA · Cndair CL6002B19 · Drag Control System
  > FLIGHT 5728 - RIGHT FLIGHT SPOILER DEPLOYED DURING FLIGHT. REPLACED THE RIGHT FLIGHT SPOILER PCU.
- [SDR COMA0560402](https://openairdocs.org/sdr/COMA0560402.md): Lamp · inoperative · Jul 19, 2005 · N957CA · Cndair CL6002B19 · Emergency Lighting
  > FLIGHT 5108- EMERGENCY FLOOR PATH LIGHTS INOPERABLE. REPLACED FLOOR TRACK LIGHTING ASSEMBLY.
- [SDR COMA0560377](https://openairdocs.org/sdr/COMA0560377.md): Idg · underserviced · Jul 3, 2005 · N957CA · Cndair CL6002B19 · AC Generator-Alternator
  > NR 1 IDG CAUTION. SERVICED IDG OIL. OPERATION CHECKS SATISFACTORY.
- [SDR COMA0560171](https://openairdocs.org/sdr/COMA0560171.md): Warning Light · illuminated · Mar 12, 2005 · N957CA · Cndair CL6002B19 · Door Warning System
  > FLIGHT 5705 DURING CLIMBOUT OF CVG RECEIVED A CABIN DOOR HANDLE MESSAGE, CREW DECLARED AN EMERGENCY AND RETURNED TO THE FIELD. PERFORMED OPERATIONAL CHECK OF CABIN DOOR AND PRESSURIZATION, DISCREPANCY COULD NOT BE DUPLICATED.
- [SDR COMA0560136](https://openairdocs.org/sdr/COMA0560136.md): Proximity Switch · unreliable · Feb 19, 2005 · N957CA · Cndair CL6002B19 · Door Warning System
  > FLIGHT 5148 CABIN DOOR OUTER HANDLE CAUTION. REPLACED PROXIMITY SWITCH DI17.
- [SDR COMA0560012](https://openairdocs.org/sdr/COMA0560012.md): Idg · lack of lube · Dec 29, 2004 · N957CA · Cndair CL6002B19 · AC Generator-Alternator
  > FLIGHT 5884, NR 1 IDG CAUTION DURING T/O. SERVICED THE IDG OIL SYSTEM, OPERATIONAL CHECKS WERE SATISFACTORY.
- [SDR COMA0460358](https://openairdocs.org/sdr/COMA0460358.md): Warning Light · false indication · Jun 8, 2004 · N957CA · Cndair CL6002B19 · Door Warning System
  > FLIGHT 5301 CABIN DOOR OUTER HANDLE CAUTION MESSAGE. DEFERRED MAINT ON DOOR WARNING SYSTEM PER MEL.
- [SDR COMA0460305](https://openairdocs.org/sdr/COMA0460305.md): Reservoir · malfunctioned · May 8, 2004 · N957CA · Cndair CL6002B19 · Hydraulic Reservoir, Main
  > FLIGHT 5417 GEAR DISAGREE WARNING. COULD NOT DUPLICATE. REPLACED THE NR 3 HYDRAULIC RESERVOIR.
- [SDR COMA0460276](https://openairdocs.org/sdr/COMA0460276.md): Warning System · false activation · Apr 22, 2004 · N957CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > FLIGHT 5417 DURING APPROACH INTO BNA RECEIVED A NR 3 HYDRAULIC LOW PRESSURE CAUTION FOLLOWED BY NOSE GEAR DISAGREE. CREW DECLARED AN EMERGENCY, CAUTION MESSAGES CLEARED, AIRCRAFT LANDED SAFELY. REFERENCE CRJ FSM NORMAL PROCEDURES 3-98, A NUISANCE GEAR DISAGR
- [SDR COMA0360308](https://openairdocs.org/sdr/COMA0360308.md): Warning Light · illuminated · Jul 2, 2003 · N957CA · Cndair CL6002B19 · Engine Thrust Reverser
  > FLIGHT 5562 RECEIVED A RIGHT THRUST REVERSER UNLOCK CAUTION DURING TAKEOFF ROLL, ABORTED AND RETURNED TO THE GATE. DEFERRED THE RIGHT THRUST REVERSER PER MEL.
- [SDR COMA0360109](https://openairdocs.org/sdr/COMA0360109.md): Priority Valve · unreliable · Feb 19, 2003 · N957CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > FLIGHT 5575 NLG FAILED TO EXTENDREPLACED THE NLG PRIORITY VALVE.
- [SDR COMA0360019](https://openairdocs.org/sdr/COMA0360019.md): Bearing · stiff · Jan 10, 2003 · N957CA · Cndair CL6002B19 · Passenger/Crew Doors
  > FLIGHT 5179 CABIN DOOR OUTER HANDLE CAUTION MESSAGE.REPLACED THE LOWER TORQUE TUBE BEARINGS.
- [SDR COMA0360002](https://openairdocs.org/sdr/COMA0360002.md): Lamp · inoperative · Jan 3, 2003 · N957CA · Cndair CL6002B19 · Emergency Lighting
  > FLIGHT 5751 FORWARD SECTION OF EMERGENCY FLOOR LIGHTING IS INOP.REPLACED THE LIGHT STRIP

Next page: https://openairdocs.org/deregistered/N957CA-2018-04-18/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 n_number = 'N957CA' AND deregistration_id = 'N957CA-2018-04-18'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N957CA-2018-04-18/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.