N768SK
Service difficulty reports · 152
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 = 'N768SK' 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 = 'N768SK' 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 SWIA201436563Cowl Door · damagedCHAFE DAMAGE ON RIB, STIFFENER, HINGE 2 OF LT LOWER FAN COWL DOOR. C CHECK REWORKED CHAFE DAMAGE IAW STS EA.SDR SWIA201436564Floor Panel · corrodedFOUND CORROSION UNDER CARGO FLOOR PANEL 281JLF. C CHECK REMOVED CORROSION IAW REO.SDR SWIA201436565Skin · chafedLT INBD FLAP HAS CHAFES AROUND INBD HINGE BOX AT WS 54.55. C CHECK REPAIRED LT INBD FLAP LOWER SKIN IAW REO.SDR SWIA201436569Axle · corrodedLT MLG NR 1 AXLE FOUND CORROSION. C CHECK REPAIRED LT NR 1 AXLE ROOT RADIUS CORROSION IAW REO.SDR SWIA201436568Axle · corrodedLT MLG NR 2 AXLE FOUND CORROSION. C CHECK REPAIRED LT NR 2 AXLE ROOT RADIUS CORROSION IAW REO.SDR SWIA201436567Axle · corrodedRT MLG NR 3 AXLE FOUND CORROSION. C CHECK REPAIRED RT NR 3 AXLE ROOT RADIUS CORROSION IAW REO.SDR SWIA201436566Axle · corrodedRT MLG NR 4 AXLE FOUND CORROSION. C CHECK REPAIRED RT NR 4 AXLE ROOT RADIUS CORROSION IAW REO.SDR SWIA201436571Structure · crackedFOUND CRACK ON ELECTRICAL BAY FLOOR AT FS 193 RT CORNER. C CHECK REPAIRED CRACK IN FS 193 ELECTRICAL BAY FLOOR RT IAW REO.SDR SWIA201436570Structure · crackedFOUND CRACK ON ELECTRICAL BAY FLOOR AT FS 193 LT CORNER. C-CHECK REPAIRED CRACK TO ELECTRICAL BAY FLOOR AT FS 193 LT CORNER IAW REO.SDR SWIA201435978Light · inoperativeEMERGENCY EXIT LT IN GALLEY HAS LIGHTS BURNED OUT. FLT 6529 RELAMPED.SDR SWIA201335838Light · inoperativeNR 5 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 5562 RELAMPED.SDR SWIA201335463Light · inoperative2ND TO LAST CEILING POD LIGHT IS BURNED OUT. FLT 6444 RELAMPED.SDR SWIA201334355Light · inoperativeEXTERIOR EMERGENCY LIGHTS BURNED OUT. FLT#6435 RELAMPED.SDR SWIA201232462Acm · malfunctionedRIGHT PACK CREATES SMOKE IN CABIN. (SERVICE) REPLACED THE RIGHT AIR CYCLE MACHINE P/N: GG670-95009-5 S/N ON: 01382 S/N OFF:01207.SDR SWIA201232194Light · inoperativeLEFT OVERWING EMERGENCY LOWER EXIT SIGN 2 BULBS BURNED OUT. (FLT 6535) RELAMPED EMERGENCY LIGHTS.SDR SWIA201231575Light · unsecureBULKHEAD EMERGENCY EXIT LIGHT IS UNSECURE. (FLT 6435) SECURED BULKHEAD EMERGENCY EXIT SIGN IN REFERENCE TO MM.SDR SWIA201231496Connector · disconnectedEXTERIOR NR 3 EMERGENCY LIGHT BEHIND RIGHT EMERGENCY EXIT IS OUT. (SERVICE) RECONNECTED CONNECTOR FOR THE EXTERIOR NR 3 EMERGENCY LIGHT ON THE RIGHT SIDE.SDR SWIA201230985Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5212) RELAMPED EMERGENCY LIGHT.SDR SWIA201230474Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229511Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5310) RELAMPED EMERGENCY LIGHT.SDR SWIA201229462Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5493) RELAMPED EMERGENCY LIGHT.SDR SWIA201229358Battery Pack · dischargedFORWARD EMERGENCY LIGHTS ARE OUT. (SERVICE) REPLACED FORWARD EMERGENCY BATTERY PACK.SDR SWIA201229381Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5198) RELAMPED EMERGENCY LIGHT.SDR SWIA201229191Light · inoperativeSECOND TO AFT CEILING EMERGENCY LIGHT IS OUT. (FLT 6193) RELAMPED EMERGENCY LIGHT.SDR SWIA201128769Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT INOPERATIVE. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128535Light · inoperativeSECOND TO AFT OVERHEAD EMERGENCY LIGHT BURNED OUT. (FLT 5156) RELAMPED EMERGENCY LIGHT.SDR SWIA201128490Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5156) RELAMPED EMERGENCY LIGHT.SDR SWIA201128395Light · inoperativeNR 6 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128038Light · inoperativeLAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6236) RELAMPED EMERGENCY LIGHT.SDR SWIA201127727Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2044) RELAMPED EMERGENCY LIGHT.SDR SWIA201127537Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2002) RELAMPED EMERGENCY LIGHT.SDR SWIA201127374Light · inoperativeNR 1 AND NR 2 OVERHEAD EMERGENCY LIGHT NOT ILLUMINATING. (FLT 6337) RELAMPED EMERGENCY LIGHT.SDR SWIA201127302Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5534) RELAMPED EMERGENCY LIGHT.SDR SWIA201127213Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6525) RELAMPED EMERGENCY LIGHT.SDR SWIA201126339Link · corrodedLEFT ENGINE FORWARD YOKE MOUNT LINK HAS PITTING. (ENGINE CHANGE) INSTALLED NEW FORWARD YOKE MOUNT LINK AT LEFT ENGINE.SDR SWIA201126260Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6841) RELAMPED EMERGENCY LIGHT.SDR SWIA201126201Light · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE ROW 7 BURNED OUT. (FLT 1180) RELAMPED EMERGENCY LIGHT.SDR SWIA201126029Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6881) RELAMPED EMERGENCY LIGHT.SDR SWIA201125933Light · inoperativeTHE 2ND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 7010) RELAMPED EMERGENCY LIGHT.SDR SWIA201125886Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 7 IS OUT. (FLT 6361) RELAMPED EMERGENCY LIGHT.SDR SWIA201125753Light · inoperativeOVERHEAD EMERGENCY LIGHT POD IS OUT. (FLT 6710) RELAMPED EMERGENCY LIGHT.SDR SWIA201125524Floorbeam · crackedFS 280 FLOORBEAM CRACKED ON BOTH SIDES. (C-CHECK) REPLACE PER SRM.SDR SWIA201025202Light · inoperativeTHE 2ND AFT OVERHEAD EMERGENCY LIGHT IS NOT WORKING. (FLT 6430) RELAMPED EMERGENCY LIGHT.SDR SWIA201024540Sign · inoperativeCABIN EMERGENCY FLOOR LEVEL LIGHTED EXIT SIGN INOP. (FLT 6734) RELAMPED EMERGENCY LIGHT.SDR SWIA201023660Light · inoperativeLEFT SIDE EXIT ROW LIGHTING ABOVE THE EMERGENCY DOOR INOP. (FLT 6701) RELAMPED EMERGENCY LIGHT.SDR SWIA200921248Light · inoperativeFLT 6647 - LAST (REAR) EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200820222Floorbeam · crackedFS 280 FLOORBEAM CRACKED AT LBL9 AND RBL9. C-CHECK, REPAIRED PER REO.SDR SWIA200718305Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT HANDRAIL SUPPORT, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS PER CRJ 700 REO 67-0-52-11-104 REV B, REPAIR SCHEME 2 SHEET 6.SDR SWIA200718304Web · crackedPAX DOOR AFT WEB IS CRACKED AT HANDRAIL SUPPORT, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS IN ACCORDANCE WITH CRJ 700 REO 601R-52-11-104 REV B.SDR SWIA200617204Relay · defectiveCABIN SIDEWALL LIGHTING FLICKERING WITH AN ASSOCIATED ELECTRICAL HOT SMELL FROM CB PANELS IN COCKPIT AND A RELAY CLICKING SOUND COMING FROM FLIGHT ATTENDANT SWITCH PANEL. REPLACED RELAY 156 IAW MM 33-21-00. OPERATIONAL CHECKS GOOD.
Back to N768SK