# Service difficulty reports: N409CA, cancelled Jun 12, 2013

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

- [SDR COMA2012061850046](https://openairdocs.org/sdr/COMA2012061850046.md): Bulkhead · cracked · Jun 7, 2012 · N409CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > AFT PRESSURE BULKHEAD AT FS 621.00 AND RBL 27.00 HAS A CRACK 32.15 INCHES UP FROM WL 72.00. COMPLIED WITH PATCH REPAIR IAW BOMBARDIER GREO 601R-53-61-1285.
- [SDR COMA2012061850045](https://openairdocs.org/sdr/COMA2012061850045.md): Frame · corroded · Jun 7, 2012 · N409CA · Cndair CL6002B19 · Fuselage Main, Frame
  > CORROSION FOUND ON FRAME ATTACH FLANGE AT FS 333.00 BETWEEN STR 26L AND 26R. FRAME SPLICE REPAIR PERFORMED IAW BOMBARDIER REO 601R-53-21-2317.
- [SDR COMA2012061850044](https://openairdocs.org/sdr/COMA2012061850044.md): Floorbeam · corroded · Jun 6, 2012 · N409CA · Cndair CL6002B19 · Fuselage Main, Floor Beam
  > CORROSION FOUND ON FLOORBEAM CAP AT FS 559.00+112-621.00, AND AT LBL 27.00. CORROSION FOUND TO BE OUT OF LIMITS IAW CRJ 200 SRM 53-61-43-01 AND 53-00-00-01. REMOVED DAMAGED FLOORBEAM CAP, AND INSTALLED NEW FLOORBEAM CAP IAW CRJ SRM 51-42-06-00 AND 51-42-21-
- [SDR COMA2012061850043](https://openairdocs.org/sdr/COMA2012061850043.md): Attach Fitting · corroded · Jun 5, 2012 · N409CA · Cndair CL6002B19 · Fuselage Main, Floor Beam
  > CORROSION FOUND ON FLOORBEAM ATTACHMENT FITTING TO THE PRESSURE BULKHEAD AT FS 621.00 AND LBL 9.0. CORROSION FOUND TO BE BEYOND LIMITS IAW CRJ 200 SRM 53-61-43-02 AND 53-00-00-01. FABRICATED FLOORBEAM ATTACHMENT FITTING IAW CRJ 200 SRM 53-61-43-00, 51-21-11,
- [SDR COMA2011100250073](https://openairdocs.org/sdr/COMA2011100250073.md): Connector · dirty · Oct 2, 2011 · N409CA · Cndair CL6002B19 · Engine Starting System Wiring
  > EN ROUTE CVG-MSP RECEIVED A "NO STARTER CUT-OUT" MESSAGE, CREW DECLARED AN EMERGENCY AND DIVERTED TO MSN. FLIGHT LANDED WITHOUT INCIDENT. CLEANED THE LT ELECTRICAL CONNECTORS FOR THE STARTER AND START VLAVE. PERFORMED 2 ENGINE STARTS WITH NO FURTHER DEFECTS
- [SDR COMA2011072250048](https://openairdocs.org/sdr/COMA2011072250048.md): Oil System · low · Jul 21, 2011 · N409CA · Cndair CL6002B19 · Turbine Engine Oil System
  > ON CLIMBOUT FROM DTW RECEIVED LOW OIL PRESSURE WARNING FOR RIGHT ENGINE. EMERGENCY DECLARED, A/C RETURNED TO DTW LANDED SAFELY. SERVICED RIGHT ENGINE WITH OIL AND PERFORMED OIL CONSUMPTION CHECK. OIL CONSUMPTION CHECK WITH IN LIMITS. PERFORMED CHIP DETECTO
- [SDR COMA2010100750216](https://openairdocs.org/sdr/COMA2010100750216.md): Bpsu · faulty · Oct 5, 2010 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > ON APPROACH INTO EWR RECEIVED FLAPS FAIL MSG. FLAPS FAILED WHEN SELECTED TO 20 DEG. EMERGENCY DECLARED, A/C LANDED SAFELY. REMOVED AND REPLACED LEFT BPSU.
- [SDR COMA2010080950170](https://openairdocs.org/sdr/COMA2010080950170.md): Bulkhead · cracked · Aug 8, 2010 · N409CA · Cndair CL6002B19 · Fuselage Main, Bulkhead
  > PRESSURE BULKHEAD WEB CRACKED ABOVE LINTEL FITTING FS 621.00. REPAIRED IN ACCORDANCE WITH REO 601R-53-61-1230 REV "D" AND REO 601R-53-61-3754.
- [SDR COMA2010080950169](https://openairdocs.org/sdr/COMA2010080950169.md): Web · cracked · Aug 7, 2010 · N409CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FS 621.00 WEB CRACKED ABOVE CARGO DOOR TRACK AT LBL 27.50. REPAIRED IAW REO 601R-53-61-1541.
- [SDR COMA2010080650167](https://openairdocs.org/sdr/COMA2010080650167.md): Floorbeam · corroded · Aug 6, 2010 · N409CA · Cndair CL6002B19 · Fuselage Main, Floor Beam
  > CORROSION FOUND ON FLOORBEAM UPPER FLANGE AT LBL 27, FS 615, AROUND NUT PLATE HOLE. REPAIRED IN ACCORDANCE WITH REO 601R-53-61-3757 DATED 2010-08-05.
- [SDR COMA2010080650168](https://openairdocs.org/sdr/COMA2010080650168.md): Door Frame · cracked · Aug 5, 2010 · N409CA · Cndair CL6002B19 · Fuselage Main, Structure
  > LOWER CARGO DOOR FS 605.00 FRAME P/N 601R35027-31 IS CRACKED. INSTALLED FRAME AS REQUIRED USING SOLID RIVETS IAW SRM 51-42-06.
- [SDR COMA2010080450166](https://openairdocs.org/sdr/COMA2010080450166.md): Angle · cracked · Aug 4, 2010 · N409CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CRACK ON CAP ANGLE AT FS 559.00 LBL 18.00. REPAIRED CAP ANGLE IAW REO 601R-53-41-260.
- [SDR COMA2010073050165](https://openairdocs.org/sdr/COMA2010073050165.md): Crossbeam · cracked · Jul 30, 2010 · N409CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CRACK ON FLOOR SUPPORT CROSSBEAM AT FS 280.00 AT LBL12.00 UPPER RADIUS. REPAIRED CROSSBEAM IAW REO 601R-53-11-171.
- [SDR COMA2010073050164](https://openairdocs.org/sdr/COMA2010073050164.md): Post · cracked · Jul 29, 2010 · N409CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CRACK ON POST AT FS 559.00 RBL 18.00 LOWER CORNER RADIUS. REPAIRED POST IAW REO 601R-53-41-067.
- [SDR COMA2010073050163](https://openairdocs.org/sdr/COMA2010073050163.md): Crossbeam · cracked · Jul 29, 2010 · N409CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CRACK ON FLOOR SUPPORT CROSSBEAM AT FS 280.00 AT RBL 12.00 UPPER RADIUS. REPAIRED CROSSBEAM IAW REO 601R-53-11-171.
- [SDR COMA2010031650061](https://openairdocs.org/sdr/COMA2010031650061.md): Connector · dirty · Mar 14, 2010 · N409CA · Cndair CL6002B19 · Ice/Rain Protection System Wiring
  > EN ROUTE FROM JFK TO BUF RECEIVED LT ENG A/I COWL CAUTION MSG. QRH COMPLETED, EMERGENCY DECLARED. A/C LANDED SAFELY AT BUF. CLEANED CONNECTOR FOR COWL ANTI-ICE VALVE AND PRESSURE SWITCH. PERFORMED OPS CHECK OF COWL ANTI-ICE SYSTEM, OPS CHECK GOOD.
- [SDR COMA2010020150027](https://openairdocs.org/sdr/COMA2010020150027.md): Transmitter · failed · Jan 28, 2010 · N409CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > ON APPROACH INTO DTW RECEIVED FLAPS FAIL CAUTION MSG AT 20 DEG WITH FLAPS SELECTED TO 30 DEG. EMERGENCY DECLARED, A/C LANDED SAFELY AT DTW. REMOVED AND REPLACED LEFT FLAP POSITION TRANSMITTER.
- [SDR COMA2010010250001](https://openairdocs.org/sdr/COMA2010010250001.md): Flap · malfunctioned · Jan 2, 2010 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > RECEIVED A FLAP FAIL CAUTION DURING DTW 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 COMA2009082650189](https://openairdocs.org/sdr/COMA2009082650189.md): Selector Valve · failed · Aug 25, 2009 · N409CA · Cndair CL6002B19 · Landing Gear Door Retract Section
  > ON APPROACH INTO JFK RECEIVED GEAR DISAGREE MSG, MLG APPEARED TO NOT COME DOWN. EMERGENCY DECLARED, A/C LANDED SAFELY. REMOVED AND REPLACED MLG SELECTOR VALVE.
- [SDR COMA2009042750122](https://openairdocs.org/sdr/COMA2009042750122.md): Flap · failed · Apr 26, 2009 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > ON APPROACH INTO BOS RECEIVED FLAPS FAIL MSG, FLAPS FAILED AT 0 DEG. EMERGENCY DECLARED, A/C LANDED SAFELY. TRANSFERRED TO DEFERRED LIST PER MEL GMM 5-2.
- [SDR COMA0860112](https://openairdocs.org/sdr/COMA0860112.md): Shutoff Valve · faulty · Feb 5, 2008 · N409CA · Cndair CL6002B19 · Airfoil Anti/De-ice System
  > FLIGHT 5003 - RECEIVED RIGHT COWL ANTI-ICE CAUTION ON CLIMB, ANTI-ICE SELECTED OFF. RETURNED TO CVG, LANDED WITHOUT INCIDENT. REPLACED RT COWL PRSOV. NO FURTHER DEFECTS.
- [SDR COMA0760735](https://openairdocs.org/sdr/COMA0760735.md): Wire Harness · failed · Dec 18, 2007 · N409CA · Cndair CL6002B19 · Landing Gear System Wiring
  > FLIGHT 5512 - ANTI-SKID I/B CAUTION MESSAGE ON APPROACH INTO LGA. AIRCRAFT DIVERTED TO JFK AND LANDED SAFELY. REMOVED AND REPLACED RIGHT MAIN LANDING GEAR INBOARD WIRE HARNESS.
- [SDR COMA0760425](https://openairdocs.org/sdr/COMA0760425.md): Flap · malfunctioned · Jun 8, 2007 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 4940 - FLAPS FAIL AT 30 DEGREES ON APPROACH, 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 MESSAGES.
- [SDR COMA0760058](https://openairdocs.org/sdr/COMA0760058.md): Sensor · failed · Jan 24, 2007 · N409CA · Cndair CL6002B19 · Airfoil Anti/De-ice System
  > FLIGHT 5276 - LEFT WING ANTI-ICE CAUTION MESSAGE DURING TAKEOFF ROLL. ABORTED TAKEOFF AND RETURNED TO GATE. REMOVED AND REPLACED A LEFT WING TEMP SENSOR.
- [SDR COMA0760057](https://openairdocs.org/sdr/COMA0760057.md): Sensor · failed · Jan 24, 2007 · N409CA · Cndair CL6002B19 · Airfoil Anti/De-ice System
  > FLIGHT 5276 - LEFT WING ANTI-ICE CAUTION MESSAGE DURING TAKEOFF ROLL. ABORTED TAKEOFF AND RETURNED TO GATE. REMOVED AND REPLACED A LEFT WING TEMP SENSOR.
- [SDR COMA0660639](https://openairdocs.org/sdr/COMA0660639.md): Wire · broken · Nov 17, 2006 · N409CA · Cndair CL6002B19 · Light System Wiring
  > FLIGHT 5401 - THE EMERGENCY LIGHTING STRIP BY THE SERVICE DOOR FAILED TO ILLUMINATE. REPAIRED BROKEN WIRING ON EMERGENCY EXIT LIGHTING STRIP.
- [SDR COMA0660557](https://openairdocs.org/sdr/COMA0660557.md): Control Unit · faulty · Sep 28, 2006 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5087- FLAP FAIL AFTER LANDING, FLAPS WILL NOT MOVE FROM 45 DEGREES.PERFORMED AD 2006-12-21, FIRST EVENT PARAGRAPH (G) 1,2,3, (A,B,C) FLAP SYSTEM WAS RESET WITH NO FURTHER MESSAGES. THIS ACTION FOLLOWED IN DAY BY EO 27-046AD AND SUBSEQUENT REPLACEMENT OF
- [SDR COMA0660543](https://openairdocs.org/sdr/COMA0660543.md): Flap System · malfunctioned · Sep 15, 2006 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5135 - RECEIVED A FLAP FAIL CAUTION AFTER LANDING WHEN RETRACTING THE FLAPS. 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 COMA0660411](https://openairdocs.org/sdr/COMA0660411.md): Selector Valve · faulty · Jun 28, 2006 · N409CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > FLIGHT 5573 - EN ROUTE JFK - RDU RECEIVED A LANDING GEAR DISAGREE WARNING. REPLACED THE MAIN LANDING GEAR SELECTOR VALVE.
- [SDR COMA0660343](https://openairdocs.org/sdr/COMA0660343.md): Caution Message · activated · May 12, 2006 · N409CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5169 - FLAP FAIL CAUTION MESSAGE AT 28 DEGREES ON THE GROUND. 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 FURTHER FLAP CAUTION MESSAGES.
- [SDR COMA0660202](https://openairdocs.org/sdr/COMA0660202.md): Flap System · malfunctioned · Feb 27, 2006 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5141 - DURING SYR APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE AT 8 DEGREES. 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 FURTHER FLAP CAUTION ME
- [SDR COMA0660194](https://openairdocs.org/sdr/COMA0660194.md): Anti-Ice System · malfunctioned · Feb 26, 2006 · N409CA · Cndair CL6002B19 · Airfoil Anti/De-ice System
  > FLIGHT 5178 - DURING TAKEOFF ROLL AT BOS RECEIVED A LT WING ANTI-ICE CAUTION MESSAGE, ABORTED TAKEOFF AND RETURNED TO THE GATE. PERFORMED AN OPERATIONAL CHECK OF THE WING ANTI-ICE SYSTEM, DISCREPANCY COULD NOT BE DUPLICATED BY MAINTENANCE.
- [SDR COMA0660102](https://openairdocs.org/sdr/COMA0660102.md): Flap System · malfunctioned · Jan 26, 2006 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5251- RECEIVED A FLAP FAIL CAUTION MESSAGE DURING JFK APPROACH, 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 AND E). FLAP SY
- [SDR COMA0560805](https://openairdocs.org/sdr/COMA0560805.md): Drive Shaft · lack of lube · Jan 7, 2006 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5189 - FLAPS FAIL CAUTION. CLEANED AND LUBRICATED FLEX DRIVE SHAFTS AND INSPECTED PER AD 98-20-01.
- [SDR COMA0560799](https://openairdocs.org/sdr/COMA0560799.md): Warning Light · illuminated · Jan 5, 2006 · N409CA · Cndair CL6002B19 · Drag Control System
  > FLIGHT 5718 - FOUND SPOILERON CAUTION MESSAGE. RESET SECU'S SYSTEM CHECK NORMAL.
- [SDR COMA0560736](https://openairdocs.org/sdr/COMA0560736.md): Overheat Sensor · malfunctioned · Dec 18, 2005 · N409CA · Cndair CL6002B19 · Airfoil Anti/De-ice System
  > FLIGHT 5021 - WING ANTI-ICE WARNING. REPLACED THE LT WING ANTI-ICE OVERHEAT SWITCH.
- [SDR COMA0560535](https://openairdocs.org/sdr/COMA0560535.md): Warning Light · illuminated · Oct 5, 2005 · N409CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > FLIGHT 5355 - NWS INOP CAUTION DURING GEAR EXTENSION. CND, PERFORMED OPERATIONAL CHECK OF NWS SYSTEM, FOUND NO FAULTS.
- [SDR COMA0560507](https://openairdocs.org/sdr/COMA0560507.md): Flap System · malfunctioned · Sep 18, 2005 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 4991- DURING LANDING RECEIVED A FLAP FAIL CAUTION MESSAGE AT 8 DEGREE FLAP POSITION SETTING. COMPLIED WITH AS 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 FURTHER FLA
- [SDR COMA0560499](https://openairdocs.org/sdr/COMA0560499.md): Latch · unsecure · Sep 13, 2005 · N409CA · Cndair CL6002B19 · Passenger/Crew Doors
  > FLIGHT 5856 - RECEIVED A CABIN DOOR HANDLE CAUTION MESSAGE DURING CLIMBOUT OF SAT. FLIGHT RETURNED TO SAT. FOUND THE OUTER CABIN DOOR HANDLE NOT FULLY STOWED, OPERATIONAL CHECK INDICATED NO DISCREPANCIES.
- [SDR COMA0560438](https://openairdocs.org/sdr/COMA0560438.md): Warning Light · activated · Aug 10, 2005 · N409CA · Cndair CL6002B19 · Engine Thrust Reverser
  > FLIGHT 5243 - RT THRUST REVERSER UNLOCKED MESSAGE. CND FOUND NO DEFECTS WITH RT THRUST REVERSER.
- [SDR COMA0560387](https://openairdocs.org/sdr/COMA0560387.md): Proximity Switch · unreliable · Jul 9, 2005 · N409CA · Cndair CL6002B19 · Door Warning System
  > FLIGHT 5611 - CABIN DOOR OUTER HANDLE CAUTION. REPLACED HANDLE PROXIMITY SENSOR.
- [SDR COMA0560252](https://openairdocs.org/sdr/COMA0560252.md): Warning Light · illuminated · Apr 11, 2005 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5811 FLAPS FAIL CAUTION. INSPECTED FLAP SYSTEM IAW AD 98-20-01. NO DEFECTS FOUND. COULD NOT DUPLICATE.
- [SDR COMA0560034](https://openairdocs.org/sdr/COMA0560034.md): Door · noisy · Jan 8, 2005 · N409CA · Cndair CL6002B19 · Service Doors
  > FLIGHT 5119 EXTREMELY LOUD NOISE FROM NOSE AREA OF AIRCRAFT. FOUND 02 SERVICE DOOR OPEN. INSPECTED DOOR, NO DEFECTS.
- [SDR COMA0560007](https://openairdocs.org/sdr/COMA0560007.md): Warning System · malfunctioned · Dec 21, 2004 · N409CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 4958, FLAPS FAIL CAUTION. COULD NOT DUPLICATE. C/W ALL REQUIRED MAINTENANCE PER AD 98-20-01. NO DEFECTS FOUND.
- [SDR COMA0460530](https://openairdocs.org/sdr/COMA0460530.md): Control System · inoperative · Sep 14, 2004 · N409CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5502 FLAPS FAIL CAUTION MESSAGE. RESET FLAP SYSTEM AND DEFERRED MAINT. IAW AD 98-20-01.
- [SDR COMA0460455](https://openairdocs.org/sdr/COMA0460455.md): Sill · cracked · Aug 13, 2004 · N409CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > CARGO LANDING CRACKED AT THRESHOLD FWD STOP, UNDER STOP ADJACENT TO HI-LITE. REPAIRED IAW REO 601R-53-61-690.
- [SDR COMA0460453](https://openairdocs.org/sdr/COMA0460453.md): Angle · cracked · Aug 13, 2004 · N409CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > RIGHT HAND ANGLE CRACKED. REPAIRED IAW REO 601R-53-61-004 REV B.
- [SDR COMA0460452](https://openairdocs.org/sdr/COMA0460452.md): Angle · cracked · Aug 13, 2004 · N409CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > LEFT HAND ANGLE CRACKED, IAW REO 601R-53-61-004 REV B.
- [SDR COMA0460082](https://openairdocs.org/sdr/COMA0460082.md): Bolt · out of adjust · Jan 23, 2004 · N409CA · Cndair CL6002B19 · Passenger/Crew Doors
  > FLIGHT 5103 CABIN DOOR OUTER HANDLE CAUTION. ADJUSTED INNER HANDLE STOP BOLT.
- [SDR COMA0460023](https://openairdocs.org/sdr/COMA0460023.md): Warning Light · illuminated · Jan 6, 2004 · N409CA · Cndair CL6002B19 · Door Warning System
  > FLIGHT 5222 CABIN DOOR WARNING DURING FLIGHT. COULD NOT DUPLICATE. INSPECTED DOOR AND FOUND NO DEFECTS.

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

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