N676SW, cancelled Oct 26, 2017
Service difficulty reports · 282
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 = 'N676SW' AND deregistration_id = 'N676SW-2017-10-26' 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 = 'N676SW' AND deregistration_id = 'N676SW-2017-10-26' 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 SWAA040479Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STRINGER 18R. REPAIRED SKIN PER SRM.SDR SWAA040466Channel · crackedDURING SCHEDULED C1 CHECK, FOUND L1 DOOR FRAME CUTOUT H-CHANNEL CRACKED AT UPPER HINGE. REPAIRED PER EA.SDR SWAA032823Beam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL BEAM CRECKED AT BS 663, BL 0, WL 208. REPAIRED BEAM PER BFG ER.SDR SWAA032815Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT STR 9L, BS 400 AND 480, AND STR 9R, BS 400 AND 480. REPAIRED DAMAGED AREA PER BFG ER.SDR SWAA032812Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAMES AT STR 9L, BS 747, 787, 827, 907 AND STR 9R, BS 787, 827, 847, 887. REPAIRED FRAMES PER BFG ER.SDR SWAA032814Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION ON SHEAR TIE BS 947.5, STR 23L AND 24L. REPAIRED SHEAR TIE PER BFG ER.SDR SWAA032813Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD AT BS 947, RBL 42, WL 208. REPAIRED DAMAGED AREA PER ER.SDR SWAA032811Stringer · crackedDURING SCHEDULED D CHECK, FOUND CRACKED STR 6R AT BS 1011. REPAIRED DAMAGED AREA PER SRM.SDR SWAA032810Skin · corrodedDURING SCHEDULED D CHECK, FOUND LOWER EXT FUSELAGE SKIN BULGED AT BS 527, LBL 7. REPAIRED DAMAGED AREA PER BFG ER.SDR SWAA032802Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 25, WL 206. REPAIRED BEAM PER BFG ER.SDR SWAA032796Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 500, RBL 10, WL 148.5. REPAIRED SHEAR TIE PER SRM.SDR SWAA032728Spar · corrodedDURING SCHEDULED D CHECK, FOUND LT HORIZONTAL STAB REAR SPAR LOWER CHORD CORRODED. REPAIRED SPAR PER SRM.SDR SWAA032714Floor Panel · crackedDURING SCHEDULED D-CHECK, FOUND FLOOR WEB CRACKED AT BS 986.5 AND BS 1016, RBL 41. REPAIRED FLOORWEB PER SRM.SDR SWAA032700Frame · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION ON RT AFT GALLEY DOOR FRAME AT BS 996, RBL 48, WL 208. REPAIRED FRAME PER SRM.SDR SWAA032699Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER 15 L CRACKED AT BS 380 FRAME. REPAIRED STRINGER PER SRM.SDR SWAA032698Fitting · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION IN AFT CARGO COMP BS 1011, STRINGER 20 R, AT 1016 BULKHEAD ATTACHMENT. REPAIRED BULKHEAD ATTACHMENT PER SRM.SDR SWAA032695Bulkhead · crackedPAE - DURING SCHEDULED D-CHECK, FOUND CRACKED WEB AT BS 178.5, LBL 24, WL 207. REPAIRED PER SRM. (M)SDR SWAA032692Frame · corrodedPAE - DURING SCHEDULED D-CHECK, FOUND CORROSION ON AFT CARGO COMP FRAME BS 847 RBL 4 TO LBL 4, WL 154. REPAIRED PER SRM. (M)SDR SWAA032693Support · corrodedPAE - DURING SCHEDULED D-CHECK, FOUND CORROSION ON TORQUE BOX UPPER SUPPORT CHORD BS 1088 WL 250, RBL 20. REPAIRED PER SRM. (M)SDR SWAA032680Angle · crackedDURING SCHEDULED D CHECK, FOUND SUPPORT ANGLE CRACKED AT BS 178, WL 207, LBL 5. REPAIRED PER SRM.SDR SWAA032694Stringer · corrodedPAE - DURING SCHEDULED D-CHECK, FOUND CORROSION ON BS 272 STRINGER 22. REPAIRED PER SRM. (M)SDR SWAA032676Frame · crackedDURING SCHEDULED D CHECK, FOUND BOTH LEFT AND RIGHT FRAMES CRACKED AT BS 188. REPAIRED FRAMES PER SRM.SDR SWAA032667Beam · corrodedDURING SCHEDULED D CHECK, FOUND STUB BEAM INBOARD CHORD CORRODED AT BS 616, LBL 65. REPAIRED BEAM PER SRM AND BOEING SB.SDR SWAA032662Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM AT BS 312 LBL 11 TO RBL 37, WL 208 CORRODED. REPAIRED FLOORBEAM PER SRM.SDR SWAA032661Rib · crackedDURING SCHEDULED D CHECK, FOUND NR 3 SLAT LWR T/E SPAR CRACKED AT IB RIB OF ACTUATOR ATTACH POINT. REMOVED AND REPLACED NR 3 SLAT LWR T/E SPAR CORD PER SRM.SDR SWAA032649Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 663, STRINGER 1. REPAIRED FRAME PER SRM.SDR SWAA032648Stringer · corrodedDURING SCHEDULED D CHECK, FOUND STRINGER 25R CORRODED AT BS 903 TO 910. REMOVED AND REPLACED PER SRM.SDR SWAA032647Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 807 LBL 1 WL 149. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA032646Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND 2 EACH SHEAR TIES CORRODED AT BS 747 AND 827, RBL 1 AND RBL 5, BOTH AT WL 147. REPAIRED SHEAR TIES PER SRM.SDR SWAA032644Stringer Clip · crackedDURING SCHEDULED D CHECK, 3 EACH STRINGER CLIPS CRACKED AT BS 747, STR 11R, BS 767, STR 13R, BS 767, STR 11R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA032634Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CORRODED AT BS 727C+8, LT SIDE, BS 727B+8, RT SIDE. REPAIRED CREASE BEAM SECTIONS PER SRM.SDR SWAA032154Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR UPPER HINGE CUT OUT. REPAIRED SKIN PER SRM.SDR SWAA032155Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SVC DOOR UPPER HINGE CUT OUT. REPAIRED SKIN PER SRM.SDR SWAA031940Bracket · out of positionAFT ENTRY DOOR EVACUATION SLIDE GIRT BAR WOULD NOT LOCK PROPERLY AT FLOOR BRACKETS. REPAIRED FLOOR BRACKETS PER SWA EA.SDR SWAA031794Bushing · wornAIRFRAME VIBRATION ON CLIMB-OUT AND DESCENT, REMOVED AND REPLACED HARDWARE AND BUSHINGS ON BOTH LT AND RT ELEVATOR TAB ROD ENDS PER MM.SDR SWAA031530Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 619, STR 4L. REPAIRED SKIN PER SRM.SDR SWAA031524Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER CLIPS CRACKED (2 EA) AT STR 4L, BS 620 AND BS 680. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA031373Lens · looseDURING SCHEDULED C3 CHECK, FOUND AFT CABIN CENTER EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA031372Ballast · inoperativeDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BALLAST AND BATTERY PER MM.SDR SWAA031070Link · looseSEVERE VIBRATION FELT FROM NOSE GEAR UPON LANDING. REMOVED AND REPLACED BOTH NLG UPPER & LOWER TORSION LINKS PER MM.SDR SWAA030599Elevator · wornDURING SCHEDULED C2 CHECK, SWA SI 11139-55, BOTH LH & RH ELEVATORS FAILED FREE PLAY CHECK. R&R BOTH LH & RH ELEVATORS PER MM.SDR SWAA030584Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA030579Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA030573Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA030206Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 967, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA030207Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD EMERGENCY EVAC SLIDE LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA022857Skin · crackedDURING SCHEDULED C1 CHECK, FOUND AFT CARGO DOOR EXTERNAL SKIN CRACKED AT HANDLE CUT OUT, UPPER AFT CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA021372Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED (2 EA) AT BS 500 PLUS 16, STR 10R AND BS 500D PLUS 18, 12L. REPAIRED SKIN PER SWA RA.SDR SWAA021175Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020414Skin · crackedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR SKIN CRACKED AT LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA T1.
Back to N676SW, cancelled Oct 26, 2017