N771SK
Service difficulty reports · 177
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 = 'N771SK' 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 = 'N771SK' 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 SWIA201128762Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT INOPERATIVE. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127695Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 IS OUT. (FLT 2018) RELAMPED EMERGENCY LIGHT.SDR SWIA201127076Connector · dirtyLEFT BLEED DUCT WARNING. (FLT 5556) CLEANED CONNECTOR J805 AT LEFT BLEED LOOP A.SDR SWIA201127022Connector · dirtyLEFT BLEED DUCT MESSAGE. (FLT 5556) CLEANED LEFT BLEED LOOP "A" CONNECTOR J805.SDR SWIA201126738Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5529) RELAMPED EMERGENCY LIGHT.SDR SWIA201126322Light · inoperativeNR 4 CEILING EMERGENCY LIGHT IS OUT. (FLT 6365) RELAMPED EMERGENCY LIGHT.SDR SWIA201024209Light · inoperativeNR 5 EMERGENCY CEILING FLOODLIGHT INOP. (FLT 6567)RELAMPED.SDR SWIA201023662Light · inoperativeOVERHEAD EMERGENCY LIGHT PRIOR TO EXIT ROW INOP. (FLT 6722) RELAMPED EMERGENCY LIGHT.SDR SWIA201023562Light · inoperativeEMERGENCY CEILING LIGHT NR 4 INOP. (FLT 5923) RELAMPED EMERGENCY LIGHT.SDR SWIA200923474Floorbeam · crackedC-CHECK, FS 280 BEAM CRACKED. REPAIRED PER REO.SDR SWIA200922551Light · detachedEMERGENCY LIGHT IN GALLEY NEAR FLOOR IS DETACHED. (FLT 6427) REPLACED EMERGENCY LIGHT.SDR SWIA200922371Sign · inoperativeEMERGENCY EXIT SIGN INOP. (FLT 6621) RELAMPED EMERGENCY EXIT SIGN.SDR SWIA200921959Lamp · burned outEMERGENCY FLOOD LIGHT ROW 14 INOP. (FLT 6393) RELAMPED EMERGENCY LIGHT.SDR SWIA200920849Windshield · crackedFLT 5876 - LEFT WINDSHIELD CRACKED. REPLACED WINDSHIELD.SDR SWIA200920838Lamp · burned outFLT 6852 - CEILING EMERGENCY LIGHT AT ROW 10 INOP. RELAMPED.SDR SWIA200820750Cover · brokenFLT 6669 - GALLEY FLOOR LEVEL FLOOD LIGHT COVER BROKE MISSING. REPLACED GALLEY FLOOR EMERGENCY FLOODLIGHT.SDR SWIA200820377Floorbeam · crackedC-CHECK, COCKPIT FLOOR SUPPORT CRACKED AT FS 280. REPLACED PER SRM.SDR SWIA200820138Floorbeam · crackedFS 280 CROSSBEAM CRACKED AT LBL 9 AND RBL 9 (C-CHECK). REPAIRED PER REO.
SDR SWIA200819776Engine · leakingOIL IS LEAKING OUT OF NR 2 ENGINE. (FLT 6084) REPLACED LEAKING SUCTION LINE ON NR 2 ENGINE DRIVEN HYDRAULIC PUMP. OPS CHECK GOOD.SDR SWIA200819320Bearing · roughFLT 6272 - AILERON FLIGHT CONTROLS DO NOT FEEL SMOOTH AT LOWER AIRSPEEDS. REPLACED FIRST OFFICERS CONTROL COLUMN BEARINGS PER AMM 27-11-01. OPS CHECK GOOD.SDR SWIA200819286Servo · roughFLT 6653 - CONTROL YOKE FEELS LIKE THE AILERONS ARE STICKING. REPLACED AILERON SERVO IAW CRJ MM 23-11-21. OPS CHECK GOOD, P/N: 622-4404-101, S/N OFF: 1RTYY.SDR SWIA200819260Gear · lack of lubeFLT 6577 - AILERON ACTION IS NOT SMOOTH. LUBRICATED AILERON PRIMARY SERVO GEAR TEETH PER CRJ 700 SERVICE LETTER SL-22-004. OPS CHECK GOOD.
SDR SWIA200718932Striker · out of adjustFLT 5830 - RIGHT EMERGENCY DOOR CAUTION ON THE GROUND. ADJUSTED DOOR SENSOR STRIKER PLATE. OP CHECKS GOOD IAW MM 52-70-00.
SDR SWIA200718401Sign · inoperativeRED AND WHITE INDICATOR LIGHTS ON AFT SIDE OF CEILING EXIT SIGN WILL NOT ILLUMINATE. REPLACED AFT SIDE OF CEILING EMERGENCY SIGN ASSEMBLY IAW CRJ 700 MM 33-00-00.SDR SWIA200718307Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT HANDRAIL SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS PER REO 670-52-11-104 (B) NOTES 1-10,15.SDR SWIA200718306Web · crackedPAX DOOR AFT WEB IS CRACKED AT HANDRAIL SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS AT PAX DOOR AFT WEB PER REO 670-52-11-104.SDR SWIA200616852Acm · malfunctionedAFTER TAKEOFF THE LEFT PACK PUT OUT A BURNING SMELL AND A SLIGHT HAZE FILLED THE CABIN. ABOUT THE SAME TIME RECEIVED A LEFT PACK TEMP STATUS MESSSAGE AND THE TEMP WAS DROPPING RAPIDLY. REPLACED LEFT AIR CYCLE MACHINE. OPERATIONAL CHECKS GOOD, S/N OFF: 01103
Back to N771SK