N802SK
Service difficulty reports · 338
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 = 'N802SK' 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 = 'N802SK' 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 SWIA201540957Retainer · gougedFWD BAGGAGE BAY DOOR SEAL RETAINER IS GOUGED, RT INBD FWD AND AFT, C-CHECK RO 4/1/15. REPAIRED GOUGES ON FWD BAGGAGE BAY DOOR SEAL RETAINER. REO COMPLIED WITH PRESSURE LEAK CHECK OF SEAL, LEAK CHECK GOOD AT THIS TIME. REF: AMM.SDR SWIA201440169Pin · unserviceableRT ENGINE VIBRATION REACHED 5.2 AT FL 360. REPLACED FAN BLADE PINS WITH SERVICEABLE UNITS. LUBED FAN BLADE TANGS AND REINSTALLED ORIGINAL SET OF FAN BLADES IAW ENGINE MANUAL.SDR SWIA201438394Lamp · dimLEFT FWD OVERWING EMERGENCY EXIT FLOOR LIGHT IS DIM. REPLACED THE LAMP IAW AMM.SDR SWIA201436337Battery · dischargedEMERGENCY LIGHTS NOT WORKING. FLT 4564 CHARGED EMERGENCY LIGHTS BATTERY.SDR SWIA201335638Light · inoperativeNR 7 CEILING EMERGENCY FLOOD LIGHT IS BURNED OUT. SERVICE RELAMPED.SDR SWIA201335330Light · inoperativeNR 7 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 4616 RELAMPED.SDR SWIA201334416Light · inoperativeEMERGENCY LIGHT BURNED OUT. FLT#4454 RELAMPED.SDR SWIA201334292Floor Support · crackedRT FLOOR ANGLE CRACKED @ FS 274. C-CHECK LOCATED & DRILLED NEW RT COCKPIT FLOOR SUPPORT IAW SRM.SDR SWIA201334293Floor Support · crackedLT FLOOR ANGLE IS CRACKED @ FS 274. C-CHECK DRILLED NEW LT COCKPIT FLOOR SUPPORT IAW SRM,SDR SWIA201334294Angle · corrodedPAX DOOR SILL UPPER MID CAP ANGLE CORRODED. C-CHECK REPLACED PAX DOOR SILL UPPER MID CAP ANGLE IAW SRM.SDR SWIA201334298Seat Track · corrodedLT SIDE SEAT TRACK FS 785 TO 847+16 HAS SEVERAL SPOTS OF CORROSION. C-CHECK BLENDED CORROSION IAW SRM.SDR SWIA201334302Seat Track · corrodedRT FLOOR SEAT TRACK FROM FS 453 TO FS 581 IS CORRODED. C-CHECK BLENDED CORROSION IAW SRM & REO.SDR SWIA201334301Seat Track · corrodedRT FLOOR SEAT TRACK FROM FS437 TO FS453 IS CORRODED. C-CHECK BLENDED CORROSION IAW SRM & REO.SDR SWIA201334300Seat Track · corrodedLT SIDE SEAT TRACK FS669 TO 720 HAS SEVERAL SPOTS OF CORROSION. C-CHECK BLENDED CORROSION IAW SRM AND REO.SDR SWIA201334299Seat Track · corrodedLT SIDE SEAT TRACK FS 744.15 TO 761.18 HAS SEVERAL SPOTS OF CORROSION. C-CHECK BLENDED CORROSION IAW SRM & REO.SDR SWIA201334297Seat Track · corrodedLT SIDE SEAT TRACK FS 910 TO 969 HAS SEVERAL SPOTS OF CORROSION. C-CHECK BLENDED CORROSION IAW SRM.SDR SWIA201334296Seat Track · corrodedRT SIDE SEAT TRACK FS 699 TO 720 HAS SEVERAL SPOTS OF CORROSION. C-CHECK BLENDED CORROSION IAW SRM.SDR SWIA201334295Seat Track · corrodedRT SIDE SEAT TRACK FS 744 TO 761 HAS CORROSION. C-CHECK BLENDED CORROSION IAW SRM.SDR SWIA201334303Structure · corrodedCORROSION FOUND AT FS 280 TO FS 282 STRINGER 27 TO 26R ON CIRCUMFERENTIAL JOINT. C-CHECK REPAIRED CORROSION IAW REO.SDR SWIA201334308Hinge Fitting · chafedRT WS54.55 HINGE BOX AFT FITTING HAS OTBD FITTING LUGS CHAFED. C-CHECK REPAIRED FLAP HINGE BOX WING FITTING IAW STS.SDR SWIA201334307Floorbeam · crackedLT COCKPIT FLOOR BEAM CRACKED. C-CHECK REPAIRED LT COCKPIT FLOOR BEAM IAW REO.SDR SWIA201334306Floorbeam · crackedRT COCKPIT FLOOR BEAM CRACKED. C-CHECK REPAIRED COCKPIT FLOOR BEAM IAW REO.SDR SWIA201334305Sill · corrodedRT FLOOR SILL FROM FS 280 TO FS 319 CORRODED. C-CHECK REPLACED RT FLOOR SILL IAW SRM.SDR SWIA201334304Skin · chafedFS SKIN IS CHAFED. C-CHECK COMPLIED WITH SKIN REPAIR IAW REO.SDR SWIA201334311Floorbeam · crackedFLOOR BEAM CRACKED LT & RT SIDES AT FS 280. C-CHECK REPLACED LT & RT CROSS BEAMS IAW REO.SDR SWIA201334310Sill · corrodedGALLEY SERVICE DOOR SILL IS CORRODED. C-CHECK REPLACED GALLEY SERVICE DOOR SILL IAW SRM. PN SH670-31996-3.SDR SWIA201334309Sill · corrodedAFT CARGO BAY DOOR SILL IS CORRODED. C-CHECK REMOVED CORROSION IAW REO & STS.SDR SWIA201333829Light · inoperativeEMERGENCY OVERHEAD LIGHT AT ROW 16 IS BURNED OUT. FLT#4583 RELAMPED.SDR SWIA201333315Battery Pack · failedEMERGENCY LIGHTS DO NOT STAY LIT. (FLT 4477) REMOVED AND REPLACED NR 1-5 ELBP'S IAW AMM.SDR SWIA201232051Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4469) RELAMPED EMERGENCY LIGHT.SDR SWIA201231939Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201231784Light · inoperativeNR 8 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4690) RELAMPED EMERGENCY LIGHT.SDR SWIA201231671Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4441) RELAMPED EMERGENCY LIGHT.SDR SWIA201231378Light · inoperativeMOST REAR OVERHEAD EMERGENCY LIGHT IS BURNT OUT. (FLT 4668) RELAMPED EMERGENCY LIGHT.SDR SWIA201231315Light · inoperativeOVERHEAD EMERGENCY LIGHT IN CENTER OF AISLE 2ND FROM THE REAR IS OUT. (FLT 4577) RELAMPED EMERGENCY LIGHT.SDR SWIA201231177Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 IS OUT. (FLT 4703) RELAMPED EMERGENCY LIGHT.SDR SWIA201231051Light · inoperativeNR 4 AND NR 5 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4535) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230707Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4482) RELAMPED EMERGENCY LIGHT.SDR SWIA201230629Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 4557) RELAMPED EMERGENCY LIGHT.SDR SWIA201229753Hydraulic Line · damagedLOST ALL HYDRAULIC PRESSURE IN SYSTEM 2. (FLT 4481) NR 2 HYDRAULIC SUCTION LINE HAD A PIN HOLE. REPLACED LINE.SDR SWIA201229610Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4464) RELAMPED EMERGENCY LIGHT.SDR SWIA201229255Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 18 IS OUT. (FLT 4439) RELAMPED EMERGENCY LIGHT.SDR SWIA201229112Wire Harness · faultyGEAR WOULD NOT CYCLE UP AFTER TAKEOFF RECEIVED GEAR UP DISAGREE WARNING. (FLT 4452) REPLACED NLG RIGHT SIDE PROX HARNESS AND PSEU. SERVICED NLG STRUT.SDR SWIA201129093Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 IS OUT. (FLT 4535) RELAMPED EMERGENCY LIGHT.SDR SWIA201129090Wire Harness · failedON TAKEOFF RECEIVED "GEAR DISAGREE" WARNING MESSAGE. (FLT 4792) REPLACED NLG LEFT PROXIMITY SENSOR HARNESS.SDR SWIA201129008Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4467) RELAMPED EMERGENCY LIGHT.SDR SWIA201128941Light · inoperativeLAST EMERGENCY LIGHT IN FRONT OF AFT LAVATORY OVERHEAD IS INOPERATIVE. (FLT 4537) RELAMPED EMERGENCY LIGHT.SDR SWIA201128244Light · inoperativeNR 1, 2 AND 3 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4759) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127739Light · inoperativeAFT TWO CEILING EMERGENCY LIGHTS ARE OUT. (FLT 4467) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127592Light · inoperativeOVERHEAD EMERGENCY LIGHTS AT ROWS 1, 13 AND 18 ARE OUT. (FLT 4745) RELAMPED EMERGENCY LIGHTS.
Back to N802SK