N778SK
Service difficulty reports · 209
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 = 'N778SK' 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 = 'N778SK' 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 SWIA201437091Axle · corrodedNR 2 LT MLG PISTON AXLE FOUND CORROSION. C-CHECK, REPAIRED IAW REO.SDR SWIA201437090Axle · corrodedNR 3 RT MLG PISTON AXLE FOUND CORRODED. C-CHECK, REPAIRED IAW REO.SDR SWIA201437089Axle · corrodedNR 4 RT MLG PISTON AXLE FOUND CORRODED. C-CHECK, REPAIRED PISTON AXLE ROOT RADIUS IAW REO.SDR SWIA201437088Floor Support · corrodedRT OTBD FLOOR SUPPORT CORRODED JUST AFT OF FS 280. C-CHECK, REPLACED FLOOR SUPPORT IAW SRM.SDR SWIA201437087Skin · chafedLEFT INBD FLAP PANEL 584GB IS CHAFED. C-CHECK, REPLACED FLAP PANEL IAW SRM..SDR SWIA201335560Light · inoperative4TH EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 6348 RELAMPED.SDR SWIA201334725Light · inoperativeAFT POD LIGHT BURNED OUT. FLT#5627 RELAMPED.SDR SWIA201332517Light · inoperativeFLOOR LEVEL EMERGENCY EXIT SIGN AT SEAT 12D BURNED OUT. (FLT 5604) RELAMPED EMERGENCY EXIT SIGN.SDR SWIA201232017Beam · crackedTHE 280 BEAM WAS CRACKED AT RBL 9 AND LBL 9. (C-CHECK) REPAIRED PER REO.SDR SWIA201231093Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 5643) RELAMPED EMERGENCY LIGHT.SDR SWIA201230978Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5389) RELAMPED EMERGENCY LIGHT.SDR SWIA201230656Light · inoperativeOVERHEAD EMERGENCY LIGHT IS OUT AT ROW 14. (FLT 6409) RELAMPED EMERGENCY LIGHT.SDR SWIA201230514Light · inoperativeFORWARD OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5477) RELAMPED EMERGENCY LIGHT.SDR SWIA201230450Light · inoperativeNR 3 AND NR 5 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 5559) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230410Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5166) RELAMPED EMERGENCY LIGHT.SDR SWIA201230023Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6269) RELAMPED EMERGENCY LIGHT.SDR SWIA201229966Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5327) RELAMPED EMERGENCY LIGHT.SDR SWIA201229888Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6460) RELAMPED EMERGENCY LIGHT.SDR SWIA201229799Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201202109646Lamp · burned outFLT 6240, NR 1 OVERHEAD EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201229492Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201129010Light · inoperativeSECOND TO LAST CEILING EMERGENCY LIGHT IS OUT. (FLT 5201) RELAMPED EMERGENCY LIGHT.SDR SWIA201128892Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5186) RELAMPED EMERGENCY LIGHT.SDR SWIA201128714Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5174) RELAMPED EMERGENCY LIGHT.SDR SWIA201128093Light · inoperativeNR 1 AND NR 2 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 6276) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128061Light · inoperativeNR 5 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127761Light · inoperativeNR 1 EMERGENCY LIGHT INOPERATIVE. (FLT 2002) RELAMPED EMERGENCY LIGHT.SDR SWIA201127694Light · inoperativeNR 3 AND NR 5 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 2032) RELAMPED EMERGENCY LIGHT.SDR SWIA201127504Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2005) RELAMPED EMERGENCY LIGHT.SDR SWIA201127280Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 15 IS OUT. (FLT 6374) RELAMPED EMERGENCY LIGHT.SDR SWIA201127281Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 9 IS OUT. (FLT 6497) RELAMPED EMERGENCY LIGHT.SDR SWIA201126867Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6222) RELAMPED EMERGENCY LIGHT.SDR SWIA201126868Light · inoperativeTHE 2ND TO AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5634) RELAMPED EMERGENCY LIGHT.SDR SWIA201126758Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 6237) RELAMPED EMERGENCY LIGHT.SDR SWIA201126759Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 9 IS OUT. (FLT 5443) RELAMPED EMERGENCY LIGHT.SDR SWIA201126105Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6960) RELAMPED EMERGENCY LIGHT.SDR SWIA201126028Light · inoperativeOVERHEAD EMERGENCY LIGHT IS OUT AT ROW 15. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201125926Floorbeam · crackedFS 280 FLOORBEAM CRACKED ON BOTH LEFT AND RIGHT SIDES. (C-CHECK) REPLACE PER SRM.SDR SWIA201125865Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6265) RELAMPED EMERGENCY LIGHT.SDR SWIA201125739Light · inoperativeNR 4 CEILING EMERGENCY LIGHT IS OUT. (FLT 6508) RELAMPED EMERGENCY LIGHT.SDR SWIA201025167Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT INOPERATIVE. (FLT 7027) RELAMPED EMERGENCY LIGHT.SDR SWIA201024989Lamp · burned outFORWARD EMERGENCY EXIT LIGHT INOPERATIVE. (FLT 6148) RELAMPED.SDR SWIA201024494Light · inoperativeNR 4 CEILING EMERGENCY LIGHT INOP. (FLT 6369) RELAMPED EMERGENCY LIGHT.SDR SWIA201023796A/C Pack · smokeSMOKE IN CABIN ON CLIMB. (FLT 5940) LEFT PACK OVERTEMPED AND SMOKING DURING OPERATION CHECKS. REPLACED LT ACM.SDR SWIA201023717Light · inoperativeEMERGENCY CEILING LIGHT INOP. (FLT 6442) RELAMPED EMERGENCY LIGHT.SDR SWIA200923257Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 2 INOP. (FLT 6550)RELAMPED.SDR SWIA200922922Light · inoperativeFORWARD CEILING EMERGENCY LIGHT INOP. (FLT 5785) RELAMPED EMERGENCY LIGHT.SDR SWIA200923215Angle · crackedFS280 DIAGONAL ANGLE CRACKED. (C CHECK)REPLACED ANGLE PER SRM.SDR SWIA200923214Floorbeam · crackedFS280 FLOORBEAM TOP SURFACE CRACKED. (C CHECK)REPLACED BEAM PER REO.SDR SWIA200921957Lamp · burned outEMERGENCY EXIT SIGNS INOP. (FLT 6139) RELAMPED SIGNS.
Back to N778SK