# Service difficulty reports: N814CA, cancelled Oct 29, 2019

A list on [N814CA, cancelled Oct 29, 2019](https://openairdocs.org/deregistered/N814CA-2019-10-29.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 · 76 reports

- [SDR COMA2012041650037](https://openairdocs.org/sdr/COMA2012041650037.md): Seat Track · corroded · Apr 11, 2012 · N814CA · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > RIGHT INBD SEAT TRACK FOUND TO BE CORRODED AT FS 409 - 409+128. REMOVED AND REPLACED RIGHT INBD SEAT TRACK.
- [SDR COMA2012041650036](https://openairdocs.org/sdr/COMA2012041650036.md): Seat Track · corroded · Apr 11, 2012 · N814CA · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach Fittings
  > LEFT INBD SEAT TRACK AT FS 409 - 409+128 FOUND TO BE CORRODED. REMOVED AND REPLACED LEFT INBD SEAT TRACK.
- [SDR COMA2012041650035](https://openairdocs.org/sdr/COMA2012041650035.md): Stiffener · corroded · Apr 11, 2012 · N814CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > LEFT INBD INTERCOSTAL BETWEEN FS 349.00 AND 364.00 AND BETWEEN STR 27 AND STR 26L IS CORRODED. REMOVED AND REPLACED INTERCOSTAL BETWEEN FS 349.00 AND 364.00 AND BETWEEN STR 27L AND STR 26L.
- [SDR COMA2012041650034](https://openairdocs.org/sdr/COMA2012041650034.md): Frame · corroded · Apr 11, 2012 · N814CA · Cndair CL6002B19 · Fuselage Main, Frame
  > CORROSION FOUND ON BOTH SIDES OF FRAME AT FS 349.00 BETWEEN STR 25L & 25R. FRAME SPLICE REPAIR PERFORMED IAW REO 601R-53-21-2290.
- [SDR COMA2012041650033](https://openairdocs.org/sdr/COMA2012041650033.md): Frame · corroded · Apr 11, 2012 · N814CA · Cndair CL6002B19 · Fuselage Main, Frame
  > CORROSION FOUND ON FRAME SECTION AT BS 605.00, BETWEEN STR 27 AND 26L. PERFORMED FRAME SPLICE REPAIR IAW REO 601R-53-61-4460.
- [SDR COMA2012041650032](https://openairdocs.org/sdr/COMA2012041650032.md): Floorbeam · corroded · Apr 11, 2012 · N814CA · Cndair CL6002B19 · Fuselage Main, Floor Beam
  > DURING INSPECTION FOUND FLOORBEAM CAP TO BE CORRODED AT LBL 27.00 FS 615.00. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-21 AND SMI-2-53M002.
- [SDR COMA2012041650031](https://openairdocs.org/sdr/COMA2012041650031.md): Stiffener · cracked · Apr 11, 2012 · N814CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CRACK FOUND ON STIFFENER AT RBL 18.00, FS 409.128. REMOVED AND REPLACED STIFFENER AT RBL 18.00, FS 409.128.
- [SDR COMA2012041650030](https://openairdocs.org/sdr/COMA2012041650030.md): Floor Support · corroded · Apr 11, 2012 · N814CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FLOOR SILL ANGLES FOUND TO BE CORRODED BEYOND SRM 53-41-45-01 LIMITS. FLOOR SILL ANGLES WERE REPAIRED IAW GREO 601R-53-41-666.
- [SDR COMA2012041650029](https://openairdocs.org/sdr/COMA2012041650029.md): Sill · cracked · Apr 11, 2012 · N814CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CARGO DOOR SILL IS CRACKED. PERFORMED REPAIR TO CARGO DOOR SILL IAW BOMBARDIER REO 601R-53-61-593.
- [SDR COMA2011110250089](https://openairdocs.org/sdr/COMA2011110250089.md): Pump · failed · Nov 1, 2011 · N814CA · Cndair CL6002B19 · Hydraulic Pump (Electric/Engine), Main
  > ON CLIMBOUT FROM YYZ RECEIVED GEAR DISAGREE, NOSE LANDING GEAR FAILED TO RETRACTED. EMERGENCY DECLARED, A/C RETURNED TO YYZ LANDED SAFELY. REMOVED AND REPLACED 3A HYDRAULIC PUMP. OPS CHECK GOOD.
- [SDR COMA2010113050249](https://openairdocs.org/sdr/COMA2010113050249.md): Sensing Element · shorted · Nov 30, 2010 · N814CA · Cndair CL6002B19 · Pneumatic Indicating System
  > EN ROUTE, RECEIVED ANTI-ICE DUCT WARNING MSG. EMERGENCY DECLARED, ACFT DIVERTED AND LANDED SAFELY. INSPECTED ACFT FOUND LT WHEEL WELL LOOP A41WK SHORTED. REPLACED LOOP A41WK, OPS CHECK GOOD.
- [SDR COMA2010042350105](https://openairdocs.org/sdr/COMA2010042350105.md): Web · cracked · Apr 22, 2010 · N814CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > FS 559.00 WEB IS CRACKED AT NUT PLATE ON RBL 18.00. WORK ACCOMPLISHED ON TASK CARD REO 601R-53-41-260 RIGHT SIDE REPAIR.
- [SDR COMA2010042350104](https://openairdocs.org/sdr/COMA2010042350104.md): Web · cracked · Apr 22, 2010 · N814CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > FS 621.00 WEB IS CRACKED AT LINTEL FITTING. REPAIRED LINTEL FITTING AT FS 621.00 IAW BOMBARDIER REO601R-53-61-1230 AND EA 10-5361-02933.
- [SDR COMA2010041650097](https://openairdocs.org/sdr/COMA2010041650097.md): Web · cracked · Apr 14, 2010 · N814CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > WEB CRACKED AT FS 621.00 ABOVE CARGO DOOR TRACK ON LBL 27.50. REPAIRED WEB IAW REO 601R-53-61-1541 REV B.
- [SDR COMA2010040850088](https://openairdocs.org/sdr/COMA2010040850088.md): Post · cracked · Apr 7, 2010 · N814CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > POST CRACKED AT FS 409.00+128 RBL 27.00 INBOARD RADIUS. REPAIRED POST IAW REO 601R-53-41-056.
- [SDR COMA2009081050180](https://openairdocs.org/sdr/COMA2009081050180.md): Bpsu · failed · Aug 9, 2009 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > ON APPROACH INTO YYZ RECEIVED FLAPS FAIL CAUTION MSG AT 20 DEG. EMERGENCY DECLARED, A/C LANDED SAFELY. REMOVED AND REPLACED LEFT BPSU.
- [SDR COMA2009043050123](https://openairdocs.org/sdr/COMA2009043050123.md): Angle · cracked · Apr 29, 2009 · N814CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > LEFT SIDE FS 559 CAP ANGLE CRACKED AT LBL 18.00. REPAIRED CAP ANGLE BY SPLICING IN NEW SECTION IAW EA 10-5341-02601.
- [SDR COMA2008112450006](https://openairdocs.org/sdr/COMA2008112450006.md): Pdu · faulty · Nov 23, 2008 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > RECEIVED FLAP FAIL MSG, WHEN SELECTING FLAPS TO 8 DEG AT 200 KNOTS. EMERGENCY DECLARED, A/C LANDED SAFELY. REMOVED AND REPLACED FLAP SYSTEM PDU.
- [SDR COMA0860120](https://openairdocs.org/sdr/COMA0860120.md): Flap · malfunctioned · Feb 10, 2008 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5441 - RECEIVED FLAP FAIL CAUTION MESSAGE ON APPROACH. EMERGENCY DECLARED, LANDED WITHOUT INCIDENT. COMPLIED WITH SI-2-2710001 FLAP CAUTION MESSAGE "FIRST EVENT" MAINTENANCE ACTION, FLAP SYSTEM WAS RESET WITH NO FURTHER MESSAGES.
- [SDR COMA0860110](https://openairdocs.org/sdr/COMA0860110.md): Actuator · faulty · Feb 4, 2008 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Actuator
  > FLIGHT 5620 - RECEIVED FLAP FAIL CAUTION MESSAGE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED OUTBOARD ACTUATOR ON LEFT OUTBOARD FLAP. PERFORMED SI-2-270001. NO FURTHER DEFECTS.
- [SDR COMA0860109](https://openairdocs.org/sdr/COMA0860109.md): Actuator · faulty · Feb 4, 2008 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Actuator
  > FLIGHT 5620 - RECEIVED FLAP FAIL CAUTION MESSAGE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED INBOARD ACTUATOR ON LEFT OUTBOARD FLAP. PERFORMED CARD SI-2-2710001. NO FURTHER DEFECTS.
- [SDR COMA0860094](https://openairdocs.org/sdr/COMA0860094.md): Flap · malfunctioned · Jan 21, 2008 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5154 - UPON SELECTION OF FLAPS TO 8 DEGREES, RECEIVED FLAPS FAIL CAUTION MESSAGE. EMERGENCY DECLARED, AIRCRAFT LANDED SAFELY. COMPLIED WITH TASK CARD SI-2-27I0002, FLAPS FAIL CAUTION MESSAGE FOLLOW UP MAINTENANCE ACTION.
- [SDR COMA0760522](https://openairdocs.org/sdr/COMA0760522.md): Warning System · activated · Aug 6, 2007 · N814CA · Cndair CL6002B19 · Door Warning System
  > FLIGHT 5179 - DURING CLIMB PAX DOOR OUTER HANDLE CAUTION MESSAGE APPEARED. FOLLOWED QRH MESSAGE WENT AWAY. AIRCRAFT LANDED SAFELY BACK AT RIC. TRANSFERRED TO DEFERRED LIST PER MEL 52-70-01-1.
- [SDR COMA0760173](https://openairdocs.org/sdr/COMA0760173.md): Reservoir · contaminated · Feb 9, 2007 · N814CA · Cndair CL6002B19 · Hydraulic Reservoir, Main
  > FLIGHT 5579 - RECEIVED HYD SYSTEM NR 3 LOW PRESSURE WARNING ON TAKEOFF ROLL. ABORTED TAKEOFF BELOW 80 KTS. RETURNED TO GATE WITHOUT INCIDENT. FOUND EXCESSIVE AIR IN NR 3 HYD RESERVOIR. BLED AND SERVICED RESERVOIR. NO FURTHER DEFECTS.
- [SDR COMA0760120](https://openairdocs.org/sdr/COMA0760120.md): Fcu · faulty · Jan 31, 2007 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5295 - RECEIVED FLAP FAIL MESSAGE. DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. REPLACED FECU AND COMPLIED WITH EO 27-046AD. NO FURTHER DEFECTS.
- [SDR COMA0760119](https://openairdocs.org/sdr/COMA0760119.md): Pdu · faulty · Jan 31, 2007 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5295 - RECEIVED FLAP FAIL MESSAGE. DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. REPLACED PDU AND COMPLIED WITH EO 27-046AD. NO FURTHER DEFECTS.
- [SDR COMA0760099](https://openairdocs.org/sdr/COMA0760099.md): Actuator · failed · Jan 28, 2007 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Actuator
  > FLIGHT 5086 - FLAPS FAIL AT 500 FT ON APPROACH TO CVG FAILED AT 0 DEGREES WHEN SELECTING 8 DEGREES. REMOVED AND REPLACED FLAP ACTUATOR.
- [SDR COMA0760098](https://openairdocs.org/sdr/COMA0760098.md): Actuator · failed · Jan 28, 2007 · N814CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5086 - FLAPS FAIL AT 500 FT ON APPROACH TO CVG FAILED AT 0 WHEN SELECTING 8 DEGREES. REMOVED AND REPLACED FLAP ACTUATOR.
- [SDR COMA0760063](https://openairdocs.org/sdr/COMA0760063.md): Flap System · malfunctioned · Jan 25, 2007 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5396 - RECEIVED A FLAP FAIL CAUTION MESSAGE DURING YYZ APPROACH AT ZERO DEGREE FLAP SETTING. 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 CA
- [SDR COMA0660696](https://openairdocs.org/sdr/COMA0660696.md): Landing Gear · malfunctioned · Dec 7, 2006 · N814CA · Cndair CL6002B19 · Nose/Tail Landing Gear
  > FLIGHT 5282 - NOSE GEAR DISAGREE DURING RETRACTION. NOSE GEAR STAYED DOWN AND LOCKED. DECLARED EMERGENCY AND RETURNED TO AIRPORT. FERRIED TO RFD. PSEU FLAGGED S23FOYND, NOSE GEAR NOT EXTENDING COMPLETELY. FLUSHED AND SERVICED NLG, SWUNG 3 TIMES, NO FURTHE
- [SDR COMA0660614](https://openairdocs.org/sdr/COMA0660614.md): Flap System · malfunctioned · Nov 4, 2006 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5096 - EN ROUTE CVG-BGR RECEIVED A FLAP FAIL CAUTION MESSAGE AT ZERO DEGREE FLAP SETTING. 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 CAUT
- [SDR COMA0660529](https://openairdocs.org/sdr/COMA0660529.md): Landing Gear · malfunctioned · Sep 5, 2006 · N814CA · Cndair CL6002B19 · Nose/Tail Landing Gear
  > FLIGHT 5162 - DURING CLIMB EN ROUTE BUF-JFK THE NOSE LANDING GEAR DID NOT RETRACT. PERFORMED MULTIPLE STATIC GEAR SWINGS, DISCREPANCY COULD NOT BE DUPLICATED BY MAINTENANCE.
- [SDR COMA0660477](https://openairdocs.org/sdr/COMA0660477.md): Warning Message · illuminated · Aug 6, 2006 · N814CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > FLIGHT 5581 - AFTER TAKEOFF FROM BGR RECEIVED A LANDING GEAR DISAGREE WARNING MESSAGE, CREW DECLARED AN EMERGENCY AND RETURNED TO THE FIELD. SERVICED THE NLG WITH NITROGEN.
- [SDR COMA0660431](https://openairdocs.org/sdr/COMA0660431.md): Caution Message · illuminated · Jul 15, 2006 · N814CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5168 - DURING TAXI-IN RECEIVED A FLAP CAUTION MESSAGE AT 25 DEGREES. COMPLIED WITH AD 09-20-01 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (B) 1, 2, 3, (A, B, C AND E). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTION MESSAGES.
- [SDR COMA0660430](https://openairdocs.org/sdr/COMA0660430.md): Caution Message · illuminated · Jul 14, 2006 · N814CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5324- EN ROUTE JFK-BOS RECEIVED A FLAP FAIL CAUTION MESSAGE AT ZERO DEGREES, CREW DECLARED AN EMERGENCY AND RETURNED TO JFK. FLIGHT LANDED WITHOUT INCIDENT. COMPLIED WITH AD 09-20-01 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (B)
- [SDR COMA0660407](https://openairdocs.org/sdr/COMA0660407.md): Computer · faulty · Jun 27, 2006 · N814CA · Cndair CL6002B19 · Attitude Gyro and Indicating System
  > FLIGHT 5188 - DURING TAKEOFF ROLL ENCOUNTERED FAILURE OF AHRS NR 1, ABORTED TAKEOFF AND AIRCRAFT RETURNED TO THE GATE. REPLACED THE NR 1 AHRS COMPUTER.
- [SDR COMA0660365](https://openairdocs.org/sdr/COMA0660365.md): Control Lever · faulty · May 31, 2006 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5414- EN ROUTE CMH-ATL RECEIVED A FLAP FAIL CAUTION MESSAGE AT 20 DEGREES, FLIGHT RETURNED TO CMH. REPLACED THE FLAP CONTROL LEVER.
- [SDR COMA0660255](https://openairdocs.org/sdr/COMA0660255.md): Sill · corroded · Mar 15, 2006 · N814CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > SERVICE DOOR SILL PLATE CORRODED AND REQUIRES REPLACEMENT. REMOVED AND REPLACED SERVICE DOOR SILL PLATE IAW CRJ AMM 20-21-00.
- [SDR COMA0660254](https://openairdocs.org/sdr/COMA0660254.md): Panel · corroded · Mar 15, 2006 · N814CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FOUND CORROSION ON GALLEY AFT INBOARD MOLDING. REMOVED CORROSION FROM GALLEY MOLDING AND TREATED WITH PREVENTATIVE.
- [SDR COMA0660106](https://openairdocs.org/sdr/COMA0660106.md): Control Handle · faulty · Feb 1, 2006 · N814CA · Cndair CL6002B19 · Landing Gear Selector
  > FLIGHT 5474 - AFTER T/O THE LANDING GEAR FAILED TO RETRACT, CREW DECLARED AN EMERGENCY AND RETURNED TO THE FIELD. REPLACED THE LANDING GEAR CONTROL HANLE ASSEMBLY.
- [SDR COMA0560767](https://openairdocs.org/sdr/COMA0560767.md): Warning Light · illuminated · Jan 3, 2006 · N814CA · Cndair CL6002B19 · Engine Thrust Reverser
  > FLIGHT 5487 - LT T/R UNLOCK CAUTION. DEFERRED MAINTENANCE ON T/R PER MEL.
- [SDR COMA0560542](https://openairdocs.org/sdr/COMA0560542.md): Flap System · malfunctioned · Oct 9, 2005 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5707 - FLAPS FAIL CAUTION. RESET FLAP SYSTEM AND DEFERRED MAINTENANCE PER AD 98-20-01.
- [SDR COMA0560534](https://openairdocs.org/sdr/COMA0560534.md): Flap System · malfunctioned · Oct 4, 2005 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5096 - FLAPS FAIL CAUTION. RESET FLAP SYSTEM AND DEFERRED MAINTENANCE PER AD 98-20-01.
- [SDR COMA0560529](https://openairdocs.org/sdr/COMA0560529.md): Actuator · unreliable · Sep 30, 2005 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Actuator
  > FLIGHT 5858 - FLAPS FAIL CAUTION. REPLACED THE RT WING FLAP ACTUATORS.
- [SDR COMA0560526](https://openairdocs.org/sdr/COMA0560526.md): Coupling · worn · Sep 28, 2005 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5184 - FLAPS FAIL CAUTION. REPLACED NR 1 AND NR 5 FLEX DRIVES ON LT FLAPS.
- [SDR COMA0560524](https://openairdocs.org/sdr/COMA0560524.md): Control Unit · malfunctioned · Sep 26, 2005 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5301- FLAPS FAIL CAUTION. CND, REPLACED THE FECU.
- [SDR COMA0560509](https://openairdocs.org/sdr/COMA0560509.md): Warning Light · illuminated · Sep 18, 2005 · N814CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5638 - DURING ATL APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE AT 45 DEGREE FLAP POSITION SETTING. COMPLIED WITH AD 98-20-01 FLAP CAUTION MESSAGE FIRST EVENT MAINTENANCE ACTION PARAGRAPH (B) 1, 2, 3 (A, B, C AND E). FLAP SYSTEM WAS RESET WITH NO FURT
- [SDR COMA0560508](https://openairdocs.org/sdr/COMA0560508.md): Pdu · faulty · Sep 18, 2005 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5638 - DURING JFK APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE AT 40 DEGREE FLAP POSITION SETTING. REPLACED THE POWER DRIVE UNIT.
- [SDR COMA0560469](https://openairdocs.org/sdr/COMA0560469.md): Bpsu · faulty · Aug 26, 2005 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5441- WHILE AT GATE AT JAX RECEIVED A FLAP FAIL CAUTION MESSAGE. REPLACED THE LEFT BRAKE PPOSITION SENSING UNIT.
- [SDR COMA0560470](https://openairdocs.org/sdr/COMA0560470.md): Fcu · faulty · Aug 26, 2005 · N814CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5441 - DURING CRUISE RECEIVED A FLAP HALFSPEED MSG FOLLOWED BY A FLAP FAIL CAUTION MESSAGE. CREW DECLARED AN EMERGENCY AND FLIGHT LANDED AT JAX WITH FLAPS AT ZERO DEGREES. REPLACED THE FLAP ELECTRONIC CONTROL UNIT.

Next page: https://openairdocs.org/deregistered/N814CA-2019-10-29/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 = 'N814CA' AND deregistration_id = 'N814CA-2019-10-29'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N814CA-2019-10-29/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, except the copies of manufacturers’ service documents, which belong to their rights holders.