N343SW, cancelled Oct 27, 2017
Service difficulty reports · 247
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 = 'N343SW' AND deregistration_id = 'N343SW-2017-10-27' 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 = 'N343SW' AND deregistration_id = 'N343SW-2017-10-27' 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 SWAA043079Shaft · inoperativeAIR TURNBACK, UNABLE TO STAY BELOW MAX CONTINUOUS EGT DURING CLIMBOUT TO FL 26, NR 1 EGT WAS 900 DEGREES TO 910 DEGREES AT CLIMB N1. REMOVED AND REPLACED NR 1 ENGINE VBV MOTOR SHAFT PER MM.SDR SWAA042952Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN AT BS 767, STRINGER 18L, CRACKED. REPAIRED SKIN PER EA AND SRM.SDR SWAA042769Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT AFT ENTRY DOOR CUTOUT UPPER AFT RADIUS CRACKED. REPAIRED DOOR SKIN CUTOUT PER SRM.SDR SWAA041691Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA041637Slide · looseDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EVAC SLIDE LOOSE. SECURED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041636Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 790, STRINGER 17L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA032656Lamp · inoperativeDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA032620Window Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT NR 2 PAX WINDOW FRAME CRACKED. REMOVED AND REPLACED RT NR 2 PAX WINDOW FRAME PER SRM AND ERO.SDR SWAA032616Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT WING RIB LOWER CHORD CRACKED AT WBL 135.5 BETWEEN STRINGERS 2 AND 3. REPAIRED RIB PER SRM AND T1-257-008.SDR SWAA032615Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA032614Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, ABOVE STR 14L. REPAIRED FRAME PER SRM.SDR SWAA032598Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 360 STRINGER SPLICE CRACKED AT STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA032573Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 BULKHEAD CRACKED AT STR 7L. REPAIRED BULKHEAD WEB PER SRM AND ERO.SDR SWAA032572Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM CORRODED AT BS 947 TO BS 967 RT SIDE. REPAIRED CREASE BEAM PER SRM.SDR SWAA032571Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 987, RBL 45. REPAIRED FLOORBEAM PER SRM.SDR SWAA032570Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA032553Window Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND NR 1 AND NR 2 LT SIDE PAX WINDOW FRAMES CRACKED AT FASTENER HOLE. REMOVED AND REPLACED WINDOW FRAMES PER SRM.SDR SWAA032541Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT CREASE BEAM CORRODED AT BS 947 AND BS 967. REPAIRED CREASE BEAM SECTION PER SRM.SDR SWAA032540Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 540 FUSELAGE STRINGER SPLICE CRACKED AT 10R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA032510Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER SPLICE CRACKED AT BS 540, STR 10L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA032509Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 291.5, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA032477Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND 3 EA STRINGER CLIPS CRACKED AT BS 737, STR 19R, BS 727B, STR 21R, AND BS 727A, STR 21R. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA032454Angle · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TO FRAME ANGLE CRACKED AT BS 294.5 STR 23L. REPAIRED PER SRM.SDR SWAA032453Skin · crackedDURING SCHEDULED C2 CHECK, FOUND SKIN CRACKED AT AFT EDGE OF COOLING FAN EXHAUST. REPAIRED PER EA.SDR SWAA032442Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 13R. REPAIRED SKIN PER SRM.SDR SWAA032441Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA032435Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 348.5, STR 6L. REPAIRED FRAME PER SRM.SDR SWAA031663Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED AT BS 178, WL 207, RBL 14 AND WL 203, RBL7. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA031604Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT AFT EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED EMERGENCY EXIT LIGHT PER MM.SDR SWAA031628Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR OVERHEAD EMERGENCY EXIT LIGHT 2 EA BULBS INOP. RELAMPED EXIT LIGHT PER MM.SDR SWAA030829Slide · looseFWD SERVICE DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA022818Trim Tab · crackedDURING SCHEDULED A1 CHECK, SWA SI 11139-55, RT ELEVATOR TAB CRACKED AT NR 3 HINGE CUTOUT. REMOVED AND REPLACED RT ELEVATOR TAB PER MM.SDR SWAA022548Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT LOWER FWD CORNER OF AFT ENTRY DOOR. REPAIRED SKIN PER SWA EA.SDR SWAA022492Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021721Slide · out of adjustFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021622Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020812Slat · delaminatedDURING SCHEDULED C4 CHECK, FOUND NR 4 L/E SLAT T/E WEDGE DELAMINATED ON INBD EDGE. REMOVED AND REPLACED NR 4 L/E SLAT PER MM.SDR SWAA020446Fan · overtempFLIGHT ATTENDANTS REPORTED BURNING ODOR IN CABIN, SMELL ALSO NOTED IN COCKPIT. REMOVED AND REPLACED AIR CONDITIONING RECIRCULATION FAN PER MM.SDR SWAA020085Skin · crackedDURING SCHEDULED C3 CHECK, FOUND KEEL BEAM LOWER SKIN CRACKED 1.25 INCHES BETWEEN MLG W/W. REPAIRED SKIN PER SRM.SDR SWAA020084Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012746Lens · crackedDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY LIGHT LENS CRACKED. R&R LENS PER MM.SDR SWAA012754Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED .562 INCH AT AFT SVC DOOR LOWER HINGE CUT OUT. REPAIRED SKIN PER SRM.SDR SWAA012670Lens · looseFWD OVERHEAD AISLE EXIT LENS COVER FELL OFF. REINSTALLED LENS COVER PER MM.SDR SWAA011824Battery Pack · dischargedDURING SCHEDULED 1/4D CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT BATTERY PACK INOP. REMOVED AND REPLACED OVERWING BATTERY PACK.SDR SWAA011842Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD CRACKED AT BS 178, RBL 0.5 & WL 207. REPAIRED BULKHEAD PER SRM.SDR SWAA011779Battery Pack · defectiveDURING SCHEDULED 1/4D CHECK, FOUND EMERGENCY LIGHT BATTERY PACK AT LT OVERWING NOT CHARGING. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA002732Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SVC DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER MM.SDR SWAA002531Tee Chord · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD T-CHORD CRACKED, LBL 5.7, WL 184. REPAIRED CHORD PER SRM.SDR SWAA002524Stiffener · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 663 VERTICAL STIFFNER CRACKED AT RBL 3. R&R STIFFNER PER SRM.SDR SWAA002516Battery Pack · dischargedDURING SCHEDULED SPECIAL VISIT, FOUND BOTH AFT GALLEY EMERGENCY EXIT LIGHTS INOP. R&R BATTERY PACK PER MM.
Back to N343SW, cancelled Oct 27, 2017