N727SK
Service difficulty reports · 184
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 = 'N727SK' 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 = 'N727SK' 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 SWIA2020020748336Pin · wornHORIZONTAL STABILIZER INNER PIN WORN OUT OF LIMITS (C-CHECK) RO 2/05/2020 ORDERED AND RECEIVED HORIZONTAL STABILIZER INNER PIN INSTALLED ON JOB 71019197 OP 3 CAMP # 20227292SDR SWIA2020020748312Intercostal · corrodedINTERCOSTAL CLIP AT FS 333.0 STGR 20R FWD SIDE IS CORRODED. (C-CHECK) RO 2/05/2020 REMOVED CORRODED CLIP AND INSTALLED NEW CLIP AT FS333.0 STGR20R,REF BOMBARDIER DWG AND CRJ-700 SRM AND TASK CARD.SDR SWIA2020020748311Stringer · corroded* STRINGER 26R HAS CORROSION FROM FS1031.00 TO FS1047.00. (MARKED) (C-CHECK) RO 2/05/2020 REMOVED AND INSTALLED NEW STRINGER 26R FROM FS1015.00 TO FS1096.00 REF- CRJ700 SRM, DRAWING AND BOMBARDIER REO. LEAK CHECK GOOD,NO LEAKS NOTED. COMPLIED WITH TASK.SDR SWIA2020020748310Stringer · corroded* STRINGER 25L HAS CORROSION FROM FS1031.00 TO FS1047.00. (MARKED) (C-CHECK) RO 2/05/2020 REMOVED CORROSION AT STGR 25L FROM FS1031.00 TO FS1047.00 REF-CRJ-700 SRM, AND REO, PART WITHIN LIMITS, SEE CONTINUATION CARD FOR DETAILS. PRESSURE CHECKS GOOD. WEIGSDR SWIA2020020748338Intercostal · corroded*INTERCOSTAL CORRODED. FS349.00 €“ FS364.00 AT STGR20R IS CORRODED. (C-CHECK) RO 2/05/2020 REMOVED CORROSION ON INTERCOSTAL AT FS349.0 TO FS364.0 STGR20R, ORIGINAL PART THICKNESS = .063",MATERIAL REMOVED = .003",REMAINING THICKNESS = .060", ALLOWABLE BLENSDR SWIA2020020748335Floorbeam · corroded* THE FLOOR ANGLE SUPPORT BELOW FLOOR AT FS 280.00 BETWEEN STRG 25R AND 25L HAS CORROSION IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK) RO 2/05/2020 BLENDED OUT CORROSION ON SUPPORT ANGLE, ORIGINAL PART THICKNESS = .050",MATERIAL REMOVED .012",MATERIAL REMAINISDR SWIA2020020748331Seat Track · corrodedINTERIOR FUSELAGE(SIDE SEAT RAIL) AT APPROX FS 708.0HAS PITTING CORROSION ON SEAT RAIL R/H SIDE (C-CHECK) RO 2/05/2020 REPLACED RH SIDE SEAT RAIL AT FS708. SEE CONTINUE CARD FOR DETAILS OF WORK PERFORMEDSDR SWIA2020020748330Seat Track · corrodedSEAT RAIL RBL 9, BEGINNING AT FS349 AFTWARDS TO APPROX FS477, HAS CORROSION PITTING ALONG ITS LENGTH AS MARKED. (C-CHECK) RO 2/05/2020 REPLACED RH SEAT RAIL AT RBL 9 FROM FS349 TO FS477. SEE CONTINUE CARD FOR DETAILS OF WORK PERFORMEDSDR SWIA2020020748329Seat Track · corrodedINTERIOR FUSELAGE( SIDE SEAT RAIL) AT APPROX FS 708.0 HAS PITTING CORROSION INSIDE SEAT RAIL. L/H SIDE (C-CHECK) RO 2/05/2020 REPLACED LH SIDE SEAT RAIL AT FS708. SEE CONTINUE CARD FOR DETAILS OF WORK PERFORMEDSDR SWIA2020020748328Floor Support · corroded*RIGHT FLOOR SILL FS349.00 €“ FS364.00 IS CORRODED. (C-CHECK) RO 2/05/2020 REMOVED CORROSION ON R/H FLOOR SILL FS349-FS364 REF CRJ 700 SRM. R/H FLOOR SILL FS 349 TO FS364 OUT OF LIMITS REF CRJ 700 SRM. COMPLIED WITH REO FOR R/H SILL FROM FS349 TO FS364SDR SWIA2020020748309Door Sill · corroded* THE AFT CARGO DOOR SURROUND STRUCTURE FUSELAGE SIDE LOWER SILL HAS MULTIPLE LOCATIONS OF CORROSION FROM FS 1000.00 TO FS1047.00. (C-CHECK) RO 2/05/2020 REMOVED AND INSTALLED NEW AFT CARGO DOOR LOWER SILL FS1000.00 REF-CRJ-700 SRM, AND BOMBARDIER DWG, LESDR SWIA2020020748308Floorbeam · damaged* FORWARD CARGO BAY FLOOR BEAM AND CAP PLATE HAS A HOLE IN THE EDGE AT APPROXIMATLY FS581, LBL 11, MARKED. (C-CHECK) RO 2/05/2020 REPLACED CAP PLATE AT FS581, LBL11 REF CRJ-700 SRM, DWG. REMOVED UNDERLYING DAMAGE AND FOUND REWORKED AREA TO BE WITHIN LIMITSDR SWIA2020020748307Floor Support · corrodedRH FLOOR SILL ANGLE FROM FS280 TO FS319 FWD OF THE SERVICE DOOR HAS CORROSION(MARKED (C-CHECK) RO 2/05/2020 REMOVED AND REPLACED RH FLOOR SILL ANGLE FROM FS280 TO FS319 OF SERVICE DOOR REFC-RJ-700 SRM AND DWG. LEAK CHECK GOOD,NO LEAKS NOTED. COMPLIED WITHSDR SWIA2020020748306Floorbeam · corrodedFLOOR SUPPORT ANGLE AT APROX. FS280, WL 72.00 HAS CORROSION ALONG ITS ENTIRE WIDTH. (C-CHECK) RO 2/05/2020 BLENDED OUT CORROSION ON COCKPIT FLOOR SUPPORT ANGLE, ORIGINAL PART THICKNESS = .063", MATERIAL REMOVED = .021", REMAINING PART THICKNESS = .042", ALSDR SWIA2020020748305Door Sill · corrodedPAX DOOR SURROUND STRUCTURE, BACKUP SILL LOCATED AT STGR 21L, FS333.00 TO FS349.00 HAS CORROSION. (C-CHECK) RO 2/05/2020 REMOVED DAMAGED - OUT OF LIMITS - AND INSTALLED NEW BACK UP SILL AT STGR 21L BETWEEN FS 333.00 - FS 349.00 REF CRJ 700 SRM AND BOMBARDISDR SWIA2020020748304Door Sill · corrodedPAX DOOR SURROUND STRUCTURE SILL BACKUP LOCATED AT STGR 21L, FS310.00 TO FS333.00 HAS CORROSION. (C-CHECK) RO 2/05/2020 REMOVED AND REPLACED PAX DOOR SILL LOCATED AT STGR 21L, FS310.00 TO FS333.00 REF-CRJ-700 SRM, LEAK CHECK GOOD. COMPLIED WITH THE TASK.SDR SWIA2020020748303Frame · corrodedFRAME AT FS319, AT APROX. STGR21L HAS CORROSION ON THE AFT SIDE. (C-CHECK) RO 2/05/2020 REMOVED DAMAGED AND INSTALLED NEW FRAME AT FS 319 BETWEEN STGR 21L AND 18L REF CRJ 700 SRM AND BOMBARDIER DWG. PRESSURE LEAK CHECK GOOD. COMPLIED WITH THE TASK.SDR SWIA2020020748302Cup · corrodedPAX DOOR THRESHHOLD AREA, BOTH FWD AND AFT "CUPS" FOR HANDRAIL CLEARENCE HAVE CORROSION(MARKED) (C-CHECK) RO 2/05/2020 PAX DOOR THRESHHOLD AREA, BOTH FWD AND AFT "CUPS" FOR HANDRAIL CLEARENCE NO ALLOWABLE DAMAGE ALLOWED OUT OF LIMITS REF CRJ 700 SRM. REMOSDR SWIA2020020748301Angle · corrodedPAX DOOR THRESHOLD AREA, MID CAP ANGLE HAS CORROSION. (C-CHECK) RO 2/05/2020 REMOVED AND REPLACED PAX DOOR THRESHOLD MID CAP ANGLE REF-CRJ-700 SRM, BOMBARDIER DWG & BOMBARDIER. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH TASK.SDR SWIA2020020748300Angle · corrodedPAX DOOR THRESHOLD AREA, FWD CAP ANGLE HAS CORROSION. (C-CHECK) RO 2/05/2020 REMOVED OUT OF LIMITS CAP ANGLE AND INSTALLED NEW FWD CAP ANGLE P/N SH670-31821-5 REF CRJ700 SRM, DWG. COMPLIED WITH TASK CARD.SDR SWIA2020020748299Stringer · corrodedSTRINGER 20R, JUST AFT OF FS333, HAS CORROSION.(MARKED) (C-CHECK) RO 2/05/2020 REMOVED AND INSTALLED NEW STRINGER 20R AT FS333 REF-CRJ-700 SRM AND BOMBARDIER DWG. LEAK CHECK GOOD,NO LEAKS NOTED. COMPLIED WITH TASK.SDR SWIA2020020748298Intercostal · corrodedSTGR 27R INTERCOSTAL FROM FS364 TO FS349, HAS CORROSION(MARKED) (C-CHECK) RO 2/05/2020 REMOVED DAMAGED AND INSTALLED NEW LATCH PIN INTERCOSTAL AT FS364 - FS349, STGR 27R REF CRJ-700 SRM AND DWG. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH THE TASK.SDR SWIA2020020748297Intercostal · corrodedSTGR 27L INTERCOSTAL FROM FS364 TO FS349, HAS CORROSION(MARKED) (C-CHECK) RO 2/05/2020 REMOVED DAMAGED AND INSTALLED NEW LATCH PIN INTERCOSTAL AT FS364 - FS349, STGR 27L REF CRJ-700 SRM, AND DWG. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH THE TASK.SDR SWIA2020020748296Structure · chafedRH AILERON TOP LEADING EDGE HAS CHAFE MARKS AT CENTER AREA (C-CHECK) RO 2/05/2020 REMOVED CHAFE MARKS FROM RH AILERON UPPER LEADING SKIN AND FOUND REWORKED AREA TO BE OUT OF LIMITS. REPLACED SKIN REF CRJ-700 SRM, DWG. COMPLIED WITH TASK.SDR SWIA2020020748295Frame Angle · corroded*CLIP ON FORWARD SIDE OF FRAME, FS349.00, FOR INTERCOSTAL STGR20R IS CORRODED. (C-CHECK) RO 2/05/2020 REMOVED CORRODED CLIP AND INSTALLED NEW CLIP AT FWD SIDE OF FS349.0 STGR 20R,REF CRJ700 SRM AND BOMBARDIER DWG, / COMPLIED TASK CARD.SDR SWIA2020020748294Frame Angle · corroded*CLIP ON AFT SIDE OF FRAME, FS319.70, FOR INTERCOSTAL STGR20R IS CORRODED. (C-CHECK) RO 2/05/2020 REMOVED CORRODED CLIP ON AFT SIDE OF FS319.7 STGR 20R AND INSTALLED NEW CLIP,REF CRJ-700 SRM AND BOMBARDIER DWG AND TASK CARD.SDR SWIA2020020748293Intercostal · corroded*INTERCOSTAL CORRODED. FS319.70 €“ FS349.00 AT STGR20R IS CORRODED. (C-CHECK) RO 2/05/2020 REMOVED AND REPLACED INTERCOSTAL AT FS319.70 - 349.00 AT STGR 20R REF-CRJ-700 SRM AND BOMBARDIER DWG. COMPLIED WITH TASK.SDR SWIA2020020748292Mount · corroded*GALLEY MOUNT HAS CORROSION AROUND AND INSIDE OF THE MOUNT BOLT HOLE. (MARKED) (C-CHECK) RO 2/05/2020 REPLACED GALLEY FLOOR FITTING WITH NEW REF BOMBARDIER DRAWING AND CRJ-700 SRM.SDR SWIA2020020748291Drag Angle · cracked*RH V/STAB TO FUSELAGE AFT ATTACHMENT DRAG ANGLE POSSIBLE CRACK. MARKED (C-CHECK) RO 2/05/2020 COMPLIED THE REPAIR AT RH VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE REF-CRJ-700 REO. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH TASK.SDR SWIA201948290Drag Angle · cracked*LH V/STAB TO FUSELAGE AFT ATTACHMENT DRAG ANGLE POSSIBLE CRACK. MARKED (C-CHECK) RO 2/05/2020 COMPLIED THE REPAIR AT LH VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE REF-CRJ-700 REO. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH SKYWEST TASDR SWIA2020020748289Drag Angle · cracked*LH V/STAB TO FUSELAGE ATTACHMENT FWD DRAG ANGLE POSSIBLE CRACK. MARKED (C-CHECK) RO 2/05/2020 COMPLIED THE REPAIR AT LH VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD DRAG ANGLE REF-CRJ-700 REO. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH SKYWEST TASDR SWIA2020020748288Intercostal · corrodedPAX DOOR INTERCOSTAL DD4 P/N 601R31902-317 HAS CORROSION (C-CHECK) RO 2/05/2020 REMOVED AND INSTALLED NEW PAX DOOR INTERCOSTAL DD4 REF-CRJ-700 SRM. NO LEAKS NOTED. SEE CONTINUATION CARD FOR DETAILS OF WORK PERFORMED. COMPLIED WITH THE TASK.SDR SWIA2020020748287Intercostal · corrodedPAX DOOR INTERCOSTAL DD3 P/N 601R318056-1 HAS CORROSION (C-CHECK) RO 2/05/2020 REMOVED AND INSTALLED NEW PAX DOOR INTERCOSTAL DD3 REF-CRJ-700 SRM. NO LEAKS NOTED. SEE CONTINUATION CARD FOR DETAILS OF WORK PERFORMED. COMPLIED WITH THE TASK.SDR SWIA2020020748286Intercostal · corrodedPAX DOOR INTERCOSTAL DD4 P/N 601R318081-1 HAS CORROSION (C-CHECK) RO 2/05/2020 REMOVED AND INSTALLED NEW PAX DOOR INTERCOSTAL DD4 REF-CRJ-700 SRM. NO LEAKS NOTED. SEE CONTINUATION CARD FOR DETAILS OF WORK PERFORMED. COMPLIED WITH THE TASK.SDR SWIA2020020748334Roller · wornLH SLAT TRACK 2-2 AFT I/B SIDE ROLLER WORN. (PN: CC670-12027-3) (C-CHECK) RO 2/05/2020 REMOVED AND REPLACED WORN LH SLAT TRACK 2-2 AFT I/B SIDE ROLLER WITH NEW. (PN: CC670-12027-3), REF CRJ700 AMM'S. ALL CHECKS GOOD, SEE CONTINUATION FOR FURTHER DETAILS.SDR SWIA2020020748333Roller · wornLH SLAT TRACK 1-2 AFT O/B SIDE ROLLER WORN. (PN: CC670-12027-3) (C-CHECK) RO 2/05/2020 REMOVED AND REPLACED WORN LH SLAT TRACK 1-2 AFT O/B SIDE ROLLER WITH NEW. (PN: CC670-12027-3) REF CRJ700 AMM'S. ALL CHECKS GOOD.SDR SWIA2020020748327Drag Angle · crackedSUSPECTED CRACK ON PAX DOOR AFT DRAG ANGLE (C-CHECK) RO 2/05/2020 REPLACED PASSENGER DOOR AFT DRAG ANGLE WITH NEW. REF CRJ-700 SRM AND BOMBARDIER DRAWING.SDR SWIA2020020748285Hinge · gougedPAX DOOR PIANO HINGE ( FUSELAGE SIDE ) HAVE MULTIPLE LANDS WITH SCRATCHES AND LAND # 27 IS GOUGED FROM SPRING PIN (C-CHECK) RO 2/05/2020 REMOVED AND INSTALLED NEW PASSENGER DOOR HINGE, FUSELAGE SIDE, PER CRJ 700 SRM AND BOMBARDIER DWG. PRESSURE CHECK GOOD.SDR SWIA2020020748337Shaft · broken*SERVICE DOOR - SPRING ON THE LOWER ROLLER ASSEMBLY SHAFT IS BROKEN. (FLAGGED) (C-CHECK) RO 2/05/2020 REMOVED THE BROKEN AND INSTALLED NEW SPRING PN MS24586C103 BY INSERTING HOOK ENDS INTO EYE BOLT AND AROUND PIN ON THE LOWER ROLLER ASSEMBLY TORQUE TUBE OFSDR SWIA2020020748284Striker · gouged* PAX DOOR BOTTOM SEAL STRIKER IS GOUGED IN 11 PLACES, MARKED. (C-CHECK) RO 2/05/2020 INSTALLED NEW PAX DOOR BOTTOM SEAL STRIKER REF CRJ700 SRM AND CRJ 700 SRM AND BOMBARDIER DWG. PRESSURE CHECKS GOOD. NO LEAKS NOTED. COMPLIED WITH TASK CARD.SDR SWIA2020020748283Housing · cracked* AFT BAG BAY DOOR HANDLE HOUSING IS CRACKED IN 2 PLACES, MARKED. (C-CHECK) RO 2/05/2020 REMOVED AND INSTALLED NEW AFT CARGO DOOR HANDLE HOUSING REF-CRJ-700 SRM, OPS & LEAK CHECK GOOD.SEE CONTINUATION CARD FOR DETAILS. / COMPLIED WITH TASK.SDR SWIA2020020748332Panel · chafedRH WING PANEL 622DB IS CHAFED. (C-CHECK) RO 2/05/2020 REMOVED CHAFE ON R/H WING PANEL 622DB REF CRJ 700 SRM. R/H WING PANEL 622DB FOUND OUT OF LIMITS REF CRJ 700 SRM. LOCATED AND DRILLED NEW R/H WING PANEL 622DB REF CRJ 700 SRM.SDR SWIA2020020748282Mount · corrodedGALLEY 1 IB AFT MOUNT FITTING CORRODED. (C-CHECK) RO 2/05/2020 REPLACED GALLEY 1 IB AFT MOUNT FITTING WITH NEW. REF CRJ-700 SRM AND BOMBARDIER DRAWING.SDR SWIA2020020748281Channel · damagedD: AFT DRAIN MAST HAS 2 DAMAGED SCREWS (AFT 2 SCREWS). TEMPORARY REPAIR COMPLIED WITH PER REO. PERMANENT REPAIR DUE WITHIN 6000 FLIGHT HOURS BY TAT 42428.6. / C: MCI / RA# 36609 / NOTE: MX CODE BUILT TO TRACK 600 FLT HR LPI OR EDDY CURRENT INSP PER NDTM 51-20-SDR SWIA2018121345375Post · crackedLBL30 POST ON FWD SIDE OF FS202 BULKHEAD HAS A CRACK INDICATION NOTED AT THE TOP IN THE AFT I-BEAM FLANGE INTERSECTION 0.200" LONG. (202-MOD) RO: 12/12/2018 REPAIRED CRACKED LBL 30 POST IAW SRM.SDR SWIA2018121345374Frame · crackedLH 220 FRAME VISUALLY CRACKED. (202-MOD) RO: 12/12/2018 REPAIRS WERE ACCOMPLISHED IAW SRM.SDR SWIA2018121345373Frame · crackedFS220 FRAME ON R/H SIDE OF A/C HAS A CRACK INDICATION NOTED AT FASTENER HOLE I/B OF LIGHTING HOLE BELOW STGR13A. INDICATION IS 0.100" LONG. (202-MOD) RO: 12/12/2018 REPAIRS WERE ACCOMPLISHED IAW SRM.SDR SWIA2018121345372Post · crackedRBL30 POST ON FWD SIDE OF FS202 BULKHEAD HAS A CRACK INDICATION NOTED AT THE TOP IN THE AFT I-BEAM FLANGE INTERSECTION 0.200" LONG. (202-MOD) RO: 12/12/2018 REPAIRED CRACKED RBL 30 POST IAW SRM.SDR SWIA2018121345371Frame · crackedLH 235 FRAME CRACKED. (202-MOD) RO: 12/12/2018 REPAIRED LH 235 FRAME IAW SRM.SDR SWIA201642328Floor Support · corrodedREMOVE AND REPLACE RT FWD FLOOR SUPPORT BS 280 TO 319 DUE TO OUT OF LIMITS CORROSION. REPLACED THE RT FLOOR SUPPORT IAW SRM.
Back to N727SK