N791SK
Service difficulty reports · 128
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 = 'N791SK' 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 = 'N791SK' 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 SWIA202157241Seat Track · damagedREMOVE AND REPLACE SIDE SEAT RAIL BETWEEN F863.00 TO FS953.00 ON RIGHTHAND SIDE (C-CHECK RO 4/1/2021) REMOVED AND REPLACED SIDE SEAT RAIL BETWEEN FS863.00 AND FS953.00 IAW CRJ700 AMM 53-00-49-400-801-A03.SDR SWIA202157240Seat Track · damagedREMOVE AND REPLACE SIDE SEAT RAIL BETWEEN FS785.15 TO FS863.00 ON RIGHTHAND SIDE (C-CHECK RO 4/1/2021) REMOVED AND REPLACED RH SIDE SEAT RAIL BETWEEN FS785.15 AND FS 863.00 REF. CRJ-700 AMM, 53-00-49-000-801-A03 AND CRJ700 AMM 53-00-49-400-801-A03.SDR SWIA202157229Seat Track · corrodedSEAT TRACK ON LBL9 FROM FS847.00 TO FS988.00 HAS CORROSION AND DAMAGE. (C-CHECK RO 4/1/2021) REMOVED AND REPLACED SEAT TRACK P/N: SH670-37420-7 PO: T58846 ON LBL9 FROM FS847.00 TO FS988.00 REF. CRJ700 AMM 53-00-49-400-801-A03.SDR SWIA202157228Seat Track · corrodedSEAT TRACK LOCATED ON LBL9 FROM FS677.00 TO FS847.00 HAS CORROSION AND DAMAGE (C-CHECK RO 4/1/2021) REMOVED AND INSTALLED NEW SEAT TRACK LOCATED ON LBL9 FROM FS677.00 TO FS847.00 P/N SH670-35864-5. REF CRJ-700 AMM 53-00-49-400-801 (CONFIG A03), TOOL TUC78SDR SWIA202157227Seat Track · corrodedSEAT TRACK ON RBL9 FROM FS847.00 TO FS977.00 HAS CORROSION AND DAMAGE (C-CHECK RO 4/1/2021) REMOVED AND REPLACED SEAT TRACK AT RBL 9 FROM STA 847-977 IAW CRJ700 AMM 53-00-49-400-801-A09 AND CRJ700 AMM 53-00-49-000-801-A03SDR SWIA202157226Seat Track · corrodedSEAT TRACK LOCATED ON RBL9 FROM FS677.00 TO FS847.00 HAS CORROSION AND DAMAGE (C-CHECK RO 4/1/2021) REMOVED AND REPLACED SEAT TRACK SECTION ON RBL 9 FROM FS677 TO FS847.00 IAW CRJ700 AMM 53-00-49-400-801 A03SDR SWIA202157225Seat Track · corrodedSEAT TRACK ON RBL9 FROM FS581.00 TO FS677.00 HAS CORROSION AND DAMAGE (C-CHECK RO 4/1/2021) REMOVED AND REPLACED SEAT TRACK P/N: SH670-33425-5 PO: T58673 ON RBL9 FROM FS581.00 TO FS677.00 REF. CRJ700 AMM 53-00-49-400-801-A03SDR SWIA202157224Seat Track · corrodedSEAT TRACK ON RBL9 FROM FS485.00 TO FS581.00 HAS CORROSION AND DAMAGE (C-CHECK RO 4/1/2021) REMOVED AND REPLACED SEAT TRACK AT RBL 9, FS485.00 TO FS581.00 IAW CRJ700 AMM 53-00-49-400-801-A03.SDR SWIA202157223Seat Track · corrodedSEAT TRACK ON RBL9 FROM FS349.00 TO 485.00 HAS CORROSION AND DAMAGE (C-CHECK RO 4/1/2021) REMOVED AND REPLACED SEAT RAIL ON RBL9 FROM FS349.00 TO FS485.00 IAW CRJ700 AMM 53-00-49-400-801-A03SDR SWIA202157222Support Fitting · corroded* LH WING OTBD FLAP HINGE BOX FWD SUPPORT FITTING AT APPROXIMATELY WS264 HAS CORRODED HARDWARE (C-CHECK RO 4/1/2021) REMOVED AND REPLACED FORWARD SUPPORT FITTING BOLT AND HARDWARE AT APPROX. WS264. REF CRJ 700 AMM 57-54-02-000-805 (CONFIG A01) & 57-54-02SDR SWIA202157221Structure · corroded* LH INBD GROUND SPOILER TO PCU HARDWARE IS CORRODED (C-CHECK RO 4/1/2021) LH INBD GROUND SPOILER TO PCU HARDWARE REPLACED WITH NEW. REF CRJ 700 AMM 27-63-01-400-801-A01 STEPS 4.A. (1-4 & 10).SDR SWIA202157173Intercostal · crackedNOSE HYDRAULIC COMPARTMENT - INTERCOSTAL @ TOP / CEILING OF COMPARTMENT @ APROX FS 184 / LBL22 IS CRACKED @ CORNER RADIUS AS MARKED (C-CHECK RO 4/1/2021) REMOVED AND REPLACED NOSE HYDRAULIC COMPARTMENT INTERCOSTAL AND CLEAT @ TOP OF CEILING @ APX FS 184 /SDR SWIA202157172Post · corrodedFS280 DOOR POST IS CORRODED AT RBL9, BOTTOM SECTION (C-CHECK RO 4/1/2021) .REPAIRED FS.280 DOOR POST AT RBL9 BOTTOM SECTION REF. MHIRJ REO 670-53-11-1672 REV.--, DATED 2021-03-15. COMPLIED WITH SKYWEST CARD 51-900-1002-SKY. COMPLIED WITH SKYWEST M-337 MASDR SWIA202157171Floorbeam · corrodedFS280 CAP ANGLE IS CORRODED AND BENT AT FLOOR LEVEL, RBL9 (C-CHECK RO 4/1/2021) REMOVED AND REPLACED THE FS280 CAP AT FLOOR LEVEL RBL9. REF CRJ700 SRM 51-42-06-001-001-A01 AND REF CRJ700 SRM 51-42-13-001-001-A01. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA202157170Post · corrodedFS280 DOOR POST AT LBL9 IS CORRODED AT BOTTOM FLOOR LEVEL (C-CHECK RO 4/1/2021) PERFORMED PERMANENT REPAIR TO LHS F.S.280 DOOR POST AT LBL9 IN REF CRJ700 SRM 53-11-10-201-006-A01. SEE CONTINUATION CARD FOR WORK PERFORMED. COMPLIED WITH ATTACHED 51-900-100SDR SWIA202157169Floorbeam · corrodedFS280 CAP ANGLE IS CORRODED AND BENT AT FLOOR LEVEL, LBL9 (C-CHECK RO 4/1/2021) REMOVED AND REPLACED FS280 CAP ANGLE AT FLOOR LEVEL LBL9. REF DWG CC670-34010 REV K, CRJ700 SRM 51-42-06-001-001-A01 AND REF CRJ700 SRM 51-42-13-001-001-A01 . COMPLIED WITH TASDR SWIA202157168Striker · dented* PASSENGER DOOR AFT SEAL STRIKER DENTED/GOUGED NEAR UPPER END. ( MARKED ) (C-CHECK RO 4/1/2021) REPAIRED PASSENGER DOOR AFT SEAL STRIKER DENTED/GOUGED NEAR UPPER END REF MHIRJ REO 670-53-22-001 REV J DATED:2016-11-10 REPAIR TYPE 1. LEAK CHECK GOOD. SKY SDR SWIA202157167Slat Track · worn*RH WING SLAT TRACK 3-3 HAS WEAR MARKS ON LOWER FACE (C-CHECK RO 4/1/2021) BLENDED WEAR DAMAGE, RH WING SLAT TRACK 3-3 LOWER FACE, REFERENCE CRJ700 SRM 51-12-00-001-001-A01. BLEND OUT STRUCTURALLY ACCEPTABLE REFERENCING REO 670-57-42-1033 REV-- DATED 2021SDR SWIA202157166Slat Track · corroded*RH WING SLAT TRACK 1-2 HAS CORROSION ON LOWER FACE (C-CHECK RO 4/1/2021) REMOVED CORROSION ON RH WING SLAT TRACK 1-2, WITHIN LIMITS AND COMPLIED WITH MHI REO 670-57-42-1018 REV-- DATED 2021-02-21. RIGGING OF THE SLATS AND SLAT DISCONNECT SENSOR ARE GOOD SDR SWIA202157165Slat Track · corroded*LH WING SLAT TRACK 1-2 HAS CORROSION ON LOWER FACE (C-CHECK RO 4/1/2021) REPAIRED LH WING SLAT TRACK 1-2. PER MHI RJ REO 570-57-42-1017 REV -- DATED 2021-02-21. COMPLIED WITH TASK 51-900-1002-SKY. RIGG CHECK GOOD.SDR SWIA202157244Seat Track · corrodedLH CENTER INBOARD SEAT APPROX TRACKS FS 364 TO 677 HAS CORROSION GOUGES AND SCRATCHES AS MARKED (C-CHECK RO 4/1/2021) BLENDED AND EVALUATED SEAT TRACKS. REF CRJ700 SRM 53-21-49-101-001-A01. FOUND TO BE OUT OF LIMITS. ALL SEAT TRACKS REPLACED ON MX TRANS #SDR SWIA202157220Seat Track · corrodedRH CENTER INBOARD SEAT APPROX TRACKS FS 677 TO 977 HAS CORROSION GOUGES AND SCRATCHES AS MARKED (C-CHECK RO 4/1/2021) EVALUATED CORROSION AND DAMAGE TO SEAT TRACK LOCATED ON RBL9 FROM FS677.00 TO FS847.00 IAW CRJ700 SRM 53-41-49-101-001-A01 AND FOUND OUT SDR SWIA202157219Seat Track · corrodedLH CENTER INBOARD SEAT APPROX TRACKS FS 677 TO 988 HAS CORROSION GOUGES AND SCRATCHES AS MARKED (C-CHECK RO 4/1/2021) EVALUATED CORROSION AND DAMAGE TO SEAT TRACK LOCATED ON LBL9 FROM FS677.00 TO FS847.00 IAW CRJ700 SRM 53-41-49-101-001-A01 AND FOUND OUT SDR SWIA202157218Seat Track · corrodedRH CENTER INBOARD SEAT APPROX TRACKS FS 349 TO 677 HAS CORROSION GOUGES AND SCRATCHES AS MARKED (C-CHECK RO 4/1/2021) EVALUATED CORROSION AND DAMAGE TO SEAT TRACK LOCATED ON RBL9 FROM FS349.00 TO FS485.00 IAW CRJ700 SRM 53-21-49-101-001-A01 AND FOUND OUT SDR SWIA202157217Seat Track · corrodedRH SIDE SEAT TRACKS HAVE CORROSION GOUGES AND SCRATCHES FS364 TO 762.85 AS MARKED (C-CHECK RO 4/1/2021) BLENDED AND EVALED SEAT TRACKS. REF CRJ700 SRM 53-31-49-001-001-A01. ALL SEAT TRACK REPLACED ON MX TRANS #22308760 JOB 71029374 OP 81 BETWEEN FS364.00 SDR SWIA202157216Seat Track · corrodedRH SIDE SEAT RAILS HAVE CORROSION GOUGES AND SCRATCHES FS784.15 TO 969 AS MARKED (C-CHECK RO 4/1/2021) BLENDED AND EVALUATED RH SIDE SEAT TRACKS BETWEEN FS863.00 TO FS953.00. FOUND TO BE OUT OF LIMITS REF CRJ 700 SRM 53-41-51-101-001 A01. SEE MX TRANS #2SDR SWIA202157215Seat Track · corrodedLH SIDE SEAT TRACKS HAVE CORROSION GOUGES AND SCRATCHES FS364 TO 762.85 AS MARKED (C-CHECK RO 4/1/2021) BLENDED AND EVALUATED SEAT TRACKS. REF CRJ700 SRM 53-21-49-101-001-A01. FOUND TO BE OUT OF LIMITS. ALL SEAT TRACKS REPLACED ON MX TRANS #22306976 JOB 7SDR SWIA202157214Seat Track · corrodedRH SIDE SEAT TRACKS RETAINER APPROX FS784.15 TO 855.50 HAS CORROSION AS MARKED (C-CHECK RO 4/1/2021) REMOVED AND REPLACED SIDE SEAT TRACK RETAINER FROM FS784.15 TO FS855.00 ON RH SIDE IAW CRJ700 SRM 51-41-02-001-001-A01.SDR SWIA202157213Floorbeam · corroded*AVIONICS BAY FORWARD FLOORBOARD SUPPORT ON THE AFT SIDE OF THE FS280.00 FRAME IS CORRODED AT MULTIPLE AREAS ON BOTH THE TOP AND LOWER SURFACE. (MARKED) (C-CHECK RO 4/1/2021) REMOVED AND REPLACED MAIN AVIONICS BAY FORWARD FLOORBOARD SUPPORT ON THE AFT SIDSDR SWIA202157204Floorbeam · cracked*FS 280 BEAM / RBL 12 ANGLE BRACKET HAS EVIDENCE OF CRACK AT TOP OF RADIUS. (C-CHECK RO 4/1/2021) REMOVED AND REPLACED BRACKET, FS280, RBL12, REF CRJ 700 SRM 51-42-21-001-001-A01SDR SWIA202157164Floor Support · corroded*R/H FLOOR SILL FROM FS 280 TO 319 HAS 2EA AREAS OF CORROSION. MARKED WITH RED GREASE PENCIL. (C-CHECK RO 4/1/2021) REPLACED RH FLOOR SILL FROM FS280 TO FS319. REF CRJ700 SRM 51-42-06-001-001-A01 AND REF CRJ700 SRM 51-42-21-001-001-A01. REF CRJ700 SRM 51-SDR SWIA202157163Angle · corrodedPAX DOOR SURROUND STRUCTURE KICKPLATE ANGLE CORRODED (MARKED) (C-CHECK RO 4/1/2021) REMOVED AND REPLACED PAX DOOR SURROUND STRUCTURE KICKPLATE ANGLE IAW CRJ700 SRM 51-42-6-001-001-A01/ CRJ700 SRM 51-42-21-001-001-A01 AND DWG SH670-31810 REV Y. COMPLIED WISDR SWIA202157162Frame · corrodedMAIN AVIONICS BAY FS319 FRAME FROM STR 18L TO STR 21L CORRODED ON UPPER FREE FLANGE (C-CHECK RO 4/1/2021) REPLACED FS319 FRAME FROM STR 18L TO STR 21L WITH NEW FRAME SECTION, REFERENCE CRJ700 SRM 51-42-06-001-001-A01, CRJ700 SRM 51-42-21-001-001-A01 AND BSDR SWIA202157161Stringer · corrodedMAIN AVIONICS BAY STR 21L BACK-UP SILL BETWEEN FS333.00 AND FS349.00 CORRODED (C-CHECK RO 4/1/2021) REPLACED STR 21L BACK UP SILL FROM FS333 - FS349. REF CRJ700 SRM 51-42-06-001-001-A01 AND DWG SH670-31810 REV AE. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA202157160Stringer · corrodedMAIN AVIONICS BAY STR 21L BACK-UP SILL BETWEEN FS310.00 AND FS333.00 CORRODED (C-CHECK RO 4/1/2021) REPLACED STRG 21L BACK UP SILL FROM FS310 TO FS333. REF CRJ700 SRM 51-42-06-001-001-A01 AND REF CRJ700 SRM 51-42-21-001-001-A01 AND DWG SH670-31810 REV AE.SDR SWIA202157159Intercostal · corrodedMAIN AVIONICS BAY RH LATCH-PIN INTERCOSTAL BETWEEN FS349.00 AND FS364.00 CORRODED (C-CHECK RO 4/1/2021) REMOVED AND REPLACED WITH NEW RH LATCH PIN INTERCOSTAL FROM FS349.00 TO FS364.00. REF CRJ700 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DWGSDR SWIA202157158Intercostal · corrodedMAIN AVIONICS BAY LH LATCH-PIN INTERCOSTAL BETWEEN FS349.00 AND FS364.00 CORRODED (C-CHECK RO 4/1/2021) REMOVED AND REPLACED WITH NEW LH LATCH PIN INTERCOSTAL FROM FS349.00 TO FS364.00. REF CRJ700 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DWGSDR SWIA202157157Doubler · corrodedMAIN AVIONICS BAY FWD DRAIN MAST DOUBLER AFT O/B ATTACH ANGLE AT FS349.00 CORRODED (C-CHECK RO 4/1/2021) REPLACED THE FWD DRAIN MAST DOUBLER AFT OUTBD ATTACH ANGLE. REF CRJ700 SRM 51-42-06-001-001-A01 AND DWG SH670-32278 REV NC AND DWG SH670-32250 REV K. SDR SWIA202157156Doubler · corrodedMAIN AVIONICS BAY FWD DRAIN MAST DOUBLER AFT I/B ATTACH ANGLE AT FS349.00 CORRODED (C-CHECK RO 4/1/2021) REPLACED FWD DRAIN MAST DOUBLER AFT INBD ATTACH ANGLE AT FS349.00. REF CRJ700 SRM 51-42-06-001-001-A01 AND DWG SH670-32250 REV K. COMPLIED WITH TASK SDR SWIA202157155Frame · corrodedMAIN AVIONICS BAY FS333.00 FRAME CORRODED BETWEEEN STR 26L AND STR 26R (C-CHECK RO 4/1/2021) REMOVED AND INSTALLED NEW FRAME MAIN AVIONICS BAY FS333.00 FRAME CORRODED BETWEEEN STR 26L AND STR 26R REF CRJ-700 SRM 53-00-06-201-006-A01.LEAK CHECK GOOD,COMPLISDR SWIA202157154Web · corrodedFS 280 WEB HAS EVIDENCE OF CORROSION UNDER CAP ANGLE AT FLOOR LEVEL RBL 11. (C-CHECK RO 4/1/2021) REMOVED AND REPLACED CAP ANGLE AT FLOOR LEVEL RBL11. REF CRJ700 SRM 51-42-06-001-001-A01 AND REF CRJ700 SRM 51-42-13-001-001-A01. COMPLIED WITH TASK CARD 51-SDR SWIA202157153Web · corrodedFS 280 WEB HAS EVIDENCE OF CORROSION UNDER CAP ANGLE AT FLOOR LEVEL LBL 11. (C-CHECK RO 4/1/2021) REMOVED AND REPLACED CAP ANGLE AT FLOOR LEVEL LBL11. REF CRJ700 SRM 51-42-06-001-001-A01 AND REF CRJ700 SRM 51-42-13-001-001-A01. COMPLIED WITH TASK CARD 51-SDR SWIA202157152Floorbeam · corrodedFS 280 FLOOR SUPPORT ANGLE FOR COCKPIT FLOORBOARD 221ALF HAS EVIDENCE OF CORROSION. (C-CHECK RO 4/1/2021) REMOVED & REPLACED FS 280 FLOOR SUPPORT ANGLE FOR COCKPIT FLOORBOARD 221ALF REF CRJ-700 SRM51-42-06-001-001-A01 AND DWG# CC670-33052 REV G. COMPLIED SDR SWIA202157151Stringer · corrodedMAIN AVIONICS BAY STR 25R CORRODED BETWEEN FS295.00 AND FS310.00 (C-CHECK RO 4/1/2021) REMOVED AND INSTALLED A NEW STGR 25R FROM FS280.00 TO FS333.00 REF BOMBARDIER DWG SH670-31630 REV-K, CRJ700 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01. SEE ASDR SWIA202157150Frame · corrodedFRAME FS349.00 FORWARD/AFT WEBS & UPPER/LOWER FLANGES ARE CORRODED AT MULTIPLE AREAS, STGR25L €“ STGR24R(MARKED) (C-CHECK RO 4/1/2021) REMOVED AND INSTALLED NEW FRAME FS349.00 FORWARD/AFT WEBS & UPPER/LOWER FLANGES ARE CORRODED AT MULTIPLE AREAS, STGR25LSDR SWIA202157149Doubler · corrodedFORWARD WATER DRAIN MAST SUPPORT DOUBLER, FS333.00 €“ FS349.00 STGR25R -STGR24R, HAS CORROSION AT MULTIPLE AREAS. (MARKED) (C-CHECK RO 4/1/2021) INSTALLED NEW DRAIN MAST DOUBLER FROM FS333 TO FS349. REF CRJ700 SRM 51-42-06-001-001-A01 AND DWG SH670-32250SDR SWIA202157148Frame · corrodedFRAME, 319.00, FORWARD LOWER FLANGE AND WEB ARE CORRODED BETWEEN STGR25L & STGR24R. (MARKED) (C-CHECK RO 4/1/2021) REMOVED AND REPLACED FRAME SECTION FS319.70 PER CRJ700 SRM 53-00-06-201-006-001. COMPLIED WITH TASK CARD 51-900-1002-SKY AND NO LEAKS NOTED,SDR SWIA202157147Stringer · corrodedSTRINGER 26L IS CORRODED BETWEEN FS310.00 & FS319.00. (MARKED) (C-CHECK RO 4/1/2021) REPLACED STR 26L FROM FS280 TO FS333. REF CRJ700 SRM 51-42-06-001-001-A01, REF CRJ700 SRM 51-42-21-001-001-A01 AND BOMBARDIER DWG SH670-31630 REV K. COMPLIED WITH TASK CASDR SWIA202157146Frame · corrodedFRAME, 310.00, FORWARD LOWER FLANGE AND WEB ARE CORRODED BETWEEN STGR24L & STGR25R. (MARKED) (C-CHECK RO 4/1/2021) REMOVED AND REPLACED WITH NEW FRAME AT FS310.00 FROM STR 23L TO 18R. REF CRJ700 SRM51-42-06-001-001-A01, 51-42-21-001-001-A01, DWG SH670-316SDR SWIA202157145Door Sill · corrodedAFT CARGO DOOR SILL CORRODED (C-CHECK RO 4/1/2021) REMOVED AND REPLACED AFT CARGO DOOR SILL IAW DWG MM670-35085 REV L. COMPLIED WITH TASKCARD 51-900-1002.
Back to N791SK