N604SK
Service difficulty reports · 174
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 = 'N604SK' 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 = 'N604SK' 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 SWIA201229881Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 15 IS OUT. (FLT 4565) RELAMPED EMERGENCY LIGHT.SDR SWIA201128984Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4630) RELAMPED EMERGENCY LIGHT.SDR SWIA201128201Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4672) RELAMPED EMERGENCY LIGHT.SDR SWIA201127225Floorbeam · cracked(C-CHECK) LEFT FS 274 FLOORBEAM IS BUCKLED AND RIGHT FS 274 FLOORBEAM IS CRACKED. REPLACED BOTH LEFT AND RIGHT FS 274 FLOORBEAMS PER SRM.SDR SWIA201127207Floorbeam · corroded(C-CHECK) FS 280 FLOORBEAM CORRODED. REPLACED PER REO.SDR SWIA201024414Connector · looseNR 1 EMERGENCY CEILING FLOODLIGHT INOP. (SVC CHECK) RE-SECURED CONNECTOR.SDR SWIA201023749Light · inoperativeEMERGENCY FLOOD LIGHT OVER ROW 16 INOP. (FLT 4766) RELAMPED EMERGENCY LIGHT.SDR SWIA200923326Floorbeam · crackedFS 280 FLOORBEAM CRACKED ON LEFT AND RIGHT SIDES. (C CHECK) REPLACED BEAM PER REO.SDR SWIA200923364Drag Angle · crackedPASSENGER DOOR DRAG ANGLE CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA200923849Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPLACED BEAM PER SRM AND REO.SDR SWIA200923848Floor Support · corrodedCOCKPIT FLOOR SUPPORT CORRODED. (C CHECK) REPLACED SUPPORT PER SRM.SDR SWIA200923251Light · inoperativeAFT EMERGENCY LIGHT ON CEILING INOP. (FLT 4524)RELAMPED.SDR SWIA200923038Light · inoperativeNR 3 EMERGENCY FLOOD LIGHT INOP. (FLT 4623)RELAMPED.SDR SWIA200922765Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 8 INOP. (FLT 4575) RELAMPED EMERGENCY LIGHT.SDR SWIA200922002Lamp · burned outFLT 4653, EMERGENCY OVERHEAD LIGHT INOP. RELAMPED.SDR SWIA200921812Lamp · burned outFLT 4510 - CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921178Lamp · burned outFLT 4884 - AFT EMERGENCY LIGHT IN CEILING INOP. RELAMPED.SDR SWIA200920881Lamp · burned outFLT 4600 - OVERHEAD EMERGENCY FLOODLIGHT ROW 15 INOP. RELAMPED.SDR SWIA200820691Lamp · burned outFLT 4687 - CABIN EMERGENCY CELIING LIGHTS NR 3 AND NR 4 INOP. RELAMPED.SDR SWIA200820483Torque Link · corrodedDURING C-CHECK, RIGHT MLG PISTON ASSEMBLY LOWER INBOARD TORQUE LINK CORRODED. REPAIRED PER CMM.SDR SWIA200820482Piston · corrodedDURING C-CHECK, LEFT MLG PISTON ASSEMBLY LOWER AFT TOP OF AXLE SUPPORT CORRODED. REPAIRED PER REO.SDR SWIA200820481Beam · corrodedDURING C-CHECK, LEFT SIDE OF BEAM AT FS 280 CORRODED. REPAIRED PER REO.SDR SWIA200718565Oxygen Mask · unlatchedFORWARD LAV OXYGEN MASKS FELL DURING FLIGHT, FLIGHT NR 4012. RESTOWED FORWARD LAVATORY OXYGEN MASKS.SDR SWIA200616601Servo · malfunctionedPILOT REPORTS AUTOPILOT DISENGAGING ON APPROACHES. REPLACED ELEVATOR AUTOPILOT SERVO IAW MM 22-11-24. OPERATIONAL TEST GOOD IAW MM 22-11-24-710-801.
Back to N604SK