N308SW, cancelled Aug 30, 2018
Service difficulty reports · 105
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 = 'N308SW' AND deregistration_id = 'N308SW-2018-08-30' 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 = 'N308SW' AND deregistration_id = 'N308SW-2018-08-30' 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 SWIA200922141Light · not seatedFORWARD MOST CEILING EMERGENCY LIGHT INOP. (FLT 6318) RESEATED LIGHT BULB.SDR SWIA200921937Trim Panel · out of positionMAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. (FLT 6287) REPOSITIONED LOWER TRIM, OPERATED MAIN CABIN DOOR NUMEROUS TIMES, OPS CHECK GOOD.SDR SWIA200921841Handle · failedFLT 6841 - GEAR DISAGREE MESSAGE DISPLAYED. REPLACED GEAR HANDLE ASSEMBLY.SDR SWIA200921749Roller · lack of lubeMAIN CABIN DOOR STICKS WHEN OPENING. (FLT 7765) LUBED DOOR ROLLERS AND HOOKS.SDR SWIA200921702Hmu · power lossFLT 7785 - LEFT ENGINE POWER LOSS ON CLIMB. REPLACED HMU.SDR SWIA200921594Door · stiffFLT 6494 - MAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. REPOSITIONED FLIGHT ATTENDANT SEAT.SDR SWIA200921504Sign · brokenFLT 6102 - EMERGENCY "EXIT" SIGN ROW 9 BROKEN. RESECURED.SDR SWIA200920895Lamp · burned outFLT 5491 - EMERGENCY LIGHT ROW 1 INOP. RELAMPED.SDR SWIA200920799Proximity Sensor · out of adjustFLT 5706 - LANDING GEAR WOULD NOT RETRACT ON TAKEOFF. ADJUSTED LEFT MLG DOWNLOCK PROX SENSOR. REPLACED GEAR HANDLE ASSEMBLY, P/N 120-38594-401 S/N ON, 120346, S/N OFF: 120350.SDR SWIA200920776Actuator · bindingFLT 5441 - FA REPORTS MAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. CLEANED AND LUBED DOOR HANDLE ACTUATOR AND BEARING COMPONENTS.SDR SWIA200819942Guide · bindingMAIN CABIN DOOR WILL NOT OPEN. FLIGHT 5473. ADJUSTED GUIDE RETAINING HARDWARE AND OPS CHECKED DOOR PER AMM 52-10-00.
SDR SWIA200819909Wire · damagedFIRST TWO FLOOR EMERGENCY LIGHTS ARE INOP. (FLIGHT NR 5438) REPAIRED WIRING TO EMERGENCY LIGHTS. OPS CHECK GOOD.
SDR SWIA200819703Unknown · malfunctionedON DESCENT, THE CABIN PRESSURE BEGAN TO INCREASE FOLLOWED BY A "CABIN PRESS WARNING" MESSAGE. FLIGHT 3616 - PRESSURIZED AIRCRAFT SEVERAL TIMES. COULD NOT DUPLICATE. OPS CHECK GOOD AT THIS TIME.
SDR SWIA200819502Wire · damagedFLT 5590 - ROW 1 EMERGENCY LIGHT IS INOP. REPAIRED WIRING AT EMERGENCY LIGHT. OPS CHECK GOOD.
SDR SWIA200819463Outflow Valve · malfunctionedFLT 3695 - AUTO PRESSURIZATION FAILED ON CLIMB-OUT. REPLACED ELECTRONIC ALTITUDE CONTROLLER AND ELECTROPNEUMATIC OUTFLOW VALVE IAW AMM 21-30-03. OPS CHECK GOOD, PN 2091G010800, SN/OFF 205, PN 22201T011400, SN/OFF 527.
SDR SWIA200718967Bracket · crackedFLT 5490 - LEFT OUTBOARD FLAP, INBOARD ROLLER BRACKET IS CRACKED. REPLACED LEFT OUTBOARD FLAP, INBOARD ROLLER ASSEMBLY AS NEEDED IAW 51-40-02.
SDR SWIA200718848Wire · damagedFLT 5561 - RED EMERGENCY LIGHTS ON FLOOR ARE INOP. REPAIRED WIRES AT RED EMERGENCY LIGHT FIXTURE.
SDR SWIA200718830Wire · inoperativeFLT 5589 - MULTIPLE FLOOR LEVEL EMERGENCY LIGHTS ARE INOPERATIVE. REPAIRED WIRING ON FLOOR EMERGENCY LIGHTS.
SDR SWIA200718476Coffeemaker · overheatedF/A REPORTS COFFEE POT OVERHEATED WITH A BURNING ODOR. REPLACED COFFEE POT WITH SERVICEABLE UNIT. OPS CHECKS GOOD.SDR SWIA200718028Control Valve · smokeSELECTED PACKS TO NORMAL AND LEFT PACK FAILED WITH AIR CONDITION SMOKE. REPLACED LEFT PACK TEMPERATURE CONTROL VALVE IAW 21-60-01. OPERATIONAL CHECKS GOOD.SDR SWIA200717691Bulkhead · corrodedLEFT FORWARD BULKHEAD IN FRONT OF 1ST SEAT LOWER ATTACH TRACK CORRODED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED LOWER ATTACH TRACK FOR LEFT FORWARD BULKHEAD WITH A SERVICEABLE UNIT.SDR SWIA200717690Rib · crackedLEFT INBOARD WING RIB NR 8 LOWER CLIP CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED CLIP ON LEFT INBOARD WING RIB NR 8 LOWER. SEE RII 28-900-1000 IAW SRM 51-40-02.SDR SWIA200717689Floorbeam · crackedRIGHT FLOORBEAM AT FRAME 13 ANGLE, INBOARD SIDE, CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED SUPPORT ANGLE AT FRAME 13A FLOOR PROP, INBOARD SIDE OF RIGHT FLOOR PROP PER EMB 120 SRM 51-40-02.SDR SWIA200717688Floorbeam · crackedLEFT FLOORBEAM AT FRAME 13 CRACKED BOTH SIDES, DISCOVERED DURING C-CHECK INSPECTION. SPLICED IN REPLACEMENT SECTION PER EMB 120 SRM 53-10-10. SEE RII 53-800-1000.SDR SWIA200717687Stringer · crackedNR 10 STRINGER CRACKED BETWEEN RIBS NR 8 AND NR 9 AT RIGHT INBOARD WING, DISCOVERED DURING C-CHECK INSPECTION. REPAIRED NR 10 STRINGER BETWEEN RIBS NR 8, NR 9 INSIDE RIGHT WING IAW SRM 57-20-03 AND RII CARD 57-900-1000.SDR SWIA200616834Battery Pack · dischargedEMERGENCY LIGHTS CENTER SECTION AND ROW 6 INOP. REPLACED EMERGENCY LIGHTS BATTERY PACK. OPERATIONAL CHECKS GOOD, SN OFF 1193/0396.SDR SWIA200616817Control Valve · leakingSHORTLY AFTER TAKEOFF, GREEN SYSTEM "LOW LEVEL" LIGHT ILLUMINATED AND STAYED ON AND THE BLUE SYSTEM WAS FLUCTUATING ERRATICALLY FROM ZERO TO FULL. REPLACED BLUE SYSTEM BRAKE CONTROL VALVE REF MM 32-41-02.SDR SWIA200616626Stop · out of adjustMAIN CABIN DOOR VERY HARD TO OPEN/CLOSE. ADJUSTED MAIN CABIN DOOR BACKSTOPS IAW MM 52-11-00, PG 501. OPERATIONAL CHECK GOOD.SDR SWIA200515130Light · inoperativeFIRST 4 FLOOR LEVEL EMERGENCY LIGHTS NOT WORKING. REPLACED LIGHT ASSY WITH SERVICEABLE UNIT. OPS CHECK GOOD.SDR SWIA200514870Battery Pack · dischargedONE OF THE FLOOR EMERGENCY LIGHTING STRIPS AND THE 2 OVERWING EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED CENTER AND AFT ELBP. OPS CHECKED GOOD, PN D366-04-001 SN/OFF 551 PN D366-04-001 SN/OFF 1219.SDR SWIA200514617Stick Shaker · inoperativeF/O STICK SHAKER INOPERATIVE. REPLACED STICK SHAKER IAW EMB MM 27-34-04, OPERATIONAL CHECK GOOD. P/N C-81802-2, S/N OFF 843.SDR SWIA200413801Stick Shaker · inoperativeFOS STICK SHAKER INOPERATIVE. REMOVED AND REPLACED FOS STICK SHAKER IAW MM 27-34-04. OPERATIONAL CHECK SATISFACTORY. P/N: C-81802-2 S/N OFF: 641SDR SWIA200211511Fitting · leakingWHILE INFLIGHT RECEIVED A LOW RESERVOIR PRESSURE LIGHT. WHEN EXTENDING GEAR THE MAIN PUMP LOW PRESSURE LIGHT ILLUMINATED. TURNED ELECTRIC PUMP TO ON. IMMEDIATELY LOW LEVEL LIGHT ILLUMINATED AND GAUGE WENT TO 0. PRESSURE FLUCTUATED BUT FLAPS CAME DOWN. PRESDR SWIA200211406Relay · arcedRELAYS FO SIDE PANEL HOT. SMOKE ODOR IN COCKPIT. REPLACED APU FEEDER PROTECTION RELAY K0152 AND BUS BARS W1264, W163 DUE TO ARCING. OPERATED AIRCRAFT ELECTRICAL UNDER HEAVY LOADS ON APU GENERATOR WITHOUT CONTACTOR OR BUS BAR AREA SHOWING ANY SIGNS OF ABNORMSDR SWIA200110225Switch · defectiveFUEL LOW TEMPERATURE LIGHT CAME ON DURING TAXI. INSTALLED SERVICEABLE FUEL TEMPERATURE SWITCH ON LEFT ENGINE. CHECKS OK.SDR SWIA200110216Controller · failedCABIN PRESSURE PEGGED AT 2000 FPM, SWITCHED TO MANUAL; THAT HAD NO EFFECT ON PRESSURE. RETURNED TO SLC. REMOVED AND REPLACED CABIN PRESSURE CONTROLLER IAW 21-30-00. OPS CHECK GOOD.SDR SWIA200110172Transducer · malfunctionedABORTED TAKEOFF DUE TO ANTI-SKID LIGHT ON OVERHEAD. ANTI-SKID DISENGAGES (ON RIGHT SIDE) THROUGH 60 KTS ON TAKEOFF ROLL UNTIL AIRBORNE, THEN NORMAL IN AIR. UPON LANDING DISENGAGES UPON TOUCHDOWN THROUGH 20KTS, THEN NORMAL AT LOW SPEEDS.REMOVED AND REPLACED LSDR SWIA200110158Probe · inoperativeABORTED TAKEOFF IN COD DUE TO ERRATIC NP GAUGE. TAXIED BACK TO GATE AND OBTAINED SPECIAL FLIGHT PERMIT. FERRIED AIRCRAFT TO SLC.INSTALLED SERVICEABLE NP PROBE ON RIGHT ENGINE. P/N: 01R3033515 S/N OFF: CH17235.SDR SWIA200110116Rod End · wornABORTED TAKEOFF DUE TO RIGHT ENGINE TORQUE FLUCTUATIONS. DEFERRED PER MEL 73-21-1. TROUBLESHOT SYSTEM. FOUND A WORN ROD END ON THE RIGHT ENGINE PCU. REPLACED THE ROD END AND PERFORMED AN OPS CHECK OF ENGINE. ALL CHECKS GOOD.SDR SWIA200110082Relay · failedRIGHT ENGINE TORQUE LOSS AT 14,000 FEET. PERFORMED OPS CHECK OF EEC 14,000 FT SWITCH PER MM 73-23-01. NO DEFECTS NOTED. REMOVED AND REPLACED REVERSION RELAY. PERFORMED OPS CHECK GOOD IAW MM 73-23-00. P/N: M83536/6-022SDR SWIA200110010Battery Pack · dischargedMIDDLE EMERGENCY LIGHTS INOP. REMOVED AND REPLACED MIDDLE ELBP IAW 33-50-02. OPS CHECK GOOD.SDR SWIA200110011Fuse · blownEMERGENCY LIGHT STRIP IN AISLE INOP. REMOVED AND REPLACED FUSE. OPS CHECK GOOD.SDR SWIA972570Pressure Switch · faultyDURING EN ROUTE CLIMB THE RIGHT REAR ELECTRIC FUEL PUMP COULD NOT SUPPLY ENOUGH PRESSURE. THE RIGHT FORWARD PUMP WOULD CYCLE ON AND OFF. WITH THE FORWARD PUMP IN THE ON POSITION THE LOW PRESSURE LIGHT WENT OUT. REMOVED AND REPLACED RIGHT ENGINE LOW PRESSURESDR SWIA972457Controller · malfunctionedPRESSURIZATION SYSTEM UNABLE TO MAINTAIN THE CABIN ALTITUDE SELECTED. OPERATED AUTO PRESSURIZATION WITH TEST BOX, OPERATION NORMAL. NO LEAKS FOUND AT EXITS OR BOTH ECS PACKS ENTERING CABIN. COULD NOT DUPLICATE.SDR SWIA972222Autopilot Sys · malfunctionedAUTOPILOT AND TRIM ON THE MAP PANEL. FD COMMANDED PITCH DOWN. COMPUTER FLAG ON FOS SIDE. DC AFCS CIRCUIT BREAKER POPPED. ELECTRONIC ALARM IN THE HEAD SET. RETURNED TO SLC. RESET DC AFCS CIRCUIT BREAKER. PERFORMED OPS CHECK OF AUTOPILOT SYSTEM IAW MM 22-2SDR SWIA972051Circuit Breaker · failedNUMBER TWO PITOT HEAT CIRCUIT BREAKER POPPED INFLIGHT. RETURNED TO SLC. REMOVED AND REPLACED CIRCUIT BREAKER FOR NUMBER TWO PITOT HEAT. OPS CHECKS GOOD.SDR SWIA972049Wire · misinstalledNUMBER TWO PITOT STATIC HEATER CB POPPED. RESET ONCE AND POPPED AGAIN. RETURNED TO FIELD. FOUND THE WIRES FOR NUMBER TWO AND AUX PITOT HEAT TO BE REVERSED. INSTALLED WIRES TO CORRECT PITOT HEAD IAW MM 30-32-00 AND 30-33-00. INSTALLED A SERVICEABLE AUX PISDR SWIA971959Actuator · failedOUTBOARD FLAP DISAGREEMENT. COULD NOT FIX PER QRH. RETURNED TO SLC. REMOVED AND REPLACED LEFT OUTBOARD FLAP ACTUATOR IAW MM 27-50-09. OPS CHECKS AND LEAK CHECKS GOOD. RII 27-307. P/N ON: 343000-1003, S/N: 0330, S/N OFF: 0554.SDR SWIA971673Fuel Filter · malfunctionedON CLIMBOUT FROM SLC, LEFT FUEL FILTER LIGHT CAME ON. RETURNED TO FIELD. REPLACED LEFT ENGINE LOW AND HIGH PRESSURE FUEL FILTERS, RUN UP OPS CHECKS OK, AND LEAK CHECK OK.SDR SWIA971369Deice Light · illuminatedMIDDLE LEFT WING DEICE LIGHT ILLUMINATED FOLLOWED BY SEVERAL OTHER DEICE LIGHTS. RETURNED TO BFL. REPLACED AIR ON RIGHT ENGINE. PERFORMED OPS CHECK OF DEICE SYSTEM AND OPS CHECK GOOD AT THIS TIME.
Back to N308SW, cancelled Aug 30, 2018