N809SK
Service difficulty reports · 246
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 = 'N809SK' 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 = 'N809SK' 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 SWIA202265362None · damagedWHILE PERFORMING SB 670SH-53-043 THE LBL36 BEAM WAS DAMAGED DURING THE LOCATE AND DRILL UP PROCESS. (C-CHECK RO 4/11/2022) RECEIVED NEW SERVICEABLE LBL 36 BEAM, REFER TO MX TRANS 24494113 FOR DETAILS OF WORK PERFORMED.SDR SWIA202158724Rib · chafedREF CP 22914537-1 AND CP22912256-1 CHAFE DAMAGE FOUND ON RH TRAILING EDGE RIB FLS13.56 LIGHTENING HOLE. DAMAGE MEASURES L= . 2401 D= .1800 (FILED CLOSED) REO 690-57-51-224 DATED 2021-06-06 REV -- COMPLIED WITH. SEE CP 22920547 FOR BLENDING OF DAMAGE ANSDR SWIA202158215Controller · failedDURING DESCENT, HEARD A LOUD POP FROM THE RT FLIGHT DECK WINDOW. NEXT, RECEIVED A RT WINDOW HEAT CAUTION MESSAGE. FLIGHT DECK FILLED WITH AN ACRID BURNING ODOR, NO SMOKE WAS VISIBLE. ODOR DISSIPATED RAPIDLY. SUSPECT THAT THE RT WINDOW FAILED. (FLIGHT 3812)SDR SWIA202157725Windshield · delaminatedTRANSFER FROM EAML 622766 : FRONT WINDSHIELD STARTED TO ARC AND DELAMINATED (FLIGHT 3659 - FILED CLOSED) REMOVED AND REPLACED FRONT LEFT WINDSHIELD PER CRJ900 TASK CARD 56-220-100-SKY. OPS CHECK AND LEAK CHECK GOOD AT THIS TIME.SDR SWIA202155454Skin · dentedTRANSFER FROM EAML 560725: DENT AND SCRATCH (14.5L X 1.2"W X .100" MAX DEEP, REF) ON FUSELAGE SKIN PANEL (DWG. SH670-31071; .047" THK IN THE DAMAGED AREA, REF) BETWEEN FS 453.00-FS 469.00 AND STR 15R -16R. OUT OF SRM LIMITS. THIS HAS BEEN DETERMINED TO BE A SDR SWIA202155374Connector · unsecureBRAKE OVERHEAT MESSAGE ON APPROACH. RIGHT OUTBOARD BRAKE INDICATED 14. MESSAGE CLEARED PRIOR TO IMITATING QRH, THEN MESSAGE RETURNED WITH AN INDICATION OF 8. COMPLIED WITH QRH. MESSAGE CLEARED. FOUND RIGHT OUTBOARD BRAKE TEMP SENSOR CANNON PLUG LOOSE. SESDR SWIA2020030549024Intercostal · corrodedAV BAY DOOR SURROUND STR 27 R/H INTERCOSTAL SHOWS EVIDENCE OF CORROSION ACROSS 100% OF LOWER FLANGE. (C-CHECK) RO 3/3/2020 INTERCOSTAL FOUND OUT OF LIMITS, REF. CRJ900 SRM. REMOVED AND REPLACED INTERCOSTAL, REF. CRJ900 SRM. NO LEAKS NOTED AT THIS TIME. SDR SWIA2020030549023Frame · corrodedF.S.581.00 FRAME @ STGR #27 HAS CORROSION ON FLANGE (C-CHECK) RO 3/3/2020 INSTALLED REPAIR PARTS REF REO, COMPLIED WITH M-337 AND TASK CARD.SDR SWIA2020030549035Angle · crackedANGLE P/N CC670-33199-4 FOUND CRACKED AT AFT END (C-CHECK) RO 3/3/2020 REPLACED NEW ANGLE P/N CC670-33199-4 REF CRJ-900 SRM.SDR SWIA2020030549087Stringer Splice · corrodedSTRINGER 22L SPLICE AT F.S. 333 HAS DEEP PITTING CORROSION. (C-CHECK) RO 3/3/2020 REMOVED AND REPLACED STRINGER SPLICE. REF CRJ900 SRM. LOCATED AND DRILLED, REF CRJ900 SRM. SEALED EDGES AND RESTORED FINISH, REF. CRJ900 SRM.SDR SWIA2020030549033Stiffener · crackedFS 280 RH WEB VERTICAL STIFFENER ON FWD SIDE AT RBL 28 IS CRACKED AT LOWER END THROUGH FASTENER HOLES. (C-CHECK) RO 3/3/2020 REPLACED STIFFNER REF CRJ-900 SRM.SDR SWIA2020030549085Fitting · corrodedPAX DOOR SURROUND, FWD DRAIN TUBE FITTING CORRODED ALL THE WAY THROUGH. 100% MATERIAL LOSS. (C-CHECK) RO 3/3/2020 INSTALLED NEW DRAIN TUBE REF CRJ 900 SRM 51-42-06SDR SWIA2020030548996Angle · crackedFOUND CRACK IN 2 ANGLES ON STGR 21 FS320.00 AND FS 310.00 (C-CHECK) RO 3/3/2020 REMOVED AND REPLACED 2(EA) ANGLES ON STR 21, COMMON TO BACKUP SILL, REF CRJ900 SRM. ANGLES FABRICATED ON JOB: 915086105 OP:74, MX TRANS #20400883 AND JOB:915086105 OP:75, MX TRSDR SWIA2020030549020Splice · corrodedUPON REMOVAL, FS280 CROSS BEAM (QTY2) CENTER SPLICE FOUND CORRODED. (C-CHECK) RO 3/3/2020 FS280 CROSSBEAM CENTER LOWER SPLICE REPLACED. REF: CRJ900 SRM. COMPLIED WITH SWA M-337 FOR MAJOR REPAIR.SDR SWIA2020030549019Bulkhead · corrodedR/H FS280 BULKHEAD LOWER WEB FOUND CORRODED (C-CHECK) RO 3/3/2020 REPLACED R/H FS 280 BULKHEAD LOWER WEB REF. CRJ 900 SRM AND BOMBARDIER SB. COMPLIED WITH SWA M-337 FOR MAJOR REPAIR.SDR SWIA2020030549018Channel · brokenR/H PRESSURE FLOOR SILL FWD DRAIN CHANNEL SPOUT BROKEN AT RBL36 APROX (F.S. 693.00). (C-CHECK) RO 3/3/2020 C/W REOSDR SWIA2020030549017Bulkhead · crackedFS280 L/H BULKHEAD LOWER WEB FOUND CORRODED AND CRACKED (C-CHECK) RO 3/3/2020 FS280 L/H BULKHEAD LOWER WEB REPLACED WITH NEW FABRICATED LOWER WEB. REF: CRJ900 SRM SB COMLIED WITH SWA M-337 FOR MAJOR REPAIR.SDR SWIA2020030549014Skin · gougedGOUGE FOUND ON EXTERNAL SKIN BETWEEN FS 942.00 AND FS 954.00 OVER STRG 27 (C-CHECK) RO 3/3/2020 REMOVED AND FABRICATED REPAIR PARTS; -1 BOTTOM DOUBLER (2024-T3 0.063" P.O. TX0012791), -2 TOP DOUBLER (2024-T3 0.063" P.O. TX0012791) , -3 FILLERS (2024-T3 0.0SDR SWIA2020030549084Seat Track · corrodedEVIDENCE OF CORROSION ON R/H SEAT TRACK U CHANNEL AT FS 677-720 (C-CHECK) RO 3/3/2020 REPLACED RH SEAT TRACK "U" CHANNEL AT FS 677 - 720 REF CRJ-900 AMM.SDR SWIA2020030549013Frame · corrodedEVIDENCE OF CORROSION ON FRAME AT STR 21 TO 20 AT FS 319 (C-CHECK) RO 3/3/2020 REMOVED AND INSTALLED NEW FRAME P/N SH670-31891-3 REF CRJ900 SRM AND BOMBARDIER DWG. NO LEAK NOTED. COMPLIED WITH TASK CARD AND MAJOR REPAIR M-337SDR SWIA2020030549083Fitting · corroded*PAX DOOR SILL AFT DRAIN FITTING CORRODED THROUGH. (C-CHECK) RO 3/3/2020 INSPECTED AND FOUND TO BE VISIBLY OUT OF LIMITS, 100% MATERIAL LOSS. REMOVED AND REPLACED DRAIN FITTING, REF CRJ900 SRM.SDR SWIA2020030549082Attach Angle · corrodedCORROSION ON 2 EA FLOOR SILL ATTACH ANGLES @ PAX DOOR ( P/N. SH670-31821-5) (C-CHECK) RO 3/3/2020 BLENDED BOTH ANGLES, INSPECTED, AND DETERMINED TO BE OUT OF LIMITS, REF. CRJ900 SRM. REMOVED AND REPLACED FWD AND AFT ANGLES, REF. CRJ900 SRM. LOCATED AND SDR SWIA2020030549012Crossbeam · corroded280 CROSSBEAM HAS EVIDENCE OF CORROSION (C-CHECK) RO 3/3/2020 REMOVED AND INSTALLED 280 L/H AND R/H CROSSBEAMS REF. CRJ 900 SRM AND BOMBARDIER SB. COMPLIED SWA M-337 FOR MAJOR REPAIR.SDR SWIA2020030549080Crossbeam · corroded* L/H 280 CROSSBEAM CORRODED ON FWD SIDE OF BEAM AT UPPER SECTION. (C-CHECK) RO 3/3/2020 REMOVED AND REPLACED ON MX# 20326924 JOB 915086104 OP 131SDR SWIA2020030549079Structure · corroded*EVIDENCE OF CORROSION FOUND AT APROX FS847.00 +45.00 BETWEEN LH STRG 22 AND LH STRG 23 (C-CHECK) RO 3/3/2020 COMPLIED WITH REPAIR OF CORROSION @ FS847.00 + 45.00 BETWEEN LH STRG 22 AND LH STGR 23 PER REO. ALL STEPS COMPLIED WITH. SEE CONTINUE CARD FOR DETSDR SWIA2020030549011Stringer · corrodedSTRINGER 27 @ FS.352.00 HAS CORROSION (C-CHECK) RO 3/3/2020 REMOVED AND INSTALLED NEW STRINGER 27 PN: SH670-31371-3 FS 352.00 TO FS 340.00 REF CRJ-900 SRM COMPLIED WITH TASKCARD AND M-337 NO LEAKS NOTEDSDR SWIA2020030549077Structure · corroded* CORROSION DETECTED ON "BOTH" FWD/AFT SIDES OF F.S. 549.00, L/H FUSELAGE, BELOW FLOOR SILL AND ABOVE FBB DOOR SURROUND STRUCTURE (MARKED). (C-CHECK) RO 3/3/2020 COMPLIED WITH ALL STEPS OF REO. SEE CONTINUE CARD FOR DETAILS. NO LEAKS NOTED.SDR SWIA2020030549076Structure · corroded* CORROSION DETECTED ON "BOTH" FWD/AFT SIDES OF F.S. 533.00, L/H FUSELAGE, BELOW FLOOR SILL AND ABOVE FBB DOOR SURROUND STRUCTURE (MARKED) (C-CHECK) RO 3/3/2020 COMPLIED WITH ALL STEPS OF REO. SEE CONTINUE CARD FOR DETAILS.SDR SWIA2020030549075Angle · corroded* CORROSION DETECTED AT STGR (19R) ON (CLIP/ANGLE) MEMBER THAT ATTACHES TO STGR (19R) ON AFT SIDE OF F.S. 661.00+90.00 (MARKED). (C-CHECK) RO 3/3/2020 REMOVED TENSION FITTING P/N SH670-39090-1 REF CRJ900 SRM; LOCATED, DRILLED AND TRIMMED REPLACEMENT DIAPHSDR SWIA2020030549073Door Sill · corroded* CORROSION DETECTED ON R/H FLOOR "SILL" FROM F.S. 349.00 TO F.S.364.00, LARGE AREAS (MARKED). (C-CHECK) RO 3/3/2020 REMOVED AND REPLACED FLOOR SILL ON RHS BETWEEN FS349-FS409 REF CRJ900 SRM. NO LEAKS NOTED AT THIS TIMESDR SWIA2020030549071Door Sill · corroded* CORROSION DETECTED ON R/H FLOOR " SILL" FROM F.S. 280.00 TO F.S. 318.70, IN SEVERAL PLACES (MARKED). (C-CHECK) RO 3/3/2020 REPLACED R/H FLOOR SILL BETWEEN FS 280.00-319.00 REF. CRJ 900 SRM NO LEAKS FOUNDSDR SWIA2020030549070Support Angle · corroded* CORROSION DETECTED ON FLOOR BOARD SUPPORT "ANGLE" ATTACHED TO FWD SIDE OF F.S. 280.00 CROSS BEAM , BETWEEN (LBL 12.0) AND (RBL 12.00) (MARKED). (C-CHECK) RO 3/3/2020 FLOOR BOARD SUPPORT ANGLE ATTACHED TO FWD SIDE OF FS280 CROOBEAM BTWN LBL12 & RBL12 REPSDR SWIA2020030549031Bracket · crackedPASSENGER DOOR WHEEL SUPPORT WHEEL PULLEY BRACKET IS CRACKED (C-CHECK) RO 3/3/2020 REMOVED AND REPLACED PAX DOOR WHEEL SUPPORT WHEEL PULLEY BRACKET P/N 601R317187-1 AND BRACKET,PULLEY**C P/N 601R317186-1 IAW CRJ 900 SRM.SDR SWIA2020030549010Stringer · corroded*CORROSION DETECTED ON STGR (22L) BETWEEN F.S. 501.00 AND F.S. 517.00, JUST FWD OF FBB FWD DOOR OPENING (MARKED). (C-CHECK) RO 3/3/2020 REMOVED STRINGER 22L AT 517.00-477.00 IAW CRJ900 SRM. INSTALLED STRINGER SPLICE IAW CRJ900 SRM. COMPLIED WITH AND M-337SDR SWIA2020030549009Stringer · corroded* CORROSION DETECTED ON STGR (19R) BETWEEN F.S. 645.00 AND F.S. 661.00 (MARKED). (C-CHECK) RO 3/3/2020 REMOVED DAMAGED SECTION OF STRINGER. REF: CRJ-900 S.R.M. INSTALLED QTY2 REPAIR SPLICES, QTY2 SHIMS & STRG SECTION. REF: CRJ900 SRM. NO LEAKS NOTED AT THSDR SWIA2020030549008Stringer · corroded* CORROSION DETECTED ON (STGR 19R) BETWEEN F.S. 597.00 AND F.S. 629.00 (MARKED). (C-CHECK) RO 3/3/2020 REMOVED DAMAGED/CORRODED STRINGER SECTION . REF: CRJ-900 S.R.M. FABRICATED NEW STRINGER SECTION AND QTY 2 STRINGER SPLICES ON STGR 19R BETWEEN F.S. 597.0SDR SWIA2020030549007Frame · corroded* CORROSION DETECTED ON (AFT) SIDE OF F.S. 349.00, ON "VERTICAL FACE" AND THE "FLANGE" , BETWEEN STGR 26L AND 26R (MARKED). (C-CHECK) RO 3/3/2020 REMOVED AND REPLACED FRAME FLANGE AT FS 349.0 STR 26L - 26R REF BOMBARDIER REO. NO LEAKS NOTED AT THIS TIMESDR SWIA2020030549006Stringer · corroded* CORROSION DETECTED ON STGR (22R) JUST FWD OF F.S. 349.00 (MARKED). (C-CHECK) RO 3/3/2020 REMOVED AND REPLACED STR 22R, P/N SH670-31379-1, REF CRJ 900 SRM. NO LEAKS NOTED AT THIS TIME COMPLIED WITH M-337 AND TASKCARD.SDR SWIA2020030549089Door Sill · corrodedPAX DOOR SILL IS CORRODED (MARKED) (C-CHECK) RO 3/3/2020 BLENDED, INSPECTED AND DETERMINED TO BE OUT OF LIMITS, 100% MATERIAL LOSS, REF. CRJ900 SRM. REMOVED AND REPLACED MID CAP ANGLE, REF CRJ900 SRM. SEE CONTINUATION FOR DETAILS.SDR SWIA2020030549069Stringer · corrodedLH STRG 26 HAS CORROSION ON APROX FS 350.00 (C-CHECK) RO 3/3/2020 REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. C/W REO. NO LEAKS NOTEDSDR SWIA2020030549067Stringer · corrodedCORROSION FOUND ON STRG 20 FROM APROX FS 320.00 TO FS 333.00 ON BEAM. (C-CHECK) RO 3/3/2020 INSTALLED NEW BACK UP SILLS P/N- SH670-31822-1 AND SH670-31823 -1 REF: CRJ-900 S.R.M. NO LEAKS NOTED AT THIS TIMESDR SWIA2020030549064Support Angle · corrodedUNDERFLOOR INSIDE A-BAY AT FS 280.00, FLOOR SUPPORT ANGLE IS CORRODED (C-CHECK) RO 3/3/2020 EVALUATED AND FOUND TO BE OUT OF LIMITS, NO DAMAGE ALLOWED ON CRAWLWAY ANGLE PN# SH670-32330-1 REF CRJ-900 SRM. REMOVED AND REPLACED WITH NEW ANGLE P/N SH670-32330-SDR SWIA2020030549063Seat Track · corrodedRH SIDE SEAT TRACK FS744.00-FS752.00 HAS SEVERAL AREAS OF CORROSION (C-CHECK) RO 3/3/2020 REMOVED & REPLACED WITH NEW RH SEAT TRACK @ FS 744.00-FS752 REF CRJ900 AMM. SEE CONTINUE CARD FOR DETAILS.SDR SWIA2020030549062Seat Track · corrodedRH SIDE SEAT TRACK FS677.00-FS720.00 HAS SEVERAL AREAS OF CORROSION (C-CHECK) RO 3/3/2020 REPLACED RH SIDE SEAT TRACK FS 677-720 REF CRJ-900 AMM.SDR SWIA2020030549061Seat Track · corrodedLH SIDE SEAT TRACK"U" CHANNEL FS693.00-FS720.00 HAS SEVERAL AREAS OF CORROSION (C-CHECK) RO 3/3/2020 REMOVED AND REPLACED LH SIDE SEAT TRACK "U" CHANNEL @FS693.00-SF720.00 P/N: SH690-37554-1. REF CRJ900 SRM. SEE CONTINUE CARD FOR DETAILS.SDR SWIA2020030549060Seat Track · corrodedLH SIDE SEAT TRACK"U" CHANNEL FS785.00-FS847.00(+6) HAS SEVERAL AREAS OF CORROSION (C-CHECK) RO 3/3/2020 REPLACED TRIM RETAINER "U CHANNEL" AT FS 785-847 REF. CRJ 900 SRM.SDR SWIA2020030549058Seat Track · corrodedLH FLOOR SEAT TRACK FS379.00-FS469.00 HAS SEVERAL AREAS OF CORROSION (C-CHECK) RO 3/3/2020 REPLACED LH FLOOR SEAT TRACK REF CRJ-900 AMM.SDR SWIA2020030549056Seat Track · corrodedRH FLOOR SEAT TRACK FS349.00-FS469.00 HAS SEVERAL AREAS OF CORROSION (C-CHECK) RO 3/3/2020 REPLACED RH FLOOR SEAT TRACK REF CRJ-900 AMM.SDR SWIA2020030549055Seat Track · corrodedLH FLOOR SEAT TRACK FS849.00-FS985.00 HAS SEVERAL AREAS OF CORROSION (C-CHECK) RO 3/3/2020 REPLACED LH FLOOR SEAT TRACK REF CRJ-900 AMM.SDR SWIA2020030549054Seat Track · corrodedLH FLOOR SEAT TRACK FS830.00-FS849.00 HAS SEVERAL AREAS OF CORROSION (C-CHECK) RO 3/3/2020 REPLACED LH FLOOR SEAT TRACK FS 830.00 - 849.00 REF CRJ-900 AMM. SEE JOB 915086105 OP 60 MX TRANS # 20366659 FOR FABRICATION
Back to N809SK