N313SW, cancelled Sep 8, 2017
Service difficulty reports · 402
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 = 'N313SW' AND deregistration_id = 'N313SW-2017-09-08' 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 = 'N313SW' AND deregistration_id = 'N313SW-2017-09-08' 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 SWAA011528Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 805, STR 19. REPAIRED SKIN PER SRM.SDR SWAA010624Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 3 EXTERNAL FUSELAGE SKIN CRACK AT BS 940, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA010623Stiffener · crackedDURING SCHEDULED SERVICE CHECK, FOUND BS 663 BULKHEAD STIFFENER CRACKED AT LBL 6.5. REPAIRED STIFFENER PER SWA RA.SDR SWAA010428Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 EXTERNAL FUSELAGE SKIN CRACK AT BS 500C, STR 15L. REPAIRED SKIN PER SRM.SDR SWAA010029Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC AND ENTRY DOORS EMERGENCY EVAC SLIDE GIRT ASSY''S OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY''S PER MM.SDR SWAA001654Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER AS DOOR WAS CLOSED. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001112Sensor · erraticAIR TURNBACK. APU FIRE WARNING LIGHT ILLUMINATED AND BELL SOUNDED. APU FIRE EXTINGUISHER DISCHARGED. APU WAS NOT OPERATING. INSPECTED APU COMPARTMENT, NO EVIDENCE OF FIRE NOTED. FOUND APU TAIL PIPE OVERHEAT SENSOR FAULTY. DEFERRED APU PER MEL.SDR SWAA001034Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR FWD LOWER CORNER FUSELAGE CUTOUT DOUBLER CRACKED. REPAIRED SKIN PER SWA RA NR 1-353-2299.SDR SWAA001033Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT ENTRY DOOR FUSELAGE STUB FRAME CRACKED AT FWD UPPER CORNER. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA001023Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND PRESS WEB CRACKED, BS 663, RBL 39, AND BS 665, RBL 34. REPAIRED WEB PER TI-353-032.SDR SWAA000971Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 987 FLOORBEAM UPPER SURFACE CORRODED, LBL 45 TO RBL 45. REPAIRED BEAM PER SRM.SDR SWAA000969Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SERVICE DOOR AFT FRAME CRACKED IN TWO PLACES. REPAIRED FRAME PER SRM AND BAC DRAWING.SDR SWAA000968Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 328 FLOORBEAM UPPER SURFACE CORRODED, LBL 28 TO RBL 28. REMOVED AND REPLACED BEAM UPPER CHORD SECTION PER SWA RA NR 1-353-424.SDR SWAA000967Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD RT SIDE CHORD CRACKED, WL 207. REPLACED CHORD SECTION PER SRM.SDR SWAA000966Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT WING LOWER RIB CHORD CRACKED, STA 135.5, STRINGER 2. REPAIRED RIB PER SWA RA NR 1-357-0847.SDR SWAA000970Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED ON UPPER SURFACE, BS 947, LBL 53. REPAIRED BEAM PER SWA RA NR 1-353-2292.SDR SWAA000956Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 294.5 FLOORBEAM UPPER SURFACE CORRODED AROUND NUT CLIP HOLES. REPAIRED BEAM PER SRM.SDR SWAA000955Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND 1.5 INCH LONG CRACK BS 1016 BULKHEAD STRINGER 6L. REPAIRED BULKHEAD PER SWA RA NR 1-353-2291.SDR SWAA000943Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 312 FLOORBEAM UPPER SURFACE AFT FLANGE CORRODED, LBL 10. REPAIRED BEAM PER SRM.SDR SWAA000939Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 663 - 665 PRESSURE WEB HAS 2 CRACKS, LBL 28 AND LBL 32. REPAIRED WEB PER SRM AND T1-353-046.SDR SWAA000510Skin · crackedDURING WALKAROUND INSPECTION, FOUND EXTERNAL FUSELAGE SKIN CRACK, BS 500D, STRINGER JUST BELOW STRINGER 15R. REPAIRED SKIN PER SRM.SDR SWAA991547Battery · dischargedLOWER AFT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA991541Bracket · looseDURING SCHEDULED BC2 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT BAR ATTACH BRACKETS LOOSE. TIGHTENED HOLDING BRACKETS PER MM.SDR SWAA991526Light · looseFWD EEPLS LIGHT PULLED UP FROM TRACK. REINSTALLED FWD EEPLS LIGHT SECTION PER MM.SDR SWAA991525Cover · crackedAFT ENTRY DOOR EVACUATION SLIDE PRESS GAUGE VIEW LENS CRACKED. REMOVED AND REPLACED SLIDE COVER ASSY PER MM.SDR SWAA991472Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED APPROX BS 500 TO 500A, STRINGER 11R. REPAIRED SKIN PER SRM.SDR SWAA991023Skin · crackedDURING SCHEDULED C1 CHECK, FOUND NR 1 L/E SLAT AUX TRACK SKIN CUTOUT CRACKED. REPAIRED SKIN PER SWA RA NR 1-A57-0691.SDR SWAA990968Battery Packs · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT LT AND RT DOORS EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BOTH BATTERY PACKS PER MM.SDR SWAA990853Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND CRACKED FUSELAGE SKIN AT BS 500C-500D, STRINGER 10L. REPAIRED SKIN PER SRM.SDR SWAA990830Module · inoperativeLOSS OF 'A' SYSTEM HYDRAULICS AFTER TAKEOFF. REMOVED AND REPLACED 'A' SYS HYD MODULE AND BOTH CASE DRAIN FILTERS, SYSTEM OPS CHECKED GOOD PER MM.SDR SWAA990645Slide · deployedFWD ENTRY DOOR SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990537Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 2 CRACKS ON FUSELAGE SKIN APPROX 3 INCHES LONG, BS 927 STR 25L AND BS 935, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA990378Blade · damagedAT FL 310, FELT AND HEARD A LOUD THUMP, NOTED CHANGE IN NR 1 ENG N2 AND FUEL FLOW INCREASE. ENG VIBRATION MON ROSE TO PLUS 4. PERFORMED CHECKLIST, RAN ON REDUCED POWER. VIBRATION CONTINUED TO SHUTDOWN AT GATE. INSPECTED AND FOUND ICE DAMAGE TO C1 FAN. REPSDR SWAA982180Skin · crackedDURING SCHEDULED C2 CHECK, FOUND NR 3 CRACK ON UPPER SURFACE OF FIXED L/E NEAR OUTBD END OF NR 2 SLAT. REPAIRED PER BOEING SRM.SDR SWAA982096Skin · crackedDURING SCHEDULED RON CHECK, FOUND 4 IN SKIN CRACK, RT SIDE ABOVE AND BETWEEN CABIN WINDOWS 12-13. REPAIRED PER BOEING SRM.SDR SWAA980111Floorbeam · double drilledDURING SCHEDULED 1/4 D CHECK, FOUND FLOORBEAM HAS 12 DOUBLE DRILLED HOLES FROM BS 420-440 RBL 13. REPAIRED PER BOEING SRM.SDR SWAA980110Floorbeam · crackedDURING SCHEDULED 1/4 D CHECK, FOUND FLOORBEAM CRACKED UPPER SIDE AT BS 480 RBL 13. REPAIRED PER BOEING SRM.SDR SWAA970850Lamp · inoperativeDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EMERGENCY LIGHT INOP. RELAMPED PER BOEING M/M.SDR SWAA970595Bulkhead · dentedDURING SCHEDULED C4 CHECK, FOUND PRESSURE BULKHEAD BS 178 DENTED FLOOR LEVEL. REPAIRED PER BOEING SRM.SDR SWAA970396Bulkhead · dentedDURING SCHEDULED C4 CHECK, FOUND AFT PRESSURE BULKHEAD DENTED AT FLOOR LEVEL, BS 1016. REPAIRED PER BOEING SRM.SDR SWAA970063Skin · dentedDURING SCHEDULED SERVICE CHECK, FOUND UPPER FUSELAGE SKIN SCRATCHED WITH A DEEP DENT BETWEEN STRINGERS 4 AND 5L, 42 FWD OF FWD ENTRY DOOR. REPAIRED PER BOEING SRM.SDR SWAA960473Engine · failedEXPERIENCED NR 1 ENGINE VIBRATION, FOLLOWED BY A/C YAWING TO THE LEFT. N2 RED WARNING LIGHT ILLUMINATED. ENGINE THROTTLE WAS RETARDED TO IDLE, BUT VIBRATION CONTINUED. CREW PERFORMED ENGINE SHUT-DOWN PROCEDURES. AIRCRAFT RETURNED TO OAK AND MADE AN UNEVENTSDR SWAA950681Window · crackedDURING CLIMBOUT AT 31,000 FEET, NOTED FIRST OFFICER'S SLIDING WINDOW CRACKED. AIRCRAFT RETURNED TO BOI AND MADE AN UNEVENTFUL LANDING. INSPECTED WINDOW AND CONFIRMED TO BE OUTER PANE. REMOVED AND REPLACED WINDOW ASSEMBLY PER BOEING M.M.SDR SWAA950583Skin · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CRACKS AT BS 178 WL 189 BL 0. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL AND TRAMCO EWO 95-0494.SDR SWAA950582Te Skin · crackedDURING SCHEDULED D-CHECK, FOUND NUMBER 3 SLAT LOWER T/E SKIN CRACKED AT I/B END. REPAIRED PER BOEING DRAWING 65C30133 AND BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950581Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 1016 LBL 5 WL 208 AND AT BS 294 AT LBL12 WL 208. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950580Skin · gougedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 316 BELOW S17L AND AT BS 332 BETWEEN S19 AND 20L. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950579Skin · damageDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CHAFING DAMAGE FROM BS 867 TO 887 BETWEEN S2 LT AND RT. REPAIRED PER TRAMCO EWO 95-0497 AND BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950578Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO DOOR AFT FRAME CRACKED AT BS 492 RBL 39 WL 162. REPAIRED PER TRAMCO EWO 95-0497 AND BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950577Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 500D, S19R. REPLACED PER BOEING STRUCTURAL REPAIR MANUAL.
Back to N313SW, cancelled Sep 8, 2017