N837AS, cancelled Jun 8, 2017

Service difficulty reports · 125

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 = 'N837AS' AND deregistration_id = 'N837AS-2017-06-08'
  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.

SDR ASOA201100083Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED AT DOOR ASSIST PULLEY. REPAIRED PAX DOOR AFT DRAG ANGLE IAW REO 601R-52-11-513.Jan 13, 2011 · N837AS · Cndair CL6002B19 · Passenger/Crew DoorsSDR ASOA201100082Support Fitting · crackedPILOTS OTBD WINDSHIELD POST LOWER SUPPORT FITTING CRACKED. DRILLED HOLES FOR NEW FITTING IAW SRM 51-40-11. INSTALLED NEW SERVICEABLE FITTING, PN 601R33235-3S IAW SRM 51-42-21. (CLOSED)Jan 13, 2011 · N837AS · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR ASOA201100081Frame · corrodedCORROSION FOUND ON FS 349.00 FRAME, STR 26L IN MAIN AVIONICS COMPARTMENT. INSTALLED FRAME SECTOR IAW SRM 51-42-06 AND 51-42-21.Jan 13, 2011 · N837AS · Cndair CL6002B19 · Fuselage Main, FrameSDR ASOA201100080Frame · corrodedCORROSION FOUND ON FS 333.00, STR 26L-26, IN MAIN AVIONICS COMPARTMENT. CORROSION OUT OF LIMITS IAW SRM 53-00-00. REMOVED FRAME IAW SRM 51-42-06 AND 51-42-21. LOCATED, DRILLED AND INSTALLED NEW FRAME IAW SRM CH 51-40-11, CH 51-42-06 AND CH 51-42-21.Jan 13, 2011 · N837AS · Cndair CL6002B19 · Fuselage Main, FrameSDR ASOA201100079Frame · corrodedCORROSION FOUND ON FS 319, FRAME, STR 26L IN MAIN AVIONICS COMPARTMENT. LOCATED AND DRILLED NEW FRAME. INSTALLED FRAME IAW SRM CH 51-40-11, CH 51-42-06 AND 51-42-21.Jan 13, 2011 · N837AS · Cndair CL6002B19 · Fuselage Main, FrameSDR ASOA201100078Seat Track · corrodedRT SEAT TRACK HAS CORROSION, FS 394.00-409+128, RBL 9. REMOVED CORRODED SEAT TRACKS IAW AMM 53-01-11-000-802. INSTALLED NEW SERVICEABLE SEAT TRACKS AND SCREWS IAW AMM 53-01-11-400-802.Jan 13, 2011 · N837AS · Cndair CL6002B19 · Fuselage, Seat/Cargo Attach FittingsSDR ASOA201100207Floor Support · corrodedFLOOR SILL STRUCTURE IS CORRODED BETWEEN FS 312.00 AND FS 319.70 JUST FWD OF SERVICE DOOR. R & R DAMAGED SECTION OF FLOOR SILL FWD OF SERVICE DOOR IAW SRM 51-42-06. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. REQUIRES COMPLETION FOR THIS REPAIRJan 11, 2011 · N837AS · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR ASOA201100183Attach Fitting · corrodedSERVICE DOOR THRESHOLD STEP PLATE NEEDS REPLACEMENT DUE TO HEAVY CORROSION AND DAMAGE. FOUND CLIP THAT ATTACHES FS 319 TRANSVERSE BEAM RT TO THE SERVICE DOOR SILL ANGLE TO BE CORRODED AND REQUIRES REPLACEMENT. REMOVED DAMAGED CLIP AT FS 319 (RT) AND REPLACEDJan 11, 2011 · N837AS · Cndair CL6002B19 · Fuselage Main, Attach FittingsSDR ASOA201100067Light · crackedEMERGENCY EXIT FLOOD LIGHT ON THE SIDE OF THE GALLED IS CRACKED. INSTALLED SERVICEABLE EMERGENCY EXIT FLOODLIGHT ASSY IAW AMM 20-21-00-910-801. PERFORMED THE OPS TEST OF THE EMERGENCY EXIT FLOODLIGHT ON THE SIDE OF THE GALLEY IAW AMM 33-51-00-710-801. NO DJan 11, 2011 · N837AS · Cndair CL6002B19 · Emergency LightingSDR ASOA201100053Bulkhead · crackedFOUND REAR PRESSURE BULKHEAD WEB HAS INDICATION NOTED AT LBL 27.50 (AREA MARKED AT TOP OF AFT CARGO DOOR TRACK). C/W EC/TC REO 601R-53-61-1541 AND MET ALL THE REQUIREMENTS OF REO 601R-53-61-1541, REV B. THE REPAIR REQUIRES PAINT ON THE FWD/AFT SIDE OF THE BUJan 10, 2011 · N837AS · Cndair CL6002B19 · Fuselage Main, BulkheadSDR ASOA201100052Isolator · crackedFOUND REAR PRESSURE BULKHEAD HAS A CRACKED ISOLATOR AT RBL 36.20 APPROX WL 96 AND A CRACKED ISOLATOR AT RBL 27.50 APPROX WL 95. R & R MOUNT ISOLATOR REAR PRESSURE BULKHEAD IAW SRM 51-42-06. THIS REPAIR IS CLASSIFIED AS A MINOR REPAIR IAW ASA SOP 5702. (CLOSEJan 10, 2011 · N837AS · Cndair CL6002B19 · Fuselage Main, BulkheadSDR ASOA201001581Cover · brokenEMERGENCY LIGHT COVER ON WALL NEAR MAIN DOOR BROKEN. REPLACED EMERGENCY FLOOR LEVEL LIGHT ASSY IAW AMM 33-51-19. OP'S CHECKS GOOD. (CLOSED)Oct 15, 2010 · N837AS · Cndair CL6002B19 · Emergency LightingSDR ASOA201000911Engine · failedLEFT ENGINE EXPERIENCED SEVERE DAMAGE DURING THE DEPARTURE PHASE OF FLIGHT. AROUND 3,000 FT, HEARD A LOUD BANG AND EXPERIENCED YAW. POWER WAS SET AROUND 88 PERCENT "N". (EMERGENCY DECLARED - A/C RETURNED TO DEPARTURE AFTER T/O) LT ENGINE ASSY WAS REPLACED.Jun 13, 2010 · N837AS · Cndair CL6002B19 · Engine (Turbine/Turboprop)SDR ASOA201000338Bulb · inoperativeEMERGENCY LIGHT ON F/A WARDROBE HAS SEVERAL INOP BULBS. R & R FLOOR-LEVEL EMERGENCY FLOODLIGHTS AS REQUIRED IAW IAW AMM 33-51-19. OPS CHECK GOOD.Feb 28, 2010 · N837AS · Cndair CL6002B19 · Emergency LightingSDR ASOA20100030Battery · deterioratedR & R BATTERIES IN CAPT'S FLASHLIGHT IAW AMM 25-61-00. (CLOSED)Jan 11, 2010 · N837AS · Cndair CL6002B19 · Emergency EquipmentSDR ASOA201000030Flashlight · inoperativeCAPTAIN'S EMERGENCY FLASHLIGHT INOP.Jan 11, 2010 · N837AS · Cndair CL6002B19 · Emergency EquipmentSDR ASOA200901010Light · inoperativeEMERGENCY FLOODLIGHT AT PAX DOOR INOP.Sep 14, 2009 · N837AS · Cndair CL6002B19 · Emergency LightingSDR ASOA200900965Light · inoperativeRIGHT NR 4 EXTERIOR EMERGENCY LIGHT INOP.Aug 30, 2009 · N837AS · Cndair CL6002B19 · Emergency LightingSDR ASOA200900926Charger · inoperativeSECOND CEILING EMERGENCY FLOODLIGHT INOP, CABIN EMERGENCY LIGHTS - CEILING LEVEL EMERGENCY FLOOD LIGHTS. REMOVED AND REPLACED NR 4 BATTERY CHARGER IAW AMM 33-51-05. OPS CHECK GOOD.Aug 24, 2009 · N837AS · Cndair CL6002B19 · Emergency LightingSDR ASOA200900925Charger · inoperativeFOURTH CEILING EMERGENCY FLOOD LIGHT INOP (CABIN EMERGENCY LIGHTS - CEILING LEVEL EMERGENCY FLOOD LIGHTS. REMOVED AND REPLACED NR 4 BATTERY CHARGER IAW AMM 33-51-05. OPS CHECK GOOD.Aug 24, 2009 · N837AS · Cndair CL6002B19 · Emergency LightingSDR ASOA200900162Light · brokenEMERGENCY EXIT LIGHT ON WARDROBE IS BROKEN.Feb 3, 2009 · N837AS · Cndair CL6002B19 · Emergency LightingSDR ASOA200900159Light · inoperativeEMERGENCY LIGHTS IN FWD CABIN ARE INOP.Feb 2, 2009 · N837AS · Cndair CL6002B19 · Emergency LightingSDR ASOA200900120Anchor Fitting · crackedPAX DOOR FWD ANCHOR FITTING IS CRACKED.Jan 25, 2009 · N837AS · Cndair CL6002B19 · Passenger/Crew DoorsSDR ASOA200900147Channel · damagedINDICATION NOTED AT FS 409+128 RBL 18 WL 69.0 INBD U CHANNEL IN RADIUS AT TOP FASTENER APPROX .30" LENGTH, VERTICALLY 95Ï¿½6 F.S.H. WILE PERFORMING ASA TASK AWL253-41-199.Jan 16, 2009 · N837AS · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR ASOA200900129Bulkhead · damagedREAR PRESSURE BULKHEAD WEB THAT SURROUND THE LINTEL ATTACHMENT FITTING HAS A INDICATION NOTED APPROX .1" IN LENGTH 70% FSH FAILED NDT INSP.Jan 14, 2009 · N837AS · Cndair CL6002B19 · Fuselage Main, BulkheadSDR ASOA200900128Bulkhead · damagedFS 559.0 BULKHEAD WEB AND CAP ANGLE HAS INDICATIONS NOTED AT LT/RT CAP ANGLE LBL 18 & RBL 18 APPROX .2" IN LENGTH 70% FSH AND RT WEB WL 58.70, WL 59.10 APPROX .5" IN LENGTH 80% FSH ALL AREAS FAILED NDT INSP, MARKED ON ACFT. REPAIRED FS 559.0 BULKHEAD WEB AND Jan 14, 2009 · N837AS · Cndair CL6002B19 · Fuselage Main, BulkheadSDR ASOA200900070Angle · corrodedRT FLOOR SILL ANGLE CORRODED FROM FS 409+128 TO FS 559, RBL 36 - RBL 47. REMOVED MINOR CORROSION AT PRESSURE FLOOR SILL ASSY BETWEEN FS 409+128 AND FS 559 IAW REO 601R-53-41-666. DAMAGED REMOVED FROM FLOOR SILL PNL FOUND TO BE WITHIN LIMITS OF REO 601R-53-41Jan 14, 2009 · N837AS · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR ASOA200900069Angle · corrodedLT FLOOR SILL ANGLE CORRODED FROM FS 409+128 TO FS 559, LBL 36 - LBL 47. REMOVED MINOR CORROSION DAMAGE AT PRESSURE FLOOR SILL ASSY IAW REO 601R-53-41-666. DAMAGED REMOVED FROM FLOOR SILL PANEL FOUND TO BE WITHIN LIMITS OF REO 601R-53-41-666.Jan 14, 2009 · N837AS · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR ASOA200900068Placard · wornPAX DOOR EXIT PLACARD IS WORN.Jan 14, 2009 · N837AS · Cndair CL6002B19 · Placards and MarkingsSDR TRAX200800866Step · crackedPAX DOOR LOWER STEP CRACKED. REMOVED AND REPLACED LOWER PAX DOOR STEP IAW AMM 52-11-04. (B)Jul 3, 2008 · N837AS · Cndair CL6002B19 · Passenger/Crew DoorsSDR TRAX200800292Window · crackedF/O SIDE WINDOW SHATTERED AT FL250. AIRCRAFT RETURNED TO ATL AFTER T/O. EMERGENCY DECLARED.Feb 21, 2008 · N837AS · Cndair CL6002B19 · Flight Compartment WindowsSDR TRAX200701722Flap System · failedCLIMBING OUT 26,000FT GOT FLAP FAIL, FLAPS AT 0. A/C RETURNED TO ATL AFTER T/O. EMERGENCY DECLARED. FLTS 4573, 4860 CX.Nov 12, 2007 · N837AS · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR TRAX200701203Flap · failedFLAPS FAIL CAUTION AT 14K FT WHILE CLIMBING OUT OF ATL. EMERGENCY DECLARED.Aug 16, 2007 · N837AS · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR TRAX200700403Attach Angle · crackedRT WING MIDDLE L/E,I/B ATTACH ANGLE IS CRACKED. REMOVED AND REPLACED RT WING ATTACH ANGLE L/E, IAW CRJ SRM 51-40-11 PG 1-3, CRJ SRM 51-41-02 PG 1-5, P/N 600-12045-12.Mar 19, 2007 · N837AS · Cndair CL6002B19 · Wing, Attach FittingsSDR TRAX200700402Attach Angle · crackedRT. WING I/B L/E, O/B ATTACH ANGLE IS CRACKED. REMOVED AND REPLACED RT WING L/E ATTACH ANGLE (P/N 600-12025-8), IAW CRJ SRM 51-40-11 PG 1-3, CRJ SRM 51-41-02 PG 1-5.Mar 19, 2007 · N837AS · Cndair CL6002B19 · Wing, Attach FittingsSDR TRAX200700401Angle · crackedUPPER ATTACH ANGLE BETWEEN LT WING INBOARD AND MIDDLE LE`S ARE CRACKED. REMOVED DAMAGED ANGLE ON LT WING LE AND DUPLICATED USING 0.040, 2024-T3 PER CRJ SRM 51-24-21 AND 51-40-11. OK TO ALODINE, PRIME, AND INSTALL. ALODINED AND PRIMED ANGLE IAW CRJ SRM 51-25-0Mar 19, 2007 · N837AS · Cndair CL6002B19 · Wing Miscellaneous StructureSDR TRAX200700400Attach Angle · crackedLT WING MIDDLE L/E,I/B ATTACH ANGLE IS CRACKED. REMOVED AND REPLACED LEFT WING L/E I/B ATTACH ANGLE, WITH NEW ONE, P/N 600-12045-11, IAW CRJ SRM 51-41-02 PG 1-5, AND 51-40-11 PG 1-3.Mar 19, 2007 · N837AS · Cndair CL6002B19 · Wing, Attach FittingsSDR TRAX200700399Attach Angle · crackedUPPER ATTACH ANGLE BETWEEN RT WING I/B AND MIDDLE L/E'S IS CRACKED. REMOVED DAMAGED UPPER ATTACH ANGLE BETWEEN RT WING I/B AND MIDDLE L/E'S AND DUPLICATED USING 0.040, 2024-T3, PO 10054 PER CRJ SRM 51-24-36, 51-24-21, AND 51-40-11. INSTALLED SERVICEABLE DUPLMar 19, 2007 · N837AS · Cndair CL6002B19 · Wing, Attach FittingsSDR TRAX200700404Skin · crackedLEFT BONDED SKIN COMMON TO FS 640 FRAME IS CRACKED. COMPLIED WITH REO 601R-53-61-506 REPAIR TO SKIN BUTT STRAP L/H SIDE FS 640.00 STR 8-13.Mar 19, 2007 · N837AS · Cndair CL6002B19 · Fuselage Main, Plate/SkinSDR TRAX200700397Turbine · crackedCRACK FOUND ON NR 2 ENGINE LPT AT 9 O'CLOCK POSITION MEASURING 0.300 INCH MARKED PER SB CF34-3B1-72-A022 01.Mar 19, 2007 · N837AS · Cndair CL6002B19 · Turbine SectionSDR TRAX200700428Angle · crackedRIGHT FS 484 RBL 27 ANGLE CRACKED.Mar 17, 2007 · N837AS · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR TRAX200700383Angle · crackedLEFT FS 484 LBL 36 ANGLE CRACKED. [SUP 05-02-07] COMPLIED WITH REPAIR TO INTERCOSTAL AT F.S. 484, LBL 36, IAW REO 601R-53-41-059, PRESSURIZATION CHECK GOOD, IAW CRJ MM 21-30-00.Mar 17, 2007 · N837AS · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR TRAX200700375Placard · wornEXIT PLACARD ON 2ND STAIR WORN (PAX DOOR). REMOVED EXIT PLACARD FROM 2ND STAIR ON PAX DOOR INSTALLED SERVICEABLE EXIT PLACARD P/N S1594-18, ON 2ND STAIR OF PAX DOOR IAW CRJ 200 AMM 11-30-00-944-001. SUPPLEMENTAL - SDR CLOSED 03/22/07.Mar 16, 2007 · N837AS · Cndair CL6002B19 · Placards and MarkingsSDR TRAX200700376Door Frame · crackedPAX DOOR FRAME CRACKED AT FS 338. REPAIRED PAX DOOR FRAME IAW EO'S REO 601R-52-11-1205 AND REO 601R-52-11-402.Mar 16, 2007 · N837AS · Cndair CL6002B19 · Fuselage Main, StructureSDR TRAX200700374Placard · wornEMERGENCY EXIT ARROW ON WARDROBE WORN. REMOVED WORN EMERGENCY EXIT ARROW. INSTALLED SERVICEABLE EMERGENCY EXIT ARROW IAW CRJ AMM 11-30-02.Mar 16, 2007 · N837AS · Cndair CL6002B19 · Placards and MarkingsSDR TRAX200700173Flap System · malfunctionedFLAPS FAIL CAUTION MSG AT 0 DEG ON APPROACH TO YYZ, FOLLOWED QRH, LANDED UNEVENTFUL. EMERGENCY DECLARED.Feb 4, 2007 · N837AS · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR TRAX200601088Light · inoperativeEMERGENCY LIGHTS WILL NOT COME ON.Dec 7, 2006 · N837AS · Cndair CL6002B19 · Emergency LightingSDR TRAX200601075Handle · brokenPAX DOOR HANDLE BROKEN.Dec 3, 2006 · N837AS · Cndair CL6002B19 · Passenger/Crew DoorsSDR TRAX200600467Step · separatedBOTTOM STEP SEPARATING AT ATTACHED STAY ROD BRACKET TO STEP COMPOSITE.Jul 6, 2006 · N837AS · Cndair CL6002B19 · Passenger/Crew DoorsSDR TRAX200600251Step · brokenBOTTOM STEP BROKEN, FLT 4620 DEL 371 MINS.May 22, 2006 · N837AS · Cndair CL6002B19 · Passenger/Crew Doors
Back to N837AS, cancelled Jun 8, 2017