N823SK
Service difficulty reports · 178
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 = 'N823SK' AND registry_match = 'registration' 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 = 'N823SK' AND registry_match = 'registration' 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 SWIA202164377None · corroded* THE MONUMENT FITTING BETWEEN FS364 AND FS379 AND BETWEEN LBL27 AND THE LH FLOOR SILL HAS CORROSION. (MARKED) (C-CHECK RO 2/16/2022) REMOVED AND REPLACED WITH NEW MONUMENT FITTING BETWEEN FS364 AND FS379 LBL27 AND LH FLOOR SILL REF CRJ900 SRM 51-42-06SDR SWIA202164376None · corroded* THE MONUMENT FITTING BETWEEN FS364 AND FS379 AND LBL9 AND LBL27 HAS CORROSION. (MARKED) (C-CHECK RO 2/16/2022) REMOVED AND REPLACED WITH NEW MONUMENT FITTING BETWEEN FS364 AND FS379 LBL9 AND LBL27 REF CRJ900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-SDR SWIA202164375None · corroded* THE RH FLOOR SILL HAS MULTIPLE LOCATIONS OF CORROSION BETWEEN FS280 AND FS319. (MARKED) (C-CHECK RO 2/16/2022) REMOVED DAMAGE AND EVALUATED REPAIR. REPAIR FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED DAMAGED DOUBLER AND SILL. REF. CRJ900 SRM 51-42SDR SWIA202164374None · corroded* THE FS280 CROSSBEAM HAS CORROSION AT LBL9 WHERE IT ATTACHES TO THE ANGLE. (MARKED) (C-CHECK RO 2/16/2022) REMOVED DAMAGED L/H FS280.00 CROSSBEAM AND REPLACED WITH NEW. REF. REO#670-53-11-594 REV -A DATE 2015/06/26, DWG CC670-34010 REV -K, CRJ900 SRMSDR SWIA202164373None · corroded* THE FS280 FLOOR PANEL SUPPORT ANGLE HAS MULTIPLE LOCATIONS OF CORROSION. (MARKED) (C-CHECK RO 2/16/2022) REMOVED AND REPLACED THE FS280 FLOOR SUPPORT ANGLE P/N:CC670-34095-1 WITH NEW REF. CRJ900 SRM 51-42-06-001-001-A01, AND CRJ900 SRM 51-42-21-001-0SDR SWIA202164372None · corroded*MAIN AVIONICS BAY FWD WATER-WASTE SURROUND STRUCTURE UPPER DIAPHRAM CORRODED. (C-CHECK RO 2/16/2022) REMOVED AND REPLACED DAMAGED FWD WASTE WATER SURROUND STRUCTURE DIAPHRAGM. REF. DRWG SH670-32280 REV. H AND CRJ 900 SRM 51-42-06-001-001-A01 REV. 38 DASDR SWIA202164371None · gouged*AFT BAGGAGE BAY DOOR, FWD FLOOR SUPPORT SPLICE/JOINT IS GOUGED. FLAGGED (C-CHECK RO 2/16/2022) REMOVED DAMAGE AND EVALUATED REPAIR. REPAIR FOUND TO BE WITHIN LIMITS. REF. MHIRJ REO 690-53-61-1054 REV --, 2022-01-08. CRJ 900 SRM 51-42-21-001-001-A01 DSDR SWIA202164370None · scratchedPASSENGER DOOR HINGE (FUSELAGE SIDE) HAS MULTIPLE SCRATCHES AND PIN HOLES (C-CHECK RO 2/16/2022) REMOVED AND REPLACED PASSENGER DOOR HINGE (FUSELAGE SIDE). REF: CRJ-900 SRM 53-21-23-201-007-A01 AND DWG SH670-31810 REV AE. COMPLIED WITH SKYWEST TASK CASDR SWIA202164369None · scratchedPASSENGER DOOR HINGE (DOOR SIDE) HAS MULTIPLE SCRATCHES AND PIN HOLES (C-CHECK RO 2/16/2022) REMOVED AND REPLACED WITH NEW PAX DOOR HINGE HALF PER REFERENCE CRJ 900 SRM 52-11-01-201-002-A01 STEP 4R AND 4T AND DRAWING 601R31702 REV N. COMPLIED WITH SKYWSDR SWIA202164368None · corroded*INTERCOSTAL BELOW GALLEY SERVICE DOOR AT STGR 20 HAS CORROSION FROM FS310 TO FS 319. (C-CHECK RO 2/16/2022) REMOVED AND REPLACED STR 20R INTERCOSTAL FROM FS310.00 TO FS319.70 REF. DRWG SH670-31950 REV. Y AND CRJ 900 SRM 51-42-06-001-001-A01. COMPLIED WSDR SWIA202164367None · corroded*R/H FWD JACK FITTING SUPPORT (INTERCOSTAL) FROM FS265 TO FS280 HAS CORROSION. (C-CHECK RO 2/16/2022) INSTALLED RH FWD JACK FITTING SUPPORT (INTERCOSTAL) BETWEEN FS265.00 AND FS280.00 REF. CRJ 900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DSDR SWIA202164366None · corroded*L/H FWD JACK FITTING SUPPORT (INTERCOSTAL) FROM FS265 TO FS280 HAS CORROSION. (C-CHECK RO 2/16/2022) INSTALLED LH FWD JACK FITTING SUPPORT (INTERCOSTAL) BETWEEN FS265.00 AND FS280.00 REF. CRJ 900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DSDR SWIA202164365None · cracked*RH ENGINE LOWER TRANSCOWL OTBD A-BRACKET IS CRACKED (C-CHECK RO 2/16/2022) REMOVED AND REPLACED NEW A-BRACKET P/N CN624-2082-201 ON OUTBD SIDE OF RH LOWER TRANSCOWL. REF. AND COMPLIED WITH REO 670-54-21-971 REV A, DATED 2017-05-11 AND SKY WEST TASK CARSDR SWIA202164364None · cracked*RH ENGINE LOWER TRANSCOWL INBD A-BRACKET IS CRACKED (C-CHECK RO 2/16/2022) REMOVED AND REPLACED NEW A-BRACKET P/N CN624-2082-201 ON INBD SIDE OF RH LOWER TRANSCOWL. REF. AND COMPLIED WITH REO 670-54-21-971 REV A, DATED 2017-05-11 AND SKY WEST TASK CARDSDR SWIA202164363None · missing*RH ENGINE LOWER TRANSCOWL LOWER Z-CHANNEL/BRACKET HAS MISSING AND LOOSE FASTENERS (C-CHECK RO 2/16/2022) PERFORMED REPAIR TO CRACK ON INNER PERFORATED SKIN UNDER Z- STIFFENER. REF. REO 690-54-21-406 REV --,DATED 2022-01-19 AND COMPLIED WITH SKY WEST TSDR SWIA202164362None · chafed*RH ENGINE LOWER TRANSCOWL LATCH DOOR COAMING HAS CHAFING (MARKED) (C-CHECK RO 2/16/2022) INSTALLED NEW LATCH DOOR COAMING P/N CN624-2060-209, 2 EA NEW BEARING PADS P/N CN624-2130-201, AND NEW DOUBLER P/N CN624-2068-209. REF. AND COMPLIED WITH REO 670-5SDR SWIA202164361None · cracked*RH ENGINE UPPER TRANSCOWL OTBD A-BRACKET IS CRACKED (C-CHECK RO 2/16/2022) REMOVED AND REPLACED RH ENGINE UPPER TRANSCOWL O/B "A" BRACKET P/N CN624-2082-201. REF. CRJ900 SRM 51-42-10-001-001-A01 AND REO 670-54-21-971, REV A, DATED 2017/05/11. WEIGHT RESDR SWIA202164360None · cracked*RH ENGINE UPPER TRANSCOWL INBD A-BRACKET IS CRACKED (C-CHECK RO 2/16/2022) REMOVED AND REPLACED RH ENGINE UPPER TRANSCOWL I/B "A" BRACKET P/N CN624-2082-201. REF. CRJ900 SRM 51-42-10-001-001-A01 AND REO 670-54-21-971, REV A, DATED 2017/05/11. WEIGHT RESDR SWIA202164359None · chafed*RH ENGINE UPPER TRANSCOWL LATCH DOOR COAMING IS CHAFED (MARKED) (C-CHECK RO 2/16/2022) PERFORMED REPAIR TO RH ENGINE UPPER TRANSCOWL LATCH DOOR COAMING IAW ALL STEPS OF REO 690-54-21-407 REV --, DATED 2022-01-28/COMPLIED WITH SKY WEST TASK CARD 51-900-SDR SWIA202164358None · cracked*LH ENGINE LOWER TRANSCOWL INBD A-BRACKET IS CRACKED (C-CHECK RO 2/16/2022) REMOVED AND REPLACED L/H ENGINE LOWER TRANSCOWL "A" BRACKET (PN CN624-2082-201) REF REO# 670-54-21-971, REV A, DATED 5/11//17. WEIGHT ON/WEIGHT OFF OF PARTS. DAMAGED PART WEIGHESDR SWIA202164357None · chafed*LH ENGINE LOWER TRANSCOWL LATCH DOOR COAMING IS CHAFED (MARKED) (C-CHECK RO 2/16/2022) PERMEANANTLY REPAIRED LOWER TRANSCOWL LATCH COAMING REF MHIRJ REO 690-54-21-405 REV -- 2022-01-18 / C/W TASK CARD 51-900-1002-SKYSDR SWIA202164356None · cracked*LH ENGINE UPPER TRANSCOWL OTBD A-BRACKET IS CRACKED (C-CHECK RO 2/16/2022) REMOVED AND REPLACED L/H ENGINE UPPER TRANSCOWL O/B "A" BRACKET (PN CN624-2082-201) REF REO# 670-54-21-971, REV A, DATED 5/11/17. WEIGHT ON/WEIGHT OFF OF DAMAGED AND NEW PARTS ISDR SWIA202164355None · cracked*LH ENGINE UPPER TRANSCOWL INBD A-BRACKET IS CRACKED (C-CHECK RO 2/16/2022) REMOVED AND REPLACED L/H ENGINE UPPER TRANSCOWL I/B "A" BRACKET (PN CN624-2082-201) REF REO# 670-54-21-971, REV A, DATED 5/11/17. WEIGHT ON/WEIGHT OFF OF DAMAGED AND NEW PARTS ISDR SWIA202164354None · chafed*LH ENGINE UPPER TRANSCOWL LATCH DOOR COAMING IS CHAFED (MARKED) (C-CHECK RO 2/16/2022) REMOVED AND REPLACED L/H ENGINE UPPER TRANSCOWL LATCH DOOR COAMING REF REO# 670-54-21-1207, REV A, DATED 8/27/15. COMPLIED FULLY W/SKYCARD 51-900-1002-SKY.SDR SWIA202164353None · chafed*EXTERNAL SKIN UNDER THE AFT CARGO DOOR PROTECTOR PLATE HAS MULTIPLE AREAS OF CHAFFING (MARKED) (C-CHECK RO 2/16/2022) REPAIRED EXTERNAL SKIN UNDER AFT CARGO DOOR PROTECTOR PLATE IAW REO 690-53-61-1055 REV -- DATE 2021-12-27 STEPS. 1-4 (SEE CONTINUATIONSDR SWIA202164352None · gougedLOWER FUSELAGE EXTERNAL SKIN JUST AFT OF FS 942.00 AT APPROX STR 27 AT EXISTING DOUBLER THERE IS DEEP GOUGING AND WEAR CAUSED BY FAIRING. (C-CHECK RO 2/16/2022) PERFORMED PERMANENT REPAIR ON STGR27 AT APPROX. FS942.00. REF. REO 670-53-00-290 REV -F DATSDR SWIA202164351None · gougedPAX DOOR ENTRY SURROUND AFT UPPER LATCH CAM HAS DEEP WEAR GOUGE. (C-CHECK RO 2/16/2022) BLENDED CHAFE AREA ON PAX DOOR SURROUND UPPER AFT LATCH CAM FITTING REF. CRJ-900 SRM, 51-12-00-001-001-A01. FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED WITH NEWSDR SWIA202164350None · corrodedAFT CARGO DOOR FLOOR SILL HAS AREAS OF CORROSION. (C-CHECK RO 2/16/2022) REMOVED AND INSTALLED NEW AFT CARGO FLOOR SILL P/N: MM670-35655-003. REF CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 51-42-10-001-001-A01, CRJ900 SRM 51-42-21-001-001-A01 AND DWG MSDR SWIA202164349None · chafed*CENTER BAGGAGE BAY DOOR INNER SKIN IS CHAFED AT THE AFT INBD CORNER. LOCATIN FLAGGED. (C-CHECK RO 2/16/2022) REPAIRED CENTER BAGGAGE BAY DOOR INNER SKIN AT THE AFT INBD CORNER REF REO 690-52-35-293 REV.-- DATED 2021-12-30 ALL STEPS COMPLETED. COMPLIED SDR SWIA202164348None · chafed*CENTER BAGGAGE BAY DOOR INNER SKIN IS CHAFED AT THE FWD INBD CORNER. LOCATIN FLAGGED. (C-CHECK RO 2/16/2022) BLENDED CENTER BAGGAGE BAY DOOR INNER SKIN AT FWD INBD CORNER REF. CRJ900 SRM 51-12-00-001-001-A01. REPAIRED CENTER BAGGAGE BAY DOOR INNER SKINSDR SWIA202164347None · corroded*ATTACH ANGLE IN L/H INBD WING DRY-BAY HAS AREA OF CORROSION. LOCATION IS IN THE WHEEL WELL OTBD FWD AREA. (C-CHECK RO 2/16/2022) REMOVED AND REPLACED ATTACH ANGLE IN LH INBD WING DRY BAY. REF CRJ-900 SRM 51-42-21-001-001-A01 AND CRJ 900 SRM 51-42-06-00SDR SWIA202164346None · chafed*L/H INBD FLAP LWR SKIN IS CHAFED AT LOCATION OF OTBD HINGE FAIRING (C-CHECK RO 2/16/2022) .BLENDED OUT CHAFFING ON LOWER SKIN LH I/B FLAP REF. CRJ-900 SRM, 51-12-00-001-001-A01. REPAIRED THE L/H I/B LWR SKIN AT THE O/B HINGE FAIRING PER MHIRJ REO 690-5SDR SWIA202164345None · chafed*L/H INBD FLAP LWR SKIN IS CHAFED AT LOCATION OF INBD HINGE FAIRING. (C-CHECK RO 2/16/2022) BLENDED OUT CHAFFING ON LOWER SKIN LH I/B FLAP REF. CRJ-900 SRM, 51-12-00-001-001-A01. REPAIRED THE L/H I/B FLAP LWR SKIN AT THE I/B HINGE FAIRING PER MHIRJ REOSDR SWIA202155398Skin · puncturedAIRCRAFT SKIN PUNCTURED AT THE LOWER FUSELAGE JUST AFT OF AFT CARGO DOOR OUT OF LIMITS, REF CP22129929 (DAMAGE BETWEEN FS 1051.30 AND FS 1069.75 BETWEEN STGR 23LT AND STRG 24LT). FILED CLOSED. COMPLIED WITH REO 690-53-61-969-REV- DATED 01/14/2021 AND TASK CASDR SWIA201844341Selector Valve · failedGEAR DISAGREE AFTER TAKE OFF. NOSE AND MAIN GEAR DID NOT COME UP. REMOVED AND REPLACED THE MLG SELECTOR VALVE AND LDG GEAR SELECTOR HANDLE. OPS CHECKED GOOD.SDR SWIA201844210Skin · scratchedSERVICE DOOR OUTER SKIN HAS A SCRATCH IN MIDDLE OF THE DOOR. COMPLIED WITH ALL THE STEPS OF REO REPAIRED THE SERVICE DOOR OUTER SKIN.SDR SWIA201844199Floorbeam · corrodedCARGO FLOORBEAM CORRODED AT BS 1020, LBL 27. REPAIRED THE FLOORBEAM IAW REO.SDR SWIA201844209Stringer · corrodedMAIN AVIONICS BAY STRINGER 27 CORRODED FROM BS 306 TO 333. REMOVED AND INSTALLED A NEW STRINGER IAW SRM.SDR SWIA201844208Stringer · corrodedMAIN AVIONICS BAY STRINGER 25R, BS 333 TO 364 CORRODED. REMOVED AND INSTALLED A NEW STRINGER IAW SRM.SDR SWIA201844207Stringer · corrodedMAIN AVIONICS BAY STRINGER 26R FROM BS 333 TO 364 CORRODED. REMOVED AND INSTALLED A NEW STRINGER IAW SRM.SDR SWIA201844206Stringer · corrodedMAIN AVIONICS BAY STRINGER 26L FROM BS 333 TO 364 CORRODED. REMOVED AND INSTALLED A NEW STRINGER IAW SRM.SDR SWIA201844205Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT BS 333 CORRODED BETWEEN STRINGERS 26L AND 26R. REMOVED AND INSTALLED A NEW SECTION FRAME, REINFORCEMENT ANGLE AND STRINGER CLEATS IAW REO.SDR SWIA201844204Buttstrap · corrodedMAIN AVIONICS BAY BUTTSTRAP AT BS 333 CORRODED BETWEEN STRINGERS 26L AND 26R. BLENDED THE CORROSION TO THE BUTTSTRAP. PERFORMED ALL STEPS OF REO.SDR SWIA201844203Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT BS 319 CORRODED BETWEEN STRINGERS 26L AND 26R. REMOVED AND INSTALLED NEW SECTION LOWER FRAME AND STRINGER CLEATS IAW REO.SDR SWIA201844202Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT BS 310 CORRODED BETWEEN STRINGERS 26L AND 27L. REMOVED AND THE SECTION OF THE FRAME, REINFORCEMENT ANGLE AND STRINGER CLEATS IAW REO.SDR SWIA201844201Stringer · corrodedMAIN AVIONICS BAY STRINGER 26R FROM BS 280 TO 333 CORRODED. REMOVED AND REPLACED THE STRINGER IAW SRM.SDR SWIA201844200Stringer · corrodedMAIN AVIONICS BAY STRINGER 26L FROM BS 280 TO 333 FOUND CORRODED. REMOVED AND REPLACED THE STRINGER IAW SRM.SDR SWIA201844198Intercostal · crackedPAX DOOR FWD INTERCOSTAL IS CRACKED AT FLANGE COMMON TO INNER SKIN. REMOVED AND INSTALLED A NEW PAX DOOR INTERCOSTAL IAW SRM. COMPLIED WITH A LEAK CHECK OF REPAIRED AREA IAW AMM. NO LEAKS WERE NOTED. LEAK CHECKED GOOD.SDR SWIA201541527Web · corrodedSERVICE DOOR FWD FLOOR WEB PROTECTOR CORRODED. R & R A NEW FLOOR WEB PROTECTOR, PN SH670-32040-3 IAW SRM.SDR SWIA201541521Frame · corrodedLOWER FRAME AT BS 295 REQUIRES REPAIR DUE TO CORROSION. COMPLIED WITH PERMANENT REPAIR TO THE FS 295.00 LOWER FRAME IAW REO.
Back to N823SK