N357SW, cancelled Mar 22, 2018
Service difficulty reports · 356
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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-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 SWAA061178Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 379, LBL 2, AFT SIDE OF E & E COOLING DUCT EXHAUST PORT. REPAIRED SKIN PER SWA EA.SDR SWAA054060Light · damagedDURING SCHEDULED RON CHECK, FOUND EEPLS STRIP DAMAGED. REMOVED AND REPLACED EEPLS SECTION PER MM.SDR SWAA052964Light · looseEEPLS STRIP LOOSE AT FWD END. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA052191Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD GALLEY LOWER EMERGENCY EXIT LIGHT INOP. SECURED LIGHT PER MM.SDR SWAA051791Slide · deployedR2 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA051666Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 769, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA051665Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA051587Light · faultyRIGHT MLG GREEN LIGHT INDICATOR INOP DURING GEAR EXTENSION. RECYCLED MLG HANDLE-LIGHT ILLUMINATED. REMOVED AND REPLACED KORRY LIGHT PER MM.SDR SWAA043412Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA042939Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT AT ROW 8 DEF, INOP. RELAMPED LIGHT PER MM.SDR SWAA042456Seal · tornDECLARED EMERGENCY/DIVERSION. AT FL370 ALTITUDE WARNING HORN CAME ON. CABIN ALTITUDE WAS 9500 FT. WENT TO STANDBY ON PRESSURE CONTROLLER, NO HELP. WENT TO MANUAL AND STARTED AN EMERGENCY DESCENT, CABIN GOT TO 11500 FT. NO WARNING LIGHTS. REMOVED AND REPLACSDR SWAA042451Pushrod · wornDURING SCHEDULED C4 CHECK, RT ELEVATOR FAILED THE FREEPLAY CHECK. REMOVED AND REPLACED RIGHT ELEVATOR CONTROL PUSH ROD ATTACH BOLTS PER MM.SDR SWAA042110Fitting · crackedDURING RON, FOUND NLG ACTUATOR UPPER ATTACH FITTING GUSSET CRACKED. REMOVED AND REPLACED NLG FITTING PER SRM.SDR SWAA041950Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 794, RBL 7 TO RBL 11, CORRODED. REPAIRED SHEAR TIE PER EA.SDR SWAA041949Doubler · crackedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO DOOR DOUBLER AT BS 793, RBL 9, CRACKED. REPAIRED DOUBLER PER EA.SDR SWAA041942Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 927, STRINGER 27L, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041675Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING AFT OUTBOARD T/E FLAP DELAMINATED. REMOVED AND REPLACED RT WING AFT OUTBOARD T/E FLAP PER MM.SDR SWAA032549Skin · crackedDURING SCHEDULED PM CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS AT STRINGER 23L, BS 747, AND BS 727E. REPAIRED SKIN PER SRM.SDR SWAA032245Pcu · leakingDIVERSION, DECLARED EMERGENCY HYD 'A' SYS QTY IND DECREASED AND 'A' SYS ENG DRIVEN PUMP LOW PRESS LIGHT ILLUMINATED. FOUND HYD FLUID LEAK AT 'A' SYS AILERON PCU. REMOVED AND REPLACED SAME PER MM.SDR SWAA032018Engine · failedABORTED TAKEOFF, NR 2 ENGINE WOULD NOT ACCELERATE ON TAKEOFF. REMOVED AND REPLACED NR 2 ENGINE PER MM.SDR SWAA030759Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SVC DOOR, LOWER FWD CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA030060Cover · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE COVER FELL OFF. REINSTALLED COVER PER MM.SDR SWAA022802Tab · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11139-55, LEFT ELEVATOR NR 3 AND NR 4 HINGE ATTACH POINTS WORN. REMOVED AND REPLACED LEFT ELEVATOR TAB PER MM.SDR SWAA022119Bearing · failedDIVERSION, ON CLIMB-OUT FROM HOU, AIRFRAME LATERAL VIBRATION FELT, NR 2 ENGINE N2 IND FLUCTUATES 2.0 PERCENT. REMOVED AND REPLACED NR 2 ENGINE DUE TO AGB SHAFT BEARING FAILURE PER MM.SDR SWAA021384Flap · delaminatedDURING SCHEDULED PM CHECK, FOUND LT OTBD T/E FLAP DELAMINATED ON BOTTOM SURFACE. REMOVED AND REPLACED LT OTBD T/E FLAP PER MM.SDR SWAA021309Bushing · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11111-55, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR TAB BUSHINGS PER MM.SDR SWAA020081Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (4 EA) AT STR 8R, BS'S 360, 400, 440 AND 867. REPAIRED FRAMES PER BFG ER.SDR SWAA020080Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (5 EA) AT STR 8L, BS'S 380, 400, 440, 867 AND 907. REPAIRED FRAMES PER BFG ER.SDR SWAA020075Actuator · crackedDURING SCHEDULED D CHECK, FOUND NR 4 GROUND SPOILER OTBD ACTUATOR CRACKED. REMOVED AND REPLACED ACTUATOR PER MM.SDR SWAA020043Stiffener · crackedDURING SCHEDULED D CHECK, FOUND LT HORIZ STAB MAIN BOX INTERIOR L/E STIFFENER ON INTERSPAR WEB CRACKED AT STA 95. REPAIRED STIFFENER PER SRM.SDR SWAA020035Web · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE WEB CRACKED AT BS 294, STR 12L. REPAIRED WEB PER SRM.SDR SWAA013447Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA013446Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 827, WL 148 AND LBL 1. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA013421Stringer · crackedDURING SCHEDULED D CHECK, FOUND 2 EA STRINGER SPLICES CRACKED, BS 907, STR 4L AND STR 4R. REMOVED AND REPLACED STRINGER SPLICE SECTIONS PER SRM.SDR SWAA013420Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CORRODED, BS 616 TO BS 639 RT SIDE. REPAIRED BEAM WEB PER SRM.SDR SWAA012288Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEB CRACKED .125 LONG ST BS 178, LBL 90 & WL 234. REPAIRED WEB PER SRM.SDR SWAA011714Cover · damagedEEPLS COVERS DAMAGED. R&R EEPLS COVERS PER MM.SDR SWAA011034Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY AND SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY''S PER MM.SDR SWAA010509Slide · out of adjFWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA002099Wire · exposedEEPLS WIRES EXPOSED. SECURED EEPLS TRACK PER MM.SDR SWAA991963Controller · inopAIR TURNBACK, AIRCRFT WOULD NOT PRESSURIZE AFTER TAKEOFF. REMOVED AND REPLACED PRESSURE CONTROLLER PANEL PER MM.SDR SWAA991717Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND THROUGH EDDY CURRENT INSP, BS 178 BULKHEAD SIDE CHORD CRACKED, LBL 26, AND RBL 26. REMOVED AND REPLACED SIDE CHORD SECTIONS PER SRM.SDR SWAA991701Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, RBL 5 AND LBL 5. REPAIRED BULKHEAD PER SRM.SDR SWAA991686Light · inopDURING SCHEDULED 1/4D CHECK, FOUND EEPLS INOP AT ROW 17. RELAMPED PER MM.SDR SWAA991685Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR AFT FRAME CRACKED AT LOWER END. REPAIRED FRAME PER BOEING DRAWING.SDR SWAA990943Light · looseDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT LIGHTS LOOSE AT OVERHEAD BIN BULLNOSE, ROWS 9 RT AND 14 LT. RESECURED LIGHTS PER MM.SDR SWAA990773To Warning · activatedABORTED TAKEOFF WHEN MASTER CAUTION, AND ENG ANNUNCIATOR LIGHTS STAYED OUT ON RECALL FOR TAKEOFF, TAKE OFF WARNING HORN SOUNDED. PERFORMED TAKEOFF WARNING CHECK PER MM OPS CHECKED GOOD.SDR SWAA990388Wire · exposedDURING INSPECTION, FOUND TRACK LIGHTING IN FLOOR BY ROW 14 HAS EXPOSED WIRES. SECURED WIRES PER MM.SDR SWAA980807Lights · inoperativeDURING WALKAROUND CHECK, FOUND EMERGENCY LIGHTS BETWEEN ROW 12-16 INOP. REPAIRED WIRING ON EGRESS LIGHTS PER BOEING MM.SDR SWAA980694Floor Lights · inoperativeDURING WALKAROUND CHECK, FOUND EMERGENCY EXIT FLOOR LIGHTS ROW 14-16 INOP. RESECURED PER BOEING MM.
Back to N357SW, cancelled Mar 22, 2018