N236SW, cancelled Jun 12, 2019
Service difficulty reports · 96
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 = 'N236SW' AND deregistration_id = 'N236SW-2019-06-12' 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 = 'N236SW' AND deregistration_id = 'N236SW-2019-06-12' 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 SWIA200616962Unknown · smokeAPU BLEED CAUSING SMOKE IN THE CABIN. INSPECTED BLEED AIR DUCT ON APU. UNABLE TO DUPLICATE DISCREPANCY. OPERATIONAL CHECKS GOOD.SDR SWIA200616627Battery · dischargedEMERGENCY EXIT LIGHTS AT ROW 9 EXIT INOP. REPLACED AFT EMERGENCY BATTERY ASSY. OPERATIONAL CHECK GOOD.SDR SWIA200616606Smoke Detector · malfunctionedLAV SMOKE DETECTOR SOUNDS INTERMITTENTLY. REPLACED FAULTY DETECTOR. OPERATIONAL CHECK GOOD.SDR SWIA200616447Battery · dischargedSMOKE DET IN LAV SOUNDS CONTINIOUSLY. REPLACED BATTERY IN LAV. OPERATIONAL CHECK GOOD.SDR SWIA200616446Smoke Detector · malfunctionedLAV SMOKE DETECTOR GOES OFF. REPLACED DETECTOR. OPERATIONAL CHECK GOOD.SDR SWIA200616387Windshield · crackedFO WINDSHIELD CRACKED RIGHT SIDE. REPLACED RIGHT WINDSHIELD IAW 56-10-01, PN NP-151311-2 SN OFF 96026H2228.SDR SWIA200515590Actuator · inoperativeON TAKEOFF, RUDDER JAMMED. REPLACED RUDDER BLUE SYSTEM ACTUATOR IAW MM 27-22-00. OPERATIONAL CHECK GOOD.SDR SWIA200515439Servo · bindingROUGHNESS IN CONTROL YOKE WHEN MOVING AILERONS FROM CENTER TO THE LT. REPLACED AILERON AUTO-PILOT SERVO IAW 22-10-05. OPERATIONAL CHECK GOOD.SDR SWIA200515263Smoke · detectedLAV SMOKE DETECTOR WENT OFF IN FLIGHT, F/A NOTICED SMOKEY ODOR. INSPECTED LAVATORY AND GALLEY LIGHT ASSYS. NO DEFECTS NOTED. ALSO INSPECTED CARGO AREA. NO PROBLEMS FOUND. NO SMOKE ODOR FOUND PRESENT.SDR SWIA200514963Bulb · burned outROW 9 EMERGENCY LIGHT BULB IS INOPERATIVE. REPLACED BULB AT ROW 9, FORWARD RED, EMERGENCY LIGHT AT FLOOR TRACK. OPERATIONAL CHECK GOOD.SDR SWIA200514755Smoke · detectedF/A REPORTED LIGHT SMOKE AND BURNING SMELL DURING DESCENT IN BOTH AUTO & LOW. RAN RIGHT AND LEFT PACKS ON GROUND FROM APU BLEED. NO SMOKE NOTED AT THIS TIME.SDR SWIA200514656Acm · smokeON DESCENT, WITH BLEED AND PACKS SELECTED ON AUTO AND LOW, RIGHT PACK FAIL INDICATION, SLIGHT SMELL OF SMOKE IN FLIGHT DECK AND CABIN. REMOVED AND REPLACED RIGHT ACM IAW EMB 120 MM 21-50-05, OPERATIONAL CHECK GOOD.SDR SWIA200514436Door · lack of lubeMAIN CABIN DOOR VERY DIFFICULT TO OPEN. LUBRICATED MAIN DOOR.SDR SWIA200414316Light · looseONE EMERGENCY LIGHT ROW 9 CAME LOOSE. REPLACED DAMAGED RED EMERGENCY FLOOR LAMP IN ROW 9 IAW 33-50-00. OPERATIONAL CHECK GOOD.SDR SWIA200414155Headset · smokeF/A REPORTS SMOKE COMING FROM INTERPHONE IN AFT GALLEY. REPLACED AFT ATTENDANT HEADSET IAW MM 23-41-01. OPERATIONAL CHECK GOOD.SDR SWIA200414071Light · smokeMIDDLE STORM LIGHT SMOKES AT THE LEADS WHEN OPERATED. REPLACED MIDDLE STORM LIGHT IAW 33-21-02, OPERATIONAL CHECK GOOD. P/N 10-21C22-513, S/N OFF 151.SDR SWIA200413943Ballast · smokeDURING PASSENGER DEPLANING, MOMENTARILY SMELLED SMOKE AND NOTICED C/B A30 POPPED. REPLACED LAV LIGHT BALLAST AND RESET BREAKER A30, OPERATIONAL CHECK GOOD.SDR SWIA200413634Stringer · crackedLEFT NACELLE EXHAUST CRADLE STRINGER CRACKED INBOARD SIDE. ITEM FOUND AT C-CHECK. REPLACED LEFT HAND NACELLE EXHAUST CRADLE STRINGER INBOARD SIDE PER SRM 51-40-00.SDR SWIA200413545Indicator · failedBUZZING SOUND AND SMOKE FROM LEFT SIDE INSTRUMENT PANEL. PULLED CIRCUIT BREAKER ON RADIO ALTIMETER, NOISE STOPPED. REPLACED RADIO ALTIMETER WITH SERVICEABLE UNIT. OPERATIONAL CHECK GOOD.SDR SWIA200413253Warning System · malfunctionedDURING TAXI-IN, RECEIVED SPORADIC TRIPLE CHIME TAKEOFF TRIM WITH TRIM IN GREEN BAND. PERFORMED TEST AFTER SHUT DOWN AND DID NOT PASS. RERACKED AURAL WARNING UNIT AND RESET AURAL WARNING CB. OPS CHECKS GOOD.SDR SWIA200412933Wire · brokenNO STICK SHAKER RIGHT SIDE. REPAIRED BROKEN WIRE. OP CHECK OK.SDR SWIA200312612Shaft · damagedTRIED TO MOVE YOKE TO THE LT AND IT WAS BOUND UP AND WOULD NOT GO TO THE LT. REPLACED BELLCRANK SHAFT IAW MM 31-30-10. OPS CHECK GOOD.SDR SWIA200312034Actuator · malfunctionedRIGHT RUDDER LIMITED TO APPROXIMATELY 1/3 OF FULL TRAVEL DURING INITIAL CLIMB. RUDDER WORKS CORRECTLY WITH BLUE SYSTEM SWITCH TURNED OFF. REMOVED AND REPLACED BLUE SYSTEM RUDDER ACTUATOR IAW EMB 120 MM 27-22-02. OPS CHECK GOOD IAW EMB MM 27-20-00. NO DEFECSDR SWIA200311953Seal · contaminatedAIRCRAFT DID NOT PRESSURIZE ON TAKEOFF. TRIED BOTH AUTO AND MANUAL. RETURNED TO SLC. CLEANED DEBRIS FROM THE SEAL AROUND THE LEFT OVERWING EXIT. PRESSURIZED THE AIRCRAFT. BOTH AUTO AND MANUAL PRESSURE CHECKS GOOD.SDR SWIA200311917Controller · malfunctionedPAX 02 MASKS DEPLOYED IN FLIGHT CLIMBING THROUGH 8,000 FEET. NOTICED DELTA-P WAS AT 7,000 FT AND THE CABIN WAS LESS THAN ZERO. REMOVED AND REPLACED ALTITUDE CONTROLLER IAW MM 21-30-01. OPS CHECK GOOD, NO DEFECTS NOTED.SDR SWIA200311897Actuator · leakingUPON DEPLOYING FLAPS 15 DEGREES, FLAPS DISAGREEMENT LIGHT CAME ON, FOLLOWED BY LOW LEVEL LIGHT FOR RT/BLUE HYDRAULIC PUMP, LOW PRESS, MAIN PUMP LOW PRESS AND ELECTRIC PUMP LIGHT. UPON POSTFLIGHT, FOUND SIGNIFICANT FLUID LEAK. REMOVED AND REPLACED RIGHT NACSDR SWIA200311884Battery · malfunctionedEMERGENCY LIGHTS EXIT LIGHT ARE INOP ABOVE 5C AND 5A. REMOVED AND REPLACED NR 2 MID EMERGENCY LIGHT BATTERY PACK IAW MM 33-50-02. OPS CHECK GOOD.SDR SWIA200211370Light · smokeCAPTAIN'S FLOODLIGHT SMOKES WHEN THE LIGHT IS ON. REPLACED CAPTAIN'S FLOODLIGHT FIXTURE WITH SERVICEABLE UNIT.SDR SWIA200211315Wire · missingFORWARD EMERGENCY LIGHT EXIT SIGN DOES NOT ILLUMINATE. FOUND WIRE MISSING FROM REAR TERMINAL BLOCK. REINSTALLED WIRE FOR FORWARD EMERGENCY LIGHT WITH NEW HARDWARE. COMPLIED WITH OPS CHECK OF LIGHT AND FOUND OK.SDR SWIA200210838Proximity Sensor · faultyDURING TAKEOFF, TRIM AURAL WARNING SOUNDED. TAKEOFF WAS ABORTED. TRIM SETTING WAS 34. EVEN WITH TRIM IN MIDDLE OF GREEN BAND, AURAL WARNING SOUNDED. REMOVED AND REPLACED BOTH RIGHT AND LEFT ELEVATOR TRIM TAB PROX SENSORS. OPS CHECKS GOOD.SDR SWIA200210857Butt Strap · corrodedRIGHT SIDE BUTT STRAP A BEAM LAV HAS DEEP PITTING AND INTERGRANULAR CORROSION. REMOVED AND REPLACED RIGHT SIDE BUTT STRAP IAW SRM 51-40-02.SDR SWIA200210856Crossbeam · corrodedBOTH CENTER CROSS BEAMS ADJACENT TO CENTER OMEGA BEAM AT LAV AREA HAVE DEEP PITTING AND INTERGRANULAR CORROSION. REMOVED AND REPLACED BOTH CENTER CROSS BEAMS IAW SRM 51-40-02.SDR SWIA200210855Butt Strap · corrodedCENTER BUTT STRAPS A BEAM LAV HAVE DEEP PITTING AND INTERGRANULAR CORROSION. REMOVED AND REPLACED (2) CENTER BUTT STRAPS IAW SRM 51-40-02.SDR SWIA200210854Floorbeam · corrodedCENTER OMEGA BEAM AT BUTT STRAP SPLICE A BEAM LAV HAS VISIBLE CORROSION EXTENDING MORE THAN 10 PERCENT INTO MATERIAL. REMOVED AND REPLACED THE CENTER OMEGA BEAM IAW SRM 51-40-02.SDR SWIA200210853Seat Track · corrodedRIGHT SIDE SEAT TRACK IN FORWARD CABIN AREA HAS CORROSION AROUND SEVERAL SCREWS. REMOVED AND REPLACED RIGHT SIDE FORWARD FLOOR SEAT TRACK IAW 53-01-05.SDR SWIA200110480Smoke · detectedDUE TO REPORT OF SMOKE IN THE LAV AREA AND SMOKE DETECTOR GOING OFF CONTINUOUSLY FOR THREE MINUTES INFLIGHT, INSPECT CABIN FOR SOURCE OF SMOKE AND CORRECT ANY DISCREPANCIES. LAV SMOKE DETECTOR ALARM SOUNDED DURING CRUISE. F/A AND PAX SMELLED SMOKE. ALARM SSDR SWIA972562Relay · odorSTRONG ELECTRICAL SMELL COMING FROM UNDERNEATH FIRST OFFICERS SHELF. THE SHELF IS ALSO VERY HOT. FOUND AP FEEDER PROTECTION RELAY WARM. REPLACED APU FEEDER PROTECTION RELAY. OPS CHECK OF APU AND GENERATOR GOOD.SDR SWIA971973Warning System · activatedFIRST OFFICER''S TRIM FAIL WARNING ANNUNCIATED DURING TAKEOFF. TAKEOFF ABORTED. AUTO PILOT RED MAP LIGHT ANNUNCIATED AS WELL. REPLACED F/O''S APC-65B WITH SERVICEABLE UNIT. OPS CHECKS GOOD ON GROUND. (P/N 622-8315-402), (S/N 32445) ON, (S/N 2947) OFF.SDR SWIA971923Control Box · malfunctionedON APPROACH, PUT GEAR DOWN, LEFT DISPLAYED RED LIGHTS ONLY. NOSE AND RIGHT DISPLAYED NO RED OR GREEN LIGHTS. GEAR MADE A LOUD RACKET AND VIBRATION. RECYCLED GEAR UP AND BACK DOWN. GEAR EXTENDED NORMALLY WITH 6 GREEN LIGHTS. REPLACED LANDING GEAR CONTROL BSDR SWIA971715Generator · failedAUXILLARY GENERATORS NUMBER ONE AND NUMBER TWO BOTH FAILED IN FLIGHT, WOULD NOT RESET. RETURNED TO LAX. RAN ENGINES, FOUND RIGHT AUXILLARY GENERATOR WORKING NORMAL.SDR SWIA971556Inverter · failedDUAL INVERTER FAILURE. RETURNED TO PSP. REMOVED AND REPLACED NUMBER 1 AND NUMBER 2 INVERTERS. OPS CHECKS GOOD AT THIS TIME.SDR SWIA971005Uplock Hook · out of adjustWHEN LANDING GEAR IS RETRACTED THE GEAR COMES UP AND THE DOORS CLOSE BUT THE LEFT MAIN GEAR UNSAFE LIGHT STAYS ILLUMINATED. RETRACTED LANDING GEAR AND CHECKED CLEARANCE OF ROLLER AND UPLOCK HOOK. ADJUSTED CLEARANCE IAW MM 32-61-01. LANDING GEAR OPS CHECKS GSDR SWIA97995Strap · corrodedRT FLOOR BUTT STRAP IN GALLEY/LAVATORY AREA HAS CORROSION. REPLACED BUTT STRAP WITH NEW ASSEMBLY AS REQUIRED PER SRM.SDR SWIA97994Strap · corrodedCENTER FLOOR BUTT STRAP IN GALLEY/LAVATORY AREA HAS CORROSION. REPLACED BUTT STRAP WITH NEW ASSEMBLY AS REQUIRED PER SRM.SDR SWIA97823Warning Light · illuminatedON TAKEOFF ROLL, LEFT EEC FAILURE WARNING ILLUMINATED AND AURAL WARNING SOUNDED. WITH CONDITION LEVERS IN MININUM, LEFT RPM WAS 90 PERCENT UNTIL THE EEC WAS TURNED OFF, THEN LEFT RPM WAS NORMAL. ABORTED TAKEOFF. MEL 23-21-1. TROUBLESHOT SYSTEM. OHMED WIRESDR SWIA95783Pcu · malfunctionedON CLIMBOUT, RT TORQUE GAUGE FLUCTUATES 80 PERCENT TO 105 PERCENT BOTH IN DIGITAL AND ANALOG WITH EEC'S IN MANUAL. REMOVED AND REPLACED RT ENGINE PCU. ALL GROUND RUNS AND LEAKS CHECKS IAW MM 61-00-00.
Back to N236SW, cancelled Jun 12, 2019