N237SW, cancelled Dec 22, 2015
Service difficulty reports · 80
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 = 'N237SW' AND deregistration_id = 'N237SW-2015-12-22' 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 = 'N237SW' AND deregistration_id = 'N237SW-2015-12-22' 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 SWIA200412752Annunciator · malfunctionedON APPROACH AT 130 KIAS SELECTED FLAP 45, GOT FLAP LIGHT ON MAP WITH ASSOCIATED CONTROL FAULT FLAP WARNING INDICATION. FLAPS OPERATED NORMALLY ON GROUND. REPLACED FLAP ANNUNCIATOR WITH A SERVICEABLE UNIT. OP CHECK GOOD. S/N OFF: 0074.SDR SWIA200412746Computer · malfunctionedCAPTAIN'S AP FAILS IN FLIGHT. REMOVED AND REPLACED AUTOPILOT NR 1 COMPUTER WITH SERVICEABLE UNIT. OPS CHECK GOOD IAW MM 22-10-00.SDR SWIA200312720Handle · malfunctionedFLAPS DO NOT RESPOND TO FLAP HANDLE. FLAP 15 SELECTED. FLAPS REMAIN UP. REMOVED FLAP HANDLE AND INSTALLED A SERVICEABLE UNIT. OPS CHECKS GOOD.SDR SWIA200312695Ballast · failedGALLEY LIGHT AND COFFEE POTS WENT OUT/INOP AND SMOKE WAS SMELLED IN CABIN. FOUND GALLEY BALLAST TO BE BAD. REMOVED AND REPLACED BALLAST IAW MM 25-30-04. OPS CHECK GOOD.SDR SWIA200312650Terminal · damagedEXIT ROW 9 OVERHEAD BIN MOUNTED EMERGENCY EXIT LIGHT SIGN INOPERATIVE. REPAIRED WIRE TERMINAL IN OVERHEAD. OPS CHECKS OKAY.SDR SWIA200312599Actuator · malfunctionedGREEN HYDRAULIC SYSTEM LOST ALL FLUID AFTER LANDING. NOTICED ASSOCIATED ALARMS AND LIGHTS. REPLACED RIGHT OUTBOARD ACTUATOR IAW AMM 27-53-05. OPS AND LEAK CHECKED GOOD.SDR SWIA200312526Light · inoperativeONE OF TWO RED LIGHTS INOP AT FORWARD MAIN CABIN DOOR. REPLACED BULB AT INOP (RED) FORWARD FLOOR EMERGENCY LIGHTING STRIP. OPS CHECK GOOD.SDR SWIA200210901Seat Track · corrodedLEFT SIDE AFT SECTION OF SEAT RAIL NEEDS TO BE REPLACED DUE TO CORROSION. REMOVED AND REPLACED SEAT RAIL IAW MM 53-01-05.SDR SWIA200210900Roller · corrodedLEFT OUTBOARD FLAP OUTBOARD ROLLER HAS CORROSION PITTING. REMOVED AND REPLACED OUTBOARD FLAP ROLLER IAW MM 27-50-12.SDR SWIA200110386Actuator · out of adjLT MLG WOULD NOT RETRACT AFTER TAKEOFF. SYSTEM A&B LIGHTS INDICATED RED WITH GEAR HANDLE IN THE UP POSITION. RETURNED TO SMX. SHORTENED LEFT MAIN GEAR ACTUATOR ROD END 1/2 TURN. CYCLED GEAR MULTIPLE TIMES. OPS CHECKS GOOD.SDR SWIA972509Fairing · departedIN FLIGHT, FELT STRANGE VIBRATION FOR A FEW SECONDS. UPON CONDUCTING POST FLIGHT INSPECTION, FOUND A SECTION OF UPPER AILERON FAIRING MISSING. REMOVED DAMAGED LEFT AILERON UPPER FAIRING AND REPLACED WITH SERVICEABLE UNIT.SDR SWIA972299Probe · failedDURING TAKEOFF ROLL JUST AFTER TORQUE REACHED 80 PERCENT AND 100 PERCENT , FIRST OFFICER SAW TORQUE ON NR 1 (LEFT) ENGINE DROP. DIGITAL DROPPED TO 4 PERCENT AND ANALOG DROPPED TO 10 PERCENT BUT WAS FLUCTUATING. JUST AS TAKEOFF WAS ABORTED THE LEFT ENGINE LOSSDR SWIA972223Switch · out of adjCARGO DOOR LIGHT AND AURAL WARNING ON TAKEOFF. ABORTED TAKEOFF. (DEFERRED CARGO DOOR LIGHT.) ADJUSTED FORWARD CARGO DOOR MICROSWITCH. OPS CHECK GOOD. PLACARD REMOVED.SDR SWIA972047Pump · failedAFTER TAKEOFF, RIGHT ENGINE SURGING. TORQUE FLUCTUATION 10 - 15 PERCENT, NH FLUCTUATION. RETURNED TO SLC. REMOVED AND REPLACED THE HMU AND THE FUEL PUMP ON THE RIGHT ENGINE IAW EMB MM 73-21-00 AND RII 13-301. P/N ON: PUMP 3040627 HMU 786390-10, S/N ON: PUMSDR SWIA972005Actuator · failedAFTER TAKEOFF, LEFT MAIN LANDING GEAR RED LIGHT UNSAFE LIGHT WOULD NOT EXTINGUISH ASSOCIATED WITH CONTINOUS LOUD NOISE. WHEN LANDING GEAR HANDLE LOWERED OBSERVED GREEN GEAR SAFE INDICATION. REPLACED LEFT MLG ACTUATOR IAW MM 37-32-1. OPS AND LEAK CHECKS GOSDR SWIA971992Landing Gear · malfunctionedAFTER TAKEOFF, THE LEFT MAIN GEAR LIGHT REMAINED RED AND A VIBRATION WAS FELT IN THE AIR. RETURNED TO RDD. COULD NOT DUPLICATE PROBLEM. PERFORMED TEN GEAR SWING CYCLES. SYSTEM CHECKS OK.SDR SWIA971900Pcu · failedAFTER TAKEOFF TORQUE FLUCTUATED AS MUCH AS 15 PERCENT CONTINUOUSLY RIGHT ENGINE. RETURNED TO FIELD. REPLACED RIGHT ENGINE PCU IAW MM 61-21-00 AND CARD RII 61-304. OPS CHECKS GOOD. P/N ON: 782490-46, S/N ON: 910985, S/N OFF: 890661.SDR SWIA971850Light · inoperativeLEFT HAND FLOOR EMERGENCY LIGHTING HAS ONE LIGHT OUT. RE-INSTALLED LEFT HAND FLOOR EMERGENCY LIGHTING BULB IAW MM 3351001, OPS CHECK GOOD.SDR SWIA971112Actuator · failedDURING GEAR RETRACTION, AFTER GEAR UP LIGHTS ARE OUT MOMENTARILY, LEFT MAIN INTRANSIT LIGHT CAME BACK ON. CYCLED GEAR AND ALL STAYED OUT NORMAL. RETURNED TO SLC, REPLACED LEFT MLG ACTUATOR PER MM 32-32-10. CYCLED GEAR AND INDICATION AND OPERATION CHECKS GOOSDR SWIA971083Wire · brokenINFLIGHT LEFT INTAKE DE-ICE INOP AND MULTIPLE WING AND STAB DE-ICE LIGHTS INOP CAME ON. RECYCLED AND CHANGED TIMERS BUT ALL STILL INOP. RETURNED TO LAX. CLEANED ALL EJECTORS AND CHECKED FOR LEAKS. ALL FOUND NORMAL. REPLACED RIGHT ENGINE EJECTOR DUE TO BROSDR SWIA971050Retract Mech · out of adjustAT TAKEOFF ON GEAR RETRACTION, LEFT MAIN LANDING GEAR RED A AND B LIGHTS STAY ON. RECYCLED GEAR NO HELP. RETURNED TO SLC. FOUND UPLOCK HOOK/UPLOCK ACTUATOR CYLINDER ADJUSTMENT OFF. ADJUSTED ROLLER PER MM 32-32-09. OPS CHECKS GOOD.SDR SWIA971049Prox Sensor · failedAFTER DEPARTURE, RETRACTED GEAR, LEFT MAIN A AND B INDICATED RED GEAR NOT FULLY RETRACTED. RETURNED TO SLC. REMOVED AND REPLACED LANDING GEAR RELAY BOX AND REMOVED AND REPLACED LEFT MAIN LANDING GEAR UPLOCK A AND B PROXIMITY SENSOR PER MM 32-61-07. OPERATEDSDR SWIA971035Valve · failedAUTO AND MANUAL PRESSURIZATION INOP. RETURNED TO THE GATE IN SLC. REMOVED AND REPLACED ELECTRO/PNEUMATIC VALVE IAW MM 21-30-3. AUTO AND MANUAL PRESSURIZATION OPS CHECKS GOOD.SDR SWIA971013Strap · corrodedRIGHT SIDE BUTT STRAP IN AFT CABIN AREA CORRODED. REMOVED AND REPLACED RIGHT SIDE BUTT STRAP IN AFT CABIN AREA IAW SRM 51-40-02.SDR SWIA971012Crossbeam · corrodedFORWARD LAVATORY FLOOR CROSSBEAM CORRODED. REMOVED AND REPLACED FORWARD LAVATORY FLOOR CROSSBEAM IAW SRM 51-00-00.SDR SWIA971011Strap · corrodedCENTER BUTT STRAP IN AFT CABIN AREA CORRODED. REMOVED AND REPLACED CENTER BUTT STRAP IN AFT CABIN AREA IAW MM 51-00-00.SDR SWIA971010Strap · corrodedCENTER BUTT STRAP IN FORWARD CARGO CORRODED. REMOVED AND REPLACED CENTER BUTT STRAP IN FORWARD CARGO IAW SRM 51-00-00.SDR SWIA97842Uplock Cam · damagedAFTER DEPARTURE UPON BRINGING GEAR HANDLE TO UP POSITION, BOTH A AND B INTRANSIT LIGHTS ILLUMINATED FOR RT MAIN, ACCOMPANIED BY LOUD RUMBLE. RETURNED TO FIELD. FOUND GEAR UPLOCK CAMS AND FORWARD PART OF RIGHT GEAR DOORS TO BE IN POOR CONDITION AND BINDING. SDR SWIA97841Ahc 85 · malfunctionedFIRST OFFICER'S HSI OSCILLATES MORE THAN 60 DEGREES WITH HDG FLAG ANNUNCIATED. RMI ON CAPTAIN'S SIDE SIMULTANEOUSLY FLAGGED. RETURNED TO LAX. SWAPPED AHC 85 SIDE TO SIDE FOR TROUBLESHOOTING AND PROBLEM FOLLOWED. SWAPPED BACK AND REPLACED NR 2 AHC 85. REOSDR SWIA97832Pressure Switch · failedLEFT PROPELLER DE-ICE INOP LIGHT REMAINS ILLUMINATED WHEN SYSTEM IN USE IN BOTH TIMER 1 AND TIMER 2. RETURNED TO FIELD AFTER TAKEOFF. REMOVED AND REPLACED LEFT OIL PRESSURE SWITCH, OPS AND LEAKS CHECKS GOOD.
Back to N237SW, cancelled Dec 22, 2015