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.
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
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 ASOA201100083Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED AT DOOR ASSIST PULLEY. REPAIRED PAX DOOR AFT DRAG ANGLE IAW REO 601R-52-11-513.SDR 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)SDR 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.SDR 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.SDR 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.SDR 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.SDR 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 REPAIRSDR 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 REPLACEDSDR 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 DSDR 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 BUSDR 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. (CLOSESDR 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)SDR 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.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.SDR ASOA20100030Battery · deterioratedR & R BATTERIES IN CAPT'S FLASHLIGHT IAW AMM 25-61-00. (CLOSED)SDR ASOA201000030Flashlight · inoperativeCAPTAIN'S EMERGENCY FLASHLIGHT INOP.SDR ASOA200901010Light · inoperativeEMERGENCY FLOODLIGHT AT PAX DOOR INOP.SDR ASOA200900965Light · inoperativeRIGHT NR 4 EXTERIOR EMERGENCY LIGHT INOP.SDR 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.SDR 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.SDR ASOA200900162Light · brokenEMERGENCY EXIT LIGHT ON WARDROBE IS BROKEN.SDR ASOA200900159Light · inoperativeEMERGENCY LIGHTS IN FWD CABIN ARE INOP.SDR ASOA200900120Anchor Fitting · crackedPAX DOOR FWD ANCHOR FITTING IS CRACKED.SDR 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.SDR ASOA200900129Bulkhead · damagedREAR PRESSURE BULKHEAD WEB THAT SURROUND THE LINTEL ATTACHMENT FITTING HAS A INDICATION NOTED APPROX .1" IN LENGTH 70% FSH FAILED NDT INSP.SDR 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 SDR 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-41SDR 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.SDR ASOA200900068Placard · wornPAX DOOR EXIT PLACARD IS WORN.SDR TRAX200800866Step · crackedPAX DOOR LOWER STEP CRACKED. REMOVED AND REPLACED LOWER PAX DOOR STEP IAW AMM 52-11-04. (B)SDR TRAX200800292Window · crackedF/O SIDE WINDOW SHATTERED AT FL250. AIRCRAFT RETURNED TO ATL AFTER T/O. EMERGENCY DECLARED.SDR 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.SDR TRAX200701203Flap · failedFLAPS FAIL CAUTION AT 14K FT WHILE CLIMBING OUT OF ATL. EMERGENCY DECLARED.SDR 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.SDR 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.SDR 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-0SDR 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.SDR 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 DUPLSDR 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.SDR 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.SDR TRAX200700428Angle · crackedRIGHT FS 484 RBL 27 ANGLE CRACKED.SDR 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.SDR 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.SDR 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.SDR TRAX200700374Placard · wornEMERGENCY EXIT ARROW ON WARDROBE WORN. REMOVED WORN EMERGENCY EXIT ARROW. INSTALLED SERVICEABLE EMERGENCY EXIT ARROW IAW CRJ AMM 11-30-02.SDR TRAX200700173Flap System · malfunctionedFLAPS FAIL CAUTION MSG AT 0 DEG ON APPROACH TO YYZ, FOLLOWED QRH, LANDED UNEVENTFUL. EMERGENCY DECLARED.SDR TRAX200601088Light · inoperativeEMERGENCY LIGHTS WILL NOT COME ON.SDR TRAX200601075Handle · brokenPAX DOOR HANDLE BROKEN.SDR TRAX200600467Step · separatedBOTTOM STEP SEPARATING AT ATTACHED STAY ROD BRACKET TO STEP COMPOSITE.SDR TRAX200600251Step · brokenBOTTOM STEP BROKEN, FLT 4620 DEL 371 MINS.
Back to N837AS, cancelled Jun 8, 2017