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 SWIA201436950Seat Track · corrodedPASSENGER CABIN, RT SEAT TRACK FROM BS 379 - 484 CORRODED. C-CHECK, REPLACED SEAT TRACK IAW AMM.SDR SWIA201436949Seat Track · corrodedPASSENGER CABIN LT SEAT TRACK FROM BS 484 - 574 CORRODED. C-CHECK, BLENDED AREAS IAW REO.SDR SWIA201436948Seat Track · corrodedPASSENGER CABIN RT SIDE SEAT TRACK BS 484-574 CORRODED. C-CHECK, REPLACED SEAT TRACK IAW AMM.SDR SWIA201436947Seat Track · corrodedPASSENGER CABIN LT SIDE SEAT TRACK BS 574 - 676 CORRODED. C-CHECK, BLENDED AREAS IAW REO.SDR SWIA201436946Seat Track · corrodedPASSENGER CABIN RT SIDE SEAT TRACK FROM BS 574-676 CORRODED. C-CHECK, BLENDED SEAT TRACK IAW SRM AND REO.SDR SWIA201436945Seat Track · corrodedPASSENGER CABIN LT SIDE SEAT TRACK BS 676-714 CORRODED. C-CHECK, BLENDED AREAS IAW REO.SDR SWIA201436944Seat Track · corrodedPASSENGER CABIN RT SEAT TRACK FROM BS 676-714 CORRODED. C-CHECK, REPLACED SEAT TRACK IAW AMM.SDR SWIA201436943Seat Track · corrodedPASSENGER CABIN LT SIDE SEAT TRACK FROM BS 714 - 761.85 CORRODED. C-CHECK, BLENDED AREAS IAW REO.SDR SWIA201436942Seat Track · corrodedPASSENGER CABIN RT SIDE SEAT TRACK FROM BS 714-761.85 CORRODED. C-CHECK, REPLACED DAMAGED SEAT TRACK WITH NEW IAW AMM.SDR SWIA201436941Seat Track · corrodedPASSENGER CABIN LT SIDE SEAT TRACK FROM BS 785.15-862 CORRODED. C-CHECK, BLENDED CORRODED AREAS IAW REO.SDR SWIA201436940Seat Track · corrodedPASSENGER CABIN, RT SIDE SEAT TRACK FROM BS 785.15 - 862 CORRODED. C-CHECK, REPLACED RT SEAT TRACK IAW AMM.SDR SWIA201436938Seat Track · corrodedPASSENGER CABIN LT FLOOR SEAT TRACK FROM BS 484 - 580 CORRODED. C-CHECK, BLENDED CORRODED AREAS IAW REO.SDR SWIA201436937Seat Track · corrodedPASSENGER CABIN RT FLOOR SEAT TRACK FROM BS 484-580 CORRODED. C-CHECK, REPLACED SEAT TRACK IAW AMM.SDR SWIA201436936Seat Track · corrodedPASSENGER CABIN LT SEAT TRACK FROM BS 580-682.5 CORRODED. C-CHECK, BLENDED CORRODED AREAS IAW REO.SDR SWIA201436935Seat Track · corrodedPASSENGER CABIN, RT SEAT TRACK FROM FS 580-682.5 HAD SPOTS OF CORROSION. C-CHECK, BLENDED CORROSION IAW REO.SDR SWIA201436953Attach Angle · corrodedGALLEY SERVICE DOOR SURROUND STRUCTURE LOWER DOOR SILL HAS CORROSION FROM BS 319-349. C-CHECK, REPLACED SILL MOUNTING ANGLE IAW SRM.SDR SWIA201436954Skin · chafedRIGHT ENGINE NACELLE ZONE 433, INNER SKIN IS CHAFED. C-CHECK, REPAIRED SKIN IAW REO.SDR SWIA201436649Connector · not seatedEMERGENCY EXIT LIGHT OVER GALLEY DOES NOT ILLUMINATE. FLT 5602 NR 1 EMERGENCY BATTERY CHARGER CONNECTOR NOT SEATED, ATTACHED CONNECTOR TO CHARGER IAW AMM.SDR SWIA201436648Charger · failedEMERGENCY EXIT LIGHTS OVER GALLEY DO NOT ILLUMINATE. FLT 6431 REPLACED FWD EMERGENCY LIGHT BATTERY CHARGER.SDR SWIA201333841Light · inoperativeOVERHEAD EMERGENCY LIGHT IS BURNED OUT. FLT#5620 RELAMPED.SDR SWIA201333286Battery · dischargedCABIN CEILING EMERGENCY EXIT SIGN DOES NOT ILLUMINATE. (FLT 5209) ALLOWED BATTERY TO CHARGE. OPS CHECK GOOD.SDR SWIA201333273Acm · faultyLEFT PACK TEMP CLIMBS UNCONTROLLABLY AND FILLED THE CABIN WITH SMOKE. (FLT 5212) REPLACED LEFT PACK FLOW CONTROL VALVE AND LEFT AIR CYCLE MACHINE IAW AMM.SDR SWIA201333068Landing Gear · obstructedAFTER TAKEOFF GEAR UP DISAGREE, NOSE GEAR DID NOT INDICATE UP AND LOCKED. (FLT 6467) REMOVED LARGE AMOUNT OF ICE FROM NLG AS REQUIRED. PERFORMED SEVERAL GEAR SWINGS, NO DEFECTS NOTED AND OPS CHECK GOOD.SDR SWIA201232500Light · brokenEMERGENCY OVERHEAD LIGHT IN GALLEY BROKEN. (FLT 6407) REPLACED EMERGENCY LIGHT IN FORWARD GALLEY NEAR SERVICE DOOR EXIT.SDR SWIA201232279Hydraulic Line · looseHYDRAULIC SYSTEM NR 2 FAILED IN FLIGHT. (FLT 5167) TIGHTENED NR 2 THERMAL FUSE AND LOWER HYDRAULIC LINE AT THE NR 2 THERMAL FUSE.SDR SWIA201231905Axle · corrodedCORROSION FOUND ON MLG PISTON/AXLE ROOT RADIUS NR 1. (C-CHECK) REPAIRED PER REO.SDR SWIA201231904Axle · corrodedCORROSION FOUND ON MLG PISTON/AXLE ROOT RADIUS NR 2. (C-CHECK) REPAIRED PER REO.SDR SWIA201231903Axle · corrodedCORROSION FOUND ON MLG PISTON/AXLE NR 3 ROOT RADIUS. (C-CHECK) REPAIRED PER REO.SDR SWIA201231902Axle · corrodedCORROSION FOUND ON MLG PISTON/AXLE NR 4 ROOT RADIUS. (C-CHECK) REPAIRED PER REO.SDR SWIA201231906Crossbeam · crackedFS 280 CROSSBEAM HAS CORROSION ON TOP SIDE AT LBL 11 AND CRACKED ON TOP SIDE AT RBL 11. (C-CHECK) REPAIRED PER REO.SDR SWIA201231907Drag Angle · crackedCRACK ON AFT DRAG ANGLE. (C-CHECK) REPLACED DRAG ANGLE SECTION IN REFERENCE TO REO.SDR SWIA201231323Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230583Light · inoperativeLAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6369) RELAMPED EMERGENCY LIGHT.SDR SWIA201230504Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5314) RELAMPED EMERGENCY LIGHT.SDR SWIA201230261Charger · failed1ST SECTION OF EMERGENCY LIGHTS ARE OUT. (SERVICE) REPLACED THE NR 1 EMERGENCY BATTERY CHARGER.SDR SWIA201230198Light · inoperativeOVERHEAD EMERGENCY CALL LIGHTS AT CENTER CABIN EXIT ARE OUT. (SERVICE) RELAMPED EMERGENCY LIGHTS.SDR SWIA201229821Light · inoperativeNR 2 AND NR 3 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 5379) RELAMPED EMERGENCY LIGHTS.SDR SWIA201229365Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5174) RELAMPED EMERGENCY LIGHT.SDR SWIA201229288Socket · dirtyAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5178) CLEANED SOCKET.SDR SWIA201229231Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5185) RELAMPED EMERGENCY DOOR.SDR SWIA201128826Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5362) RELAMPED EMERGENCY LIGHT.SDR SWIA201128704Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128633Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128489Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (FLT 5527) RELAMPED EMERGENCY LIGHT.SDR SWIA201128233Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5396) RELAMPED EMERGENCY LIGHT.SDR SWIA201128181Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5183) RELAMPED EMERGENCY LIGHT.SDR SWIA201128112Light · inoperativeTHE 2ND FROM LAST EMERGENCY LIGHT NOT ILLUMINATED. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127977Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5298) RELAMPED EMERGENCY LIGHT.SDR SWIA201127976Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6482) RELAMPED EMERGENCY LIGHT.SDR SWIA201127746Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 3275) RELAMPED EMERGENCY LIGHT.
Back to N770SK