N631SK
Service difficulty reports · 86
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 = 'N631SK' 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 = 'N631SK' 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 SWIA202053459Seat Track · corrodedCORROSION ON RT SIDE SEAT RAIL BETWEEN APPROXIMATELY FS 693.00 TO 761.00, AREAS MARKED. C-CHECK RO 10/17/2020. BLENDING NOT ALLOWED AT DAMAGE LOCATIONS. REMOVED 2 EA DAMAGED AND INSTALLED 2 EA NEW RT SIDE SEAT RAIL FROM FS 675 TO FS 763 WITH NEW HARDWARE, RSDR SWIA202053458Seat Track · corrodedCORROSION ON LT SIDE SEAT RAIL BETWEEN APPROXIMATELY FS 879.00 TO 939.00, AREAS MARKED. C-CHECK RO 10/17/2020. INSTALLED NEW REPLACEMENT LT SIDE SEAT RAIL AT FS 869.00 TO FS 961.00.00, REF CRJ700 AMM. TOOL NR TUC 7830 DUE:30-NOV-20.SDR SWIA202053457Seat Track · corrodedCORROSION ON LT SIDE SEAT RAIL BETWEEN APPROXIMATELY FS 677.00 TO 761.00, AREAS MARKED. C-CHECK RO 10/17/2020. REPLACED 2 EA NEW LT SIDE SEAT RAILS BETWEEN APPROXIMATELY FS 675.00-FS 713.00 AND FS 713.00-FS 763.00, REF CRJ700 AMM.SDR SWIA202053456Seat Track · corrodedCORROSION ON RT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 863.00 TO 977.00, AREAS MARKED. C-CHECK RO 10/17/2020. REPLACED RT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 863.00 TO 977.00 WITH NEW SEAT RAIL, REF CRJ700 AMM.SDR SWIA202053455Seat Track · corrodedCORROSION ON RT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 677.00 TO 863.00, AREAS MARKED. C-CHECK RO 10/17/2020. THE SEAT TRACK IS OUT OF LIMITS, REF CRJ700 SRM 53-41-49-101-001-A01. REMOVED AND INSTALLED A NEW SEAT TRACK P/N SH670-35864-5 FOR RBL 9.0 FROM FSDR SWIA202053454Seat Track · corrodedCORROSION ON LT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 863.00 TO 977.00, AREAS MARKED. C-CHECK RO 10/17/2020. THE SEAT RAIL IS OUT OF LIMITS, PER CRJ700 SRM. REMOVED AND REPLACED WITH NEW SEAT RAIL P/N SH670-37420-7 AT RBL 9.0 FROM FS 863.00-FS 977.00, PESDR SWIA202053453Seat Track · corrodedCORROSION ON LT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 677.00 TO 863.00, AREAS MARKED. C-CHECK RO 10/17/2020. THE SEAT TRACK IS OUT OF LIMITS, REF CRJ700 SRM. REMOVED AND INSTALLED A NEW SEAT TRACK P/N SH670-35864-5 FOR LBL 9.0 FROM FS 677 TO FS 863, REF SDR SWIA202053452Seat Track · corrodedCORROSION ON RT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 581.00 TO 677.00, AREAS MARKED. C-CHECK RO 10/17/2020. INSTALLED NEW REPLACEMENT RT AISLE SEAT RAIL NEW REPLACEMENT, FS 581.00 TO FS 677.00, RBL 9.00, REF CRJ700 AMM. TOOL NR TUC8605, CAL: 02-JAN-20 DSDR SWIA202053451Seat Track · corrodedCORROSION ON RT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 485.00 TO 581.00, AREAS MARKED. C-CHECK RO 10/17/2020. REMOVED CORRODED SEAT RAIL AT RBL 9 FS 485.00 TO FS 581.00, REF CRJ700 AMM. INSTALLED NEW SEAT RAIL AT RBL 9 FS 485.00 TO FS 581.00, REF CRJ700 ASDR SWIA202053450Seat Track · corrodedCORROSION ON LT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 581.00 TO 677.00, AREAS MARKED. C-CHECK RO 10/17/2020. INSTALLED NEW REPLACEMENT LT AISLE SEAT RAIL, FS 581.00 TO FS 677.00, LBL 9.00, REF CRJ700 AMM. TOOL NR TUC8605, CAL: 02-JAN-20 DUE: 31-JAN-21. SDR SWIA202053449Seat Track · corrodedCORROSION ON RT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 409.00 TO 485.00, AREAS MARKED. C-CHECK RO 10/17/2020. REPLACE RT AISLE SEAT RAIL BETWEEN APPROXIMATELY FS 349.00 TO 485.00 WITH NEW SEAT RAIL, REF CRJ700 AMM.SDR SWIA202053448Seat Track · corrodedCORROSION ON LT OUTBOARD FLOOR SEAT RAIL (FIRST CLASS) BETWEEN APPROXIMATELY FS 394.00 TO 485.00, AREAS MARKED. C-CHECK RO 10/17/2020. REMOVED CORRODED SEAT RAIL AT LBL 27 FS 364.00 TO FS 485.00, REF CRJ700 AMM. INSTALLED NEW SEAT RAIL AT LBL 27 FS 364.00 TSDR SWIA202053437Floorbeam · corrodedRT FS 280.00 CROSSBEAM HAS CORROSION JUST INBOARD SIDE OF RBL 9. C-CHECK RO 10/17/2020. REMOVED, REPLACED, AND INSALLED NEW RT FS 280 CROSSBEAM, REF CRJ 700 SRM AND DWG. COMPLIED WITH SKYWEST TASKCARD.SDR SWIA202053436Floorbeam · corrodedLT FS 280.00 CROSSBEAM HAS CORROSION JUST INBOARD SIDE OF LBL 9. C-CHECK RO 10/17/2020. REMOVED, REPLACED, AND INSTALLED NEW LT FS 280 CROSSBEAM, REF CRJ 700 SRM AND DWG. COMPLIED WITH SKYWEST TASKCARD.SDR SWIA202053435Support · crackedSLAT TRACK 1-3 CANISTER AFT SUPPORT FLANGE, SUSPECT CRACK IN MARKED AREA NEAR THE WELD AT THE TOP EDGE. C-CHECK RO 10/17/2020. PERFORMED REPAIR ON CANISTER NR 3 RT WING COMPLIED WITH REO. LEAK CHECK GOOD. COMPLIED WITH SKYWEST TASK CARDSDR SWIA202053434Floorbeam · corrodedCOCKPIT FLOOR SUPPORT HAS EVIDENCE OF CORROSION ATTACHED TO FWD OF FS 280.00 CROSSBEAM. C-CHECK RO 10/17/2020. REMOVED, REPLACED AND INSTALLED NEW COCKPIT FLOOR SUPPORT FWD OF FS 280 CROSSBEAM, REF CRJ 700 SRM AND DWG. COMPLIED WITH SKYWEST TASKCARD.SDR SWIA202053433Floor Support · corroded8 CIRCLED SPOTS OF CORROSION ON RT FLOOR SILL FROM FS 280-FS 319. C-CHECK RO 10/17/2020. REMOVED AND REPLACED CORRODED RT FLOOR SILL FROM FS 280.00-FS 319.00 WITH NEW SILL, PER BOMBARDIER DWG AND CRJ700 SRM. ALL CHECKS GOOD. SEE CONTINUATION CARD FOR FURTHSDR SWIA202053444Stringer · crackedCOMPLY WITH SB 670BA-53-040 FOR CRACK IN PAX DOOR LINTEL STRINGER 3 AT FS 280. C-CHECK RO 10/17/2020. COMPLIED WITH SB FOR CRACK IN PAX DOOR LINTEL STRINGER 3 AT FS 280. SERVICE BULLETIN, FUSELAGE-CENTER FUSELAGE, PRIMARY STRUCTURE FS 280.00-INSPECTION AND SDR SWIA202053432Door Sill · corrodedTHE PASSENGER DOOR SURROUND STRUCTURE BACKUP SILL ON STGR 21L BETWEEN FS 333 AND FS 349 HAS CORROSION ON ITS LOWER SIDE FWD END. C-CHECK RO 10/17/2020. REMOVED AND REPLACED THE CORRODED PASSENGER DOOR SURROUND STRUCTURE BACKUP SILL ON STGR 21L BETWEEN FS 333SDR SWIA202053431Door Sill · corrodedTHE PASSENGER DOOR SURROUND STRUCTURE BACKUP SILL ON STGR 21L BETWEEN FS 310 AND FS 333 HAS MULTIPLE SPOTS OF CORROSION. C-CHECK RO 10/17/2020. REMOVED AND REPLACED THE CORRODED PASSENGER DOOR SURROUND STRUCTURE BACKUP SILL ON STGR 21L BETWEEN FS 310 AND FS SDR SWIA202053443Fairing · crackedPAX DOOR FWD AND AFT HINGE FAIRING CRACKED. C-CHECK RO 10/17/2020. REPLACED, LOCATED, AND DRILLED NEW FWD (PN 601R31895-11PP) AND NEW AFT (PN 601R31895-12PP) DOOR HINGE FAIRINGS ON PAX DOOR, REF CRJ700 SRM. INSTALLED ON JOB-71032965 OP-57 MXTRANS-21547682.SDR SWIA202053430Roll Pin · wornPAX DOOR ROLL PIN HAS WORN A GROOVE INTO FUSELAGE SIDE HINGE PIN, FLAGGED. C-CHECK RO 10/17/2020. REPLACED PAX DOOR HINGE FUSELAGE SIDE, REF CRJ700 SRM AND DRAWING. ALL STEPS COMPLIED WITH. OPERATIONS CHECK AND LEAK CHEEK GOOD. COMPLIED WITH SKYWEST TASK SDR SWIA202053429Angle · corrodedGALLEY SERVICE DOOR LOWER SILL ANGLE IS CORRODED, FLAGGED. C-CHECK RO 10/17/2020. SERVICE DOOR SILL ANGLE IS EXFOLIATED AT 90% AT MULTIPLE AREAS AND HAS CORROSION ON MULTIPLE ELEMENTS OUT OF LIMITS, REF CRJ700 SRM. REMOVED AND INSTALLED NEW SERVICEABLE SERVSDR SWIA202053447Angle · corrodedAFT WING TO BODY FAIRING SUPPORT STRUCTURE CENTER SPLICE ANGLE AT FS 939.00 WAS CORRODED. C-CHECK RO 10/17/2020. REMOVED AND REPLACED CORRODED AFT WING TO BODY FAIRING SUPPORT STRUCTURE CENTER SPLICE ANGLE WITH NEW SPLICE (P/N SH670-39189-1) AT FS 939.00, RESDR SWIA202053442Hinge · cracked832DT LOWER HINGE IS CRACKED. C-CHECK RO 10/17/2020. REMOVED AND REPLACED LOWER HINGE ON PAX DOOR 832DT PANEL, PER CRJ700 SRM.SDR SWIA201743050Door Sill · corrodedSERVICE DOOR SILL CORRODED UNDER PROTECTOR PLATE. REMOVED AND REPLACED THE DOOR SILL IAW SRM.SDR SWIA201643047Frame · corrodedCORROSION ON FORWARD SIDE OF FRAME, BS 310, STRINGER 25-26L. REPLACEDTHE FRAME IAW REO.SDR SWIA201643046Frame · corrodedCORROSION ON AFT SIDE OF FRAME, BS 295, STRINGER 26L - 26R. REPAIRED IAW REO.SDR SWIA201643049Panel · chafedRT WING PANEL 684JB IS CHAFED. COMPLIED WITH REO.SDR SWIA201643048Panel · chafedLT WING PANEL 584EB CHAFED. INSTALLED A NEW PANEL IAW SRM.SDR SWIA201642151Strut · malfunctionedAFTER ROTATION, RECEIVED A WOW INPUT CAUTION AND PROXIMITY SYSTEM 1 FAULT STATUS MESSAGES. LANDING GEAR HANDLE SAFETY LATCH REMAINED IN PLACE, SO CREW MANUALLY MOVED LATCH AND SELECTED GEAR TO THE UP POSITION. RECEIVED A GEAR DISAGREE MESSAGE AND NONE OF THESDR SWIA2015402040684Floorbeam · crackedFLOORBEAM CRACKED AT BS 274 LBL 12. REPAIRED IAW REO.SDR SWIA201540683Floorbeam · crackedFLOORBEAM CRACKED AT FS 274 RBL 12. REPAIRED IAW REO.SDR SWIA201333694Skin · chafedSKIN CHAFED BS 969 BELLY AREA UNDER PANEL 196DR. BLENDED OUT CHAFE IAW REO.SDR SWIA201230103Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4786) RELAMPED EMERGENCY LIGHT.SDR SWIA201128399Connector · failedCEILING EMERGENCY LIGHTS AT 2, 7 AND 13AB ARE OUT. (SERVICE) REPLACED CONNECTOR P5480 PIN N.
Back to N631SK