N715SK
Service difficulty reports · 144
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 = 'N715SK' 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 = 'N715SK' 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 SWIA202265309None · corrodedPAX DOOR LOWER SILL ANGLE IS CORRODED. (C-CHECK RO 4/9/2022) REMOVED AND REPLACED PAX DOOR LOWER SILL ANGLE WITH NEW SERVICEABLE PART IAW CRJ 700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. MAJOR REPAIR TASK CARD 51-900-1002-SKY AND FORM M-337 COSDR SWIA202265308None · corrodedH DOUBLER AT FS 533.00 STRINGER 26L IS CORRODED. (C-CHECK RO 4/9/2022) H DOUBLER AT FS 533.00 STRINGER 26L WAS REMOVED AND REPLACED AS REQUIRED IAW CRJ 700 SRM 51-42-21-001-001-A01 AND 51-42-22-001-001-A01 REV.38B DATED 14 DEC 2020. MAJOR REPAIR TASK CASDR SWIA202265307None · corrodedR/H FLOOR SILL IS CORRODED BETWEEN F.S. 280 TO F.S. 295. (C-CHECK RO 4/9/2022) REMOVED AND REPLACED R/H FLOOR SILL I.A.W. BOMBARDIER CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 REV.38B, DATED 12/14/2020. COMPLIED WITH SKYWEST TASK CARD 51-9SDR SWIA202265306None · corrodedDOUBLER CORRODED AT STGR 27 BETWEEN FS 485.00 AND FS 517.00. (C-CHECK RO 4/9/2022) REMOVED AND REPLACED DOUBLER AT STGR 27 BETWEEN FS 485.00 AND FS 517.00 IAW CRJ 700 SRM 51-42-06-001-001-A01 REV. 38B DATED 14 DEC 2020. MAJOR REPAIR TASK CARD 51-900-10SDR SWIA202265305None · corrodedAFT CARGO DOOR LOWER SILL HAS LIGHT CORROSION AROUND SCREW HOLES AND SOME OTHER SPOTS (C-CHECK RO 4/9/2022) REMOVED AND REPLACED AFT CARGO DOOR SILL IAW CRJ-700 SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01, 51-42-21-001-001-A01, AND 53-61-23-201-001-ASDR SWIA202265304None · elongatedBL 0.00 FLOOR BEAM TENSION STRAP AT APPROX FS 773.50 FOUND TO HAVE ELONGATED FASTENER HOLE (C-CHECK RO 4/9/2022) COMPLIED WITH REO 670-53-41-593 REV -- DATED 2022-02-24. NO CHANGE TO WEIGHT AND BALANCE, M-337 AND TASK CARD 51-900-1002-SKY ATTACHED.SDR SWIA202165303None · crackedVERTICAL STABILIZER LH FWD DRAG ANGLE CRACKED. (C-CHECK RO 4/9/2022) PERFORMED SRM REPIAR TO LH FWD DRAG ANGLE IAW CRJ 700 SRM 55-31-00-201-001-A01 REVISION 38: JUL 25/2020 WITH COMPLETED 51-900-1003-SKY (CL600-2B19) STRUTRURAL REAPIR ("RII") CARD ATSDR SWIA202165302None · gougedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA54980-670-53-51-156 N715SKMXCODEID50027-PR - GOUGE DAMAGE TO LOWER FUSELAGE SKIN BETWEEN FS969.00 AND FS977.00 AT STRG 27 MEASURING 1" LENGTH X 0.7" WIDTH X .020" DEPTH. PERFORMED TEMPORARY REPAIR IAW REO 670-53-51-156SDR SWIA202165301None · gougedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA45591-670-52-11-511 715SK OP191-DTI - PAX DOOR HINGE ON FUSELAGE AFT LUG LAND HAS GOUGE FROM ROLL PIN. BLENDED GOUGED AREA REF REO 670-52-11-511 REV A TYPE 4 DISPOSITION STEP1-3. PERFORM DVI PER NDT MANUAL REF INSP ALLSDR SWIA2021080660110Controller · failedD: R WINDOW HEAT INOP / C: MEL 30-41-1A / CAT: "C" DUE 8/15/2021 / DURING OPS CHECK OF WINDSHIELD/WINDOW TEMP CONTROLLER FOUND R WINDOW HEAT CAUTION MESSAGE ON EICAS. CREATED FROM FORWARD DISCREPANCY. PLEASE REFERENCE AML 701807 REMOVED AND REPLACED RH COCKPSDR SWIA202156637Smoke Warning · activatedSMOKE AFT LAV WARNING RIGHT AFTER TAKE OFF FLIGHT 3232 - FILED CLOSED INVESTIGATED SMOKE AFT LAV WARNING AND FOUND THE SMOKE WARNING SOUNDED BECAUSE OF COMPRESSOR WASH SMOKE IN THE CABIN. REFER TO EAML 591478 FOR WORK PERFORMED. PERFORMED OPS CHECK OFSDR SWIA201743375Engine · malfunctionedAFTER ROTATION, CREW REPORTED A LOUD BANG, FOLLOWED BY ERRATIC LEFT ENGINE INDICATIONS AND THEN A LEFT ENGINE FIRE INDICATION. ONE FIRE BOTTLE WAS DISCHARGED AND MESSAGE CLEARED. SHUT DOWN THE LEFT ENGINE, DECLARED AN EMERGENCY AND RETURNED TO FIELD. CREW ALSDR SWIA201642031Stringer Splice · corrodedSTRINGER JOINT PIECE AT BS 333 COMMON TO STRINGER 25L HAS CORROSION. R & R STRINGER JOINT COMMON TO STRINGER 25L IAW SRM. LEAK CHECKED GOOD.SDR SWIA201642030Door Sill · corrodedAFT CARGO DOOR SILL CORROSION IN SEVERAL AREAS. R & R AFT CARGO DOOR SILL IAW SRM. PRESSURIZED ACFT LEAK AND OPS CHECKS GOOD AT THIS TIME.SDR SWIA201642029Web · corrodedPASSENGER DOOR CORRODED IN SEVERAL AREAS OF FWD STAIR WEB. INSTALLED NEW PAX DOOR FWD STAIR WEB ASSY IAW SRM.SDR SWIA201642028Stringer · corrodedSTRINGER 27 HAS CORROSION BETWEEN BS 333 - 349. REPAIRED IAW SRM AND STS LEAK CHECKED GOOD.SDR SWIA201642027Stringer · corrodedSTRINGER 25L HAS CORROSION BETWEEN FS 310 - 319.7. REMOVED OUT OF LIMITS STR 25L AND INSTALLED NEW SERVICEABLE STR 25L BETWEEN FS 280.00 TO FS 333.00 IAW SRM. PERFORMED PRESSURIZATION LEAK TEST IAW AMM. LEAK TEST GOOD.SDR SWIA201642026Stringer · corrodedSTRINGER 25R HAS CORROSION BETWEEN BS 319.7 - 333. R & R STRINGER IAW SRM. LEAK CHECKED GOOD.SDR SWIA201642025Intercostal · corrodedINTERCOSTAL IS CORRODED BETWEEN BS 349 - 364 AND STR 26 - 27L. R & R INTERCOSTA IAW SRM, LEAK CHECKED GOOD.SDR SWIA201642024Intercostal · corrodedINTERCOSTAL IS CORRODED BETWEEN BS 349 - 364 AND STR 26-27R. R & R INTERCOSTAL IAW SRM. LEAK CHECKED GOOD.SDR SWIA201642023Intercostal · corrodedINTERCOSTAL IS CORRODED BETWEEN BS 349 - 364, STRINGER 26L. R & R INTERCOSTAL IAW SRM. LEAK CHECKED GOOD.SDR SWIA201438656Vent · gougedVENT FLAP GOUGED AT AFT STIFFENER LOOKING FORWARD OF THE PAX DOOR FROM THE GROUND POSITION DUE TO ICE BREAKER CABLE. C-CHECK, VENT FLAP STIFFENER LOOKING FORWARD OF THE PAX DOOR FROM THE GROUND POSITION REPAIRED IAW REO.SDR SWIA201438660Door Sill · corrodedSERVICE DOOR LOWER SILL COMBING HAS CORROSION BS 319 - 349. C-CHECK, PLUGGED TWO REDUNDANT HOLES IN UPPER FLANGE OF REPLACEMENT SERVICE DOOR STRIKER PLATE IAW SRM AND AMM.SDR SWIA201438659Wheel · chafedPAX DOOR SUPPORT WHEEL OTBD AFT SIDE CHAFED. C-CHECK, BLENDED CHAFE ON PAX DOOR SUPPORT WHEEL FITTING OTBD AFT SIDE IAW SRM AND EA.SDR SWIA201438658Support · chafedPAX DOOR AFT HAND RAIL LOWER SUPPORT CHAFED FROM CONTACTING WHEEL SUPPORT. C-CHECK, BLENDED PAX DOOR AFT HAND RAIL LOWER SUPPORT IAW SRM AND STS EA.SDR SWIA201438657Skin · gougedEXTERIOR SKIN GOUGED AT BS 974 S27. C-CHECK, REPAIRED SKIN IAW REO.SDR SWIA201437522Bulb · burned outBULB BURNED OUT IN LOWER EMERGENCY EXIT ROW SIGN. REPLACED BULB.SDR SWIA201437157Lamp · burned outAFT EMERGENCY OVERHEAD LIGHT IS BURNED OUT. REPLACED LAMP.SDR SWIA201436225Light · inoperativeEMERGENCY LIGHT LT SIDE ON WALL IS BURNED OUT. FLT 6424 RELAMPED.SDR SWIA201335841Light · inoperativeNR 5 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 6429 RELAMPED.SDR SWIA201335238Light · inoperativeOVERHEAD LIGHT ABOVE EMERGENCY EXIT ROW IS BURNED OUT. FLT6195 RELAMPED.SDR SWIA201333073Engine · damagedRETURNED TO FIELD AFTER RIGHT ENGINE INGESTED BIRDS ON TAKEOFF. VIB OF 9.9 INDICATED, SHUT DOWN RIGHT ENGINE. DECLARED EMERGENCY ON SHORT FINAL. LANDED OVERWEIGHT AT A DESCENT RATE OF 300 FPM. REPLACED RIGHT ENGINE IAW AMM.SDR SWIA201333185Light · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT BURNED OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201332834Light · inoperativeNR 5 EMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 5175) RELAMPED EMERGENCY LIGHT.SDR SWIA201332758Light · inoperativeEMERGENCY OVERHEAD LIGHT NR 6 BURNED OUT. (FLT 5535) RELAMPED EMERGENCY LIGHT.SDR SWIA201332671Light · inoperativeLAST AND NR 4 EMERGENCY OVERHEAD LIGHTS BURNED OUT. (FLT 5608) RELAMPED EMERGENCY LIGHTS.SDR SWIA201332670Light · inoperativeNR 4 EMERGENCY OVERHEAD LIGHT BURNED OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201332669Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT BURNED OUT. (FLT 6315) RELAMPED EMERGENCY LIGHT.SDR SWIA201332646Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT DOES NOT ILLUMINATE. (FLT 6449) RELAMPED EMERGENCY LIGHT.SDR SWIA201232592Crossbeam · crackedFS 280 CROSSBEAM CRACKED. (C-CHECK) REPLACED FS 280.00 CROSSBEAM IAW REO.SDR SWIA201232596Frame · corrodedCORROSION FRAME LOWER FLANGE AT FS 295 STR 26L. (C-CHECK) REPAIRED CORRODED AREA OF FRAME LOWER FLANGE AT FS 295 STR 26L.SDR SWIA201232595Stringer · corrodedSTR 26R IS CORRODED ON LOWER FLANGE AT FS 345. (C-CHECK) REPAIRED CORRODED AREA ON STR 26R AT FS 345.SDR SWIA201232338Light · inoperativeEMERGENCY LIGHT OVER ROW 12 BURNED OUT. (FLT 5526) RELAMPED EMERGENCY LIGHT.SDR SWIA201232142Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6438) RELAMPED EMERGENCY LIGHT.SDR SWIA201231909Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5537) RELAMPED EMERGENCY LIGHT.SDR SWIA201231719Power Supply · failedOVERHEAD EMERGENCY LIGHTS AT ROW 2, 4, AND 7 DO NOT COME ON. (FLT 6514) REPLACED NR 1 EMERGENCY BATTERY POWER SUPPLY. P/N: AD-2013-1A S/N OFF: 78629SDR SWIA201231562Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6228) RELAMPED EMERGENCY LIGHT.SDR SWIA201231247Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5304) RELAMPED EMERGENCY LIGHT.SDR SWIA201231023Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5518) RELAMPED EMERGENCY LIGHT.SDR SWIA201230113Light · inoperativeLAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5196) RELAMPED EMERGENCY LIGHT.
Back to N715SK