N929CA, cancelled Nov 4, 2013
Service difficulty reports · 120
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "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 = 'N929CA' AND deregistration_id = 'N929CA-2013-11-04' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 = 'N929CA' AND deregistration_id = 'N929CA-2013-11-04' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR COMA2009082650188Selector Valve · failedON CLIMBOUT FROM JFK RECEIVED NOSE DOOR WARNING MSG. EMERGENCY DECLARED, A/C RETURNED TO JFK LANDED SAFELY. REMOVED AND REPLACED NLG DOOR SELECTOR VALVE.SDR COMA2009060150149Frame · crackedLEFT FS 640.00 FRAME, REINFORCING DOUBLER AND BONDED SKIN DOUBLER ARE CRACKED BETWEEN STR 9 AND 13. REMOVED DAMAGED PARTS AND COMPLIED WITH MODIFICATION K601R36009-3 ON LT FS 640.00 FRAME AND DOUBLER PER REO 601R-53-61-3184 REV A. S/B601R-53-061 KIT DRWG K60SDR COMA2009060150148Skin · crackedPERMANENT REPAIR NEEDS PERFORMED TO REPLACE TEMP REPAIR THAT WAS DONE AT FS 559.00 WEB BETWEEN RBL 9-18. REMOVED TEMP REPAIR AND INSTALLED A PERMANENT REPAIR ON FS 559 BULKHEAD WEB BETWEEN RBL 9 AND RBL 18 PER CRJ TASKCARD: SMA-2-53R0002 SECTION 2.SDR COMA2009012050065Battery Pack · failedEMERGENCY LIGHTS INOP. R&R EMERGENCY LIGHT BATTERY PACK NR 2.SDR COMA0860009Battery · faultyFLIGHT 5300 - RECEIVED INTERMITTENT BATTERY BUSS CAUTION MESSAGE. DIVERTED TO MCO, LANDED WITHOUT INCIDENT. REPLACED MAIN BATTERY. NO FURTHER DEFECTS.SDR COMA0760464Wire Harness · damagedFLIGHT 5300 - ABORTED TAKEOFF APPROX 105 - 110 KTS DUE TO ANTI-SKID CAUTION MESSAGE. REPLACED LEFT OUTBOARD LOWER MLG HARNESS ASSEMBLY. NO FURTHER DEFECTS.SDR COMAO760371Floorbeam · crackedDURING HMV7 INSPECTION FOUND FLOOR SUPPORT CHANNEL CRACKED AT LEFT CORNER FS 295, LBL 10. INSTALLED NEW P/N 600-34017-351 CHANNEL IAW SRM 51-42-06.SDR COMA0760370Bulkhead · crackedDURING HMV7 INSPECTION FOUND REAR PRESSURE BULKHEAD CRACKED AROUND LINTEL FITTING. REMOVE DAMAGE AND INSTALLED DOUBLER PER BOMBARDIER REO 601R-53-61-2168 AND REO 301R-53-61-1230.SDR COMA0760369Post · crackedDURING HMV7 INSPECTION FOUND BULKHEAD POST LOWER END CRACKED, FS 559, RBL 9. REMOVED DAMAGE AND INSTALLED DOUBLER PER BOMBARDIER REO 601R-53-41-057.SDR COMA0760377Angle · crackedCRACK AT RIGHT SIDE FS 574.00 BETWEEN STRINGERS 6 AND 7. REPLACED SPLICE ANGLE IAW SRM 51-42-06.SDR COMA0760376Stiffener · crackedFLIGHT 5320 - CRACK ON RBL 9.0 O/B RADIUS OF VERTICAL STIFFENER AT FS 559.00. REPAIRED CRACK ON RBL 9.0 O/B RADIUS OF VERTICAL STIFFENER IAW REO 601R-53-41-057.SDR COMA0760366Bulkhead · crackedTWO CRACKS VERIFIED WITH EDDY CURRENT ON SEMI-PRESSURE BULKHEAD AT FS 559 BETWEEN RBL 9 AND RBL 18. REPAIRED SEMI-PRESSURE BULKHEAD AT FS 559 AS PER REO 601R-53-41-353.SDR COMA0760352Selector Valve · faultyFLIGHT 9461- GEAR DISAGREE WARNING AND NOSE DOOR OPEN MESSAGE WHEN GEAR SELECTED DOWN. REMOVED AND REPLACED NLG SELECTOR VALVE.SDR COMA0760148Flap System · malfunctionedFLIGHT 4973 - DURING PREFLIGHT INSPECTION 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 COMA0660544Connector · damagedFLIGHT 5102 - THE EMERGENCY FLOOR LIGHTS FROM ROW 9 TO THE LAVATORY FAILED TO ILLUMINATE DURING TEST. REPAIRED CONNECTOR P40LY.SDR COMA0660541Connector · dirtyFLIGHT 5519 - SECTION OF THE EMERGENCY FLOOR LIGHTING IS INOPERATIVE. DISCONNECTED, CLEANED AND INSPECTED AFFECTED CONNECTOR FOR INOPERATIVE SECTION OF FLOOR LIGHTING.SDR COMA0660509Light · failedFLIGHT 5684 - THE EMERGENCY FLOOR PATH EXIT LIGHTING FAILED TEST BETWEEN ROWS 9-12. DEFERRED INOPERATIVE SECTION OF EMERGENCY FLOOR PATH EXIT LIGHTING PER MEL 33-51-01-5.SDR COMA0660462Cable · faultyFLIGHT 5532 - MOST REAR CABIN EMERGENCY FLOOR STRIP INOPERATIVE. REPLACED INOPERATIVE CABLE ASSEMBLY.SDR COMA0660409Computer · malfunctionedFLIGHT 5023 - PERFORMED A HIGH SPEED ABORT DUE TO ANTI-SKID CAUTION. PERFORMED A SYSTEM RESET FOR SECU NR 1 AND NR 2.SDR COMA0660352Bpsu · faultyFLIGHT 5181 - AFTER LANDING RECEIVED A FLAP FAIL CAUTION AT 45 DEGREES. REPLACED BPSU.SDR COMA0660350Flap · malfunctionedFLIGHT 5568 - DURING LGA APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE AT 8 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, CSDR COMA0660345Caution Message · false activationFLIGHT 5455 - FLAP FAIL CAUTION MESSAGE ON 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 COMA0660336Actuator · faultyFLIGHT 5137 - DURING LANDING AT YYZ, RECEIVED A FLAP FAIL CAUTION MESSAGE AT 45 DEGREES. REPLACED THE RIGHT INBOARD FLAP OUTBOARD FLAP ACTUATOR.SDR COMA0660335Actuator · faultyFLIGHT 5137 - DURING LANDING AT YYZ, RECEIVED A FLAP FAIL CAUTION MESSAGE AT 45 DEGREES. REPLACED THE RIGHT INBOARD FLAP INBOARD ACTUATOR.SDR COMA0660334Actuator · faultyDURING LANDING AT YYZ, RECEIVED A FLAP FAIL CAUTION MESSAGE AT 45 DEGREES. REPLACED THE LEFT INBOARD FLAP OUTBOARD FLAP ACTUATOR.SDR COMA0660333Actuator · faultyFLIGHT 5137 - DURING LANDING AT YYZ RECEIVED A FLAP FAIL CAUTION MESSAGE AT 45 DEGREES. REPLACED THE LEFT INBOARD FLAP INBOARD ACTUATOR.SDR COMA0660332Bpsu · faultyFLIGHT 5137 - DURING LANDING AT YYZ RECEIVED A FLAP FAIL CAUTION MESSAGE AT 45 DEGREES. REPLACED THE BRAKE POSITION SENSING UNIT.SDR COMA0660324Bpsu · faultyFLIGHT 5266- FLAPS FAIL CAUTION MESSAGE. REMOVED AND REPLACED RT BPSU.SDR COMA0660314Flap System · malfunctionedFLIGHT 5202 - FLAPS FAILED CAUTION MESSAGE OCCURRED ON FINAL APPROACH AT 45 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 MESDR COMA0660290Flap System · warning lightFLIGHT 5616 - DURING TAXI OUT RECEIVED A FLAP FAIL MESSAGE, FLIGHT RETURNED TO THE GATE. 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 CAUTIOSDR COMA0660128Flap System · malfunctionedFLIGHT 5078 - DURING BUF APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE AT 45 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 SDR COMA0560548Actuator · frozenFLIGHT 5227 - NLG DOOR OPEN WARNING. LUBRICATED AND FREED UP FROZEN ROLLER IN NLG DOORS OPERATING MECHANISM.SDR COMA0660502Wire · damagedFLIGHT 5306 - THE AFT CABIN EMERGENCY FLOOR LEVEL LIGHTING FAILED TEST. REPAIRED WIRING ON AFT EMERGENCY FLOOR LEVEL FLEX STRIP CONNECTOR.SDR COMA0560410Outflow Valve · failedFLIGHT 5499- OVERBOARD COOL CAUTION. AIRCRAFT DID NOT PRESSURIZE. FOUND OVERBOARD AND INBOARD EXHAUST VALVES IN WRONG POSITION. PREVIOUS DEFERRAL ITEM.SDR COMA0560353Pump · faultyFLIGHT 5851 - DURING CLIMBOUT OF DSM RECEIVED A GEAR DISAGREE CAUTION. CREW DECLARED AN EMERGENCY AND RETURNED TO THE FIELD, LANDING WITHOUT INCIDENT.SDR COMA0560304Skin · corrodedDURING HEAVY MAINTENANCE CHECK, THE PAX DOOR FORWARD AND AFT BOTTOM CORNERS WERE FOUND TO BE CORRODED. BOTH PARTS WERE REPLACED WITH FACTORY NEW PARTS USING THE CL 6002B-19 STRUCTURAL REPAIR MANUALSDR COMA0560295Skin Panel · crackedDURING COMPLIANCE OF TASK 002-53-160-610 (COMAIR TASK CRJ-2-162011), 1 CRACK WAS FOUND IN THE PRESSURE FLOOR SKIN AT FS 460.0, BETWEEN BL 0.0 AND RBL 9.0 THE CRACK WAS 2.0 INCH IN LENGTH. REPAIRED IN ACCORDANCE WITH BOMBARDIER REO 601R-53-41-102, REV D, DATESDR COMA0460661Selector Valve · unreliableFLIGHT 4962, LOUD CLUNKING NOISE FROM NLG. REPLACED THE NLG DOORS SELECTOR VALVE.SDR COMA0460589Warning Light · illuminatedFLIGHT 5822 GEAR DISAGREE WARNING. COULD NOT DUPLICATE. FUNCTIONAL CHECKS AND INSPECTION OF LANDING GEAR FOUND NO DEFECTS.SDR COMA0460451Wire · failedFLIGHT 4988 EMERGENCY FLOOR PATH LIGHTS ARE INOP. REPLACED THE FLOOR LIGHTS CABLE ASSY.SDR COMA0460262Uplock Hook · out of adjustFLIGHT 5659 GEAR DISAGREE WARNING ON APPROACH. COULD NOT DUPLICATE. EXTENSION AND RETRACTION CHECKS WERE NORMAL. ADJUSTED NLG UPLOCK HOOK TO M/M SPECS.SDR COMA0460259Uplock · malfunctionedFLIGHT 5870 GEAR DISAGREE WARNING ON APPROACH. REPLACED THE NLG UPLOCK.SDR COMA0460248Priority Valve · faultyFLIGHT 5596 GEAR DISAGREE WARNING, NLG INDICATED INTRANSIT. REPLACED THE NLG PRIORITY VALVE.SDR COMA0360518Pivot · lack of lubeFLIGHT 5689 AFTER TAKEOFF AND GEAR RETRACTION THE NLG INDICATED DOWN AND LOCKED WITH THE HANDLE IN THE UP POSITION. AIRCRAFT RETURNED TO DEPARTING CITY (CVG). CLEANED AND LUBRICATED THE NLG PIVOT POINTS.SDR COMA0360517Actuator · faultyFLIGHT 5745 AFTER TAKEOFF AND GEAR RETRACTION RECEIVED A NLG DISAGREE CAUTION WITH A NOSE GEAR DOOR OPEN MESSAGE. AIRCRAFT RETURNED TO DEPARTING CITY (CVG). REPLACED THE NLG DOOR ACTUATOR.SDR COMA0360376Handle · unsecureFLIGHT 5221 CABIN DOOR OUTER HANDLE CAUTION MESSAGE. FOUND OUTER HANDLE OPEN - OPERATIONAL CHECK OF DOOR SATISFACTORY. NO DEFECTS NOTED.SDR COMA0360145Trim Switch · malfunctionedFLIGHT 5219 RUDDER TRIM STUCK AT 1/4 RIGHT. REPLACED THE RUDDER TRIM PANEL.SDR COMA0260735Control BoxFLIGHT 5443 LEFT ANGLE OF ATTACK HEAT CAUTION MESSAGE.RESET SYSTEM - COULD NOT DUPLICATE.SDR COMA0260600DoorFLIGHT 5063 LOUD WHISTLING COMING FROM R/H FORWARD SIDE OF AIRCRAFT.FOUND GROUND INTERPHONE DOOR OPEN - INSPECTED FOR DAMAGE AND CLOSED DOOR.SDR COMA0260519Pseu · malfunctionedFLIGHT 5984 GEAR DISAGREE MESSAGE.REPLACED THE PSEU.
Back to N929CA, cancelled Nov 4, 2013