# Service difficulty reports: N933CA, cancelled Aug 16, 2012

A list on [N933CA, cancelled Aug 16, 2012](https://openairdocs.org/deregistered/N933CA-2012-08-16.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 COMA2010082450179](https://openairdocs.org/sdr/COMA2010082450179.md): Bpsu · faulty · Aug 21, 2010 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > ON APPROACH INTO CVG RECEIVED FLAPS FAIL CAUTION MSG. EMERGENCY DECLARED, A/C LANDED SAFELY. REMOVED AND REPLACED LEFT BPSU.
- [SDR COMA2010081650174](https://openairdocs.org/sdr/COMA2010081650174.md): Anti-Skid Sys · malfunctioned · Aug 13, 2010 · N933CA · Cndair CL6002B19 · Brake Anti-Skid Section
  > RECEIVED ANTI-SKID I/B CAUTION MSG ON GEAR EXTENSION. EMERGENCY DECLARED, A/C LANDED SAFELY. PERFORMED ANTI-SKID TEST PER AMM, OPS CHECK GOOD.
- [SDR COMA2010062550134](https://openairdocs.org/sdr/COMA2010062550134.md): Skin · dented · Jun 25, 2010 · N933CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > FOUND DENT IN FUSELAGE SKIN AT FS 584.75 STR 21R. REPAIRED FUSELAGE SKIN AT FS 584.75 STR 21R IAW EA 10-5360-02904A.
- [SDR COMA2009050450124](https://openairdocs.org/sdr/COMA2009050450124.md): Hydraulic Line · leaking · Apr 29, 2009 · N933CA · Cndair CL6002B19 · Hydraulic System, Main
  > EN ROUTE FROM CVG TO CID RECEIVED HYD 1 LOW MSG, 0 QTY AND PSI. EMERGENCY DECLARED, A/C DIVERTED TO MLI LANDED SAFELY. REMOVED AND REPLACED HYDRAULIC SYSTEM 1 RETURN LINE IN PYLON.
- [SDR COMA2009040750111](https://openairdocs.org/sdr/COMA2009040750111.md): Anti-Ice Valve · failed · Apr 6, 2009 · N933CA · Cndair CL6002B19 · Air Intake Anti/De-Ice System
  > EN ROUTE FROM CVG TO EWR RECEIVED LEFT COWL ANTI-ICE CAUTION MSG, WITH COWL ANTI-ICE SWITCHED OFF. EMERGENCY DECLARED, A/C DIVERTED TO PIT LANDED SAFELY. REMOVED AND REPLACED LEFT NOSE COWL ANTI-ICE VALVE.
- [SDR COMA0860417](https://openairdocs.org/sdr/COMA0860417.md): Frame · cracked · Oct 11, 2008 · N933CA · Cndair CL6002B19 · Fuselage Main, Frame
  > DURING 640 FRAME INSPECTION FOUND FRAME CRACKED AT STRINGER 9 RT CUTOUT. REPAIRED 640 FRAME PER REO 601R-53-61-557.
- [SDR COMA0860416](https://openairdocs.org/sdr/COMA0860416.md): Frame · cracked · Oct 11, 2008 · N933CA · Cndair CL6002B19 · Fuselage Main, Frame
  > DURING 640 FRAME INSPECTION FOUND FRAME CRACKED AT STRINGER 9 LT CUTOUT. REPAIRED 640 FRAME PER REO 601R-53-61-557.
- [SDR COMA0860194](https://openairdocs.org/sdr/COMA0860194.md): Controller · malfunctioned · Mar 24, 2008 · N933CA · Cndair CL6002B19 · Pitot/Static Anti-Ice System
  > FLIGHT 5501 - RECEIVED TAT PROBE HEAT, RIGHT AOA HEAT, RIGHT STATIC HEAT AND RIGHT PITOT HEAT CAUTION MESSAGES. RESET NR 2 ADS CONTROLLER. NO FURTHER DEFECTS.
- [SDR COMA0860167](https://openairdocs.org/sdr/COMA0860167.md): Sealant · missing · Mar 10, 2008 · N933CA · Cndair CL6002B19 · Aerodynamic Fairings
  > FLIGHT 5451 - UPON FLAP SELECTION TO 8 DEGREES A THUMPING WAS FELT. ABORTED APPROACH, DECLARED EMERGENCY, TOWER VERIFIED GEAR DOWN UPON SELECTION. LANDED WITHOUT INCIDENT. REPLACED MISSING SEALANT TO BELLY AND WING ROOT FAIRINGS. NO FURTHER DEFECTS.
- [SDR COMA0860160](https://openairdocs.org/sdr/COMA0860160.md): Priority Valve · faulty · Mar 6, 2008 · N933CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > FLIGHT 5236 - RECEIVED GEAR DISAGREE WARNING. RAN QRH, LOWERED GEAR MANUALLY, DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED NLG PRIORITY VALVE. NO FURTHER DEFECTS.
- [SDR COMA0860043](https://openairdocs.org/sdr/COMA0860043.md): Flap · malfunctioned · Jan 2, 2008 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5560 - FLAPS FAIL CAUTION MESSAGE DURING APPROACH TO BTV. AIRCRAFT DIVERTED BACK TO JFK AND LANDED SAFELY. COMPLIED WITH TASK CARD SI-2-27I001, FLAPS FAIL FIRST EVENT MAINTENANCE ACTION.
- [SDR COMA0760672](https://openairdocs.org/sdr/COMA0760672.md): Flap · malfunctioned · Nov 26, 2007 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5239 - DURING TAXI OUT FLAPS FAIL CAUTION MESSAGE ILLUMINATED. AIRCRAFT RETURNED BACK TO GATE. 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 F
- [SDR COMA0760612](https://openairdocs.org/sdr/COMA0760612.md): Lamp · inoperative · Oct 25, 2007 · N933CA · Cndair CL6002B19 · Emergency Lighting
  > FLIGHT 4989 - EMERGENCY LIGHT INOP AT PAX DOOR. RELAMPED INOP EMERGENCY LIGHT. NO FURTHER DEFECTS.
- [SDR COMA0760567](https://openairdocs.org/sdr/COMA0760567.md): Flap · malfunctioned · Sep 11, 2007 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5459 - FLAP FAIL CAUTION MESSAGE RECEIVED. DECLARED EMERGENCY AND 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 FLAP
- [SDR COMA0760523](https://openairdocs.org/sdr/COMA0760523.md): Flap · malfunctioned · Aug 9, 2007 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5419 - RECEIVED FLAP FAIL MESSAGE AT GATE. 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 COMA0760226](https://openairdocs.org/sdr/COMA0760226.md): Flap System · malfunctioned · Mar 5, 2007 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5559 - FLAPS FAIL AT GATE. 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 COMA0760180](https://openairdocs.org/sdr/COMA0760180.md): Sensor · faulty · Feb 12, 2007 · N933CA · Cndair CL6002B19 · Air Distribution System
  > FLIGHT 5542 - DISPLAY COOK CAUTION MESSAGE RECEIVED. INSPECTED DUCTING, CLEANED FLOW SENSOR CONNECTOR, REPLACED FLOW SENSOR. NO FURTHER DEFECTS.
- [SDR COMA0660700](https://openairdocs.org/sdr/COMA0660700.md): Strut · underserviced · Dec 8, 2006 · N933CA · Cndair CL6002B19 · Main Landing Gear Strut/Axle/Truck
  > AFTER TAKE-OFF AT APPROXIMATELY 145 KTS, GEAR DISAGREE MESSAGE ILLUMINATED, NOSE GEAR HAD RED HASH MARKS AND AFTER 10 SECONDS NOSE GEAR RETRACTED. AIRCRAFT RETURNED AND LANDED SAFELY. INSPECTED AIRCRAFT AND FOUND NOSE STRUT DID NOT FULLY EXTEND DURING JACKIN
- [SDR COMA0660640](https://openairdocs.org/sdr/COMA0660640.md): Flap System · malfunctioned · Nov 18, 2006 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5585 - DURING POWER UP RECEIVED A FLAP FAIL 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 COMA0660613](https://openairdocs.org/sdr/COMA0660613.md): Warning Message · illuminated · Nov 4, 2006 · N933CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5363- RECEIVED A FLAP FAIL CAUTION MESSAGE WHILE AT THE GATE WITH FLAP SETTING AT 20 DEGREES. 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 COMA0660461](https://openairdocs.org/sdr/COMA0660461.md): Reservoir · unknown · Jul 24, 2006 · N933CA · Cndair CL6002B19 · Engine Oil Storage (Airframe Furnished)
  > FLIGHT 5699 - EN ROUTE CVG-CHA EXPERIENCED HIGH OIL TEMPERATURE, FLIGHT RETURNED TO CVG. DEFERRED THE ENGINE OIL REPLENISHMENT SYSTEM PER MEL 79-12-01.
- [SDR COMA0660309](https://openairdocs.org/sdr/COMA0660309.md): Idg · faulty · Apr 22, 2006 · N933CA · Cndair CL6002B19 · DC Generating System
  > FLIGHT 5103 - DURING TAKEOFF ROLL RECEIVED A NR 2 IDG CAUTION MESSAGE, TAKEOFF WAS ABORTED AND FLIGHT RETURNED TO THE GATE. REPLACED THE RIGHT IDG.
- [SDR COMA0560276](https://openairdocs.org/sdr/COMA0560276.md): Skin Panel · cracked · Apr 26, 2005 · N933CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > DURING COMPLIANCE OF AN H-6 CHECK, ONE CRACK WAS FOUND IN THE PRESSURE FLOOR SKIN NEAR FS 461 BETWEEN BL 0.0 AND RBL 9.0. THE CRACK WAS 1.5 INCHES LONG. THE PRESSURE FLOOR SKIN WAS REPAIRED IN ACCORDANCE WTIH REO 601R-53-41-102 REV D DATED 9/29/03 AND REO 60
- [SDR COMA0560228](https://openairdocs.org/sdr/COMA0560228.md): Warning System · malfunctioned · Apr 3, 2005 · N933CA · Cndair CL6002B19 · Airfoil Anti/De-ice System
  > FLIGHT 5175 - DURING TAKEOFF ROLL, RECEIVED A RIGHT WING ANTI ICE CAUTION, ABORTED TAKEOFF AND RETURNED TO THE GATE. C/W RTO INSPECTION AND PERFORMED AN OPERATIONAL CHECK OF THE WING ANTI ICE SYSTEM. DISCREPANCY COULD NOT BE DUPLICATED.
- [SDR COMA0560079](https://openairdocs.org/sdr/COMA0560079.md): Drag Brace · lack of lube · Jan 22, 2005 · N933CA · Cndair CL6002B19 · Landing Gear Retraction/Extension System
  > FLIGHT 5466 GEAR DISAGREE WARNING. NLG DID NOT RETRACT. CLEANED AND LUBED NLG DRAG BRACE. RETRACTION CHECKS WERE SATISFACTORY.
- [SDR COMA0460550](https://openairdocs.org/sdr/COMA0460550.md): Warning Light · illuminated · Sep 27, 2004 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5742 FLAPS FAIL CAUTION MESSAGE. RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.
- [SDR COMA0460433](https://openairdocs.org/sdr/COMA0460433.md): Control Handle · malfunctioned · Jul 30, 2004 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5768 FLAPS FAIL CAUTION DURING LANDING ROLL. REPLACED THE FLAP SELECTOR LEVER.
- [SDR COMA0460343](https://openairdocs.org/sdr/COMA0460343.md): Warning Light · illuminated · May 28, 2004 · N933CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5463 FLAPS FAIL CAUTION MESSAGE. RESET FLAPS AND DEFERRED MAINT PER AD 98-20-01.
- [SDR COMA0460269](https://openairdocs.org/sdr/COMA0460269.md): Pseu · malfunctioned · Apr 13, 2004 · N933CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > FLIGHT 5479 NWS INOP, WOW INPUT CAUTION AND CIRCUIT BREAKER TRIPPED. RESET PSEU AND OPERATIONAL CHECK OF NWS WAS SATISFACTORY.
- [SDR COMA0360561](https://openairdocs.org/sdr/COMA0360561.md): Flap · malfunctioned · Dec 16, 2003 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLIGHT 5073 FLAPS DID NOT MOVE WHEN SELECTED TO 20 DEGREES. RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.
- [SDR COMA0360291](https://openairdocs.org/sdr/COMA0360291.md): Computer · malfunctioned · Jun 24, 2003 · N933CA · Cndair CL6002B19 · Drag Control System
  > FLIGHT 5797 SPOILER AND FLIGHT SPOILER CAUTION MESSAGE. REPLACED THE NR 2 SECU.
- [SDR COMA0360199](https://openairdocs.org/sdr/COMA0360199.md): Warning System · activated · Apr 16, 2003 · N933CA · Cndair CL6002B19 · Trailing Flap Position Indicating System
  > FLIGHT 5276 FLAPS FAIL CAUTION MESSAGE. RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.
- [SDR COMA0260611](https://openairdocs.org/sdr/COMA0260611.md): Anti-Ice System · Oct 30, 2002 · N933CA · Cndair CL6002B19 · Airfoil Anti/De-ice System
  > FLIGHT 5883 LEFT WING ANTI-ICE DUCT WARNING MESSAGE.COULD NOT DUPLICATE. INSPECTED ANTI-ICE SYSTEM - NO FAULTS FOUND.
- [SDR COMA0260130](https://openairdocs.org/sdr/COMA0260130.md): Door · Feb 27, 2002 · N933CA · Cndair CL6002B19 · Passenger/Crew Doors
  > FLIGHT 5409 CABIN DOOR OUTER HANDLE CAUTION MESSAGE.LUBRICATED DOOR LOCKING MECH. OPS CHECK SATISFACTORY.
- [SDR COMA0260068](https://openairdocs.org/sdr/COMA0260068.md): Skin · damaged · Jan 25, 2002 · N933CA · Cndair CL6002B19 · Fuselage Main, Plate/Skin
  > THE LEFT SIDE OF THE FUSELAGE WAS DAMAGED AT STA 379-394 AND STR 23L-24L. REMOVED THE DAMAGED AREA. FABRICATED REPAIR PARTS AND INSTALLED.
- [SDR COMA0260030](https://openairdocs.org/sdr/COMA0260030.md): Door · Jan 5, 2002 · N933CA · Cndair CL6002B19 · Passenger/Crew Doors
  > FLIGHT 5839 CABIN DOOR OUTER HANDLE MESSAGE.COULD NOT DUPLICATE OPERATED DOOR AND PRESSURIZED AIRCRAFT. NO DEFECTS.
- [SDR COMA0160826](https://openairdocs.org/sdr/COMA0160826.md): Bushing · worn · Oct 20, 2001 · N933CA · Cndair CL6002B19 · Horizontal Stabilizer, Attach Fittings
  > L/H VERTICAL STABILIZER BUSHING P/N 600-21061-7 IS WORN.REMOVED THE WORN BUSHING I/A/W CRJ AMM CH 20-26-00-910-802, FABRICATED NEW BUSHING P/N 601R55-31-033-1 I/A/W REO 601R-55-31-033 AND INSTALLED THE BUSHING I/A/W REO 601R-55-31-002.
- [SDR COMA0160822](https://openairdocs.org/sdr/COMA0160822.md): Doubler · cracked · Oct 17, 2001 · N933CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > FS 718.00 L/H AND R/H AFT DOUBLERS CRACKED, FRAME SECTIONS L/H UPPER AND R/H UPPER AND LOWER ARE CRACKED.F.S.718.00 L/H AND R/H AFT DOUBLERS REMOVED AND REPLACED IAW CANADAIR REO 601R-53-61-193 REV A. FRAME SECTIONS L/H UPPER AND R/H UPPER AND LOWER REMOVED AN
- [SDR COMA0160718](https://openairdocs.org/sdr/COMA0160718.md): Pcu · faulty · Sep 14, 2001 · N933CA · Cndair CL6002B19 · Drag Control System
  > FLIGHT #5395. DURING TAXI OUT WHILE PERFORMING FLIGHT CONTROL CHECK RECEIVED A FLIGHT SPOILER FAULT STATUS MESSAGE, AIRCRAFT RETURNED TO THE GATE.REPLACED THE LEFT OUTBOARD POWER CONTROL UNIT.
- [SDR COMA0160615](https://openairdocs.org/sdr/COMA0160615.md): Wire · loose · Aug 19, 2001 · N933CA · Cndair CL6002B19 · Landing Gear System Wiring
  > FLIGHT 5931. DURING TAXI OUT OF CVG RECEIVED A PROXIMITY FAULT STATUS MESSAGE ON ELECTRONIC DISPLAY NR 2, AIRCRAFT RETURNED TO THE GATE.REPAIRED WIRING AND SECURED GROUNDING STUD.
- [SDR COMA0160616](https://openairdocs.org/sdr/COMA0160616.md): Pseu · faulty · Aug 19, 2001 · N933CA · Cndair CL6002B19 · Landing Gear Position and Warning
  > FLIGHT #5776. DURING TAXI OUT OF HSV RECEIVED A PROXIMITY SYSTEM FAULT STATUS MESSAGE ON ELECTRONIC DISPLAY #2, AIRCRAFT RETURNED TO THE GATE.REPLACED THE PROXIMITY SENSING ELECTRONIC UNIT.
- [SDR COMA0160543](https://openairdocs.org/sdr/COMA0160543.md): Web · cracked · Jul 25, 2001 · N933CA · Cndair CL6002B19 · Fuselage, Powerplant Attach Fittings
  > CRACK ON ENGINE SUPPORT BEAM UPPER SKIN.REPAIRED I/A/W REO 601R-53-61-345.
- [SDR COMA0160542](https://openairdocs.org/sdr/COMA0160542.md): Web · cracked · Jul 25, 2001 · N933CA · Cndair CL6002B19 · Fuselage, Powerplant Attach Fittings
  > WHILE PERFORMING REPAIR TO THE ENGINE SUPPORT BEAM PER REO 53-61-345 A CRACK WAS NOTED ON THE UNDER LAYING EXTRUDED ANGLE P/N 601-35006-7 CRACK APPROX 5/16".THE CRACK WAS REPAIRED I/A/W CANADAIR REO 601R-53-61-394.
- [SDR COMA0160363](https://openairdocs.org/sdr/COMA0160363.md): Rib · cracked · Apr 26, 2001 · N933CA · Cndair CL6002B19 · Nacelle/Pylon, Frame/Spar/Rib
  > THE LT PYLON AT FS 605 IS CRACKED AT THE OUTBOARD LOWER FLANGE. REPAIRED DAMAGED AREA TO THE LT PYLON RIB AT FS 605 AT THE OUTBOARD LOWER FLANGE IAW WVAC EO 601R-54-2401A.
- [SDR COMA0160362](https://openairdocs.org/sdr/COMA0160362.md): Angle · cracked · Apr 24, 2001 · N933CA · Cndair CL6002B19 · Fuselage Miscellaneous Structure
  > THE ANGLES AT BL27 (LT & RT) AND INTERCOSTALS AT BL 36 (LT & RT) AT FS 484 ARE CRACKED. INSTALLED NEW SERVICEABLE LT & RT INBOARD AND OUTBOARD 484 ANGLES IAW WVAC EO 601R-53-2413A.
- [SDR COMA0160057](https://openairdocs.org/sdr/COMA0160057.md): Nozzle · departed · Jan 3, 2001 · N933CA · Cndair CL6002B19 · Engine Collector/Tailpipe/Nozzle
  > VIBRATION FELT DURING FLIGHT, VIBRATION STOPPED DURING DECENT. POST FLIGHT INSP FOUND LEFT ENGINE TAILPIPE AND EXHAUST FAIRING HAD DEPARTED ACFT.REPLACED LEFT ENGINE.
- [SDR COMA0060849](https://openairdocs.org/sdr/COMA0060849.md): Bpsu · malfunctioned · Oct 28, 2000 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLAPS FAILED AT 20 DEGREES. REPLACED THE LEFT HAND BPSU.
- [SDR COMA0060833](https://openairdocs.org/sdr/COMA0060833.md): Control Unit · malfunctioned · Oct 14, 2000 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Control System
  > FLAPS FAIL CAUTION MESSAGE. RESET FLAP SYSTEM AND DEFERRED MAINTENANCE PER AD 98-20-01.
- [SDR COMA0060462](https://openairdocs.org/sdr/COMA0060462.md): Bulb · failed · May 28, 2000 · N933CA · Cndair CL6002B19 · Emergency Lighting
  > AFT CEILING EMERGENCY LIGHT IS INOPERABLE. REPLACED LIGHT BULB.
- [SDR COMA0060410](https://openairdocs.org/sdr/COMA0060410.md): Actuator · worn · May 11, 2000 · N933CA · Cndair CL6002B19 · Trailing Edge Flap Actuator
  > FOUND LEFT OUTBOARD FLAP, INBOARD ACTUATOR HAD PLAY AT FORWARD BUSHING MOUNT. REMOVED AND REPLACED ACTUATOR WITH A SERVICEABLE ONE. AIRCRAFT RETURNED TO SERVICE.

Next page: https://openairdocs.org/deregistered/N933CA-2012-08-16/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 = 'N933CA' AND deregistration_id = 'N933CA-2012-08-16'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N933CA-2012-08-16/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.
