N804SK
Service difficulty reports · 289
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 = 'N804SK' 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 = 'N804SK' 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 SWIA202160509Stringer Splice · corroded*CORROSION ON STGR 26L SPLICE AT FS 333.00 (C-CHECK RO 8/18/2021) REMOVED AND REPLACED STGR 26L SPLICE AT F.S. 333.00, REF CRJ 900 SRM 51-42-06-001-001-A01 AND DWG SH670-32420 REV -E. LEAK CHECK GOOD / COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY (CLSDR SWIA202160508Stringer · corroded*CORROSION ON STGR 26L BETWEEN FS 333.00 - 319.00 (C-CHECK RO 8/18/2021) REMOVED AND REPLACED WITH STR 26 LH FROM FS280.00-FS333.00 REFCRJ 900 SRM 51-42-06-001-001-A01 REV 38 JUL 25/2020 AND 51-42-21-001-001-A01 REV 38 25/2020 DRAWING SH670-31630 REVSDR SWIA202160507Intercostal · corroded*CORROSION ON INTERCOSTAL BETWEEN STGR 27 - 26L BETWEEN FS 364.00 - 349.00 ON INBD AND OTBD FACES (C-CHECK RO 8/18/2021) REMOVED AND REPLACED WITH NEW INTERCOSTAL BETWEEN STGR 27 - 26L BETWEEN FS 364.00 - 349.00 REF DRAWING SH670-32050 REV D REF CRJ 90SDR SWIA202160506Intercostal · corroded*CORROSION ON INTERCOSTAL BETWEEN STGR 27 - 26R BETWEEN FS 364.00 -349.00 (C-CHECK RO 8/18/2021) REMOVED AND REPLACED INTERCOSTAL BETWEEN STGR 27 AND 26R BETWEEN F.S. 364.00 AND F.S. 349.00, REF CRJ 900 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01 ANDSDR SWIA2021082060505Stringer · corroded*CORROSION ON STGR 22L BETWEEN FS 333.00 - 349.00 (C-CHECK RO 8/18/2021) REPLACED STGR 22L BETWEEN FS333.00 TO FS349.00 REF DWG SH690-31350 REV. M, CRJ900 SRM 51-41-21-001-001-A01, CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 53-00-03-201-001-A02. LEAK CSDR SWIA202160504Stringer · corroded*CORROSION ON STGR 19L BETWEEN FS 349.00 - 364.00 (C-CHECK RO 8/18/2021) REPAIRED CORROSION ON STGR 19L BETWEEN F.S. 349.00 AND F.S. 364.00, REF CRJ 900 SRM 53-00-03-201-001-A02, 51-42-06-001-001-A01 AND DWG SH670-31150 REV -F, LEAK CHECK GOOD / COMPLISDR SWIA2021082060503Frame · corroded*CORROSION ON FS 319.00 AROUND GROUND STUDS BETWEEN STGR 20L - 19L (C-CHECK RO 8/18/2021) REPLACED FS319 FRAME BETWEEN STGR 18L AND 21L REF DWG SH670-31810 REV. Y AND CRJ900 SRM 51-42-06-001-001-A01 AND CRJ900 SRM 51-23-00-001-001-A01. LEAK CHECK GOOD, SDR SWIA202160502Intercostal · corroded*CORROSION ON INTERCOSTAL STGR 21L BETWEEN FS 333.00 - 349.00 (C-CHECK RO 8/18/2021) REMOVED AND REPLACED WITH NEW THE INTERCOSTAL STGR 21L BETWEEN FS 333.00 - 349.00 REF CRJ-900 SRM 51-42-06-001-001-A01 REV 38, JULY 25/2020,CRJ-900 SRM 51-42-21-001-001SDR SWIA202160501Stringer · corroded*CORROSION ON STGR 19L BETWEEN FS 319.00 - 333.00 (C-CHECK RO 8/18/2021) REMOVED AND REPLACED STGR 19L BETWEEN F.S. 310.00 AND F.S. 349.00, REF CRJ 900 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01 AND DWG SH670-31810 REV Y, LEAK CHECK GOOD. / COMPLIEDSDR SWIA202160500Floor Support · corroded*AREAS OF CORROSION ON LH FLOOR SILL BETWEEN FS 310.00 - 280.00 (C-CHECK RO 8/18/2021) REMOVED AND REPLACED LH FLOOR SILL BETWEEN F.S. 280 AND F.S. 310.00, REF CRJ 900 SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01 AND DWG 670-32170 REV V. LEAK CHECK GOSDR SWIA202160499Stringer · corroded*CORROSION ON STGR 21R BETWEEN FS 364.00 - 379.00 (C-CHECK RO 8/18/2021) REMOVED AND REPLACED CORRODED STGR 21R BETWEEN F.S. 333.0 AND F.S. 379.0, REF CRJ 900 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01 AND DWG SH670-31350 REV -A, LEAK CHECK GOOD / SDR SWIA2021082060498Floor Support · corroded*MULTIPLE AREAS OF CORROSION ON RH FLOOR SILL BETWEEN FS 280.00 - 319.00 (C-CHECK RO 8/18/2021) REMOVED CORROSION AND FOUND REWORKED AREA TO BE OUT OF LIMITS REF CRJ-900 SRM 53-00-45-201-001-A01. REPLACED RH FLOOR SILL FS280 - FS319 REF CRJ-900 SRM 51-4SDR SWIA2021082060604Seat Track · corroded*CORROSION ON SEAT TRACK ON LBL 9 BETWEEN FS 954.00 - 847.00+48 (C-CHECK RO 8/18/2021) REMOVED CORROSION FROM SEAT TRACK AND FOUND OUT OF LIMITS. REPLACED SEAT TRACK ON LBL 9 BETWEEN FS 954.00-847.00+48 REF CRJ-900 AMM 53-00-49-400-801-A07 . SEE CONTINUSDR SWIA2021082060601Seat Track · corroded* CORROSION IN MULTIPLE AREAS ON RH SIDE SEAT RAIL FS565.00 TO FS661.00+16.00 (MARKED WITH FLAG AND IN RED) (C-CHECK RO 8/18/2021) REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED RH SIDE SEAT RAIL AT FS 565.00-661.00+16 REF. CRJ-90SDR SWIA2021082060574Seat Track · corroded* CORROSION IN MULTIPLE AREAS ON RH SIDE SEAT RAIL FS661.00+16.00 TO FS669.40 (MARKED WITH FLAG AND IN RED) (C-CHECK RO 8/18/2021) CORROSION FOUND TO BE OUT OF LIMITS. REMOVED AND INSTALLED NEW RH SIDE SEAT RAIL FROM FS661.00+16.00 TO FS669.40 REF CRJ 9SDR SWIA2021082060573Seat Track · corroded* CORROSION IN MULTIPLE AREAS ON RH SIDE SEAT RAIL FS485.00 TO FS565.00 (MARKED WITH FLAG AND IN RED) (C-CHECK RO 8/18/2021) REMOVED AND REPLACED RH SIDE SEAT RAIL AT FS485 - FS565 REF CRJ900 AMM 53-00-49-000-801-A07 AND AMM 53-00-49-400-801-A07. SEE CSDR SWIA2021082060572Seat Track · corroded* CORROSION IN MULTIPLE AREAS ON LH SIDE SEAT RAIL FS661.00+16.00 TO FS669.40 (MARKED WITH FLAG AND IN RED) (C-CHECK RO 8/18/2021) REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED LH SIDE SEAT RAIL FS661.00+16.00 TO FS669.40 REF. CRSDR SWIA2021082060497Hinge Fitting · gouged* L/H AILERON (#2) HINGE FITTING (OTBD) LUG IS "GOUGED" (MARKED). (C-CHECK RO 8/18/2021) REPAIRED GOUGE TO LH AILERON #2 HINGE FITTING OB LUG TO MHIRJ REO 690-57-51-227 REV -- DATED 2021-07-01 / COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY (CL600-2DSDR SWIA2021082060496Stringer · corroded*CORROSION ON STGR 23L BETWEEN FS 1031.00 - 1051.00 (C-CHECK RO 8/18/2021) EVAL CORROSION IS 100% MATERIAL LOSS AND OUT OF LIMITS PER CRJ900 SRM 51-21-06-001-001-A01. REPAIRED STGR 23L PER CRJ900 SRM 53-00-03-201-001-A02. COMPLIED WITH TASK CARD 51-900SDR SWIA202160495Angle · corrodedMID CAP ANGLE AT PAX DOOR ENTRY HAS CORROSION (C-CHECK RO 8/18/2021) REMOVED AND REPLACED PAX DOOR MID CAP ANGLE WITH NEW, REF CRJ 900 AMM 20-21-00-910-801-A01 AND CRJ 900 SRM 51-42-06-001-001-A01 AND CRJ 900 SRM 51-42-15-001-001-A01 AND BOMBARDIER DWGSDR SWIA2021082060494Mount · damagedUPON REMOVAL OF STUCK SHANK UNDER PANEL 672DT FOUND 4EA OBLONG HOLES ON RH WINGLET FAIRING MOUNT. (C-CHECK RO 8/18/2021) REMOVED AND REPLACED RIB PN CC690-15110-4S WITH A NEW ONE IAW CRJ900 SRM 51-42-13-001-001-A01, CRJ900 SRM 51-42-21-001-001-A01, CRSDR SWIA202160493Support Bracket · corroded*CENTER BAGGAGE BAY DOOR SURROUND STRUCTURE - SUPPORT BRACKET BETWEEN FS645.00 €“ FS661.00 STGR27 €“ STGR26L HAS CORROSION. (MARKED) (C-CHECK RO 8/18/2021) SUPPORT BRACKET IN CENTER BAGGAGE BAY DOOR SURROUND STRUCTURE WAS FOUND TO BE OUT OF LIMITS. RESDR SWIA2021082060492Stiffener · cracked*AFT FACE OF FS 280 BULKHEAD ASSY AT APPROXIMATELY WL104, LBL11, STIFFENER CORNER BENT AND CRACKED AT RADIOUS. (MARKED WITH STREAMER) (C-CHECK RO 8/18/2021) REPAIRED STIFFENER ON FS280 BULKHEAD AFT FACE AT APPROX WL 104, LBL11 REF REO 690-53-11-1346 RESDR SWIA2021082060600Support Bracket · corroded*FORWARD CARGO DOOR €“ FS518.00 STGR27 €“ STGR26L SUPPORT BRACKET HAS CORROSION. (MARKED) (C-CHECK RO 8/18/2021) REMOVED AND REPLACED THE FORWARD CARGO DOOR SUPPORT BRACKET AT FS.518 BETWEEN STGR27 AND STGR26L WITH NEW REF CRJ 900 SRM 51-42-21-001-001SDR SWIA2021082060491Floorbeam · corrodedFS 280 - FLOOR PANEL SUPPORT ANGLE CORRODED (C-CHECK RO 8/18/2021) REMOVED CORROSION ON FLOOR SUPPORT ANGLE AT FS280 AND BLENDED AREA WAS FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED FLOOR SUPPORT ANGLE IAW CRJ 900 SRM 51-42-21-001-001-A01. COMPLIED SDR SWIA2021082060490Floorbeam · damagedLBL 9 FLOORBEAM @ 280 BULKHEAD - UNDERSIDE OF FLOORBEAM ARE 2 EA RIVETS WITH HEADS MISSING, AND 4 REMAINING RIVETS ARE SUSPECT. (C-CHECK RO 8/18/2021) AFTER REMOVAL OF RIVETS, 2 HOLES WERE FOUND TO BE ELONGATED. REPAIRED UNDERSIDE OF FLOORBEAM PLATE ATSDR SWIA202160489Door Sill · corrodedAFT CARGO BAY - DOOR SILL AND FLOORBOARD LANDING CORRODED (C-CHECK RO 8/18/2021) REMOVED AND REPLACED AFT CARGO BAY - DOOR SILL REF CRJ 900 SRM 51-42-06-001-001-A01 REV 38A - 14 DEC 2020, CRJ 900 SRM 51-42-21-001-001-A01 REV 38A - 14 DEC 2020, CRJ 900 SDR SWIA202160488Angle · corroded* PAX DOOR CUT-OUT KICK PLATE ANGLE CORRODED. (MARKED) (C-CHECK RO 8/18/2021) PAX DOOR CAP ANGLE FOUND TO HAVE INTERGRANULAR CORROSION AND IS FOUND TO BE OUT OF LIMITS WITH AREAS OF DEEP PITTING. REMOVED AND REPLACED PAX DOOR CUT-OUT KICK PLATE CAP ANGLSDR SWIA202160487Landing · corroded*EVALUATE CORROSION ON MAIN AVIONICS DOOR OPENING SURROUND SKIN (SEAL LANDING). (C-CHECK RO 8/18/2021) BLENDED OUT CORROSION ON MAIN AVIONICS BAY DOOR OPENING SURROUND SKIN, FOUND TO BE WITHIN LIMITS OF BOMBARDIER REO 690-53-21-032 REV -- DATED 2008/03/SDR SWIA202160486Former · corroded*PAX DOOR FWD FORMER HAS HEAVY CORROSION AROUND UPPER ROLL LATCH. (MARKED) (C-CHECK RO 8/18/2021) REMOVED AND REPLACED WITH NEW PAX DOOR FWD FORMER DWG 601R31702 REV. N AND CRJ 900 SRM 51-42-06-001-001-A01 AND CRJ 900 SRM 51-42-21-001-001-A01. LEAK CHECSDR SWIA2021082060485Floor Panel · crackedFWD EQUIPMENT COMPARTMENT - L/H SIDE - COMPARTMENT FLOOR CRACKED @ CORNER ADJACENT TO FRAME @ APROX FS 212 WL 79.5, JUST OTBD OF BRAKE ACCUMULATOR GAGES (C-CHECK RO 8/18/2021) REPAIRED CRACKED AREA OF LHS OF FWD ELECTRICAL BAY FLOOR IAW CRJ900 SRM 53-11SDR SWIA2021082060484Doubler · crackedFWD EQUIPMENT COMPARTMENT - R/H SIDE - DOUBLER UNDER ADG HAND PUMP IS CRACKED @ OTBD CORNER (C-CHECK RO 8/18/2021) FABRICATED ADG PUMP DOUBLER P/N CC670-33357-3 P0# T000057884 P/N:2024T-3, 0.040 AND FABRICATED CLEAT PO# T000058828 P/N: 2024T-3, 0.03SDR SWIA2021082060599Attach Fitting · corroded* FOUND SURFACE CORROSION ON THE RH SIDE STAY UPPER ATTACH FITTING ALONG THE AFT FACE CENTER WING REAR SPAR(AREA MARKED) (C-CHECK RO 8/18/2021) REMOVED AND REPLACED CORRODED R/H SIDE STAY UPPER ATTACH FITTING ALONG THE AFT FACE CENTER WING REAR SPAR (ASDR SWIA2021082060598Attach Fitting · cracked* FOUND A CRACK ON THE LH SIDE STAY UPPER ATTACH FITTING TO THE AFT FACE CENTER WING REAR SPAR(AREA MARKED) (C-CHECK RO 8/18/2021) REMOVED AND REPLACED DAMAGED L/H SIDE STAY UPPER ATTACH FITTING TO THE AFT FACE CENTER WING REAR SPAR WITH NEW PART (CC67SDR SWIA2021082060483Bracket · corroded* FOUND SURFACE CORROSION ON THE LH ANGLE BRACKET FITTING OF THE AFT FACE CENTER WING REAR SPAR(AREA MARKED) (C-CHECK RO 8/18/2021) EVAL LH ANGLE BRACKET FITTING OF AFT FACE CENTER WING SPAR 100% MATERIAL LOSS AND IS OUT OF LIMITS. REF CRJ900 SRM 53-00SDR SWIA2021082060482Skin · damaged* LEFT WING OUTBD FLAP TOP SKIN HAS SMOKING RIVETS MARKED (C-CHECK RO 8/18/2021) REMOVED AND REPLACED 15EA FASTENERS IN L/H WING O/B FLAP TOP SKIN REF REO 690-57-53-125 REV -- DATED 2021-06-30. COMPLIED WITH ALL STEPS OF REO 69-57-53-125-REV -- DATED 20SDR SWIA202160481Bracket · corroded*RIGHT MLG TIRE BURST PANEL BRACKET IN RHE RIGHT WHEEL WELL CORRODED. (MARKED) (C-CHECK RO 8/18/2021) REPLACED RH MLG TIRE BURST PANEL BRACKET REF DWG CC670-10320 REV. F AND CRJ900 SRM 51-42-21-001-001-A01. LEAK CHECK GOOD. COMPLIED WITH 51-900-1002-SKYSDR SWIA2021082060597Rib · cracked*LEFT AILERON ON THE FORWARD SIDE OF THE FRONT SPAR - FIRST RIB OUTBOARD OF THE OUTBOARD PCU LUG IS BENT AND CRACKED. (MARKED) (C-CHECK RO 8/18/2021) REMOVED AND REPLACED LH AILERON CONTROL SURFACE. MAINTENANCE CORRECTIVE ACTION CARPTURED ON JOB 9150679SDR SWIA202160480Support Fitting · gouged*FORWARD JACK FITTING ANGLE ON THE LEFT JACK FITTING SUPPORT AND FS280.00 BULKHEAD HAS TWO GOUGES. (C-CHECK RO 8/18/2021) REMOVED, FABRICATED NEW, AND INSTALLED NOSE JACK FITTING ANGLE ON LEFT SIDE OF NOSE JACK FITTING AT FS280.00 IAW CRJ900 SRM 51-42-SDR SWIA2021082060479Angle · corroded*FRAME FS265 STIFFENING ANGLE ON THE AFT SIDE OF THE FRAME IS CORRODED BETWEEN STGR26L €“ STGR26R. (C-CHECK RO 8/18/2021) REPLACED FRAME FS265 STIFFENING ANGLE ON THE AFT SIDE BETWEEN STGR 26L AND STGR 26R REF DWG CC670-34020 REV. A AND CRJ900 SRM 51-2SDR SWIA2021082060478Support Fitting · corroded*FORWARD JACK FITTING - RIGHT JACK FITTING SUPPORT IS CORRODED ON THE LOWER FLANGE AND WEB. (C-CHECK RO 8/18/2021) REPLACED FWD JACK FITTING AND RH NOSE JACK FITTING ANGLE REF CRJ900 SRM 51-42-06-001-001-A01 AMD CRJ900 SRM 51-42-21-001-001-A01 AND DWG CSDR SWIA202160477Fitting · corroded*FORWARD JACK FITTING - LEFT JACK FITTING SUPPORT IS CORRODED ON THE LOWER FLANGE AND WEB. (C-CHECK RO 8/18/2021) REMOVED AND REPLACED WITH NEW FWD JACK FITTING LH REF CRJ900 SRM 51-42-06-001-001-A01 REV 38A DATED 14DEC2020, CRJ900 SRM 51-42-21-001-001-SDR SWIA2021082060571Stop Fitting · gouged* CREW ESCAPE HATCH SURROUND, AFT STOP FITTINGS ARE GOUGED/CHAFED (C-CHECK RO 8/18/2021) REPAIRED CREW ESCAPE HATCH SURROUND, AFT STOP FITTINGS PER REO 690-53-11-1344 REV-- DATE 2021-07-06.SDR SWIA2019082746227Landing Gear · failedGEAR DISAGREE ON TAKEOFF. NOSE GEAR WOULD NOT RETRACT FULLY. RAN THE QRH. NO OTHER MESSAGES OR ABNORMAL ISSUES.SDR SWIA2017090843745Floorbeam · corrodedMAIN AVIONICS BAY FLOORBEAM ANGLE AT BS 280 CORRODED. REPLACED THE ANGLE IAW SRM.SDR SWIA2017090843744Doubler · corrodedMAIN AVIONICS BAY TCAS ANTENNA DOUBLER BETWEEN BS 295 AND 310 FOUND CORRODED. INSTALLED A NEW TCAS ANTENNA DOUBLER IAW SRM.SDR SWIA2017090843732Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT BS 295 CORRODED BETWEEN STRINGERS 25L AND 25R. PERFORMED A FRAME SPLICE REPAIR IAW REO.SDR SWIA2017090843743Post · corrodedBS 280 LT DOOR POST CORRODED AT BOTTOM EDGE JUST ABOVE THE CROSSBEAM. REPAIRED THE DOOR POST IAW REO.SDR SWIA2017090843742Post · corrodedBS 280 RT DOOR POST CORRODED AT BOTTOM EDGE JUST ABOVE THE CROSSBEAM. REPAIRED THE DOOR POST IAW REO.SDR SWIA2017090843741Intercostal · corrodedINTERCOSTAL JUST RIGHT OF STRINGER 27 HAS CORROSION, BETWEEN FRAMES BS 349 AND 364. INSTALLED A NEW INTERCOSTAL IAW SRM.
Back to N804SK