# Service difficulty reports: N819CA, cancelled Jun 11, 2013

A list on [N819CA, cancelled Jun 11, 2013](https://openairdocs.org/deregistered/N819CA-2013-06-11.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 · 78 reports

- [SDR COMA2012031250013](https://openairdocs.org/sdr/COMA2012031250013.md): Proximity Switch · failed · Mar 9, 2012 · N819CA · Cndair CL6002B19 · Door Warning System
  > EN ROUTE FROM IAD TO DTW RECEIVED PAX DOOR CAUTION MSG. FOLLOWED QRH CAUTION REMAINED ON, EMERGENCY DECLARED. A/C DIVERTED TO PIT LANDED SAFELY. REMOVED AND REPLACED PROX SWITCH PS2MB (DI 17). OPS CHECK GOOD.
- [SDR COMA2010040950094](https://openairdocs.org/sdr/COMA2010040950094.md): Bulkhead · cracked · Apr 9, 2010 · N819CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > CRACK ON BULKHEAD AT FS 621 LBL 27.50 WL 130 ABOVE AFT CARGO DOOR TRACK. REPAIRED BULKHEAD IAW REO 601R-53-61-1541.
- [SDR COMA2010040950093](https://openairdocs.org/sdr/COMA2010040950093.md): Bulkhead · cracked · Apr 9, 2010 · N819CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > CRACK ON BULKHEAD AT FS 621 ABOVE LINTEL. REPAIRED BULKHEAD IAW REO 601R-53-61-1230 AND EA 10-5361-02923.
- [SDR COMA2010040950092](https://openairdocs.org/sdr/COMA2010040950092.md): Angle · cracked · Apr 8, 2010 · N819CA · Cndair CL6002B19 · Cargo/Baggage Doors
  > ANGLE CRACKED IN RADIUS ON AFT CARGO DOOR BEAM MEMBER AT FS 621.00. REPLACED AFT CARGO DOOR BEAM ANGLE AT FS 621.00 IAW CRJ SRM 51-42-06.
- [SDR COMA2010040750087](https://openairdocs.org/sdr/COMA2010040750087.md): Post · cracked · Apr 7, 2010 · N819CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > VERTICAL POST AT FS 409+128, RBL 27 CRACKED AT LOWER I/B CORNER. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLER IAW REO 601R-53-41-056, REV E.
- [SDR COMA2010040750086](https://openairdocs.org/sdr/COMA2010040750086.md): Post · cracked · Apr 7, 2010 · N819CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FS 409.00 + 128 POST IS CRACKED AT LBL 27.00 INBOARD CORNER. REMOVED DAMAGED AREA AT FS 409 + 128 POST LBL 27.00 INBOARD SIDE AND APPLIED REPAIR PARTS IAW REO601R-53-41-056.
- [SDR COMA2010040750085](https://openairdocs.org/sdr/COMA2010040750085.md): Bracket · cracked · Apr 6, 2010 · N819CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > OUTBOARD BRACKET CRACKED AT RBL 9.0, FS 280.00. REMOVED AND REPLACED BRACKET AT RBL 9.0, FS 280.00 IAW CRJ SRM 51-42-21.
- [SDR COMA2010040550084](https://openairdocs.org/sdr/COMA2010040550084.md): Door Frame · cracked · Apr 5, 2010 · N819CA · Cndair CL6002B19 · Fuselage Main, Structure
  > CARGO DOOR FRAME 605.00 (P/N 601R35027-31) IS CRACKED. REPLACED DISCREPANT FRAME SECTION IAW SRM 51-42-06.
- [SDR COMA2009060150146](https://openairdocs.org/sdr/COMA2009060150146.md): Wire Harness · shorted · May 29, 2009 · N819CA · Cndair CL6002B19 · Landing Gear System Wiring
  > ON LANDING AT 110 KNOTS NWS JERKED TO THE LEFT, ON TAXI IN NWS VEERED LEFT AND RIGHT ON ITS OWN. REMOVED AND REPLACED NWS WIRE HARNESS.
- [SDR COMA2009033150107](https://openairdocs.org/sdr/COMA2009033150107.md): Angle · cracked · Mar 30, 2009 · N819CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > RIGHT FS 559 SEMI PRESSURE BULKHEAD CAP ANGLE CRACKED AT RBL 18. CUT OUT CRACKED SECTION OF CAP ANGLE, INSTALLED NEW CAP ANGLE SECTION WITH SPLICE PLATES AND DOUBLERS PER REO 601R-53-41-260 REV C AND 601R-53-41-905.
- [SDR COMA2009033150106](https://openairdocs.org/sdr/COMA2009033150106.md): Angle · cracked · Mar 30, 2009 · N819CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > LEFT FS 559 SEMI PRESSURE BULKHEAD CAP ANGLE CRACKED AT LBL 18. CUT OUT CRACKED SECTION OF CAP ANGLE, INSTALLED NEW CAP ANGLE SECTION WITH SPLICE PLATES AND DOUBLERS PER REO 601R-53-41-260 REV C.
- [SDR COMA2009033050105](https://openairdocs.org/sdr/COMA2009033050105.md): Bulkhead · cracked · Mar 24, 2009 · N819CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > FWD PRESSURE BULKHEAD CRACKED AROUND PARKING BRAKE CABLE HOLE. REPAIRED PER EA 10-5311-02555.
- [SDR COMA2009021650080](https://openairdocs.org/sdr/COMA2009021650080.md): Hydraulic Line · leaking · Feb 15, 2009 · N819CA · Cndair CL6002B19 · Hydraulic System, Main
  > ON CLIMBOUT FROM RDU RECEIVED, NR 1 HYDRAULIC SYSTEM EDP CAUTION, LOW PRESS CAUTION AND QUANTITY READING ZERO. A/C RETURNED TO RDU LANDED SAFELY. REMOVED AND REPLACED NR 1 HYDRAULIC SYSTEM PRESS LINE FOR NR 1 EDP.
- [SDR COMA2008120150011](https://openairdocs.org/sdr/COMA2008120150011.md): Selector Valve · failed · Nov 26, 2008 · N819CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > RECEIVED GEAR DISAGREE MSG, NOSE GEAR DID NOT LOCK DOWN. EMERGENCY DECLARED, QRH FOLLOWED. A/C LANDED SAFELY. REMOVED AND REPLACED NLG SELECTOR VALVE.
- [SDR COMA0860415](https://openairdocs.org/sdr/COMA0860415.md): Battery Pack · discharged · Oct 11, 2008 · N819CA · Cndair CL6002B19 · Emergency Lighting
  > EMERGENCY FLOOR LIGHTING INOP FROM ROW 9 AFT. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY PACK NR 4.
- [SDR COMA086360](https://openairdocs.org/sdr/COMA086360.md): Flap System · failed · Aug 19, 2008 · N819CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > ON APPROACH IN JAX, RECEIVED FLAPS FAIL CAUTION MSG AT 30 DEG. CREW DECLARED AN EMERGENCY, LANDED SAFELY. COMPLIED WITH TASK CARD SI-2-2710001, FLAPS FAIL FIRST EVENT MAINTENANCE ACTION. (S)
- [SDR COMA0860204](https://openairdocs.org/sdr/COMA0860204.md): Bpsu · failed · Mar 31, 2008 · N819CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5485 - FLAPS FAILED AT 0 DEGREES WHEN SELECTED TO 8 DEGREES DURING APPROACH. EMERGENCY DECLARED, AIRCRAFT LANDED SAFELY IN BGR. REMOVED AND REPLACED LT BPSU. ALSO COMPLIED WITH TASK CARD SI-2-27I0002, FLAPS FAIL CAUTION MESSAGE FOLLOW-UP MAINTENANCE
- [SDR COMA0860153](https://openairdocs.org/sdr/COMA0860153.md): Web · corroded · Mar 1, 2008 · N819CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CORROSION FOUND ON WEB WHERE IT FASTENS TO COCKPIT FLOORBOARD TOP SUPPORT ANGLE AT FS 280.00 BETWEEN LBL 9 AND RBL 9. REPAIRED COCKPIT THRESHOLD AT FS 280 USING EA 10-5310-02103 AND REO 601R-53-11-1355.
- [SDR COMA0860152](https://openairdocs.org/sdr/COMA0860152.md): Beam · cracked · Mar 1, 2008 · N819CA · Cndair CL6002B19 · Fuselage, Powerplant Attach Fittings
  > ENGINE BEAM UPPER CENTER SKIN IS CRACKED ON AFT SIDE FS 640 BETWEEN RBL 0 AND RBL 9 AT FIRE LOOP FASTENER HOLE. REPAIRED UPPER ENGINE BEAM CENTER SKIN WITH A PERMANENT REPAIR PER REO 601R-53-61-345 REV F.
- [SDR COMA0760606](https://openairdocs.org/sdr/COMA0760606.md): Bypass Valve · faulty · Oct 2, 2007 · N819CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > FLIGHT 5604 - NOSE LANDING GEAR DID NOT EXTEND. FOLLOWED QRH, GEAR EXTENDED, LANDED WITHOUT INCIDENT. REPLACED NLG RUNAROUND BYPASS VALVE. NO FURTHER DEFECTS.
- [SDR COMA0760591](https://openairdocs.org/sdr/COMA0760591.md): Priority Valve · faulty · Oct 2, 2007 · N819CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > FLIGHT 5604 - NOSE LANDING GEAR DID NOT EXTEND. FOLLOWED QRH, GEAR EXTENDED, LANDED WITHOUT INCIDENT. REPLACED MLG PRIORITY VALVE. NO FURTHER DEFECTS.
- [SDR COMA0760590](https://openairdocs.org/sdr/COMA0760590.md): Priority Valve · faulty · Oct 2, 2007 · N819CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > FLIGHT 5604 - NOSE LANDING GEAR DID NOT EXTEND. FOLLOWED QRH, GEAR EXTENDED, LANDED WITHOUT INCIDENT. REPLACED NLG PRIORITY VALVE. NO FURTHER DEFECTS.
- [SDR COMA0760592](https://openairdocs.org/sdr/COMA0760592.md): Pump · faulty · Oct 1, 2007 · N819CA · Cndair CL6002B19 · Hydraulic Pump (Electric/Engine), Main
  > FLIGHT 5054 - NOSE GEAR DISAGREE MESSAGE ON APPROACH. QRH COMPLIED WITH, AIRCRAFT LANDED SAFELY. FOUND HYD SYSTEM NR 3 3A ACMP TO HAVE LOW PRESSURE. REMOVED AND REPLACED HYD SYSTEM NR 3, 3A ACMP.
- [SDR COMA0760583](https://openairdocs.org/sdr/COMA0760583.md): Selector Valve · faulty · Sep 23, 2007 · N819CA · Cndair CL6002B19 · Landing Gear Selector
  > FLIGHT 5452 - RECEIVED NOSE GEAR DISAGREE ON EXTENSION. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED NLG SELECTOR VALVE. NO FURTHER DEFECTS.
- [SDR COMA0760416](https://openairdocs.org/sdr/COMA0760416.md): Thermocouple · faulty · May 31, 2007 · N819CA · Cndair CL6002B19 · Engine EGT/TIT Indicating System
  > FLIGHT 5400 - ABORTED TAKEOFF FOR RAPID ITT RISE ON NR 1 ENGINE. ITT NOTED AT 900 DEGREES+. INTERROGATED MDC, NO ENGINE EXCEEDENCE LOGGED. REMOVED AND REPLACED LEFT ENGINE OUTER THERMOCOUPLE.
- [SDR COMA0760013](https://openairdocs.org/sdr/COMA0760013.md): Fire Bottle · faulty · Jan 8, 2007 · N819CA · Cndair CL6002B19 · Extinguishing System
  > FLIGHT 5025 - DURING CRUISE AT FL 290, CARGO BOTTLE LOW CAUTION MESSAGE. REMOVED AND REPLACED CARGO BOTTLE.
- [SDR COMA0660594](https://openairdocs.org/sdr/COMA0660594.md): Pitot Line · contaminated · Oct 30, 2006 · N819CA · Cndair CL6002B19 · Pitot/Static System
  > FLIGHT 9495 - EFIS COMP MON AIRSPEED SPLIT ON TAKEOFF, ABORTED TAKEOFF AND RETURNED TO GATE. FOUND MOISTURE IN NR 1, 2, 3 PITOT DRAINS. PURGED DRAIN LINES, OPS CHECK GOOD.
- [SDR COMA0660592](https://openairdocs.org/sdr/COMA0660592.md): Pitot Line · contaminated · Oct 29, 2006 · N819CA · Cndair CL6002B19 · Pitot/Static System
  > FLIGHT 9495 - AIRSPEED EFIS COMP MON ON TAKEOFF. ABORTED TAKEOFF. FOUND MOISTURE IN NR 1, 2, 3 PITOT DRAINS. PURGED MOISTURE FROM DRAINS, OPS CHECK GOOD.
- [SDR COMA0660528](https://openairdocs.org/sdr/COMA0660528.md): Wire Harness · faulty · Aug 28, 2006 · N819CA · Cndair CL6002B19 · Landing Gear System Wiring
  > FLIGHT 5612 - RECEIVED AN ANTI-SKID MESSAGE DURING TAKEOFF ROLL AT CVG. CREW DECLARED AN EMERGENCY AND RETURNED TO THE GATE. REPLACED THE RIGHT MLG OUTBOARD WIRING HARNESS.
- [SDR COMA0660330](https://openairdocs.org/sdr/COMA0660330.md): B-Nut · leaking · May 4, 2006 · N819CA · Cndair CL6002B19 · Turbine Engine Oil System
  > FLIGHT 5065 - DURING CLIMBOUT OF CVG RECEIVED A LEFT ENGINE LOW OIL PRESSURE INDICATION AS AIRCRAFT ACCELERATED THROUGH 10,000 FT. CREW DECLARED AN EMERGENCY, PERFORMED AN IFSD AND RETURNED TO THE FIELD. FLIGHT LANDED WITHOUT INCIDENT. TIGHTENED LEAKING B-N
- [SDR COMA0660262](https://openairdocs.org/sdr/COMA0660262.md): Pseu · faulty · Mar 17, 2006 · N819CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > FLIGHT 4969 - EN ROUTE PHL-IND RECEIVED A NLG DOOR WARNING MESSAGE FOLLOWED BY A LOUD BANG, CREW DECLARED AN EMERGENCY AND DIVERTED TO PHL. REPLACED THE PROXIMITY SENSING ELECTRONIC UNIT.
- [SDR COMA0660261](https://openairdocs.org/sdr/COMA0660261.md): Lever · faulty · Mar 17, 2006 · N819CA · Cndair CL6002B19 · Landing Gear Selector
  > FLIGHT 4969 - EN ROUTE PHL-IND RECEIVED A NLG DOOR WARNING MESSAGE FOLLOWED BY A LOUD BANG, CREW DECLARED AN EMERGENCY AND DIVERTED TO PHL. REPLACED THE LANDING GEAR CONTROL ASSEMBLY.
- [SDR COMAO660257](https://openairdocs.org/sdr/COMAO660257.md): Proximity Sensor · malfunctioned · Mar 15, 2006 · N819CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > FLIGHT 5578 - EN ROUTE BNA-JFK RECEIVED A NOSE DOOR WARNING FOLLOWED BY INTERMITTENT GEAR DISAGREE, CREW DECLARED AN EMERGENCY, DIVERTED TO GSO, PERFORMED TOWER FLY-BY TO CONFIRM GEAR DOWN. FLIGHT LANDED WITHOUT INCIDENT. ADJUSTED THE NOSE GEAR DOOR PROXIMIT
- [SDR COMA0660250](https://openairdocs.org/sdr/COMA0660250.md): Actuator · faulty · Mar 14, 2006 · N819CA · Cndair CL6002B19 · Landing Gear Door Actuator
  > FLIGHT 5395 - DURING CLIMBOUT OF CVG RECEIVED A NOSE GEAR DOOR WARNING MESSAGE, FLIGHT DIVERTED TO CRW. REPLACED THE NOSE LANDING GEAR DOOR ACTUATOR.
- [SDR COMA0560632](https://openairdocs.org/sdr/COMA0560632.md): Ecu · malfunctioned · Nov 22, 2005 · N819CA · Cndair CL6002B19 · Steering Unit
  > FLIGHT 5256 - DURING CRUISE FLIGHT, RECEIVED A STEERING INOPERATIVE MESSAGE, CREW DECLARED AN EMERGENCY AND FLIGHT LANDED AT JFK WITHOUT INCIDENT. PERFORMED A STEERING SYSTEM RESET AND OPERATIONAL CHECK WAS SATISFACTORY.
- [SDR COMA0560520](https://openairdocs.org/sdr/COMA0560520.md): Flap System · malfunctioned · Sep 22, 2005 · N819CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5265 - FLAPS FAIL CAUTION. RESET FLAP SYSTEM AND DEFERRED MAINTENANCE PER AD 98-20-01.
- [SDR COMA0560455](https://openairdocs.org/sdr/COMA0560455.md): Window · cracked · Aug 19, 2005 · N819CA · Cndair CL6002B19 · Flight Compartment Windows
  > FLIGHT 5166 - COPILOT SIDE WINDOW CRACKED. REPLACED WINDOW.
- [SDR COMA0560447](https://openairdocs.org/sdr/COMA0560447.md): Pump · malfunctioned · Aug 15, 2005 · N819CA · Cndair CL6002B19 · Hydraulic Pump (Electric/Engine), Main
  > FLIGHT 5003 - HYDRAULIC SYSTEM 3 LOW PRESSURE CAUTION. REPLACED THE NR 3A ACMP.
- [SDR COMA0560396](https://openairdocs.org/sdr/COMA0560396.md): Coalescer Bag · dirty · Jul 16, 2005 · N819CA · Cndair CL6002B19 · Humidity Control System
  > FLIGHT 5855- BURNING SMELL IN CABIN. CND, CLEANED COALESCERS, OPERATIONAL CHECKS NORMAL.
- [SDR COMA0560380](https://openairdocs.org/sdr/COMA0560380.md): Oil Tank · overserviced · Jul 4, 2005 · N819CA · Cndair CL6002B19 · Engine Oil Storage (Airframe Furnished)
  > RECEIVED RT ENGINE HIGH OIL TEMP WARNING. CREW DECLARED EMERGENCY. PERFORMED AN I.F.S.D. AND LANDED WITHOUT INCIDENT. ENGINE OIL OVERSERVICED. REMOVED 5 QTS OF OIL. NO OTHER DEFECTS NOTED.
- [SDR COMA0560350](https://openairdocs.org/sdr/COMA0560350.md): Warning Light · illuminated · Jun 13, 2005 · N819CA · Cndair CL6002B19 · Engine Thrust Reverser
  > FLIGHT 5021 - RECEIVED A RIGHT THRUST REVERSER UNLOCK MESSAGE DURING TAKEOFF ROLL. ABORTED TAKEOFF AND RETURNED TO THE GATE. DEFERRED THE RIGHT THRUST REVERSER PER MEL 78-30-01.
- [SDR COMA0560320](https://openairdocs.org/sdr/COMA0560320.md): Warning Light · activated · May 29, 2005 · N819CA · Cndair CL6002B19 · Engine Thrust Reverser
  > RIGHT ENGINE THRUST REVERSER CAUTION DURING TAKEOFF. DEFERRED MAINTENANCE ON THRUST REVERSER I/A/W MEL.
- [SDR COMA0560273](https://openairdocs.org/sdr/COMA0560273.md): Uplock · faulty · Apr 19, 2005 · N819CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > FLIGHT 4947 DURING JFK APPROACH RECEIVED A LANDING GEAR DISAGREE, THE NLG TOOK 1 MINUTE TO INDICATE DOWN AND LOCKED. REPLACED THE NLG UPLOCK ASSEMBLY.
- [SDR COMA0560250](https://openairdocs.org/sdr/COMA0560250.md): Warning Light · illuminated · Apr 12, 2005 · N819CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > FLIGHT 5420 GEAR DISAGREE WARNING IN TURBULENCE WITH FLAPS AT -0-. SECOND ATTEMPT WITH FLAPS AT 8 DEGREES WAS NORMAL. SYSTEM OPERATION NORMAL PER AFM, NO MAINT REQUIRED.
- [SDR COMA0560131](https://openairdocs.org/sdr/COMA0560131.md): Drive Shaft · worn · Feb 16, 2005 · N819CA · Cndair CL6002B19 · Leading Edge Slat Position Indicating System
  > FLIGHT 5808 DURING CRUISE FLIGHT RECEIVED A FLAP FAIL CAUTION, CREW DECLARED AN EMERGENCY AND LANDED AT CVG WITHOUT INCIDENT. REPLACED LEFT WING FLEX DRIVE SHAFT NR 1.
- [SDR COMA0560130](https://openairdocs.org/sdr/COMA0560130.md): Drive Shaft · worn · Feb 16, 2005 · N819CA · Cndair CL6002B19 · Leading Edge Slat Control System
  > FLIGHT 5808 DURING CRUISE FLIGHT RECEIVED A FLAP FAIL CAUTION, CREW DECLARED AN EMERGENCY AND LANDED AT CVG WITHOUT INCIDENT. REPLACED LEFT WING FLEX DRIVE SHAFT NR 2.
- [SDR COMA0560129](https://openairdocs.org/sdr/COMA0560129.md): Drive Shaft · worn · Feb 16, 2005 · N819CA · Cndair CL6002B19 · Leading Edge Slat Control System
  > FLIGHT 5808 DURING CRUISE FLIGHT RECEIVED A FLAP FAIL CAUTION, CREW DECLARED AN EMERGENCY AND LANDED AT CVG WITHOUT INCIDENT. REPLACED LEFT WING FLEX DRIVE SHAFT NR 3.
- [SDR COMA0560128](https://openairdocs.org/sdr/COMA0560128.md): Drive Shaft · worn · Feb 16, 2005 · N819CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5808 DURING CRUISE FLIGHT RECEIVED A FLAP FAIL CAUTION, CREW DECLARED AN EMERGENCY AND LANDED AT CVG WITHOUT INCIDENT. REPLACED LEFT WING FLEX DRIVE SHAFT NR 5.
- [SDR COMA0460527](https://openairdocs.org/sdr/COMA0460527.md): Sensor · intermittent · Sep 1, 2004 · N819CA · Cndair CL6002B19 · Engine RPM Indicating System
  > LT ENGINE N1 FLUCTUATING BETWEEN 80 AND 86 PERCENT. COULD NOT DUPLICATE. CLEANED T2 SENSOR WIRING CONNECTOR. OPERATIONAL CHECK NORMAL.
- [SDR COMA0460526](https://openairdocs.org/sdr/COMA0460526.md): Engine · malfunctioned · Aug 31, 2004 · N819CA · Cndair CL6002B19 · Engine (Turbine/Turboprop)
  > LT ENGINE N1 DROPPED 5 PERCENT DURING T/O. COULD NOT DUPLICATE. FOUND NO DEFECTS, OPERATIONAL CHECK NORMAL.

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

This list as a web page: https://openairdocs.org/deregistered/N819CA-2013-06-11/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.