N793SK
Service difficulty reports · 75
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 = 'N793SK' 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 = 'N793SK' 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 SWIA202156518Cap · dentedPAX DOOR FWD END CAP DENTED (C-CHECK) RO 2/28/2021 PAX DOOR FWD END CAP FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED PAX DOOR FWD END CAP COVER WITH A NEW CAP P/N 600-31902-287. REF CRJ 700 SRM 51-42-13-001-001-A01SDR SWIA202156477Striker · dented*PAX DOOR SEAL STRIKER ON THE AFT SIDE IS DENTED(MARKED). (C-CHECK) RO 2/28/2021 REPAIRED PAX DOOR SEAL STRIKER REF BOMBARDIER REO 670-53-22-001 REV J DATED 2016-11-10. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA202156496Track · worn*AFT CARGO DOOR, DOOR TRACK RUBBER STOPS ARE WORN (4EA) (C-CHECK) RO 2/28/2021 REMOVED AND REPLACED AFT CARGO DOOR, DOOR TRACK RUBBER STOPS IAW CRJ700 AMM 52-31-23-000-801-A02, 52-31-23-400-802-A01. OPS TEST GOOD.SDR SWIA202056476Hinge · gougedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA41624-670-53-21-582-N793SK-DTI - THE PAX DOOR SURROUND STRUC (FUSE SIDE) HINGE LUG LAND IS GOUGED AT THE AFT MOST LAND. BLEND REPAIRED IN REF TO REO 670-53-21-582, REV F, DTD 08/02/2017, REPAIR TYPE IV. PERFORM DETASDR SWIA2020021948755Fire Warning · false activationAFTER LANDING RECEIVED APU FIRE WARNING MSG. RAN QRH, MSG CLEARED. DID NOT HAVE TO BLOW BOTTLE. DURING APPROACH STRONG FUMES SMELLING OF FUEL ENTERED THE CABIN. FLIGHT 5658 FILED CLOSED PLEASE REFERENCE AML 382777 PLEASE REFERENCE AML 382780 PLEASE REFSDR SWIA201743662Skin Panel · gougedSKIN PANEL 433BB GOUGED AT THE AFT END. REPLACED PANEL IAW SRM.SDR SWIA201743661Channel · corrodedCORROSION FOUND ON TCAS OMNIDIRECTIONAL ANTENNA CHANNEL. REMOVED AND THE CHANNEL IAW SRM. LEAK CHECKED GOOD.SDR SWIA201541576Longeron · dentedLONGERON EXTENSION LOCATED 1.00" BELOW STR 18L, DENTED FS 501.00 AND FS 517.00, FROM STR 17L TO STR 18L. REPAIRED FUSELAGE DENT BETWEEN FS 501.00 AND FS 517.00 FROM STR 17L TO STR 18L IAW REO. PRESSURE CHECK GOOD. NO LEAKS NOTED.SDR SWIA201541570Doubler · damagedDAMAGE TCAS ANTENNA DOUBLER AT STR 27 BETWEEN FS 295.00 AND FS 310.00 THAT IS FOUND TO BE OUT OF LIMITS. R & R NEW TCAS ANTENNA DOUBLER AT STR 27 BETWEEN FS 295 AND FS 310 IAW SRM. COMPLETED PRESSURE TEST TCAS ANTENNA DOUBLER AT STR 27 BETWEEN F/S 295.00 ANDSDR SWIA201541575Frame · damagedFRAME SECTOR AT FS 319 BETWEEN STR 26L AND STR 26R DAMAGED. PERFORMED SPLICE REPAIR ON FS 319.00 LOWER FUSELAGE FRAME SECTOR IAW REO. LEAK CHECKS GOOD.SDR SWIA201541574Frame · damagedFRAME SECTOR AT FS 310.00 BETWEEN STR 26L AND STR 26R DAMAGED. PERFORMED SPLICE REPAIR ON FS310.00 LOWER FUSELAGE FRAME SECTOR IAW REO. LEAK CHECKS GOOD.SDR SWIA201541573Hinge · corrodedR & R PAX DOOR PIANO HINGE, DOOR SIDE, DUE TO OUT OF LIMITS CORROSION. R & R THE PAX DOOR PIANO HINGE, DOOR SIDE IAW SRM. PRESSURE CHECK GOOD.SDR SWIA201541572Hinge · corrodedCORROSION ON PAX DOOR PIANO HINGE. FUSELAGE SIDE OUT OF LIMITS. R & R THE PAX DOOR PIANO HINGE-FUSELAGE SIDE, IAW SRM. PRESSURE CHECK GOOD.SDR SWIA201541571Floor Panel · crackedRIGHT TRU BAY FLOOR CRACKED AT FS 193. REPAIRED CRACK ON RT TRU BAY FLOOR AT FS 193 IAW REO.SDR SWIA201541569Intercostal · corrodedCORROSION OUT OF LIMITS INTERCOSTAL AT STRINGER 27R AT BS 364. R & R THE INTERCOSTAL IAW SRM.SDR SWIA201541568Intercostal · corrodedCORROSION AT INTERCOSTAL AT STRINGER 27L AT BS 364 OUT OF LIMITS. R & R INTERCOSTAL 27L FROM FS349.00 TO FS364.00 IAW SRM. COMPLETED PRESSURE TEST OF FASTENER COMMON TO SKIN ON INTERCOSTAL AT 27LT AT BS FS364 IAW AMM. NO LEAKS WERE NOTED AT THIS TIME.SDR SWIA201439421Structure · damagedLIGHTNING STRIKE CAUSED BURN DAMAGE TO THE RT HORIZONTAL STABILIZER TIP AFT FAIRING. REPAIRED IAW REO.SDR SWIA201437686Structure · gougedFOUND A GOUGED AREA ABOUT A .2500" LONG AT THE VERY INBD T/E, TOP SIDE OF THE LT WING. COMPLIED WITH REPAIR OF THE GOUGE AT THE VERY INBD T/E, TOP SIDE OF THE LT WING IAW EA.SDR SWIA201437687Skin · crackedCRACK FOUND IN COLD WORK OF LT WING PLANK. REAMED AND COLD WORKED DISCREPANT HOLE. INSTALLED HST54AG-14-22 IAW REO.SDR SWIA201437691Floor Support · crackedRIGHT COCKPIT FLOOR SUPPORT BEAM IS CRACKED AT FS 274. REPAIRED RT COCKPIT FLOOR SUPPORT BEAM AT FS274 IAW REO.SDR SWIA201437690Floor Support · crackedLEFT COCKPIT FLOOR SUPPORT BEAM IS CRACKED AT FS 274. C-CHECK, REPAIRED LT COCKPIT FLOOR SUPPORT BEAM AT FS274 IAW REO.SDR SWIA201437689Hinge · gougedPAX DOOR PIANO HINGE 2ND, 3RD AND LAST LUG FROM FWD SIDE HAS GOUGE, ON PAX DOOR SIDE. REMOVED GOUGES ON PAX DOOR HINGE 2ND, 3ND, AND LAST LUG FROM FWD SIDE IAW REO.SDR SWIA201437688Floorbeam · crackedFS 280 FLOORBEAM HAS A CRACK AT RT BL 14.0 & LT BL 14.0 ON THE UPPER FLANGE. R & R RT AND LT FS 280.00 CROSSBEAMS AND RESTORED FINISH IAW SRM.SDR SWIA201232436Smoke Warning · false activationSMOKE AFT LAV MASTER WARNING MESSAGE FOR SEVERAL SECONDS AFTER TAKEOFF. NO SIGN OR SMELL OF ACTUAL SMOKE, MESSAGE EXTINGUISHED ON ITS OWN. (FLT 5540) RAN BOTH AIR CONDITIONING PACKS AND FOUND NO DEFECTS. PERFORMED OPS CHECK OF THE LAVATORY SMOKE DETECTOR ASDR SWIA201231237Windshield · crackedLEFT WINDSHIELD HAS A CRACK ON THE OUTER PANE. (SERVICE) REPLACED LEFT WINDSHIELD. P/N: NP139321-5, S/N OFF: 09204H6318.
Back to N793SK