N692SW, cancelled Sep 7, 2017
Service difficulty reports · 434
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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 SWAA010997Cover · looseDURING SCHEDULED C2 CHECK, FOUND EEPLS TRACK COVER LOOSE AT AFT SECTION. SECURED TRACK COVER PER MM.SDR SWAA002727Connector · inoperativeAIR TURNBACK, L1 WINDOW HEAT WENT INOP. RETURNED TO OAK PER DISPATCH REQUEST. R&R WINDOW HEAT CONTROLLER & FOUND CANNON PLUG D4640 LOOSE. RECONNECTED AND OPS CHECK GOOD PER MM.SDR SWAA002687Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002520Skin · corrodedDURING SCHEDULED SERVICE CHECK, FOUND EXTERNAL FUSELAGE SKIN BULGED AFT OF E&E DOOR (APPROX BS 360), RBL 4 TO LBL 12. REPAIRED SKIN PER SRM.SDR SWAA001438Indicator · erraticAIR TURNBACK, NR 1 ENG OIL TEMP INDICATED 165 DEGS. ATTEMPTED TO REDUCE TEMP BY REDUCING POWER, NO EFFECT. DURING DESCENT OIL TEMP INDICATION BECAME ERRATIC, THEN STABILIZING TO 120 DEG. REMOVED AND REPLACED NR 1 ENG OIL TEMP IND AND OIL TEMP BULB PER MM.SDR SWAA991799Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 747, BETWEEN STRINGERS 22R-23R. REPAIRED SKIN PER SRM.SDR SWAA991469Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR LOWER HINGE CUT OUT FUSELAGE SKIN CRACKED. REPAIRED SKIN PER ER NR 99-5992.SDR SWAA991468Keel Beam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND KEEL BEAM CORRODED ON RT LOWER CHORD. REMOVED AND REPLACED KEEL BEAM RT LOWER CHORD FROM BS 500D TO 727 PER SRM.SDR SWAA991467Keel Beam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND KEEL BEAM STRESS PANEL CORRODED BETWEEN BS 610 TO BS 630. REMOVED AND REPLACED PANEL PER ER 99-6004.SDR SWAA991454Splice · crackedDURING SCHEDULED 1/4D CHECK, FOUND KEEL BEAM INBD TEE SPLICES CRACKED, BS 727, BOTH LT AND RT SIDES. REMOVED AND REPLACED TEE SPLICES PER SRM.SDR SWAA991453Angle · corrosionDURING SCHEDULED 1/4D CHECK, FOUND KEEL BEAM SUPPORT ANGLE CORRODED, BS 727, LBL 8. REMOVED AND REPLACED SUPPORT ANGLE PER SRM.SDR SWAA991427Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 520 SHEAR TIE CRACKED, STRINGER 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA990889Stop · wornDURING SCHEDULED C3 CHECK, FOUND SEVERAL WORN STOPS AT RT EMERGENCY OVERWING EXIT HATCH. REMOVED AND REPLACED STOPS PER MM.SDR SWAA990280Bulb · failedDURING SCHEDULED SC CHECK, FOUND (EMERGENCY EXIT ROW) ONE EMERGENCY LIGHT INOP FLOOR TRACK LIGHTING. RELAMPED PER MM.SDR SWAA990276Light · inopDURING SCHEDULED SC CHECK, FOUND (EMERGENCY EXIT ROW) ONE EMERGENCY FLOOR TRACK LIGHT INOP. RELAMPED FLOOR TRACK LIGHT PER M/M.SDR SWAA982100Sensor · failedAIRCRAFT EN ROUTE FROM TPA TO ABQ DIVERTED DUE TO RIGHT LANDING GEAR RED LIGHT FLICKERS ON AND OFF CRUISE. THREE GREEN LIGHTS FOR LANDING. AIRCRAFT MADE AN UNEVENTFUL LANDING. REMOVED AND REPLACED RT MAIN LANDING GEAR UPLOCK SENSOR. GEAR SWUNG. OPS CHECK GSDR SWAA980988Skin · dentedDURING SCHEDULED BC 3 CHECK, FOUND LT HORIZ STAB HAS A DENT 4 FT FROM FUSELAGE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980386Skin · puncturedDURING WALKAROUND CHECK, FOUND A SKIN PUNCTURE AND 7 CREASE AT BS 870 BETWEEN STRINGERS 25 AND 26. REPAIRED PER BOEING SRM.SDR SWAA980211Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT LOWER AFT R1 DOOR CUTOUT. REPAIRED PER BOEING SRM.SDR SWAA980134Battery Pack · dischargedDURING SCHEDULED RON CHECK, FOUND FWD EGRESS LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER BOEING MM.SDR SWAA971008Battery · dischargedDURING RON CHECK, FOUND EMERGENCY EXIT LIGHTS INOP AT FWD SERVICE DOOR AND AFT BULLNOSE. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA980042Tat Probe · inoperativeDIVERTED TO PHX, DUE TO TAT PROBE HEAT INOP. REMOVED AND REPLACED TAT PROBE AND OP CHECKED PER BOEING M/M.SDR SWAA970635Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORROSION AROUND NUTPLATES AT BS 727-947, RBL 3 AND 8. REPLACED FLOORBEAM SECTION PER BOEING SRM.SDR SWAA970578Skin · gougedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 817, RBL 26. REPAIRED PER BOEING SRM.SDR SWAA970577Skin · crackedDURING SCHEDULED D-CHECK, FOUND AFT ENTRY DOOR AND AFT SERVICE DOORS UPPER HINGE CUTOUTS CRACKED. REPAIRED PER BOEING SRM.SDR SWAA970575Skin · crackedDURING SCHEDULED BC3 CHECK, FOUND AFT SERVICE DOOR LOWER HINGE OPENING, LOWER FWD CORNER CRACKED EXTENDING FROM OPENING TO UNDER DOUBLER PLATE. REPAIRED PER SWA RA 1-353-1659.SDR SWAA970550Connector · shortedEN ROUTE, NR 1 ENGINE REVERSER UNLOCKED LIGHT ILLUMINATED, ACCOMPANIED BY MID CABIN VIBRATION AND NOISE. AIRCRAFT DIVERTED TO HOU AND MADE AN UNEVENTFUL LANDING. TROUBLESHOT AND FOUND A SHORT AT ISOLATION VALVE CONNECTOR PLUG. REPLACED CONNECTOR PER BOEING SDR SWAA970548Sensors · out of adjustEN ROUTE, NR 1 ENGINE REVERSER LIGHT ILLUMINATED INTERMITTENTLY FOR ABOUT 40 SECONDS, ALONG WITH SLIGHT VIBRATION AT MID CABIN AREA. ALSO, OVERHEAD REVERSER LIGHT ILLUMINATED. AIRCRAFT DIVERTED TO ABQ AND MADE AN UNEVENTFUL LANDING. LOCKED OUT REVERSER PER SDR SWAA961424Floorbeam · crackedDURING SCHEDULED C1 CHECK, FOUND FLOORBEAM STRAP CRACKED ABOVE AIRSTAIR SHROUD AT BS 328, LBL 12 AND 33. REPAIRED PER BOEING SRM.SDR SWAA961423Floorbeam · brokenDURING SCHEDULED C1 CHECK, FOUND FLOORBEAM STRAPS BROKEN AND CRACKED ABOVE AIRSTAIR SHROUD AT BS 312, BL 0 AND BL 12. REPAIRED PER BOEING SRM.SDR SWAA961422Floorbeam · crackedDURING SCHEDULED C1 CHECK, FOUND FLOORBEAM STRAP CRACKED UNDERNEATH FWD ENTRY DOOR. REPAIRED PER BOEING SRM.SDR SWAA961247Battery · dischargedDURING WALKAROUND CHECK, FOUND CABIN AFT UPPER EMERGENCY FLASHLIGHT WOULD NOT CHARGE. REPLACED BATTERY PER BOEING M/M.SDR SWAA961171Elev Feel Unit · malfunctionedAIRCRAFT WAS DIFFICULT TO ROTATE ON TAKEOFF. NOSE WOULD NOT COME UP WITH NORMAL BACK PRESSURE. NOSE FINALLY ROSE AFTER SEVERAL INCHES OF ADDITIONAL YOKE DISPLACEMENT. RESISTANCE WAS NOT EXCESSIVE, BUT DISPLACEMENT WAS. RETURNED TO PHX AND MADE AN UNEVENTFUSDR SWAA950461Hyd Line · rupturedDURING CLIMBOUT, EXPERIENCED SYSTEM A HYDRAULIC PRESSURE LOSS. AIRCRAFT RETURNED TO ONT AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND HYDRAULIC LINE TO RIGHT MAIN GEAR UPLOCK ACTUATOR RUPTURED. REPLACED LINE AND SERVICED SYSTEM PER BOEING M/M.
Back to N692SW, cancelled Sep 7, 2017