N809SK
Service difficulty reports · 246
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 = 'N809SK' 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 = 'N809SK' 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 SWIA201436292Seat Track · corrodedRT SIDE FLOOR SEAT TRACK HAS CORROSION FS 636.00 - FS 643.00. C-CHECK REPAIRED RT SIDE FLOOR SEAT TRACK AT FS 636.00 - FS 643.00 IAW REO.SDR SWIA201436291Skin · crackedCRACK FOUND UNDER PANEL 832AL AT SCREW HOLE ON PAX DOOR INNER SKIN. C-CHECK REPAIR TO PAX DOOR INNER SKIN UNDER PANEL 832AL IAW STS EA.SDR SWIA201436290Sill · corrodedPAX DOOR ENTRY WAY, TOP SIDE FLOOR SILL AREA HAS CORROSION NEXT TO LIGHTING DIVERTERS. C-CHECK TOP SIDE FLOOR SILL REPLACED IAW SRM & AMM.SDR SWIA201436296Lever · chafedPAX DOOR FWD PULL IN LEVER CHAFED. C-CHECK PAX DOOR FWD PULL IN LEVER CHAFE BLENDED IAW REO.SDR SWIA201436295Skin · corrodedUNDER PANEL 832CL ON PAX DOOR INNER SKIN HAS CORROSION. C-CHECK REPAIRED PAX DOOR INNER SKIN UNDER PANEL 832CL IAW STS EA.SDR SWIA201436297Skin · chafedFUSELAGE EXTERNAL SKIN & ONE RIVET CHAFED AT FS 918.50 STRINGER 27. C-CHECK BLENDED FUSELAGE SKIN AT FS 918.50 STRINGER 27 IAW REO.SDR SWIA201335410Light · inoperativeEMERGENCY EXIT SIGN ROW 14 IS BURNED OUT. FLT 4749 RELAMPED.SDR SWIA201334972Sign · detachedEMERGENCY SIGN COVER AT BULKHEAD AT MAIN CABIN DOOR IS OFF RECEPTACLE. FLT4688 REPLACED EMERGENCY SIGN ASSEMBLY AT BULKHEAD AT MAIN CABIN DOOR.SDR SWIA201334867Light · inoperativeNR 7 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT#4693 RELAMPED.SDR SWIA201334445Light · inoperativeEMERGENCY EXIT LIGHT BURNED OUT AT ROW 12 & AT MCD FLOOR LEVEL. FLT#4496 RELAMPED BOTH LOCATIONS.SDR SWIA201232392Light · inoperativeEMERGENCY OVERHEAD LIGHT ROW 17 BURNED OUT. (FLT 4772) RELAMPED EMERGENCY LIGHT.SDR SWIA201232132Pump · defectiveHYDRAULIC 3 SYSTEM QUANTITY DROPPED TO 5 PERCENT. LOSS OF ALL HYDRAULIC 3 PRESSURE. (FLT 4457) FOUND PUMP 3A TO BE LEAKING INTERNALLY. REPLACED ACMP 3A IAW AMM. P/N: 66195-01 S/N OFF: K2050.SDR SWIA201231384Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4646) RELAMPED EMERGENCY LIGHT.SDR SWIA201231192Floorbeam · crackedCOCKPIT FLOORBEAM FS 274.00 LBL 11 IS CRACKED. (C-CHECK) REPAIRED PER REO.SDR SWIA201231162Crossbeam · crackedFS 280 CROSSBEAM HAS CORROSION AND CRACKS ON LEFT AND RIGHT SIDES. (C-CHECK) REPAIR PER REO.SDR SWIA201229998Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4467) RELAMPED EMERGENCY LIGHT.SDR SWIA201229606Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4789) RELAMPED EMERGENCY LIGHT.SDR SWIA201229519Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229182Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4535) RELAMPED EMERGENCY LIGHT.SDR SWIA201129006Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4443) RELAMPED EMERGENCY LIGHT.SDR SWIA201128848Light · inoperativeAFT CEILING EMERGENCY LIGHT DOES NOT ILLUMINATE. (FLT 4818) RELAMPED EMERGENCY LIGHT.SDR SWIA201128638Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT4827) RELAMPED EMERGENCY LIGHT.SDR SWIA201128308Light · inoperativeTHE 3RD FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4765) RELAMPED EMERGENCY LIGHT.SDR SWIA201128034Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127941Light · inoperativeEMERGENCY EXIT SIDEWALL EXIT LIGHTS INOPERATIVE. (FLT 4791) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127673Light · inoperativeLAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4661) RELAMPED EMERGENCY LIGHT.SDR SWIA201127319Seal · damagedLEFT BLEED DUCT WARNING. (FLT 4703) REPLACED LEFT PYLON STUB DUCT E-SEALS, COVERS AND LOOP CONNECTIONS.SDR SWIA201126952Light · inoperativeOVERHEAD EMERGENCY LIGHTS AT ROW 7 AND 9 ARE OUT. (FLT 4620) RELAMPED EMERGENCY LIGHTS.SDR SWIA201126569Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 IS OUT. (FLT 4716) RELAMPED EMERGENCY LIGHT.SDR SWIA201126018Link · corrodedRIGHT ENGINE FORWARD MOUNT UPPER LINK ASSEMBLY IS CORRODED. (ENGINE CHANGE) REPLACED RIGHT ENGINE FORWARD MOUNT UPPER LINK ASSEMBLY.SDR SWIA201024415Light · inoperativeNR 5 CEILING EMERGENCY LIGHT INOP. (FLT 4497) RELAMPED EMERGENCY LIGHT.SDR SWIA201023999Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 10 INOP. (FLT 4690) RELAMPED EMERGENCY LIGHT.SDR SWIA201023654Sign · inoperativeFLOOR LEVEL LIGHTED EXIT SIGN INOP. (FLT 4549) RELAMPED EXIT SIGN.SDR SWIA200923368Light · inoperativeEMERGENCY CEILING LIGHT INOP AT ROW 14. (FLT 4569) RELAMPED EMERGENCY LIGHT.SDR SWIA200923339Light · inoperativeSECOND TO LAST EMERGENCY CEILING LIGHT INOP. (FLT 4565) RELAMPED EMERGENCY LIGHT.SDR SWIA200923340Light · inoperativeAFT MOST CEILING EMERGENCY LIGHT INOP. (FLT 4663) RELAMPED EMERGENCY LIGHT.SDR SWIA200923176Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 15 INOP. (FLT 4466) RELAMPED EMERGENCY LIGHT.SDR SWIA200922979Light · inoperativeMOST AFT EMERGENCY LIGHT IN CEILING INOP. (FLT 4759) RELAMPED EMERGENCY LIGHT.SDR SWIA200922076Light · inoperativeEMERGENCY OVERHEAD FLOOD LIGHT INOP. (FLT 4819) RELAMPED EMERGENCY FLOOD LIGHT.SDR SWIA200921839Lamp · burned outFLT 4542 - EMERGENCY CEILING FLOODLIGHT INOP. RELAMPED.SDR SWIA200921291Tire · failedFLT 4804 - LEFT MAIN TIRES BLOWN ON TAXI IN. REPLACED TIRES AND ACCOMPLISHED INSPECTION.SDR SWIA200921860Drag Angle · crackedC-CHECK, PASSENGER DOOR AFT DRAG ANGLE CRACKED. REPAIRED PER REO.SDR SWIA200921859Floorbeam · crackedC-CHECK, BEAM RBL 12 AT FS 274 CRACKED. REPAIRED PER REO.SDR SWIA200921858Floorbeam · corrodedC-CHECK, FS 280 LEFT BEAM CORRODED. REPAIRED PER REO.SDR SWIA200921004Lamp · burned outFLT 4588 - LEFT EXTERIOR AFT EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200819486Line · leakingFLT 3747 - "HYD EDP 2A" CAUTION MESSAGE APPEARED ON APPROACH AND QUANTITY SHOWED 0 PERCENT. REPAIRED LEAKING THRUST REVERSER HYDRAULIC LINE. OPS AND LEAK CHECK GOOD.
Back to N809SK