N685CA, cancelled Sep 22, 2008
Service difficulty reports · 64
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 = 'N685CA' AND deregistration_id = 'N685CA-2008-09-22' 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 = 'N685CA' AND deregistration_id = 'N685CA-2008-09-22' 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 C1HA200785001Threshold · crackedFLIGHT ATTENDANTS REPORTED VIBRATION IN FLOOR IN FRONT OF AFT ENTRY DOOR AND GRINDING NOISE. ON DESCENT PULLED POWER LEVERS TO IDLE CABIN STARTED TO CLIMB AND NOISE AND VIBRATION WENT AWAY, WHEN POWER LEVERS ADVANCED CABIN DESCENDED AND VIBRATION AND NOISE RESDR C1HA200685012Motor · failedON CLIMB FROM DFW ALL OF -A- SYSTEM HYD WAS LOST, COMPLIED WITH COM 2.29-2. RETURNED TO DFW. REMOVED AND REPLACED O/B FLAP DRIVE MOTOR PER MM 27-51-62, ALL TEST NORMAL. DUE TO -A- SYS HYD LOSE REPLACE NR 1 & 2 -A- SYS HYD PUMPS & FILTERS. REMOVED & REPLACESDR C1HA200685001Seat Track · corrodedUPPER CABIN SEAT TRACK AT RBL 45 HAS CORROSION AT STA 480. FOUND CORROSION OUT OF LIMITS IAW B727 SRM 53-10-1. REMOVED SEAT TRACK IAW B727 SRM 51-30-2, FABRICATED NEW TRACK USING BAC 1520-792-7178 IAW B727 SRM 53-10-2, ALODINE & PRIME IAW B727 SRM 51-10-2.SDR CIHA200685011Floorbeam · corrodedCORROSION CABIN FLOORBEAM LBL 10 TO 20 STA 360. FOUND CORROSION OUT OF LIMITS. CUT OUT DAMAGED AREA IAW B727 SRM 51-10-0. FAB 2EA ANGLE REPAIRS FROM BAC1490-2888 7075 T6IAW B727 SRM 53-10-8 FIG 8. ALODINE & PRIME IAW B727 SRM 51-10-2, INSTALLED PARTS IAW BSDR C1HA200685010Floorbeam · corrodedUPPER CABIN FLOOR ANGLE AT STA 1179 RBL 45 TO RBL 65 HAS AREAS OF CORROSION. CLEANED AREA IAW B727 SRM 53-10-0. REMOVED WEB IAW B727 SRM 51-30-2. CORROSION FOUND OUT OF LIMITS, ORIGINAL THICKNESS OF 0.300, MATERIAL LOSS 0.045, MATERIAL REMAINING 0.255 IAW SDR C1HA200685009Stiffener · crackedRIGHT W/W STA 870 AT KEEL BEAM VERTICAL STIFFENER CRACKED AT LOWER END. REMOVED AND REPLACED VERTICAL STIFFENER RIGHT W/W BS 870 P/N 65-18636-378 PO 6206100 IAW B727 SRM 51-30-2.SDR C1HA200685007Floorbeam · corrodedCABIN CORROSION FLOORBEAM 344 LBL 48 TO RBL 12. FOUND CORROSION OUT OF LIMIT IAW B727 SRM 53-10-1. REMOVED DAMAGED AREA, FABBED UPPER CHORD FROM BAC 1505-29221 ANGLE FROM BAC 149-2831 IAW B727 SRM 53-10-2 FIG 7, ALODINE & PRIME IAW B727 SRM 51-10-2, INSTALLESDR C1HA200685006Angle · crackedRT WING I/B MID FLAP HAS CRACK AT EDGE OF CUTOUT BELOW THE I/B MECHANISM. CUT OUT DAMAGED SECTION OF CHORD (70 INCHES) IN LENGTH, FABRICATED NEW SECTION P/N BAC 1503 100046 (70 INCHES) & SPLICE ANGLE 7075 T6 .050 IAW B727 SRM 57-50-2 FIG 5 & 51-40-4 FIG 1, TRSDR C1HA200685008Seat Track · corrodedUPPER CABIN SEAT TRACK AT LBL 45 DEEP CORROSSION INSIDE CROWN AREA AT STA 950 TO 970. CUT OUT SEAT TRACK FROM STA 950 TO 1115 IAW B727 SRM 53-10-1 FIG 3. FAB NEW SEAT TRACK FROM BAC1520-797 7075 T6 .02 IAW B727 SRM 53-10-5. ALODINE & PRIMED IAW B727 SRM 51-SDR C1HA200685005Seat Track · corrodedUPPER CABIN SEAT TRACK HAS CORROSION STA 469 RBL 45. FOUND CORROSION OUT OF LIMITS. REMOVED SEAT TRACK RBL 400 TO 480 IAW B727 SRM 51-30-2, FABRICATED NEW SEAT TRACK FROM BAC 1520 KTP 017 792 7178 IAW B727 SRM 53-10-2 FIG 7, & 51-20-1. ALODINED & PRIMED IAWSDR C1HA200685003Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM 380 RBL 15 TO 48. FOUND CORROSION OUT OF LIMITS IAW B727 SRM 53-10-1. CUT OUT DAMAGE AREA IAW B727 SRM 51-10-1. FAB UP CHORD FROM 7075 T6, ANGLE STRAP IAW B727 SRM 53-10-8 FIG 3. ALODINE & PRIME IAW B727 SRM 51-10-2. INSTALLEDSDR C1HA200683001Floorbeam · corrodedCABIN CORROSION FLOORBEAM 344 LBL 48 TO RBL 12. FOUND CORROSION OUT OF LIMIT IAW B727 SRM 53-10-1. REMOVED DAMAGED AREA, FABBED UPPER CHORD FROM BAC 1505-29221 ANGLE FROM BAC 149-2831 IAW B727 SRM 53-10-2 FIG 7. ALODINE & PRIME IAW B727 SRM 51-10-2, INSTALLSDR C1HA200685004Seat Track · corrodedCORROSSION CABIN SEAT TRACK LBL 24 STA 380 TO 440. REMOVED DAMAGE TRACK IAW B727 SRM 51-30-2, FABBED NEW TRACK FROM BAC 1520-792-7178 T6 IAW B727 SRM 53-10-2 FIG 7. ALODINE & PRIME IAW B727 SRM 51-10-2, INSTALLED SEAT TRACK IAW B727 SRM 53-10-5 FIG 7.SDR C1HA200585001O-Ring · failedEXPERIENCED RAPID DECOMPRESSION AT FLT 310, RAN COM RAPID DECOMPRESSION AND DESCENT CHECK LIST. CABIN STABILIZED AT 17,000 FT, FOUND LT FWD CLAMP LOOSE ON WATER SEPARATOR. REMOVED AND INSPECTED CLAMP, FOUND SERVICEABLE. INSTALLED NEW O-RINGS, REINSTALLED LTSDR C1HA200485007Connector · damagedWHILE CONFIGURING FOR LANDING, LOWERED LANDING GEAR AND RECEIVED (3 GREEN) BUT ALSO DOORS ANNUNCIATOR ON FORWARD PANEL AND LT MAIN GEAR DOOR LIGHT ON FE PANEL. ACCOMPLISHED GO-AROUND IAW COM, CONTACTED MAINT. CONTROL AND RETURNED TO LAND. AFTER INSPECTING GEARSDR C1HA200485004Wedge · gougedNR 6 SLAT CRACK AT FASTNER HOLE/2 GOUGES IN WEDGE EXTRUSIONSDR C1HA200485005Wedge · delaminatedLT OTBRD AILERON TRAILING EDGE WEDGE DELAMINATEDSDR C1HA200485006Skin · dentedLT INBD AILERON TAB 4 DENTS BEYOND SRM LIMITS HOT BOND REPAIRED, WEIGH AND BALANCE REQUIREDSDR C1HA200485003Flap · inoperativeNR 4 KRUGER FLAP WOULD NOT RETRACT AFTER TAKEOFF. AIRCRAFT CURRENTLY IN HEAVY CHECK AND CORRECTIVE ACTION WILL FOLLOW WITH C CHECK FINDING AND RESOLUTION.SDR C1HA200485002Actuator · malfunctionedNR 4 KRUGER FLAP WOULD NOT RETRACT AFTER T/O. R&R NR 4 KRUGER FLAP ACTUATOR PER M.M. 27-81-22. ACTUATOR OPS CHECKS GOOD.SDR C1HA200485001Tire · smokeDURING GEAR RETRACT LAS THERE WAS ODOR OF BURNED RUBBER IN COCKPIT AND FWD CABIN AREA, AN AUDIBLE SQUEEL WAS HEARD ORIGTINATING FROM BELOW FLIGHT DECK, JUST PRIOR TO ROTATION LAS THE NOSE WHEEL SHOOK ABNORMALLY. INBOUND INTO MSP DECLARED EMERGENCY AND LANDED SDR C1HA200385013Battery Pack · inoperativeLEFT AFT LOWER BODY EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK IAW MM 33-50-21, OPS CK GOOD.SDR C1HA200385012Battery Pack · dischargedOUTER EMERGENCY LIGHTS BY R2 & L2 DOORS ARE INOP. REMOVED AND REPLACED EMERGENCY BATTERY PACK IAW 33-50-51 IN 727 MM, ALL OPS CKS GOOD.SDR C1HA200385011Battery Pack · dischargedFWD SECTION OF FLOOR TRACK EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK IAW 727 MM 33-50-51, ALL OPS NORMAL.SDR C1HA203385010Battery · inoperativeAFT OUTSIDE LEFT EMERGENCY LIGHT INOP. REMOVED AND REPLACED M955 PWR SUPPLY AND BATTERY OPS CHECKED GOOD PER M/M 33-50-22.SDR C1HA200385009Battery Pack · dischargedEMERGENCY EXIT LIGHT OVER AFT AIRSTAIRS DOOR OUT. REMOVED AND REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHT OVER AFT AIRSTAIRS DOOR AS REQ'D, OPS NORMAL.SDR C1HA200385008Hydraulic Line · rupturedON DESCENT HAD HYD A ENG 1 PUMP LOW PRES LITE ON A QUANTITY -0- RAN PRECEDURE 2.29.2- AFTER A PUMP AND FLUID SHUT OFF TURNED OFF, QUANTITY CAME UP TO 1.5 GAL. FLT ATTENDANT REPORTED GRINDING NOISE FROM ENG 1 WHEN QTY INDICATED 1.5- PUMPS AND SHUTOFFS WERE TURNSDR C1HA200385007Actuator · leakingHYD SYS A QUANTITY GUAGE WENT TO 0.4 GAL RAN CHECK LISTS. FOR SYS LOSS CALLED DISPATCH DIVERTED TO DAL. DECLARED EMERGENCY. NO LOSS OF SYS PRESSURE END. REMOVED AND REPLACED NR 14 SPOILER ACTUATOR IAW MM 27-61-81. AND SERVICED HYD SYST TO FULL IAW MM 12-20-00.SDR C1HA200385006Battery Pack · inoperativeLT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY CHARGER AND BATTERY PACK IAW 727 MM 33-50-22, ALL OPS NORMAL.SDR C1HA200385005Housing · brokenFORWARD LAV SMOKE DETECTOR HOUSING IS BROKEN.SDR C1HA200385004Fuel Control · malfunctionedNR 1 ENGINE NOT MAKING TAKE-OFF POWER. NR 1 2.07 EPR NR 2 AND NR 3 AT 2.15 EPR ALL OTHER INDICATIONS REFLECT SAME POWER DIFFERENCE. NR 1 SLIGHTLY LOWER N1, N2, EGT. ABORTED TAKEOFF IAW AOM -SMAC PROCEDURES 4.51.28SDR C1HA200385003Indicator · malfunctionedON TAKE-OFF ROLL NR 3 EGT WAS READING ERRONEOUSLY B/L 500 100 ON TAXI THE GAUGE WANT TO 0. R & R NR 3 EGT INDICATOR PER MM 77-21-51 EGT IND NORMAL OK FOR SERVICESDR C1HA200385001Fire Detector · will not testAPU FIRE DETECTION SYSTEM WILL NOT TEST. REMOVED AND REPLACED APU FIRE HANDLE. OPS CHECK GOOD.SDR C1HA200285015Filter · looseSMOKE REPORTED FROM ENGINE NR 2 AFTER LANDING. INSPECTED FOUND LOOSE DRAIN FILTER AND TORN DRAIN SCUPPER. TIGHTENED FITTINGS, OPS CHECKED ENGINE AT IDLE. NO LEAKS NOTED.SDR C1HA200285014Air DuctINTERMITTENT FIRE LIGHT / BELL #2 PERFORMED #2 SHUTDOWN PROCEDURE EMERGENCY DECLARED. WARNING OCCURED DURING CLIMB OUT. FUEL DUMPED ENG #2 WINDMILLED 20 MINUTES, OIL PRESSURE 20 PSI, OIL PRESS AT SHUTDOWN 45 PSI.REMOVE AND REPLACE ENG. FIRE EXTINGUSHER BOTTLE SDR C1HA200285013Battery PackOverhead emergency exit light inoperative at row 20. Removed and replaced emergency exit light battery pack per MM. Operational checks good.SDR C1HA200285012Oil Filter#1 low oil pressure light illuminated on takeoff roll below 60 ktts. Aborted takeoff. Replaced #1 engine main oil filter per MM. Leak checks good.SDR C1HA200285011BatteryAFT LH EMERGENCY EXTERIOR OVERWING LIGHT INOPREMOVED AND REPLACED BATTERY PACK AS PER MM 33-50-22 OPS CHECK GOODSDR C1HA200285004Stringer · corrodedAFT PIT S29L BETWEEN STA 970 & 990 HAS CORROSION. REMOVED CORROSION IAW 727 SRM 51-10-6. INSTALLED REPAIR STRIP IAW EO AAR 0409-02 AND SRM 51-30-2.SDR C1HA200285003Support · crackedLOWER FLOORBEAM SUPPORT IS CRACKED IN 2 AREAS AT STA 300 AND 320 30 INCHES FROM CENTER LINE UNDER FWD LAV. REMOVED AND REPLACED SPLICE PLATE ON FWD END IAW SRM 51-40-2.SDR C1HA200285005Seat Track · corrodedSEAT TRACK RBL 24 STA 1100-1130 HAS CORROSION TOP & BOTTOM. SEAT TRACK REPLACED.SDR C1HA200285009Channel · corrodedLEFT AFT LAV LBL 30 STA 1128 HAS CORROSION ON METAL STRIP. FABBED NEW CHANNEL IAW SRM 51-30-6, 51-30-8, INSTALLED NEW CHANNEL IAW SRM 51-30-2.SDR C1HA200285008Lavatory · corrodedAFT LAV RT RBL 27-48 HAS CORROSION STA 1150. BLENDED CORROSION IAW SRM 53-10-1, OUT OF LIMITS IAW 51-10-1. FABRICATED REPAIR IAW 51-40-2, 51-10-2, INSTALLED REPAIR IAW SRM 51-30-2, 51-20-4.SDR C1HA200285007Floor Support · corrodedAFT LAV RT STA 1130 FLOOR SUPPORT HAS CORROSION RBL 3L. REMOVED DAMAGED CHANNEL IAW 51-30-2. FABRICATED NEW HAT CHANNEL IAW 51-20-1, 51-30-2, 51-10-2. INSTALLED NEW HAT CHANNEL IAW 51-30-2.SDR C1HA200285006Support · corrodedSUPPORT FRAME AT STA 344 15 INCHES FROM CENTER LINE IS CORRODED ON TOP AND BOTTOM. REPAIRED SUPPORT STA 344 IAW EO AAR0410-02 DOC N PC-02-X106.SDR C1HA200285002Fitting · looseAFTER DEPARTING, FELT VIBRATION THROUGH A/C. VISUALLY INSPECTED THROUGH L2 DOOR. O/B FLAP AILERON AND BALANCE TAB SEEN VIBRATING VIOLENTLY. FL 350-.81 .75 AND STILL VIBRATED, RECHECKED ON DESCENT THROUGH 15000, AND 250 KTS. SIGNIFICANTLY REDUCED VIBRATION SDR C1HA200185013Indicator · fluctuatesWHILE EN ROUTE ENG NR 2 EPR FLUCTUATED BETWEEN 1.9 & 2.0 AND N1 FLUCT BETWEEN 84 & 86 PERCENT EGT 4750 AND N2 FLUCT ALSO PARAMETERS NOT NOTED. REMOVED AND REPLACED NR 2 EPR INDICATOR NR 2 N1 INDICATOR DRAINED AND CHECKED MOISTURE TRAP, ENG TRIM CK IAW ENG TRISDR C1HA200185012Bolt · looseENGINE NR 1 LOST ALL OIL DURING LOSS OF PRESSURE PRECAUTIONARY ENGINE PROCEDURES WERE COMPLETED (AFTER 2 MIN COOL DOWN) AT 10 PSI OIL PRESSURE DROPPED TO 0 DURING WIND MILLING 17:05-18:00 OIL PRESSURE WAS AT 10 PSI AT SHUTDOWN AND DECREASE. INSPECTED ENGINE VISDR C1HA200185011BatteryR2 EMERGENCY EXIT SIGN INOP. ACTION TAKEN: REMOVED AND REPLACED BATTERY PACK AND CHARGER PER MM 33-50-1.SDR C1HA200185010Isolation Valve · failedOn taxi out had double pack trip and cooling fan CB popped. Ran C/B reset procedure and pack trip off procedure. Re-continued taxi and had double pack trip and cooling fan control breaker popped again and had right duct overheat light.ACTION TAKEN:Removed and
Back to N685CA, cancelled Sep 22, 2008