# Service difficulty reports: N931CA, cancelled Jun 7, 2011

A list on [N931CA, cancelled Jun 7, 2011](https://openairdocs.org/deregistered/N931CA-2011-06-07.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 3 · 131 reports

- [SDR COMA2010110550230](https://openairdocs.org/sdr/COMA2010110550230.md): Bpsu · faulty · Nov 3, 2010 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > ON APPROACH INTO LEX RECEIVED FLAPS FAIL CAUTION MSG AT 20 DEG. EMERGENCY DECLARED, A/C LANDED SAFELY. REMOVED AND REPLACED RIGHT WING BPSU.
- [SDR COMA2010101850223](https://openairdocs.org/sdr/COMA2010101850223.md): Reservoir · failed · Oct 16, 2010 · N931CA · Cndair CL6002B19 · Hydraulic Reservoir, Main
  > ON CLIMBOUT FROM MEM RECEIVED HYD NR 2 TEMP CAUTION MSG. EMERGENCY DECLARED, A/C RETURNED TO MEM LANDED SAFELY. REMOVED AND REPLACED NR 2 HYD RESERVOIR.
- [SDR COMA2010010250003](https://openairdocs.org/sdr/COMA2010010250003.md): Flap · malfunctioned · Jan 2, 2010 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > RECEIVED A FLAP FAIL CAUTION DURING YYZ APPROACH, CREW PERFORMED AN EMERGENCY DESCENT AND DECLARED AN EMERGENCY. COMPLIED WITH AD 2009-06-12 PARAGRAPHS H6 & H7: MAINTENANCE FOLLOWING A FLAP FAILURE USING FIM 27-50-00. TASK CARD SI-2-27-50-00.
- [SDR COMA2009050550130](https://openairdocs.org/sdr/COMA2009050550130.md): Skin · cracked · May 2, 2009 · N931CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > RT FUSELAGE SKIN IS CRACKED AT FS 235.00 IN THE RT AFT RADIUS OF THE NOSE LANDING GEAR CUTOUT. REMOVED DAMAGED PORTION OF SKIN AND INSTALLED PERMANENT REPAIR PARTS PER BOMBARDIER AEROSPACE REO 601R-53-11-048 REV (C).
- [SDR COMA2009050550129](https://openairdocs.org/sdr/COMA2009050550129.md): Frame · cracked · May 2, 2009 · N931CA · Cndair CL6002B19 · Fuselage Main, Frame
  > LEFT FS 640.00 FRAME AND BONDED SKIN DOUBLER ARE CRACKED BETWEEN STRINGER 9 AND 13. REMOVED DAMAGED PARTS AND COMPLIED WITH MODIFICATION K601R36009-3 ON LT FS. 640.00 FRAME AND DOUBLER PER S/B 601R-53-061KIT DRWG K601R36009 REV B, 601R-53-61-506 REV C AND 601
- [SDR COMA2009050550128](https://openairdocs.org/sdr/COMA2009050550128.md): Skin · dented · May 2, 2009 · N931CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > DENT WITH GOUGE AT FS 605.00 BETWEEN STRINGER 15R AND 16R. REMOVED DAMAGE AT FS 605.00 BETWEEN STRINGER 15R AND 16R AND APPLIED A PERMANENT REPAIR PER CRJ SRM 53-00-31 REPAIR 1 FIGURE 204 SHEET 1 PG 201-212.
- [SDR COMA2009050550127](https://openairdocs.org/sdr/COMA2009050550127.md): Post · cracked · May 2, 2009 · N931CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > VERTICAL BEAM POST O\B SIDE AT LBL 9 AT FS 559.0 IS CRACKED AT BOTTOM. REPAIRED BOTTOM SIDE OF VERT BEAM O\B SIDE AT FS 559.0 LBL 9 IAW REO 601R-53-730, EA 10-5341-02592 AND SR99-5140-0001.
- [SDR COMA2009012050063](https://openairdocs.org/sdr/COMA2009012050063.md): Flap · failed · Jan 14, 2009 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLAPS FAILED AT 0 DEG, ON APPROACH INTO YUL. EMERGENCY DECLARED, A/C LANDED SAFELY. COMPLIED WITH TASK CARD SI-2-27I0002, FLAPS FAIL CAUTION MESSAGE FOLLOW UP MAINTENANCE ACTION.
- [SDR COMA2008121050023](https://openairdocs.org/sdr/COMA2008121050023.md): Selector Valve · failed · Dec 9, 2008 · N931CA · Cndair CL6002B19 · Landing Gear Selector
  > ON APPROACH INTO ORD RECEIVED GEAR DISAGREE MSG AND NOSE DOOR WARNING MSG ON GEAR EXTENSION. BOTH MSG'S EXTINGUISHED PRIOR TO RUNNING QRH. NO EMERGENCY DECLARED, A/C LANDED SAFELY. REMOVED AND REPLACED NLG DOOR SELECTOR VALVE.
- [SDR COMA0860055](https://openairdocs.org/sdr/COMA0860055.md): Flap · malfunctioned · Jan 9, 2008 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5561 - FLAPS FAIL CAUTION MESSAGE AT 0 DEGREES. PERFORMED QRH, EMERGENCY DECLARED, AIRCRAFT LANDED SAFELY. COMPLIED WITH TASK CARD SI-2-27I001, FLAPS FAIL FIRST EVENT MAINTENANCE ACTION.
- [SDR COMA0760700](https://openairdocs.org/sdr/COMA0760700.md): Light · inoperative · Dec 8, 2007 · N931CA · Cndair CL6002B19 · Emergency Lighting
  > CABIN EMERGENCY FLOOR LIGHTS AT ROWS 9 THROUGH 12 INOP. REMOVED AND REPLACED LAMP ASSEMBLY.
- [SDR COMA0760699](https://openairdocs.org/sdr/COMA0760699.md): Cable · faulty · Dec 8, 2007 · N931CA · Cndair CL6002B19 · Light System Wiring
  > CABIN EMERGENCY FLOOR LIGHTS AT ROWS 9 THROUGH 12 INOP. REMOVED AND REPLACED CABLE ASSY AT ROW 12.
- [SDR COMA0760688](https://openairdocs.org/sdr/COMA0760688.md): Engine · flamed out · Dec 4, 2007 · N931CA · Cndair CL6002B19 · Engine (Turbine/Turboprop)
  > FLIGHT 5672 - LEFT ENGINE FLAMED OUT DURING START. FOUND THAT THE PREVIOUS ENGINE START HAD A TAILWIND OF APPROXIMATELY 40 KTS. DRY MOTORED ENGINE AND PERFORMED 2 ENGINE STARTS WITH NO FAULTS.
- [SDR COMA0760602](https://openairdocs.org/sdr/COMA0760602.md): Pdu · faulty · Oct 13, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 9608 - FLAPS FAILED AT 20 DEGREES. AIRCRAFT LANDED SAFELY. REMOVED AND REPLACED PDU.
- [SDR COMA0760593](https://openairdocs.org/sdr/COMA0760593.md): Bpsu · faulty · Oct 3, 2007 · N931CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5616 - RECEIVED FLAP FAIL INDICATION. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED LT BPSU. NO FURTHER DEFECTS.
- [SDR COMA0760505](https://openairdocs.org/sdr/COMA0760505.md): Flap · malfunctioned · Jul 31, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5120 - FLAPS FAIL AT 0 DEGREES IN CRUISE FLIGHT. AIRCRAFT LANDED SAFELY IN JFK. 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 MES
- [SDR COMA0760383](https://openairdocs.org/sdr/COMA0760383.md): Transmitter · faulty · May 18, 2007 · N931CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 4939 - RECEIVED FLAP FAIL MESSAGE AFTER LANDING. REPLACED LEFT FLAP POSITION TRANSMITTER. NO FURTHER DEFECTS.
- [SDR COMA0760382](https://openairdocs.org/sdr/COMA0760382.md): Pdu · faulty · May 18, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 4939 - RECEIVED FLAP FAIL MESSAGE AFTER LANDING. REPLACED PDU. NO FURTHER DEFECTS.
- [SDR COMA0760381](https://openairdocs.org/sdr/COMA0760381.md): Control Unit · faulty · May 18, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 4939 - RECEIVED FLAP FAIL MESSAGE AFTER LANDING. REPLACED FECU. NO FURTHER DEFECTS.
- [SDR COMA0760380](https://openairdocs.org/sdr/COMA0760380.md): Bpsu · faulty · May 18, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 4939 - RECEIVED FLAP FAIL MESSAGE AFTER LANDING. REPLACED LEFT BPSU. NO FURTHER DEFECTS.
- [SDR COMA0760335](https://openairdocs.org/sdr/COMA0760335.md): Bulkhead · cracked · Apr 22, 2007 · N931CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > BULKHEAD WEB CRACKED AT FS 559 BETWEEN RBL 9 AND RBL 18. INCORPORATED A PERMANENT REPAIR PER EA 10-5341-01667.
- [SDR COMA0760331](https://openairdocs.org/sdr/COMA0760331.md): Floor Skin · cracked · Apr 16, 2007 · N931CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > DURING A HMV7 INSPECTION, THE PRESSURE FLOOR SKIN AT FS 460 BETWEEN LBL 9 AND RBL 9 WAS FOUND TO BE CRACKED IN 3 PLACES. PERFORMED REPAIR PER REO 601R-53-41-10.
- [SDR COMA0760287](https://openairdocs.org/sdr/COMA0760287.md): Dcu · faulty · Mar 25, 2007 · N931CA · Cndair CL6002B19 · Automatic Data
  > FLIGHT 5429 - RECEIVED DCU NR 2 INOP MESSAGE ON CLIMB. RETURNED TO CVG AND LANDED WITHOUT INCIDENT. REPLACED NR 2 DCU. NO FURTHER DEFECTS.
- [SDR COMA0760207](https://openairdocs.org/sdr/COMA0760207.md): Flap · malfunctioned · Feb 23, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5294 - DURING PIT APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE. 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 COMA0760164](https://openairdocs.org/sdr/COMA0760164.md): Flap · malfunctioned · Feb 7, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5120 - FLAP FAIL MESSAGE RECEIVED ON APPROACH, 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 MESSAG
- [SDR COMA0760109](https://openairdocs.org/sdr/COMA0760109.md): Control Unit · faulty · Jan 30, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5092 - FLAP FAIL MESSAGE RECEIVED, DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. REPLACED FECU.
- [SDR COMA0760070](https://openairdocs.org/sdr/COMA0760070.md): Bpsu · faulty · Jan 26, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5164 - FLAP FAIL MESSAGE RECEIVED ON APPROACH AT ZERO DEGREES. DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. REPLACED LEFT BPSU.
- [SDR COMA0760069](https://openairdocs.org/sdr/COMA0760069.md): Shaft · damaged · Jan 26, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flaps
  > FLIGHT 5164 - FLAP FAIL MESSAGE RECEIVED ON APPROACH AT ZERO DEGREES. DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. REMOVED AND REPLACED NR 4 LEFT WING FLEX SHAFT.
- [SDR COMA0760068](https://openairdocs.org/sdr/COMA0760068.md): Shaft · damaged · Jan 26, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flaps
  > FLIGHT 5164 - FLAP FAIL MESSAGE RECEIVED ON APPROACH AT ZERO DEGREES. DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. REMOVED AND REPLACED NR 1 LEFT WING FLEX SHAFT.
- [SDR COMA0760067](https://openairdocs.org/sdr/COMA0760067.md): Shaft · damaged · Jan 26, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLAP FAIL MESSAGE RECEIVED ON APPROACH AT ZERO DEGREES. DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. REMOVED AND REPLACED NR 5 LEFT WING FLEX SHAFT.
- [SDR COMA0760020](https://openairdocs.org/sdr/COMA0760020.md): Flap System · malfunctioned · Jan 10, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5072 - EN ROUTE YUL-JFK RECEIVED A FLAP FAIL CAUTION MESSAGE. CREW DECLARED AN EMERGENCY AND FLIGHT 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 SYST
- [SDR COMA0760018](https://openairdocs.org/sdr/COMA0760018.md): Flap System · malfunctioned · Jan 10, 2007 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5072 - FLAP FAIL AT 4000 FT. 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 COMA0660665](https://openairdocs.org/sdr/COMA0660665.md): Ecu · faulty · Nov 30, 2006 · N931CA · Cndair CL6002B19 · Landing Gear Steering System
  > FLIGHT 9497- ABORTED TAKEOFF AT LGA DUE TO A STEERING INOPERATIVE MESSAGE, FLIGHT RETURNED TO THE GATE. REPLACED THE STEERING ELECTRONIC CONTROL UNIT.
- [SDR COMA0660664](https://openairdocs.org/sdr/COMA0660664.md): Steering Sys · malfunctioned · Nov 29, 2006 · N931CA · Cndair CL6002B19 · Landing Gear Steering System
  > FLIGHT 5436 - ABORTED TAKEOFF AT LGA DUE TO STEERING INOPERATIVE MESSAGE, FLIGHT RETURNED TO THE GATE. PERFORMED STEERING SYSTEM RESET AND TAXIED AIRCRAFT USING RUDDER PEDALS AND TILLER, NO DEFECTS NOTED.
- [SDR COMA0660651](https://openairdocs.org/sdr/COMA0660651.md): Potentiometer · malfunctioned · Nov 26, 2006 · N931CA · Cndair CL6002B19 · Landing Gear Steering System
  > FLIGHT 5179 - ON TAKEOFF ROLL 50 KNOTS NWS INOP CAUTION MESSAGE. AIRCRAFT RETURNED TO GATE. FOUND LEFT RVDT OUT OF RIG. RIGGED LEFT RVDT.
- [SDR COMA0660577](https://openairdocs.org/sdr/COMA0660577.md): Computer · malfunctioned · Oct 16, 2006 · N931CA · Cndair CL6002B19 · Landing Gear Steering System
  > FLIGHT 5217 - STEERING INOP MESSAGE CAME ON UPON GEAR RETRACTION, WOULD NOT RESET. TRANSFERRED TO DEFERRED LIST MEL 32-50-01 CAT (A).
- [SDR COMA0660308](https://openairdocs.org/sdr/COMA0660308.md): Flap System · malfunctioned · Apr 21, 2006 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5260 - DURING CVG APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE AT 43 DEGREES, CREW DECLARED AN EMERGENCY AND FLIGHT LANDED WITHOUT INCIDENT. COMPLIED WITH AD 98-20-01 FLAP CAUTION MESSAGE FIRST EVENT MAINTENANCE ACTION, PARAGRAPH (B) 1, 2, 3, (A, B, C
- [SDR COMA0660113](https://openairdocs.org/sdr/COMA0660113.md): Fitting · cracked · Feb 6, 2006 · N931CA · Cndair CL6002B19 · Wing, Landing Gear Attach Fittings
  > DURING COMPLIANCE OF AD 2004-20-09 FOUND THE RIGHT MAIN LANDING GEAR MAIN FITTING TO FAIL THE ULTRASONIC INSPECTION CRITERION. REPLACED THE MAIN LANDING GEAR ASSEMBLY.
- [SDR COMA0560734](https://openairdocs.org/sdr/COMA0560734.md): Landing Gear · warning light · Dec 18, 2005 · N931CA · Cndair CL6002B19 · Nose/Tail Landing Gear
  > FLIGHT 5113 - NWS CAUTION MESSAGE. INSPECTED NLG AND STEERING SYSTEM, OPERATIONAL CHECK SATISFACTORY, NO FAULTS IN COMPUTER.
- [SDR COMAO560518](https://openairdocs.org/sdr/COMAO560518.md): Bulkhead · cracked · Sep 22, 2005 · N931CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > WHILE PERFORMING TASK INS-2-2-27L0005 ITEM NR 6, CLEANING OF THE RIGHT REAR AILERON QUADRANT LOCATED ON THE AFT WALL OF THE MLG WHEEL WELL, DISCOVERED A CRACK ON THE SEMI-PRESSURE BULKHEAD FS 559.00, BL 23L-23R. PERFORMED TEMPORARY REPAIR PER REO 601R-53-41-3
- [SDR COMA0560389](https://openairdocs.org/sdr/COMA0560389.md): Fire Bottle · discharged · Jul 10, 2005 · N931CA · Cndair CL6002B19 · Extinguishing System
  > FLIGHT 5372 - CARGO FIRE BOTTLE LOW CAUTION. REPLACED THE CARGO FIRE BOTTLES.
- [SDR COMA0560033](https://openairdocs.org/sdr/COMA0560033.md): Warning Light · false indication · Jan 7, 2005 · N931CA · Cndair CL6002B19 · Stabilizer Control System
  > FLIGHT 5076 MACH AND STAB TRIM CAUTION. COULD NOT DUPLICATE. SYSTEM OPERATIONAL CHECKS SATISFACTORY.
- [SDR COMA0460638](https://openairdocs.org/sdr/COMA0460638.md): Warning System · unknown · Nov 22, 2004 · N931CA · Cndair CL6002B19 · Drag Control System
  > FLIGHT 5054 ADVANCING THRUST LEVER FOR TAKEOFF RECEIVED A CONFIGURATION WARNING. ABORTED TAKEOFF AND RETURNED TO THE GATE. PERFORMED FUNCTIONAL TEST OF THE SPOILER CONTROL SYSTEM, DISCREPANCY COULD NOT BE DUPLCIATED. AIRCRAFT WAS RELEASED FOR SERVICE.
- [SDR COMA0460403](https://openairdocs.org/sdr/COMA0460403.md): Strut · discharged · Jul 2, 2004 · N931CA · Cndair CL6002B19 · Main Landing Gear Strut/Axle/Truck
  > FLIGHT 5759 GEAR DISAGREE WARNING WOW AND STEERING INOP MESSAGE. SERVICED THE NLG SHOCK STRUT. RETRACTION CHECKS NORMAL.
- [SDR COMA0460074](https://openairdocs.org/sdr/COMA0460074.md): Warning Light · illuminated · Jan 21, 2004 · N931CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5004 FLAPS FAIL CAUTION MESSAGE. RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.
- [SDR COMA0360498](https://openairdocs.org/sdr/COMA0360498.md): Control Module · malfunctioned · Nov 15, 2003 · N931CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5226 FLAPS FAIL AT 27 DEGREES. RESET FLAP SYSTEM AND DEFERRED MAINTENANCE PER AD 98-20-01.
- [SDR COMA0360052](https://openairdocs.org/sdr/COMA0360052.md): Door · Jan 27, 2003 · N931CA · Cndair CL6002B19 · Passenger/Crew Doors
  > FLIGHT 5887 CABIN DOOR EMERGENCY WARNING.ADJUSTED DOOR LATCH MECHANISM.
- [SDR COMA0260619](https://openairdocs.org/sdr/COMA0260619.md): Engine · smoke · Oct 18, 2002 · N931CA · Cndair CL6002B19 · Engine (Turbine/Turboprop)
  > FLIGHT 5847 SMOKE IN CABIN.REPLACED THE R/H ENGINE, (EVIDENCE OF OIL AROUND VG ACTUATOR SPINDLE, SUSPECT #3 CARBON SEAL FAILURE.)
- [SDR COMA0260592](https://openairdocs.org/sdr/COMA0260592.md): Engine · malfunctioned · Oct 18, 2002 · N931CA · Cndair CL6002B19 · Engine (Turbine/Turboprop)
  > FLIGHT 5847 SMOKE IN CABIN. REPLACED THE RT ENGINE. EVIDENCE OF OIL AROUND VG ACTUATOR SPINDLE, SUSPECT NR 3 CARBON SEAL FAILURE.
- [SDR COMA0260589](https://openairdocs.org/sdr/COMA0260589.md): Acm · smoke · Oct 17, 2002 · N931CA · Cndair CL6002B19 · Cabin Cooling System
  > FLIGHT 5319 THICK SMOKE IN CABIN.REPLACED THE R/H ACM.

Next page: https://openairdocs.org/deregistered/N931CA-2011-06-07/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 = 'N931CA' AND deregistration_id = 'N931CA-2011-06-07'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N931CA-2011-06-07/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.