N770SK
Service difficulty reports · 253
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 = 'N770SK' 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 = 'N770SK' 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 SWIA201127644Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6296) RELAMPED EMERGENCY LIGHT.SDR SWIA201127527Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6431) RELAMPED EMERGENCY LIGHT.SDR SWIA201127362Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 15 IS OUT. (FLT 2027) RELAMPED EMERGENCY LIGHT.SDR SWIA201127222Light · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE ROW 15 IS INOPERATIVE. (FLT 6447) RELAMPED EMERGENCY LIGHT.SDR SWIA201127196Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5365) RELAMPED EMERGENCY LIGHT.SDR SWIA201126970Light · inoperativeNR 5 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126687Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IN CABIN IS INOP. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126496Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (FLT 3291) RELAMPED EMERGENCY LIGHT.SDR SWIA201126401Light · inoperativeSECOND FROM LAST OVERHEAD EMERGENCY LIGHT DOES NOT ILLUMINATE. (FLT 6594) RELAMPED EMERGENCY LIGHT.SDR SWIA201126312Light · inoperativeCEILING EMERGENCY LIGHT ABOVE ROW 15 IS OUT. (FLT 1175) RELAMPED EMERGENCY LIGHT.SDR SWIA201126259Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6935) RELAMPED EMERGENCY LIGHT.SDR SWIA201126200Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6722) RELAMPED EMERGENCY LIGHT.SDR SWIA201126082Light · inoperativeOVERHEAD EMERGENCY LIGHT OVER ROW 14 IS OUT. (FLT 6463) RELAMPED EMERGENCY LIGHT.SDR SWIA201125781Light · inoperative2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6722) RELAMPED EMERGENCY LIGHT.SDR SWIA201125743Light · inoperativeAFT MOST EMERGENCY CEILING LIGHT IS OUT. (FLT 1053) RELAMPED EMERGENCY LIGHT.SDR SWIA201025356Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT OUT. (FLT 6983) RELAMPED EMERGENCY LIGHT.SDR SWIA201025179Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT OUT. (FLT 6462) RELAMPED EMERGENCY LIGHT.SDR SWIA201025119Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT INOPERATIVE. (SERVICE CHECK) RELAMPED EMERGENCY LIGHT.SDR SWIA201024922Lamp · burned outEMERGENCY EXIT ROW LOWER LIGHT (12 C/D) INOPERATIVE. RELAMPED.SDR SWIA201024726Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 9, 10 IS INOPERATIVE. (FLT 6892) RELAMPED EMERGENCY LIGHT.SDR SWIA201024392Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 9 INOP. (FLT 6200) RELAMPED EMERGENCY LIGHT.SDR SWIA201024030Cable · out of positionMAIN CABIN DOOR DIFFICULT TO OPEN. (FLT 5934) RE-INSTALL DOOR CABLE ON PULLEY.SDR SWIA201023641Landing Gear · icedNOSE GEAR DOOR OPEN WARNING MESSAGE. (FLT 6663) REMOVED ICE AND SLUSH FROM NOSE LANDING GEAR.SDR SWIA200923075Light · inoperativeOVERHEAD CABIN EMERGENCY LIGHT INOP. (FLT 6733) RELAMPED.SDR SWIA200922925Light · inoperativeSECOND TO LAST EMERGENCY LIGHT INOP. (FLT 6636) RELAMPED EMERGENCY LIGHT.SDR SWIA200922268Light · inoperativeCEILING EMERGENCY LIGHT INOP. (FLT 6421) RELAMPED EMERGENCY LIGHT.SDR SWIA200921704Lamp · burned outFLT 6330 - NR 5 EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921218Lamp · burned outFLT 6517 - 4TH CEILING EMERGENCY LIGHT BULB VERY DIM. RELAMPED.SDR SWIA200921062Lamp · burned outFLT 6579 - GALLEY SERVICE DOOR EXIT SIGN COVER MISSING. RELAMPED.SDR SWIA200821047Unknown · damagedJOINT PIECE DAMAGED AT FS 394 AND STR 23S, DAMAGE REPAIR. REPLACED PER SRM.SDR SWIA200821046Frame · damagedFS 437 STR 27R AND 26R FRAME FLANGE DAMAGED, DAMAGE REPAIR. REPAIRED PER REO.SDR SWIA200821045Frame · damagedFRAME AT FS 409 (STRINGER 27) DAMAGED, DAMAGE REPAIR. REPAIRED PER REO.SDR SWIA200821044Frame · damagedFRAME 220 FROM STR 16R-26R DAMAGED, DAMAGE REPAIR. REPLACED PER SRM.SDR SWIA200821043Lap Joint · damagedSKIN LAP JOINT STRAP AT FS 280-202 DAMAGED, DAMAGE REPAIR. REPLACED PER SRM.SDR SWIA200821042Support · damagedADG SUPPORT STRUCTURE DAMAGED, DAMAGE REPAIR. REPLACED STRUCTURE PER SRM.SDR SWIA200821041Support · damagedRADAR ANTENNA SUPPORT STRUCTURE DAMAGED, DAMAGE REPAIR. REPLACED STRUCTURE PER SRM.SDR SWIA200821040Frame · damagedFS 169 MACHINED FRAME/BULKHEAD DAMAGED, DAMAGE REPAIR. REPLACED FRAME PER SRM.SDR SWIA200821039Structure · damagedNLG TRUNNION BOX DAMAGED, DAMAGE REPAIR. REPLACED NLG TRUNNION BOX PER SRM.SDR SWIA200821038Skin · damagedFUSELAGE SKIN FS 333-477 FROM STR 16R-20R HAS MAJOR REPAIR DAMAGE, DAMAGE REPAIR. REPAIRED PER REO.SDR SWIA200821037Spar · damagedFORWARD SPAR ON RIGHT HORIZONTAL STAB DAMAGED BETWEEN NR 9 AND NR 11 RIB, DAMAGE REPAIR. INSTALLED NEW FORWARD SPAR ON RIGHT HORIZONTAL STAB PER SRM.SDR SWIA200821036Rib · damagedNR 11 RIB FORWARD EDGE CRUSHED ON RT HORIZONTAL STAB, DAMAGE REPAIR. INSTALLED NEW NR 11 RIB PER SRM.SDR SWIA200821035Rib · crackedCLOSING RIB ON RIGHT HORIZONTAL STAB CRACKED. INSTALLED NEW CLOSING RIB PER SRM.SDR SWIA200820007Lamp · burned outSECOND FROM LAST CEILING LEVEL EMERGENCY FLOOD LIGHT IS BURNED OUT. FLT 6363. RELAMPED LIGHT.
SDR SWIA200819999Floorbeam · crackedFLOORBEAM CRACKED AT LBL AND RBL 9. FOUND AT C-CHECK. COMPLIED WITH REPAIRS TO FLOORBEAM IAW REO 670-53-11-047.
SDR SWIA200819998Floor Support · crackedCOCKPIT FLOOR SUPPORT CRACKED. FOUND AT C-CHECK, REPLACED COCKPIT FLOOR SUPPORT PER SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, 51-42-22-001-001-A01.
SDR SWIA200718710Light · inoperativeFLT 6027 - EMERGENCY LIGHTS BY PAX DOOR ARE INOP. REPLACED THE PAX DOOR FLOOR LEVEL EMERGENCY LIGHT ASSY IAW MM 33-51-11. OPS CHECK GOOD AT THIS TIME.SDR SWIA200718709Sign · missingFLT 6408 - EXIT SIGN MISSING AT FLOOR OF GALLEY BULKHEAD BY THE SERVICE DOOR. INSTALLED SERVICEABLE LENS ON FLOOR EMERGENCY EXIT FLOODLIGHT. OPS TEST GOOD.SDR SWIA200718404Window · crackedLEFT SIDE WINDOW IS CRACKED. REPLACED LEFT SIDE WINDOW IAW MM 56-12-01.SDR SWIA200718199Window · crackedRIGHT SIDE WINDOW SHATTERED. REPLACED RIGHT SIDE WINDOW IAW CRJ 700 MM 56-12-01. P/N OFF 601R33033-24, S/N OFF 05238H9811.SDR SWIA200616819Swivel Valve · brokenSTEERING INOP CAUTION ENTERING RAMP AND HYDRAULIC NR 3 SYSTEM DEPLETED. REPLACED STEERING ACTUATOR SWIVEL VALVE ANTI-ROTATION PIN AND HYDRAULIC LINES IAW CRJ 700 AMM 32-52-10, AND REO 670-32-51-0006. OPERATIONAL CHECKS GOOD.
Back to N770SK