N726SK
Service difficulty reports · 220
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 = 'N726SK' 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 = 'N726SK' 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 SWIA201335252Strut · disconnectedGALLEY SERVICE DOOR WILL NOT OPEN, DOOR HANDLE IS BINDING AT THE UP 12 O'CLOCK POSITION. FLT 5160 RECONNECTED UPLOCK STRUT ASSEMBLY. DOOR HANDLE MOVEMENT IS SMOOTH & DOOR OPEN & CLOSES PROPERLY IAW AMM.SDR SWIA201334353Light · inoperativeEMERGENCY LIGHT BURNED OUT. FLT#5597 RELAMPED.SDR SWIA201333716Light · inoperativeONE LIGHT BULB BURNED OUT ON EMERGENCY LIGHT ON RIGHT OVERWING EXIT. RELAMPED.SDR SWIA201333692Light · inoperativeRIGHT OVERWING EXIT LOWER EXIT SIGN IS BURNED OUT. RELAMPED.SDR SWIA201333353Light · inoperativeEMERGENCY LIGHT IN GALLEY BURNED OUT. (FLT 6379) RELAMPED EMERGENCY LIGHT.SDR SWIA201333091Seat Track · corrodedPREVIOUSLY WORKED RIGHT SIDE WALL SEAT TRACK AFT OF OVERWING EMERGENCY EXIT BETWEEN STA 785 AND 861 HAS CORROSION REMAINING AT STA 788, 803, 813 AND 844. (C-CHECK) BLENDED OUT CORROSION ON RIGHT SIDE WALL SEAT TRACK AFT OF OVERWING EMERGENCY EXIT AT STA 788 SDR SWIA201333095Axle · corrodedCORROSION ON LEFT MLG AXLE NR 1 ROOT RADIUS. (C-CHECK) REPAIRED LEFT MLG AXLE NR 1 IAW REO.SDR SWIA201333094Axle · corrodedCORROSION ON LEFT MLG AXLE NR 2 ROOT RADIUS. (C-CHECK) REPAIRED LEFT MLG AXLE NR 2 IAW REO.SDR SWIA201333093Axle · corrodedCORROSION ON RIGHT MLG AXLE NR 3 ROOT RADIUS. (C-CHECK) REPAIRED RIGHT MLG AXLE NR 3 IAW REO.SDR SWIA201333092Axle · corrodedCORROSION ON RIGHT MLG AXLE NR 4 ROOT RADIUS. (C-CHECK) REPAIRED CORROSION ON RIGHT MLG AXLE NR 4 IAW REO.SDR SWIA201333098Crossbeam · crackedFS 280 CROSSBEAM CRACKED AT LBL 13.1 AND RBL 11.6. (C-CHECK) INSTALLED FS 280 FLOORBEAM IAW REO.SDR SWIA201333097Bulkhead · crackedFS 280 BULKHEAD LEFT LOWER WEB CRACKED. (C-CHECK) REPAIRED FS 280 BULKHEAD LEFT LOWER WEB IAW REO.SDR SWIA201333096Bulkhead · crackedFS 280 BULKHEAD RIGHT LOWER WEB CRACKED. (C-CHECK) REPAIRED FS 280 BULKHEAD RIGHT LOWER WEB IAW REO.SDR SWIA201332759Light · inoperativeRIGHT OVERWING EXIT LOWER EMERGENCY LIGHT DOES NOT ILLUMINATE. (FLT 6420) RELAMPED EMERGENCY LIGHT.SDR SWIA201232092Light · inoperativeEMERGENCY LIGHT AT SERVICE DOOR BURNED OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201232004Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6220) RELAMPED EMERGENCY LIGHT.SDR SWIA201231975Light · inoperativeOVERWING EMERGENCY EXIT SIGN ON LEFT SIDE HAS 3 OF ITS 5 LIGHT BULBS OUT. (FLT 6440) RELAMPED THE OVERWING EMERGENCY EXIT SIGN LIGHT BULBS IN REFERENCE TO CRJ 700 AMM.SDR SWIA201231835Bearing · lack of lubeMAIN CABIN DOOR HARD TO OPEN FROM INSIDE THE CABIN. (FLT 6209) LUBED MAIN CABIN DOOR INNER HANDLE BEARING, INNER HANDLE, AND WHEEL.SDR SWIA201231768Light · inoperativeLIGHT BULB IS OUT IN THE LOWER LIGHTED EMERGENCY EXIT SIGN NEAR THE LEFT OVERWING EXIT. (SERVICE) RELAMPED EMERGENCY EXIT SIGN.SDR SWIA201231572Light · inoperativeONE EMERGENCY LIGHT BULB IS OUT ON OVERWING EXIT SIGN ON LEFT SIDE. (FLT 6404) RELAMPED EMERGENCY LIGHT.SDR SWIA201231271Hydraulic Line · failedHYDRAULIC SYSTEM NR 3 LOST ALL QUANTITY. (FLT 6261) REPLACED UPPER UPLOCK LINE ON LEFT MLG IN REF TO AMM.SDR SWIA201231130Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6479) RELAMPED EMERGENCY LIGHT.SDR SWIA201230299Lamp · burned outNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201229680Lamp · burned outNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201229526Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229117Sign · inoperativeLEFT LOWER OVERWING EMERGENCY EXIT SIGN IS OUT. (FLT 5417) RELAMPED EMERGENCY LIGHT.SDR SWIA201128958Light · inoperativeNR 3 EMERGENCY OVERHEAD LIGHT NOT WORKING. (FLT 5164) RELAMPED EMERGENCY LIGHT.SDR SWIA201128759Light · inoperativeNR 1 EMERGENCY CEILNG LEVEL LIGHT OUT. (FLT 5366) RELAMPED EMERGENCY LIGHT.SDR SWIA201128189Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 15 BURNED OUT. (FLT 5485) RELAMPED EMERGENCY LIGHT.SDR SWIA201128114Light · inoperativeNR 3, 4 AND 5 CEILING EMERGENCY LIGHTS ARE OUT. (FLT 5229) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127937Fuse · blownEMERGENCY LIGHTS AT BULKHEAD (SEAT 3C) INOPERATIVE. (FLT 6238) REPLACED FUSE IN BATTERY CHARGER OVER ROW 6 AND LIGHT FIXTURE FOR SERVICE DOOR FLOODLIGHT.SDR SWIA201127938Light · inoperativeNR 6 AFT OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. (FLT 6422) RELAMPED EMERGENCY LIGHT.SDR SWIA201128066Fuse · failedEMERGENCY LIGHTS AT ROW 3 AND NEAR THE GALLEY SERVICE DOOR ARE OUT. (FLT 1351) REPLACED FUSE IN EMERGENCY LIGHT BATTERY CHARGER OVER ROW 6 AND LIGHT FIXTURE FOR SERVICE DOOR EMERGENCY LIGHT.SDR SWIA201127714Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 12 IS OUT. (FLT 6255) RELAMPED EMERGENCY LIGHT.SDR SWIA201127403Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C-CHECK) REPLACE FLOORBEAM PER SRM.SDR SWIA201127197Battery · dischargedINTERIOR EMERGENCY LIGHTS WILL NOT ILLUMINATE. (FLT 1128) REPLACED NR 3 AND NR 4 EMERGENCY LIGHT BATTERIES. PN: 2013-1A SN 1 OFF: 95065; SN 2 OFF: 65906.SDR SWIA201127001Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5579) RELAMPED EMERGENCY LIGHT.SDR SWIA201126532Light · brokenWARDROBE EMERGENCY EXIT LIGHT BASE IS BROKEN. (SERVICE) REPLACED WARDROBE EMERGENCY EXIT LIGHT ASSEMBLY.SDR SWIA201126533Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126497Light · inoperativeOVERHEAD EMERGENCY LIGHT NEAR ROW 15 IS OUT. (FLT 5579) RELAMPED EMERGENCY LIGHT.SDR SWIA201126423Hinge Pin · lack of lubeMAIN CABIN DOOR DIFFICULT TO OPEN. (FLT 6235) LUBED TOP STEP LOWER HINGE PIN.SDR SWIA201126349Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6690) RELAMPED EMERGENCY LIGHT.SDR SWIA201126328Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6331) RELAMPED EMERGENCY LIGHT.SDR SWIA201125414Lamp · burned outAFT OVERHEAD EMERGENCY LIGHT INOPERATIVE. (FLT 6482) RELAMPED EMERGENCY LIGHT.SDR SWIA201024167Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 15 INOP. (FLT 6495) RELAMPED EMERGENCY LIGHT.SDR SWIA201023795Beam · crackedFS 280 BEAM CRACKED. (C CHECK) REPLACED PER REO.SDR SWIA201024250Web · crackedPASSENGER DOOR FORWARD WEB CRACKED AT SECOND STEP CUTOUT. (C CHECK) REPAIRED PER SRM.SDR SWIA201024249Floor Support · crackedFS 280 BEAM AND FLOOR SUPPORTS CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA201023653Mount · corrodedRIGHT ENGINE MOUNTS AND HARDWARE PITTED AND CORRODED. (ENG CHANGE) REPLACED MOUNTS AND HARDWARE.SDR SWIA200923317Light · inoperativeAFT EMERGENCY CEILING LIGHT INOP. (FLT 6252) RELAMPED EMERGENCY LIGHT.
Back to N726SK