N659SW, cancelled Mar 28, 2018
Service difficulty reports · 545
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 = 'N659SW' AND deregistration_id = 'N659SW-2018-03-28' 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 = 'N659SW' AND deregistration_id = 'N659SW-2018-03-28' 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 SWAA020593Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIPS CRACKED AT BS 400, STR 28L AND STR 28R. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020578Cover · missingDURING SCHEDULED 1/4D CHECK, FOUND EMERGENCY EXIT LIGHT COVER MISSING ON FWD LAV WALL OTBD OF F/A SEAT. INSTALLED COVER PER MM.SDR SWAA013338Fuse · failedAIR TURNBACK, LANDING GEAR FAILED TO RETRACT AFTER TAKEOFF. REMOVED AND REPLACED NOSE GEAR RETRACTION FUSE PER MM, ADJUSTED GROUND SPOILER INTERLOCK CABLE AND LANDING GEAR SAFETY SENSORS PER MM.SDR SWAA012479Light · brokenOVERHEAD EMERGENCY LIGHT BROKEN AT ROW 22 R&R LIGHT ASSY PER MM.SDR SWAA012237Retainer · out of positionAIR TURNBACK, AFTER TAKEOFF A/C CABIN WOULD NOT PRESSURIZE. F/A REPORTED NOISE FROM AFT SVC DOOR. REPOSITIONED AFT SVC DOOR PRESS SEAL RETAINER PER MM.SDR SWAA012130Fitting · crackedDURING SCHEDULED C3 CHECK, FOUND LH MLG BEAM HANGER FITTING CRACKED AT FWD END. R&R FITTING PER ALM INV. # SWA 10410.SDR SWAA010008Lens · brokenDURING SCHEDULED C1 CHECK, FOUND LT & RT OVERWING EMERGENCY EXIT LIGHT LENSES BROKEN. REMOVED AND REPLACED LENS ASSYS PER MM.SDR SWA010008Lens · brokenDURING SCHEDULED C1 CHECK, FOUND LT & RT OVERWING EMERGENCY EXIT LIGHT LENSES BROKEN. REMOVED AND REPLACED LENS ASSY''S PER MM.SDR SWAA002513Stiffener · crackedDURING SCHEDULED RON CHECK, FOUND BS 663 BULKHEAD MLG W/W STIFFNER CRACKED AT RBL 3. R&R STIFFNER PER SRM.SDR SWAA002412Light · inoperativeFWD ENTRY DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA001878Strap · looseDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT STRAP PLAYOUT EXCESSIVE. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001729Bulkhead · crackedDURING SCHEDULED SV CHECK, FOUND BS 178 BULKHEAD WEBS CRACKED AT WL 207, RBL 27 AND WL 207, LBL 27. REMOVED AND REPLACED WEBS PER SRM.SDR SWAA001512Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS FWD SECTION INOP. REMOVED AND REPLACED FWD BATTERY PACK AND CHARGER PER MM.SDR SWAA000576Bracket · looseDURING SCHEDULED BC2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT BAR STOW BRACKETS LOOSE. SECURED BRACKETS PER MM.SDR SWAA991694Angle · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE ANGLE CRACKED, BS 360, LBL 68, WL 230. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA991681Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CENTER SECTION LONGITUDINAL BEAM CRACKED ON UPPER SURFACE BS 707-710, RBL 24.5. REPAIRED BEAM PER SRM.SDR SWAA991667Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION BS 328 FLOORBEAM UPPER FACE LBL 28. REPAIRED BEAM PER SRM.SDR SWAA991647Wire · brokenDURING SCHEDULED 1/2D CHECK, FOUND EEPLS HAS BROKEN WIRE AT BATTERY PACK, BS 975. REMOVED AND REPLACED WIRING SECTION PER MM.SDR SWAA991437Lens · missingDURING SCHEDULED C4 CHECK, FOUND EEPLS LENS MISSING AT ROW 15. REPLACED LENS PER MM.SDR SWAA991266Light · burnedAIR TURNBACK, 10 MINS AFTER TAKEOFF F/A REPORTED AN ELECTRICAL ODOR AT MID CABIN. FOUND SIDEWALL LIGHT AT ROW 7 ABC AND 8 ABC BURNED INTERNALLY. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA990919Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND A 4 INCH LONG CRACK AT FUSELAGE SKIN, BS 727D, STRINGER 24R. REPAIRED SKIN PER SRM.SDR SWAA990092Acm · failedAT FL350, F/A'S REPORTED STRONG FUMES AFT OF ROW 17 IN MAIN CABIN. TURNED OFF RECIRC FAN AND RIGHT PACK AND CLOSED ISOLATION VALVE. RETURNED TO BWI. FUMES WEAKENED NOTICEABLY. DEFERRED RIGHT PACK MEL. REPLACED BOTH COALESCER BAGS. OPERATED LEFT PACK WITHSDR SWAA982991Bulb · failedDURING SCHEDULED SC CHECK, FOUND AFT ENTRY DOOR EMERGENCY LIGHT INOP. RELAMPED AND OP CHECKED PER BOEING M/M.SDR SWAA982974Battery · dischargedDURING SCHEDULED CHECK, FOUND OVERWING EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA982973Skin · crackedDURING SCHEDULED CHECK, FOUND FUSELAGE SKIN CRACK BELOW EMERGENCY ESCAPE LIGHT LT SIDE BEHIND AFT WING TO BODY FAIRING. REPAIRED PER BOEING SRM.SDR SWAA982569Light · looseDURING SCHEDULED A1 CHECK, FOUND EMERGENCY TRACK LIGHT COVER LOOSE FROM ROW 18 THROUGH AFT. RESECURED TRACK LIGHT PER BOEING MM.SDR SWAA981824Bulb · failedDURING SCHEDULED TRAN CHECK, FOUND FWD SERVICE DOOR EMERGENCY EXIT LIGHT OUT. REPLACED BULB AT FWD EXTERIOR SERVICE DOOR EMERGENCY EXIT LIGHT PER BOEING MM.SDR SWAA981803Skin · dentedDURING SCHEDULED TRAN CHECK, FOUND AFT CARGO DOOR SKIN DENTED. REPAIRED PER BOEING MM.SDR SWAA981640Doubler · crackedDURING SCHEDULED TRAN CHECK, FOUND FWD GALLEY DOOR LWR AFT INNER DOUBLER CRACKED IN AFT FRAME LOWER CORNER. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981628Bulkhead · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED BS 178 BULKHEAD WL 188 RBL 5. REPAIRED PER BOEING SRM.SDR SWAA981504Skin · gougedDURING SCHEDULED TRAN CHECK, FOUND L/E GAUGED AT NR 4 SLAT TAI CUTOUT. REPAIRED INTERNAL AND EXTERNAL SURFACES PER BOEING SRM.SDR SWAA981486Clip · damagedDURING SCHEDULED TRAN CHECK, FOUND FRAME WITH 2 CLIPS ELONGATED HOLES LBL 20 AND 26. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981485Skin · delaminatedDURING SCHEDULED TRAN CHECK, FOUND DELAMINATED RT HORIZ STAB UPPER SURFACE O/B T/E PANEL. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981484Frame · damagedDURING SCHEDULED TRAN CHECK, FOUND DAMAGE AT FASTENER HOLES ON BS 1006 FRAME BL 0 BETWEEN STR 27L TO 27R. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981483Skin · crackedDURING SCHEDULED TRAN CHECK, FOUND EXTERNAL FUSELAGE SKIN GOUGED AT BS 1032 STR 9L. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981482Shear Tie · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED SHEAR TIE AT BS 1006 LBL 6 TO LBL 8 AFT BAY BETWEEN STR 27 RT AND 27 LT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981336Channel · damagedDURING SCHEDULED TRAN CHECK, FOUND HAT CHANNEL AT BS 986.5, WL 208 WITH ELONGATED HOLES LBL 22 TO 36. REPAIRED PER BOEING SRM.SDR SWAA981297Floorbeam · damagedDURING SCHEDULED TRAN CHECK, FOUND FLOORBEAM AT BS 1006, LBL 16 AND 29 WITH ELONGATED HOLES. REPAIRED PER BOEING SRM.SDR SWAA981296Web · damagedDURING SCHEDULED TRAN CHECK, FOUND BS 1006 TO 1016, LBL 28, WL 208 AND BS 1006 TO 1016, LBL 18, WL 208 WITH ELONGATED HOLES ON SHEAR WEB. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981295Angle · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED E1-1 RACK, LEFT HAND SUPPORT ANGLE. REPAIRED PER BOEING SRM.SDR SWAA981294Skin · gougedDURING SCHEDULED TRAN CHECK, FOUND GOUGED SKIN AT BS 457, 2 ABOVE STR 27 RT. REPAIRED PER BOEING SRM.SDR SWAA981287Intercostal · damagedDURING SCHEDULED TRAN CHECK, FOUND DAMAGED INTERCOSTAL ON BOTTOM END OF FWD ENTRY DOOR ON FWD SIDE OF FWD ENTRY DOOR. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981286Angle · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED AND GOUGED L-ANGLE BEHIND PANEL 9224 ON RT HORIZ STAB. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981204Bulkhead · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED INDICATION NOTED DURING UT, BS 178 BULKHEAD, WL 198.3 TO 202.5, RBL 4.7 AND BS 178, WL 198.0 TO WL 202.5, LBL 4.7. REPAIRED PER BOEING SRM.SDR SWAA981180Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE AND ENTRY DOOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACKS PER BOEING MM.
Back to N659SW, cancelled Mar 28, 2018