N724SK
Service difficulty reports · 119
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 = 'N724SK' 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 = 'N724SK' 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 SWIA201440004Anti-Ice System · malfunctionedRETURNED TO FIELD WITH A RT COWL ANTI-ICE THAT WOULD NOT COME ONLINE WHEN SELECTED. F/O CYCLED ISOLATION VALVE FROM CLOSED POSITION AND SELECTED BLEED VALVES TO AUTO POSITION. ALL SYSTEM CHECKED GOOD. NO FAULTS POSTED. COWL ANTI-ICE OPS CHECK GOOD.SDR SWIA201439147Flashlight · inoperativeFWD F/A FLASHLIGHT NOT BLINKING. CHANGED THE FLASHLIGHT.SDR SWIA201439057Latch · chafedRT SIDE UPPER TRANS COWL HAS CHAFING INSIDE COWL AT LATCH LOCATION. REPAIRED IAW REO. FUNCTIONAL TESTED GOOD.SDR SWIA201439056Latch · chafedRT SIDE LOWER TRANSCOWL HAS CHAFING INSIDE COWL AT LATCHES. REPAIRED DAMAGED AREA IAW REO. FUNCTIONAL TESTED GOOD.SDR SWIA201439055Floor Panel · crackedFORWARD EQUIPMENT BAY FLOOR PANEL BS 192.75 WL 79.5 CRACKED. REPAIRED THE FLOOR PANEL IAW REO AND EA.SDR SWIA201439054Floor Panel · crackedFORWARD EQUIPMENT BAY FLOOR BS 192.75 AND WL 79.50 CRACKED. REPAIRED FLOOR PANEL IAW REO.SDR SWIA201439059Structure · chafedLEFT ENGINE UPPER TRANS COWL HAS CHAFING INSIDE COWLING BY LATCHES. REPAIRED IAW REO. FUNCTIONAL TESTED GOOD.SDR SWIA201439058Structure · chafedLEFT ENGINE LOWER TRANS COWL INNER COWL HAS CHAFING. REPAIRED IAW REO.SDR SWIA201438822Battery Pack · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. R & R THE FLASHLIGHT BATTERY PACK. OPS CHECKED GOOD.SDR SWIA201438701Smoke Detector · failedFIRE SYS FAULT STATUS. R & R FWD CARGO NR 1 SMOKE DETECTOR IAW AMM.SDR SWIA201438653Battery Pack · inoperativeF/A REPORTED FWD FLASHLIGHT INOPERATIVE. R & R FWD FLASHLIGHT BATTERY IAW CMM.SDR SWIA201438377Cover · brokenS EMERGENCY EXIT LIGHT COVER IS BROKEN. R & R THE COVER IAW AMM.SDR SWIA201438390Lamp · inoperativeOVERHEAD EMERGENCY LIGHT POD AT ROW 11 IS INOPERATIVE. REPLACED THE LAMP IN OVERHEAD EMERGENCY LIGHT.SDR SWIA201437801Bulb · burned outSIDE WALL EMERGENCY EXIT BULB BURNED OUT, REPLACED THE BULB.SDR SWIA201437530Lamp · burned outOVERHEAD EMERGENCY LIGHT AT ROW 20 IS BURNED OUT. REPLACED THE LAMP.SDR SWIA201437156Bulb · burned outEMERGENCY EXIT SIGN HAS A BURNED OUT BULB. REPLACED BULB.SDR SWIA201436353Light · inoperativeNR 4 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 5176 RELAMPED.SDR SWIA201335454Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS BURNED OUT. FLT 5206 RELAMPED.SDR SWIA201334643Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT#5196 RELAMPED.SDR SWIA201334483Battery Pack · dischargedOVERHEAD EMERGENCY LIGHTS & FLOOR LEVEL LIGHT IN GALLEY ARE BURNED OUT. FLT#4971 REPLACED THE BATTERY PACK. PN ON AD-2013-1A, SN ON 79463 & SN OFF 67789SDR SWIA201334424Battery Pack · dischargedEMERGENCY POD LIGHTS ARE INOPERATIVE. FLT#5160 SET EMERGENCY LIGHTS SWITCH TO ARM POSITION TO CHARGE ELBP IAW AMM.SDR SWIA201334412Light · inoperativeEMERGENCY POD LIGHT INOPERATIVE. FLT#6332 RELAMPED.SDR SWIA201333354Ballast · faultyELECTRIC SMOKE IN CABIN. (FLT 5584) REMOVED AND REPLACED BURNED CEILING LIGHT BALLAST ON AFT RIGHT SIDE.SDR SWIA201333055Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 9 BURNED OUT. (FLT 5653) RELAMPED EMERGENCY LIGHT.SDR SWIA201332933Axle · corrodedCORROSION FOUND MLG PISTON AXLE ROOT RADIUS. REPAIRED MLG PISTON AXLE ROOT RADIUS IAW REO.SDR SWIA201332935Axle · corrodedCORROSION FOUND MLG PISTON AXLE (3) ROOT RADIUS. (C-CHECK) REPAIRED MLG PISTON/AXLE (3) ROOT RADIUS IAW REO.SDR SWIA201332934Axle · corrodedCORROSION FOUND MLG PISTON AXLE (1) ROOT RADIUS. (C-CHECK) REPAIRED MLG PISTON/AXLE (1) ROOT RADIUS IAW REO.SDR SWIA201332932Axle · corrodedCORROSION FOUND MLG PISTON AXLE (4) ROOT RADIUS. (C-CHECK) REPAIRED MLG PISTON/AXLE (4) ROOT RADIUS IAW REO.SDR SWIA201332931Crossbeam · crackedFS 280 CROSSBEAM CRACKED. (C-CHECK) REPLACED FS 280 FLOORBEAM IAW REO.SDR SWIA201231938Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6281) RELAMPED EMERGENCY LIGHT.SDR SWIA201231913Light · inoperativeEXIT SIGN BULB IS INOPERATIVE NEXT TO THE OVERWING EMERGENCY EXIT DOME ON THE RIGHT SIDE OF THE AIRCRAFT. (FLT 6397) RELAMPED EXIT SIGN.SDR SWIA201231190Sign · inoperativeEMERGENCY EXIT SIGN AT LEFT OVERWING EXIT IS OUT. (FLT 6433) RELAMPED EMERGENCY EXIT SIGN.SDR SWIA201229876Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5532) RELAMPED EMERGENCY LIGHT.SDR SWIA201229118Light · inoperativeNR 1 AND NR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5160) RELAMPED EMERGENCY LIGHT.SDR SWIA201129009Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5214) RELAMPED EMERGENCY LIGHT.SDR SWIA201128771Light · inoperativeTHE 2ND OVERHEAD EMERGENCY EXIT LIGHT IS OUT. (FLT 6381) RELAMPED EMERGENCY LIGHT.SDR SWIA201128589Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6366) RELAMPED EMERGENCY LIGHT.SDR SWIA201128588Relay · failedEMERGENCY LIGHTS CYCLE ON AND OFF. (FLT 6279) REPLACED RELAY K135 ON PCB5 5B11.SDR SWIA201128141Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127904Light · inoperativeNR 1 CEILING EMERGENCY LIGHT IS OUT. (FLT 2048) RELAMPED EMERGENCY LIGHT.SDR SWIA201127596Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126879Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5514) RELAMPED EMERGENCY LIGHT.SDR SWIA201126855Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 1139) RELAMPED EMERGENCY LIGHT.SDR SWIA201126694Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6351) RELAMPED EMERGENCY LIGHT.SDR SWIA201126160Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT BURNED OUT. (FLT 6856) RELAMPED EMERGENCY LIGHT.SDR SWIA201125626Light · inoperativeTHIRD OVERHEAD CEILING EMERGENCY LIGHT BURNED OUT. (FLT 6997) RELAMPED EMERGENCY LIGHT.SDR SWIA201125395Relay · failedEMERGENCY LIGHTS TURNING ON AND OFF. (FLT 6500) REPLACED RELAY.SDR SWIA201025212Light · inoperativeFORWARD OVERHEAD EMERGENCY LIGHT OUT. (FLT 6471) RELAMPED EMERGENCY LIGHT.SDR SWIA201024549Mount · corrodedYOKE MOUNT LINK CORRODED. (ENG CHANGE) REPLACED THE YOKE MOUNT LINK, BUSHING, AND BOLT IAW MM 71-00-00.SDR SWIA201024551Light · inoperativeAFT CEILING EMERGENCY FLOOD LIGHT INOP. (FLT 6742) RELAMPED EMERGENCY LIGHT.
Back to N724SK