N576SW, cancelled Jul 20, 2015
Service difficulty reports · 101
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 = 'N576SW' AND deregistration_id = 'N576SW-2015-07-20' 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 = 'N576SW' AND deregistration_id = 'N576SW-2015-07-20' 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 SWIA201023733Frame · corrodedFLT 7769-2--MAIN CABIN DOOR FRAMES AND STRINGERS CORRODED. REPAIRED PER SRM.SDR SWIA201023794Stringer · corrodedSTRINGERS AND FITTINGS IN AREA OF MAIN CABIN DOOR CORRODED. (FLT 7769) REPAIRED PER SRM.SDR SWIA201023628Wire · looseOVERHEAD EMERGENCY EXIT LIGHT ABOVE SEAT 9BC INOP. (FLT 7756) SECURED LOOSE WIRE.SDR SWIA201023487Handle · lack of lubeFLT 5942 - MAIN CABIN DOOR HARD TO OPEN. LUBED HANDLE MECHANISM.SDR SWIA200923404Battery Pack · dischargedEMERGENCY LIGHTS AT MID FLOOR AND OVERWING EXITS INOP. (FLT 7771) REPLACED EMERGENCY LIGHTS BATTERY PACK.SDR SWIA200923335Socket · dirtyEMERGENCY LIGHT UNDER FORWARD RIGHT EMERGENCY EXIT INOP. (SVC CK) CLEANED SOCKET.SDR SWIA200923234Cap · looseMULTIPLE EMERGENCY LIGHTS INOP. (FLT 6202)RESECURED LOOSE FUSE CAP.SDR SWIA200923178Structure · crackedLEFT ENGINE NACELLE CRACKED. (C-CHECK) REPAIRED PER SRM.SDR SWIA200922968Bolt · out of adjustMAIN CABIN DOOR DIFFICULT TO CLOSE. (FLT 6574) ADJUSTED MAIN CABIN DOOR HINGE ECCENTRIC BOLTS.SDR SWIA200921363Sign · crackedFLT 6817 - EMERGENCY EXIT SIGN AT 9C CRACKED. REPLACED LIGHT ASSEMBLY.SDR SWIA200920897Light · burnedFLT 5785 - ELECTRICAL BURNING ODOR IN MID CABIN. REPLACED BURNED LIGHT ASSEMBLY AT ROW 5.SDR SWIA200820771Light · inoperativeFLT 7796 - ENTRY EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200821027Floor Support · corrodedC-CHECK, FLOOR SUPPORT WEB CORROSION REMOVAL BEYOND LIMITS PER SRM. REPLACED FLOOR SUPPORT WEB LEFT SIDE AT FS13056 -1573 PER SRM.SDR SWIA200821025Floor Support · corrodedC-CHECK, FLOOR SUPPORT WEB AT STATIONS 4410.5 - 6653 CORRODED BEYOND LIMITS. REPLACED WEB PER SRM.SDR SWIA200821024Connector · corrodedC-CHECK, J1 CONNECTOR OF NR 2 DPU CONNECTOR CORRODED. REPLACED CONNECTOR.SDR SWIA200821023Attach Fitting · crackedC-CHECK, RIGHT WING RIB NR 16 LOWER CLIP CRACKED. REPLACED PER SRM.SDR SWIA200821022Frame · crackedC-CHECK, FUSELAGE FRAME 10 CRACKED JUST BELOW LEFT DV WINDOW. REPAIRED PER SRM.SDR SWIA200821021Frame · crackedC-CHECK, LEFT INBOARD FRAME 10 WEB CRACKED, LEFT WHEEL WELL. REPAIRED PER SRM.SDR SWIA200819915Control Cable · stiffAILERON CONTROLS FEEL STIFF IN FLIGHT. (FLIGHT NR 5536) ADJUSTED LT AND RT AILERON TENSIONS IAW MM 27-00-00. OPS CHECK GOOD.
SDR SWIA200819679Beam · damagedFLT 3613 - DAMAGE TO KEELSON BEAM FOUND NEAR INBOARD SIDE OF GEAR AT NACELLE. REPLACED DAMAGED SECTION OF KEELSON BEAM IAW EMB SRM 51-40-02.SDR SWIA200819546Skin · damagedSKIN DAMAGE ON KEELBEAM AND NACELLE, COMPLIED WITH REPAIRS OF SKIN ON KEELBEAM AND NACELLE AS REQUIRED.SDR SWIA200819196Skin · delaminatedFLT 5543 - RIGHT PROPELLER TIP APPEARS TO BE DELAMINATED. REPLACED NR 1 BLADE ON RIGHT PROP WITH A SERVICEABLE UNIT IAW MM 61-11-01, P/N: RFC11M1-6A S/N OFF: 2172.
SDR SWIA200819141Mechanism · bindingPAX DOOR HANDLE WILL NOT LOCK AND STOW. LUBED HANDLE LOCKING MECHANISM, OPS CHECK GOOD.SDR SWIA200718945Torque Tube · corrodedFLT 3724 - CABIN DOOR IS DIFFICULT TO OPEN AND CLOSE. REPLACED CORRODED CABIN DOOR LOCKING TORQUE TUBE AND BUSHINGS IAW MM 52-1105. DOOR OPS CHECKS GOOD.
SDR SWIA200718866Oxygen Mask · unwanted deployFLT 5441 - OXYGEN MASKS DEPLOYED IN THE CABIN. RESTOWED ALL O2 MASKS.
SDR SWIA200718607Handle · bindingMAIN CABIN DOOR IS DIFFICULT TO OPEN, FLIGHT NR 5469. CLEANED AND LUBED DOOR HANDLE MECHANISM AND LINKAGE IAW EMB 120 MM 52-11-00.SDR SWIA200718614Battery Pack · dischargedFORWARD CABIN EMERGENCY LIGHTS DO NOT STAY ON, FLIGHT NR 5706. REPLACED FORWARD EMERGENCY BATTERY PACK IAW 33-50-02 EMB 120 MM.SDR SWIA200718533Skin · dentedFUSELAGE LOWER SECTION HAS A DENT AT STATION 18B AREA. APPLIED STRINGER REPAIR AT STRINGER 20L JUST FORWARD OF FRAME 19 PER SRM 53-00-03.SDR SWIA200718316Wire · disconnectedEMERGENCY EXIT SIGN OVER 6A IS INOPERATIVE. REPAIRED BROKEN WIRE BEHIND EMERGENCY LIGHT. OPS CHECKS GOOD.SDR SWIA200717986Actuator · malfunctionedAFTER TAKEOFF, NOSE GEAR WOULDN'T RETRACT. RETURNED TO FIELD. REPLACED NOSE GEAR ACTUATOR WITH SERVICEABLE IAW EMB 120 MM CH 37-32-11. OPERATIONAL CHECKS GOOD, PN 20605-000-05, SN/ON B51, SN/OFF 4S.SDR SWIA200616523Door · bindingMAIN CARGO DOOR HARD TO OPEN FROM INSIDE. ADJUSTED THE MAIN CABIN DOOR. OPERATIONAL CHECK GOOD.SDR SWIA200516017Battery Pack · inoperativeEMERGENCY LIGHTS REAR OF ROW 9 INOP. REPLACED AFT ELBP. OPERATIONAL CHECK GOOD IAW 24-10-05.SDR SWIA200515701Pump · leakingON DESCENT, GREEN SYSTEM MAIN PUMP LOW PRESSURE LIGHT ILLUMINATED AND ELECTRIC PUMP CYCLED ON AND OFF. HYDRAULIC QUANTITY WENT TO -0- AND FREE FALL ACCOMPLISHED. REPAIRED LEFT ENGINE HYD PUMP PRESSURE LINE, LEAK CHECK GOOD.SDR SWIA200515499Wire · brokenEXIT SIGN ABOVE SEAT 6A INOP. REPAIRED WIRE IAW WAM STANDARD PRACTICES 20-00-00. OPERATIONAL CHECK GOOD IAW AMM 23-50-00.SDR SWIA200515391Flap · crackedLEFT NACELLE FLAP IS IN THE DOWN POSITION ROUGHLY 10 DEGREES IN THE FLAPS 0 DEGREE SETTING. REPLACED LT NACELLE FLAP ASSY IAW MM 27-50-02.SDR SWIA200515396Terminal · looseROW 6A EMERGENCY EXIT ROW LIGHT DOES NOT ILLUMINATE. CONNECTED RING TERMINALS TO SIGN. OPERATIONAL CHECK GOOD.SDR SWIA200515412Frame · crackedRIGHT FRAME 1 OUTBOARD SIDE CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPLACED RIGHT FRAME NR 1 IAW SB 120-54-0036 "REV 02".SDR SWIA200413564Wire · brokenNO LIGHTS OR ALARMS SOUNDED DURING AILERON/ELEVATOR DISCONNECT OPERATION. REPAIRED TWO BROKEN WIRES WERE NEAR THE CONNECTOR AT THE ELEVATOR DISCONNECT. OPERATIONAL CHECK GOOD REFERENCING MM 27-13-01.SDR SWIA200412849Frame · crackedLEFT NACELLE INBOARD HALF FRAME UNDER TAILPIPE AFT MOUNT FRAME CRACK. DISCOVERED DURING C-CHECK INSPECTION. REPLACED NACELLE HALF FRAME IAW 120 SRM 51-10-02.SDR SWIA200412848Channel · crackedPAX DOOR MID SECTION OF DOOR AFT CHANNEL CRACKED. DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW CHANNEL TO PAX DOOR MID SECTION AFT AREA OF DOOR IAW SRM 120 51-10-02 PG 3 SEC 3A.SDR SWIA200412847Channel · crackedPAX DOOR MID SECTION OF DOOR FWD CHANNEL CRACKED. DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW CHANNEL TO PAX DOOR MID SECTION FORWARD AREA OF DOOR IAW SRM 120 51-10-02 PG 3 SEC 3A.SDR SWIA200412846Rib · crackedRT INBOARD LEADING EDGE I/B RIB IS CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPLACED AFFECTED CRACKED RIB AND INSTALLED NEW-LIKE UNIT IAW EMB120 SRM 51-10-02 PG 3 SEC 3A.SDR SWIA200312311Actuator · malfunctionedON CLIMBOUT NO RUDDER TRAVEL. RAN QRH, TURNED OFF BLUE SYSTEM, PROBLEM CEASED. REPLACED BLUE SYSTEM RUDDER ACTUATOR IAW EMB MM 27-21-00. OPS CHECKS AND LEAK CHECKS GOOD.SDR SWIA200210571Wire · chafedFLIGHT IDLE UNLOCK LIGHT ILLUMINATED ON TAKEOFF ROLL. ABORTED TAKEOFF. COULD NOT DUPLICATE DISCREPANCY. INSPECTED FLIGHT IDLE STOP WIRING AT LEFT ENGINE DECK. FOUND WIRE RUBBING ON ENGINE DECK. WIRE STILL SERVICEABLE AT THIS TIME. APPLIED ANTI-CHAFE AT RSDR SWIA972574Latch · failedRIGHT SIDE FORWARD, OUTBOARD, GEAR DOOR WON''T RETRACT. RETURNED TO PDX. REPLACED LATCH ASSEMBLY ON RIGHT FORWARD OUTBOARD GEAR DOOR PER MM 32-32-00 AND MM 52-81-01. OPS CHECK GOOD.SDR SWIA972459Control Panel · malfunctionedBOTH CAPTAINS AND FIRST OFFICER''S YAW DAMPER FAILED TO ENGAGE. TRIM FAIL LIGHT ILLUMINATED (RED TRIM FAIL LIGHT ON MAP). BURNING SMELL IN COCKPIT. EN ROUTE FRESNO, DIVERTED TO BURBANK AIRPORT. DETERMINED AUTOPILOT CONTROL PANEL SOURCE OF BURNING SMELL. RSDR SWIA972369Indicator · failedON TAKEOFF AT 80 KTS, HIGH SPEED AURAL SOUNDED. ABORTED TAKEOFF. REMOVED AND REPLACED FIRST OFFICERS HIGH SPEED INDICATOR WITH SERVICEABLE. PERFORMED OPS CHECK WITH PITOT STATIC BOX. OPS CHECK GOOD. LEAK CHECK GOOD IAW MM 34-12-01. (S/N ON: 1795) (S/N OSDR SWIA971844Structure · damagedON CLIMBOUT THE FLAPS CONTROL FAULT CAME ON INBOARD PAIR, WOULD NOT RESET. INSPECTED FLAP ASSEMBLY, FOUND RIGHT INBOARD BOND SHOE MANGLED AND APPEARED TO HAVE BEEN STUCK IN TRACK. REPLACED BOND SHOE ASSEMBLY IAW 201321 AND 275000. CYCLED FLAPS, OPS CHECK GOSDR SWIA971589Switch · out of adjustTHE CARGO DOOR LIGHT CAME ON DURING FLIGHT. RETURNED TO LAX. ADJUSTED CARGO DOOR MICROSWITCH ROCKER ARM TONGUE IAW 52-72-02. OPS CHECKS GOOD. RESET CARGO DOOR WARNING CB.SDR SWIA971329Warning · activatedRIGHT DUCT LEAK WARNING OCCURRED DURING TAKEOFF. RETURNED TO AIRPORT MEL 75-32-2. OPS CHECKS GOOD WITH NO DEFECTS NOTED.
Back to N576SW, cancelled Jul 20, 2015