N351SW, cancelled Sep 8, 2017
Service difficulty reports · 332
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 = 'N351SW' AND deregistration_id = 'N351SW-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 = 'N351SW' AND deregistration_id = 'N351SW-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 SWAA991608Shear Ties · crackedDURING SCHEDULED D CHECK, FOUND 2 EACH FUSELAGE SHEAR TIES CRACKED, BS 360 BETWEEN STRINGERS 14L-15L AND 14R-15R. REPAIRED SHEAR TIES PER SRM.SDR SWAA991607Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED, BS 907, LBL 2, WL 303. REPAIRED FRAME PER ER NR 99-6081.SDR SWAA991599Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 986 FLOORBEAM UPPER CHORD CORRODED, LBL 45 - RBL 45. REPAIRED FLOORBEAM PER ER 99-6052.SDR SWAA991598Frame · crackedDURING SCHEDULED D CHECK, FOUND 3 EACH FUSELAGE FRAMES CRACKED, BS 380 AND BS 440, WL 283, LBL 55, AND BS 440, WL 283, RBL 55. REPAIRED FRAMES PER ER 99-6050A.SDR SWAA991597Clip · crackedDURING SCHEDULED D CHECK, FOUND 2 EACH FUSELAGE STRINGER CLIPS CRACKED, BS 767 AND BS 807, STRINGER 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA991596Frame · crackedDURING SCHEDULED D CHECK, FOUND 3 EACH FUSELAGE FRAMES CRACKED, BS 827, BS 867 AND BS 907, WL 266, LBL 65. REPAIRED FRAMES PER ER 99-6050A.SDR SWAA991595Splice · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICES CRACKED AT BS 907, STRINGERS 4L AND 4R. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA991591Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND BS 500C SHEAR TIE CRACKED BETWEEN STRINGERS 13L - 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA991590Cover · damagedDURING SCHEDULED D CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE SHROUD COVER DAMAGED. REPAIRED SHROUD COVER PER MM.SDR SWAA991586Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED, BS 794, RBL 8, WL 150. REPAIRED FRAME PER SRM.SDR SWAA991585Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED, BS 420, RBL 74. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA991536Fitting · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION ON RT WING NR 8 T/E AFT FLAP TRACK ATTACH FITTING. REMOVED AND REPLACED NR 8 AFT FLAP TRACK ATTACH FITTING PER SRM.SDR SWAA991529Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP 11L CRACKED, BS 706. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA991474Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND 2 EACH CRACKS, BS 178 BULKHEAD, BL 0 - RBL 7. REPAIRED BULKHEAD PER SRM.SDR SWAA990600Lens · missingDURING SCHEDULED BC3 CHECK, FOUND MAIN ENTRY AISLE EMERGENCY EXIT LIGHT MISSING LENS. REMOVED AND REPLACED LENS PER MM.SDR SWAA990599Light · inoperativeDURING SCHEDULED BC3 CHECK, FOUND 2 EA EMERGENCY ESCAPE LIGHT TRACKS OUT AT ROWS 6 AND 3. RELAMPED LIGHTS PER MM.SDR SWAA983172Skin · crackedDURING SCHEDULED C2 CHECK, FOUND A 1.25 INCH CRACK IN FUSELAGE SKIN AT BS 727E, AT S24L. INSTALLED REPAIR DOUBLER PER BOEING SRM.SDR SWAA982522Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, PERFORM C1 TASK 2041, REPLACE EMERGENCY LIGHT BATTERY PACKS BY USING SERVICEABLE BATTERIES. IF SERVICEABLE BATTERIES ARE NOT AVAILABLE ACCOMPLISH TEST AS OUTLINE ON TASK CARD 2041. REMOVED AND REPLACED NINE EMERGENCY LIGHT BATSDR SWAA981203Web · crackedDURING SCHEDULED A2 CHECK, FOUND 2 INCH CRACK IN WEB AT BS 767, STR 22. REPAIRED PER BOEING SRM.SDR SWAA981051Stringer · crackedDURING SCHEDULED A2 CHECK, FOUND CRACKED 2 AT BS 767 STR 22. REPAIRED PER BOEING SRM.SDR SWAA980440Sign · brokenDURING WALKAROUND CHECK, FOUND EMERGENCY EXIT SIGN RT SIDE BROKEN AT OVERWING EXIT DOOR. REMOVED AND REPLACED EXIT SIGN, OPS CHECKED PER BOEING MM.SDR SWAA971065Slide · low pressureDURING WALKAROUND CHECK, FOUND FWD ENTRY DOOR SLIDE PRESS LOW. REPLACED PER BOEING M/M.SDR SWAA970528Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND CRACK INDICATION AT BS 178 BULKHEAD, WL 198 TO RBL 4.7. REPAIRED PER BOEING SRM.SDR SWAA970402Strap · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM STABILIZER STRAPS CRACKED AT BS 314, BL 0, WL 200, AND AT BS 314, RBL 31, WL 200. REPLACED PER BOEING SRM.SDR SWAA970401Strap · corrodedDURING SCHEDULED D-CHECK, FOUND TEAR STRAP CORRODED FROM BS 797 TO 857, RBL 18. REPLACED PER BOEING SRM.SDR SWAA970400Bulkhead Support · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR TO BULKHEAD SUPPORT AT BS 500D CORRODED FROM RBL 17 TO LBL 5. REPAIRED PER BOEING SRM.SDR SWAA970399Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BULKHEAD BS 178 CRACKED, AT WL 212 TO 212.5, LBL 6.7. REPAIRED PER T1-353-046.SDR SWAA961278Slide · deployedDURING SCHEDULED RON, GALLEY DOOR SLIDE DEPLOYED. REPLACED SLIDE PER BOEING M/M.SDR SWAA961277Frame · crackedDURING SCHEDULED TERMINAL CHECK, FOUND FWD SERVICE DOORWAY UPPER STUB FRAME CRACKED. REPLACED PER BOEING SRM.SDR SWAA960211Sensor · out of adjustON CLIMBOUT, CREW HAD TO USE OVERRIDE TRIGGER TO RAISE GEAR HANDLE, GEAR EXTENDED NORMALLY. AIRCRAFT RETURNED TO SLC AND MADE AN UNEVENTFUL LANDING. AIRCRAFT MX FERRIED TO PHX, ADJUSTED GROUND SHIFT SENSOR PER BOEING M/M.SDR SWAA950386Indicator · inopAFTER TAKEOFF, FLAPS WOULD NOT RETRACT PAST 5 DEGREES, EXTENDED FLAPS NORMALLY. AIRCRAFT RETURNED TO DAL AND MADE AN UNEVENTFUL LANDING. REPLACED FLAP POSITION INDICATOR PER BOEING MAINTENANCE MANUAL.SDR SWAA950385Connector · corrodedDURING CLIMBOUT, FLAPS REMAINED AT FIVE DEGREES. AIRCRAFT RETURNED TO SLC AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND RIGHT FLAP POSITION TRANSMITTER CANNON PLUG CORRODED. CLEANED PLUG AND OPERATED FLAPS THROUGH ALL SETTINGS, OK PER BOEING MAINTENAN
Back to N351SW, cancelled Sep 8, 2017