N790SK
Service difficulty reports · 105
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 = 'N790SK' 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 = 'N790SK' 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 SWIA2021072259738Seat Track · corroded*MULTIPLE SPOTS OF CORROSION ,SCRATCHES AND NICKS ON SEAT TRACK AT LBL9 BETWEEN FS847.00+16-FS969.00 (C-CHECK RO 7/20/2021) REMOVED & REPLACED WITH NEW SEAT TRACK AT LBL9 BETWEEN FS847.00+16-FS969.00 REF CRJ-700 AMM 53-00-49-400-801A03, SEE CONTINUATSDR SWIA2021072259737Seat Track · corroded*MULTIPLE SPOTS OF CORROSION ,SCRATCHES AND NICKS ON SEAT TRACK AT RBL9 BETWEEN FS847.00+16-FS969.00 (C-CHECK RO 7/20/2021) REPLACED THE SEAT TRACK ON RBL9 BETWEEN FS863.00 (FS847.00+16) AND FS969.00 WITH A SERVICABLE SEAT TRACK REFERENCING CRJ 700 AMSDR SWIA2021072259725Track · chafed* AFT BAG DOOR, FWD DOOR TRACK, LWR END, LWR DOOR ROLLER GUIDE "PLATE" HAS HEAVY "CHAFED" AREA (MARKED). (C-CHECK RO 7/20/2021) REMOVED AND INSTALLED NEW GUIDE PLATE P/N CC670-38810-1 ON AFT CARGO DOOR TRACK. REF: CRJ700 SRM 51-42-06-001-001-A01.SDR SWIA2021072259724Fitting · chafed* DURING DVI OF AFT BAG DOOR SURROUND INTERNAL STRUCTURE, FOUND (BOTH) FWD & AFT CROTCH FITTINGS TO HAVE MILD "CHAFED" AREA ON INBD EDGES (MARKED). (C-CHECK RO 7/20/2021) REMOVED MILD CHAFFING AND BURRS ON AFT BAGGAGE BAY DOOR SURROUND "CROTCH FITTINGS"SDR SWIA2021072259694Floorbeam · cracked* L/H COCKPIT FLOOR BEAM FOUND "CRACKED" AT LBL 12.00 AND F.S. 280.00 INTERFACE IN RADIUS (MARKED). (C-CHECK RO 7/20/2021) REMOVED AND REPLACED L/H COCKPIT FLOOR BEAM AT LBL 12.00 USING EXISTING INBOARD UPPER ANGLE, INBOARD LOWER ANGLE, LOWER ANGLE AND SDR SWIA2021072259693Former · corroded*PAX DOOR FWD FORMER CORRODED (C-CHECK RO 7/20/2021) REPLACED PAX DOOR FWD FORMER WITH NEW REF CRJ-700 SRM 52-11-06-001-001-A01, DWG# 601R31702 REV N. AND MHIRJ REO 670-52-11-1230 REV -- DATED 2021-05-05. COMPLIED WITH TASK CARD 51-900-1002-SKYSDR SWIA2021072259692Door Frame · corrodedPAX DOOR FWD FRAME FWD AND AFT SIDE BETWEEN INTERCOSTAL 4-5 CORRODED (C-CHECK RO 7/20/2021) REPLACED PAX DOOR CLIP (P/N: 601R319034-2) COMMON TO FRAME FS320 REF CRJ-700 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01 AND DWG 601R31702 REV N. COMPLIED WSDR SWIA2021072259691Door Sill · corroded*MULTIPLE SPOTS OF CORROSION NOTED ON ANGLE COMMON TO AFT CARGO DOOR SILL AT APPROX. FS1000.00-FS1047.00 (MARKED) (C-CHECK RO 7/20/2021) REPLACED THE AFT CARGO DOOR ANGLE COMMON TO SILL. REF CRJ700 SRM 51-42-06-001-001-A01, REF CRJ700 SRM 51-42-13-001-0SDR SWIA2021072259736Seat Track · corroded*LBL9 SEAT TRACK BETWEEN APPROX FS 677 AND FS 863 HAS EVIDENCE OF CORROSION IN AREAS AS MARKED. (C-CHECK RO 7/20/2021) REPLACED THE SEAT TRACK AT LBL9 BETWEEN APPROX FS677.00 TO FS863.00 WITH A SERVICEABLE SEAT TRACK (P/N=SH670-35864-5) REFERENCING CRJ SDR SWIA2021072259735Seat Track · corroded*RBL9 SEAT TRACK BETWEEN APPROX FS 677 AND FS 863 HAS EVIDENCE OF EXFOLIATION CORROSION IN AREAS AS MARKED. (C-CHECK RO 7/20/2021) REPLACED THE SEAT TRACK AT RBL9 BETWEEN APPROX FS677.00 TO FS863.00 WITH A SERVICABLE SEAT TRACK (P/N=SH670-35864-5) REFERSDR SWIA2021072259734Seat Track · corroded*RBL9 SEAT TRACK BETWEEN APPROX FS 591 AND FS 677 HAS EVIDENCE OF CORROSION IN AREAS AS MARKED. (C-CHECK RO 7/20/2021) REPLACED PASSENGER SEAT TRACK FROM FS591 - FS677 AT RBL9. REF CRJ700 AMM 53-00-49-400-801-A03.SDR SWIA2021072259733Seat Track · corroded*LBL9 SEAT TRACK BETWEEN APPROX FS 485 AND FS 591 HAS EVIDENCE OF CORROSION IN AREAS AS MARKED. (C-CHECK RO 7/20/2021) REPLACED THE SEAT TRACK ON LBL9 BETWEEN FS485.00 AND FS591.00 WITH A SERVICABLE SEAT TRACK REFERENCING CRJ 700 AMM 53-00-49-400-801-A0SDR SWIA2021072259732Seat Track · corroded*RBL9 SEAT TRACK BETWEEN APPROX FS 485 AND FS 591 HAS EVIDENCE OF EXFOLIATION CORROSION IN AREAS AS MARKED. (C-CHECK RO 7/20/2021) REPLACED THE SEAT TRACK ON RBL9 BETWEEN FS485.00 AND FS591.00 WITH A SERVICABLE SEAT TRACK REFERENCING CRJ 700 AMM 53-00-4SDR SWIA2021072259731Frame · corroded* FRAME UNDER AFT WING TO FUSELAGE FAIRING AT FS923.00 BETWEEN APROX. STR.25L AND STR.25R CORRODED IN MULTIPLE SPOTS (FLAGGED). (C-CHECK RO 7/20/2021) REMOVED AND REPLACED STRAP P/N SH670-39338-3 ON FRAME AFT WING TO FUSELAGE AT FS 923.00 BETWEEN APPROXSDR SWIA2021072259730Frame · corroded* FRAME UNDER AFT WING TO FUSELAGE FAIRING AT FS969.00 BETWEEN APROX. STR.25L AND STR.25R CORRODED IN MULTIPLE SPOTS (FLAGGED). (C-CHECK RO 7/20/2021) AFT-WING-TO-FUSELAGE SUPPORT STRUCTURE FRAME FLAGGED IS AT FS939. NO FAIRING SUPPORT STRUCTURE EXISTS SDR SWIA2021072259729Seat Track · corroded* PAX FLOOR SEAT TRACK CORRODED IN MUTIPLE SPOTS FROM FS364.00 TO FS485.00 AT LBL9 (MARKED). (C-CHECK RO 7/20/2021) REPLACED THE SEAT TRACK ON LBL9 BETWEEN FS364.00 AND FS485 WITH A SERVICABLE SEAT TRACK REFERENCING CRJ 700 AMM 53-00-49-400-801-A03. / TSDR SWIA2021072259728Seat Track · corroded* PAX FLOOR SEAT TRACK CORRODED IN MUTIPLE SPOTS FROM FS349.00 TO FS485.00 AT RBL9 (MARKED). (C-CHECK RO 7/20/2021) REPLACED PASSENGER SEAT TRACK FROM FS349 - FS485 AT RBL9. REF CRJ700 AMM 53-00-49-400-801-A03.SDR SWIA2021072259690Intercostal · corroded*RH BL2R INTERCOSTAL BETWEEN FS 349 AND FS 364 HAS EVIDENCE OF CORROSION AT OUTBOARD AFT SKIN FLANGE. (C-CHECK RO 7/20/2021) REPLACED INTERCOSTAL BETWEEN FS349 - FS364 STGR 26R REF CRJ-700 SRM 51-42-21-001-001-A01, 51-42-06-001-001-A01, AND DWG# SH670-3SDR SWIA2021072259689Intercostal · corroded*LH BL2L INTERCOSTAL BETWEEN FS 349 AND FS 364 HAS EVIDENCE OF CORROSION AT INBOARD AFT LOWER EDGE. (C-CHECK RO 7/20/2021) REPLACED INTERCOSTAL BETWEEN FS349-FS364, STGRS 26L-27 REF CRJ-700 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, DWG SH670-32050SDR SWIA2021072259688Intercostal · corroded*STRINGER 20R INTERCOSTAL HAS EVIDENCE OF CORROSION BETWEEN FS 310. TO FS 319.70 (C-CHECK RO 7/20/2021) REMOVED AND REPLACED INTERCOSTAL P/N SH670-32047-1 ON STRINGER 20R BETWEEN FS 310. TO FS319.70. REF: DWG# SH670-31950, REV A, CRJ 700, SRM 51-42-06-0SDR SWIA2021072259687Post · corroded*FS 280 LH BL12L POST HAS EVIDENCE OF CORROSION AT FLOOR LEVEL. (C-CHECK RO 7/20/2021) PERFORMED DOOR POST REPAIR AT FS280.00 LH BL 12L. REF CRJ700 SRM 53-11-10-201-006-A01. SEE CONTINUATION CARD FOR WORK PERFORMED. COMPLIED WITH SKYWEST TASKCARD 51-900SDR SWIA2021072259686Frame · corroded*FRAME FS 319 HAS EVIDENCE OF CORROSION ON FWD AND AFT SIDE AT STRINGER 21L AND AROUND GROUND STUDS AT STRINGER 20L. (C-CHECK RO 7/20/2021) REPLACED FRAME AT FS319 STGR 21L REF CRJ-700 SRM 51-42-06-001-001-A01 AND DWG SH670-31810 REV AE. COMPLIED WITH TSDR SWIA2021072259685Intercostal · corroded*STRINGER 21L INTERCOSTAL HAS EVIDENCE OF CORROSION BETWEEN FS 333 AND FS 349. (C-CHECK RO 7/20/2021) REMOVED AND REPLACED WITH NEW INTERCOSTAL STRINGER 21L BETWEEN FS 333 AND FS 349.REF CRJ-700 SRM 51-42-06-001-001-A01 AND DWG# SH670-31810 REV Y.PRESSSDR SWIA2021072259684Support Angle · corroded*CORROSION NOTED ON SUPPORT CLIP AT STRG26L FOR FRAME AT FS1015.00 (MARKED) (C-CHECK RO 7/20/2021) REMOVED & INSTALLED NEW SUPPORT CLIP AT STRG26L AND FS1015.00. REF CRJ700 SRM 51-42-06-001-001-A01 AND DWG# MM670-36062 REV E. / COMPLIED WITH TASKCARD 51SDR SWIA2021072259683Support Strap · corroded* SERVICE DOOR SURROUND LOWER FWD SUPPORT STRAP HAS SPOTS OF CORROSION AT APOX. FS319.70 (MARKED) (C-CHECK RO 7/20/2021) REMOVED AND REPLACED FITTING PN# SWH670-31990-1 AT FS 319 STR 17R PER REFERENCE DRAWING# SH670-31950 REV Y AND CRJ 700 SRM 51-42-2SDR SWIA2021072259682Floor Support · corroded* RH FLOOR SILL BETWEEN FS 280.00 AND FS295.00 HAS MULTIPLE SPOTS OF CORROSION (MARKED). (C-CHECK RO 7/20/2021) RH FLOOR SILL BETWEEN FS 280.00 AND FS295.00 FOUND OUT OF LIMITS IN REF CRJ700 SRM 53-00-45-201-001-A01, REMOVED AND REPLACED NEW FLOOR SILSDR SWIA2021072259681Antenna · corroded* TCAS ANTENNA HAS CORROSION INTERNALLY AROUND CANNON PLUG CUTOUT AT APROX. FS295.00 STR.27 (C-CHECK RO 7/20/2021) REMOVED AND REPLACED TCAS INNER CHANNEL AT FS295, STGR 27. REF. CRJ700 SRM 51-42-21-001-001-A01 & DWG#SH670-30023 REV G. COMPLIED 51-900-1SDR SWIA2021072259680Floorbeam · corroded* COCK PIT FLOOR PANEL AFT SUPPORT ANGLE CORRODED AT FS280.00 (MARKED). (C-CHECK RO 7/20/2021) REMOVED AND REPLACED F.S.280.00 COCKPIT AFT FLOOR SUPPORT ANGLE DUE TO OUT OF LIMIT CORROSION IN REF DWG CC670-33052, REV G, CRJ700 SRM 51-42-06-001-001-A01 ASDR SWIA2021072259679Floor Support · corroded* RH FLOOR SILL AFT OF SEVICE DOOR BETWEEN APROX. FS349.00 AND FS364.00 HAS SPOTS OF CORROSION (MARKED). (C-CHECK RO 7/20/2021) COMPLIED WITH REO 670-53-21-2020 REV -A DATED 2021-05-11 TO REPAIR RH FLOOR SILL AFT OF SEVICE DOOR BETWEEN APROX. FS349.00 SDR SWIA2021072259723Coaming · chafed* AFT CARGO DOOR COMING CHAFED IN UPPER AFT CORNER (MARKED). (C-CHECK RO 7/20/2021) REMOVED AND REPLACED AFT CARGO DOOR UPPER COMING P/N MM670-35698-001 CRJ700 SRM 51-41-02-001-001-A01AND SRM 53-61-23-201-001-A01. NO LEAKS NOTED.SDR SWIA2021072259678Door Sill · corroded* PAX DOOR LOWER SILL CORRODED IN MULTIPLE SPOTS BETWEEN FS310.00 AND FS349.00 (MARKED). (C-CHECK RO 7/20/2021) REPLACED PAX DOOR LOWER SILL WITH NEW SILL AT FS310-FS349 REF CRJ-700 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, AND DWG SH670-31810 REVSDR SWIA2021072259722Fitting · chafed* CREW ESCAPE HATCH FWD FITTINGS ARE CHAFFED. FLAGGED (C-CHECK RO 7/20/2021) REMOVED AND REPLACED CREW ESCAPE HATCH FWD FITTINGS(2EA.) REF. CRJ-700 SRM 51-41-02-001-001-A01. PERFORMED FUNCTIONAL TEST OF THE CREW ESCAPE HATCH REF. CRJ-700 AMM 52-22-00-7SDR SWIA2021072259727Hinge · crackedSERVICE DOOR - UPPER HINGE BRKT CRACKED AT ADJUSTABLE ROD FITTING - AS MARKED (C-CHECK RO 7/20/2021) REMOVED AND REPLACED UPPER BRACKET P/N CC670-38380-1 ON SERVICE DOOR. REF: CRJ 700, AMM 52-41-27-400-801-A01.SDR SWIA2021072259721Seal · deformed* FWD BAGGAGE BAY DOOR HAS SMALL CUT, DEFORMATION AND TEAR COMMON TO LOWER EDGE AND FWD CORNER (C-CHECK RO 7/20/2021) INSTALLED NEW SEAL ON FWD BAG BAY DOOR REF: CRJ700 AMM. 52-35-07-400-802-A01 CALIBRATED TOOL #TUC5600 DUE CAL: 28 FEB 22. NO LEAKS NOTESDR SWIA2021072259677Deck Plate · crackedFWD EQUIPMENT COMPARTMENT - R/H SIDE - DECK CRACKED UNDER ADG HAND PUMP - VISIBLE FROM ADG COMPARTMENT ONLY - AS MARKED (C-CHECK RO 7/20/2021) REPAIRED FWD EQUIPMENT COMPARTMENT, FS193 ELECTRICAL BAY FLOOR (DECK) RHS, REF REO 670-53-11-1688 REV-A DATEDSDR SWIA2021072259676Stringer · gouged*STGR 7R HAS WEAR /GOUGE BETWEEN FS 1144.00 - 1162.00 IN AFT EQUIPMENT BAY (C-CHECK RO 7/20/2021) REPAIRED STGR 7R HAS WEAR /GOUGE BETWEEN FS 1144.00 - 1162.00 IN AFT EQUIPMENT BAY REF CRJ-700 SRM 53-00-03-201-004-A01.OP'S TEST & LEAK CHECK A/C DISTRIBUSDR SWIA2021072259675Skin · dented*(DENT W/GOUGE) DETECTED R/H FUSELAGE SKIN, APROX 6" (FWD) F.S. 969.00 AND APROX 1" ABOVE STGR 17R/ WL 72.50. REQUIRES EVALUATION (MARKED). (C-CHECK RO 7/20/2021) (C-CHECK RO 7/20/2021) PERFORMED CUT-OUT DOUBLER REPAIR ON THE RH FUSELAGE SKIN BESDR SWIA2017102743930Skin · chafedRIGHT WING INBD FLAP PANEL 684GB CHAFED. REMOVED AND REPLACED THE PANEL IAW SRM.SDR SWIA2017102743929Skin · dentedRIGHT WING, INBD FLAP LOWER SKIN DENTED. REPAIRED IAW SRM.SDR SWIA201743928Attach Angle · corrodedLEFT ATTACH ANGLE BETWEEN BS 349 AND 364, STRINGER 26L CORRODED. INSTALLED A NEW ATTACH ANGLE IAW SRM.SDR SWIA2017102743927Frame · corrodedFRAME AT BS 333 BETWEEN STRINGER 26L AND 26R CORRODED. REMOVED AND REPLACED THE FRAME IAW REO.SDR SWIA201743926Frame · corrodedFRAME AT BS 319.7 BETWEEN STRINGER 25L AND 26R CORRODED. REMOVED AND REPLACED THE FRAME IAW REO.SDR SWIA201541670Angle · corrodedPASSENGER DOOR MID CAP ANGLE HAS EVIDENCE OF CORROSION. R & R PAX DOOR MID CAP ANGLE IAW SRM.SDR SWIA201438767Control Unit · failedSTAB TRIM RUNAWAY AT CRUISE, DIVERTED. REMOVED AND REPLACED SSCU 1 & 2. IAW AMM.SDR SWIA201438089Floorbeam · crackedFS 280, FLOORBEAM UPPER FLANGE CRACKED BETWEEN LBL 13.8 AND RBL 13.8. C-CHECK, R & R FS 280 FLOORBEAM ANGLES IAW SRM.SDR SWIA201438090Skin · chafedCHAFING ON SKIN S27 BS 977-985. C-CHECK, REPAIRED SKIN IAW REO AND MODSUM.SDR SWIA201438092Skin · dentedLEFT INBD FLAP UPPER SKIN HAS DENT LOCATED IN THE MIDDLE OF THE FLAP AROUND FLS 51.00. C-CHECK, ACCOMPLISHED PERMANENT REPAIR TO LT INBD FLAP UPPER SKIN DENT LOCATED NEAR FLS 51 IAW STS EA.SDR SWIA201438091Panel · chafedPANEL 599AB IS CHAFED. C-CHECK, REPLACED PANEL 599AB WITH NEW IAW SRM.SDR SWIA201335564Battery · dischargedEMERGENCY LIGHTS IN THE GALLEY DO NOT ILLUMINATE. FLT 6390 REPLACED FWD EMERGENCY LIGHTS BATTERY ASSEMBLY. PN 2013-1A ON 57039 SN OFF 75039.SDR SWIA201335505Lens · missingEMERGENCY EXIT SIGN IN GALLEY IS MISSING. FLT 5595 REPLACED EMERGENCY LIGHT LENS COVER AT FLOOR FLOOD LIGHT AT SERVICE DOOR.
Back to N790SK