N682SW, cancelled May 6, 2015
Service difficulty reports · 361
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 = 'N682SW' AND deregistration_id = 'N682SW-2015-05-06' 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 = 'N682SW' AND deregistration_id = 'N682SW-2015-05-06' 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 SWAA013326Indicator · failedAIR TURNBACK, AFTER T/O TRAILING EDGE FLAPS WOULD NOT RETRACT BEYOND ABOUT 2 DEG. FLAPS WERE LOWERED USING ALT FLAPS. REMOVED AND REPLACED TRAILING EDGE FLAP POSITION INDICATOR PER MM.SDR SWAA013129Battery · dischargedDURING SCHEDULED PM CHECK, FOUND BOTH FWD ENTRY AND FWD SVC DOOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA013026Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND LT & RT SIDE CHORDS CRACKED AT BS 178, WL 207. REPAIRED CHORDS PER SWA ACO 7342-53.SDR SWAA013020Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND ( 2 EA ) VERTICAL BEAM WEBS CRACKED AT BS 178, WL 227 & WL 232, LBL 17.1 & RBL 17.1. R&R WEBS PER SRM.SDR SWAA013019Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED ( 8 EA ) AT BS 178. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA012528Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY AND SVC DOORS EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA012280Lens · missingDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT LENS MISSING AT ROW 9 DEF. INSTALLED LENS PER MM.SDR SWAA012254Tab · wornDURING SCHEDULED C2 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR TAB PER MM.SDR SWAA012246Light · brokenDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED EXIT LIGHT ASSY PER MM.SDR SWAA012245Girt Bar · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA011984Shutoff Valve · failedDECLARED EMERGENCY AFTER APPROX 20 MIN AT FL 350, CABIN WARNING HORN SOUNDED, CABIN ALTITUDE WAS AT 11,000 FT AND CLIMBING. INITIATED DESCENT. CABIN ALTITUDE CONTINUED TO CLIMB TO APPROX 20,000 FT. PASSENGER OXYGEN MASKS DEPLOYED. ON DESCENT NOTICED RIGHT SDR SWAA011689Retainer · looseFED ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA011617Bushing · wornVIBRATION FELT ABOVE 250 KTS IN REAR OF AIRCRAFT, NOT ENG RELATED. Removed and replaced Rt ELEVATOR TAB BUSHING. REPAIRED ELEVATOR TAB PER MM.SDR SWAA011336Retainer · looseDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA011218Lens · brokenBULLNOSE EMERGENCY EXIT LIGHT LENS BROKEN AT ROW 9 DEF. R&R LENS PER MM.SDR SWAA011070Duct · rupturedDIVERTED, UNABLE TO MAINTAIN CABIN PRESSURE. FOUND CLAMP LOOSE ON LT WATER SEPERATOR & MUFFLER/DUCT ASSY RUPTURED IN FWD CARGO BAY, BEHIND AFT WALL. SECURED CLAMP AND R&R DUCT ASSY PER MM. OPS CHECK NORMAL PER MM.SDR SWAA010330Battery Pack · dischargedDURING SCHEDULED RON CHECK, FOUND EEPLS INOP AT FWD HALF OF CABIN. REMOVED AND REPLACED FWD EEPLS BATTERY PACK PER MM.SDR SWAA002258Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP IN AFT CABIN. REMOVED AND REPLACED AFT BATTERY PACK AND CHARGER PER MM.SDR SWAA001822Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP 11 - 23. REMOVED AND REPLACED AFT POWER PACK AND BATTERY (P/N 65C27095).SDR SWAA001770Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP AT ROWS 11D TO 23D. REMOVED AND REPLACED EEPLS BATTERY PACK PER MM.SDR SWAA992149Actuator · inoperativeAIR TURNBACK, NR 3 KRUGER FLAP WOULD NOT FULLY RETRACT, TRANSIT LIGHT ILLUMINATED. REMOVED AND REPLACED NR 3 KRUGER FLAP ACTUATOR.SDR SWAA992016Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD EMERGENCY AISLE EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY AND CHARGER PER MM.SDR SWAA991935Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 304 FRAME CRACKED, STRINGER 4L. REPAIRED FRAME PER SRM.SDR SWAA991923Brackets · corrosionDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY AND SERVICE DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER MM.SDR SWAA991918Beam · corrosionDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON FLOORBEAM UPPER SURFACE, BS 344. REMOVED AND REPLACED UPPER T-CAP FROM RBL 38 TO LBL 67 PER SRM.SDR SWAA991896Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND PRESS WEB CRACKED, BS 663, LBL 32. REPAIRED WEB PER TI-353-046.SDR SWAA991895Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM BS 312, LBL 1- RBL 21. REPAIRED BEAM PER TYPICAL REPAIR NR TI-353-007.SDR SWAA991884Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD HAS 3 EACH CRACKS, LBL 5- RBL 7. REPAIRED BULKHEAD PER SRM.SDR SWAA991876Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 5. REPAIRED BULKHEAD PER SRM.SDR SWAA991001Sensor · inoperativeAIR DIVERTION-- AT CRUISE ALTITUDE LT MAIN LANDING GEAR RED UNSAFE LIGHT ILLUMINATED AND REMAINED LIT UNTIL THE GEAR WAS LOWERED. REMOVED AND REPLACED LT MAIN GEAR UPLOCK SENSOR AND LOGIC CARD.SDR 99ZZZX2064Housing · crackedHOUSING ASSY IS CRACKED AT RETAINER NUT BOSS JUST BELOW THREADS RUNNING HALF WAY AROUND CIRCUMFERENCE OF BORE. POSSIBLE CAUSE, EXCESSIVE STRESS, FORCE AND/OR PRESSURE. RE: SOUTHWEST A/L, OPER CONTROL NR 0270131-63R.SDR SWAA990488Light · inoperativeDURING SCHEDULED BC1 CHECK, FOUND FWD EMERGENCY LIGHT INOP AT R2 DOOR. REMOVED AND REPLACED EGRESS LIGHTING BATTERY PER MM.SDR SWAA980410Csd Seal · leakingDIVERTED TO MSY DUE TO INFLT SHUTDOWN OF NR 1 ENGINE, WHEN OIL PRESSURE DROPPED BELOW RED LINE, DUE TO CSD CARBON SEAL LEAKING. LANDED WITHOUT INCIDENT. REMOVED THE CSD FOR ENGINEERING EVALUATION OF THE GEARBOX. REPLACED NR 1 ENGINE CSD GARLOC SEAL AND RETASDR SWAA971073Skin · crackedDURING SCHEDULED BC4 CHECK, FOUND AFT ENTRY DOOR LOWER FWD CORNER CRACKED FROM EDGE UNDER BEARSTRAP. REPAIRED PER SWA RA 1-A57-1744.SDR SWAA970725Frame · crackedDURING SCHEDULED 1/4 D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, LBL1. REPAIRED PER BOEING SRM.SDR SWAA970589Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY AND FWD SERVICE DOORS LOWER EMERGENCY EXIT LIGHTS INOP. REPLACED BATTERY CHARGER PER BOEING M/M.SDR SWAA970365Window · crackedIN FLIGHT, F/O'S NUMBER 1 WINDOW CRACKED, OBSTRUCTING HIS VIEW. AIRCRAFT RETURNED TO LAS AND MADE AN UNEVENTFUL LANDING. REPLACED WINDOW PER BOEING M/M.SDR SWAA961330Supply · inoperativeDURING SCHEDULED RON CHECK, FOUND FWD ENTRY EMERGENCY LIGHTING INOP. REPLACED BATTERY POWER SUPPLY AND OP CHECKED PER BOEING M/M.SDR SWAA960468Skin · crackedDURING SCHEDULED BC1 CHECK, FOUND A .5 INCH CRACK AT COOLING DUCT CUTOUT SKIN AFT END. REPAIRED PER BOEING SRM.SDR SWAA960429Charger · inoperativeDURING SCHEDULED A1 CHECK, FOUND FWD TRACK LIGHTING INOP. REPLACED BATTERY CHARGER PER BOEING M/M.SDR SWAA960358Door Frame · crackedDURING SCHEDULED B/C1 CHECK, FOUND FWD CARGO DOOR FRAME CRACKED AT UPLOCK HOOK. REPAIRED PER TI NR T1-A52-003.SDR SWAA960486Charger · inopDURING SCHEDULED SERVICE CHECK, FOUND FORWARD DOOR LOWER EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK CHARGER PER BOEING M/M.SDR SWAA95285Skin · lightning strikeDURING SCHEDULED D-CHECK, FOUND LIGHTNING STRIKE DAMAGE TO FUSELAGE SKIN AT BS 500A PLUS 8, BETWEEN S21 AND 22L, AT BS 500, BETWEEN 23 AND 24L, AND AT BS 460, BETWEEN S23 AND 24L. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95284Door Skin · crackedDURING SCHEDULED D-CHECK, FOUND FORWARD GALLEY DOOR LOWER HINGE CUTOUT CRACKED 2 PLACES. REPAIRED PER SWA ACO 3189-52.SDR SWAA95283Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 1 TO RBL7, WL 208. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95282Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 294, LBL 18.5 TO 23.5, WL 208. REPAIRED PER TRAMCO EWO 95-0231 AND BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95281Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT UPPER FLANGE, BS 947, BL 0 TO LBL 10. REPAIRED PER TRAMCO EWO 95-0231 AND BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95280Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND FORWARD UPPER FRAME OF AFT ENTRY DOOR CRACKED. REPLACED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95279Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME AT BS 294, CRACKED AT RBL 54, WL 208. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA95278Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND AFT SERVICE DOOR UPPER FRAME CRACKED. REPLACED PER BOEING STRUCTURAL REPAIR MANUAL.
Back to N682SW, cancelled May 6, 2015