N330SW, cancelled Apr 23, 2012
Service difficulty reports · 208
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 = 'N330SW' AND deregistration_id = 'N330SW-2012-04-23' 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 = 'N330SW' AND deregistration_id = 'N330SW-2012-04-23' 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 SWAA043724Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPT FRAME SHEAR TIE CORRODED AT BS 807, LBL 5 TO RBL 5. REPAIRED SHEAR TIE PER SRM.SDR SWAA043722Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPT SHEAR TIE CORRODED AT BS 787, RBL 8. REPAIRED SHEAR TIE PER SRM.SDR SWAA043671Skin · crackedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR SKIN AT LOWER FWD RADIUS CRACKED. REPAIRED DOOR SKIN PER SRM.SDR SWAA043401Battery · inoperativeDURING SCHEDULED RON, FOUND BOTH L1 & R1 DOOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA043074Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING AILERON DELAMINATED. REMOVED AND REPLACED LT AILERON PER MM.SDR SWAA042591Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 350, STRINGER 26L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042590Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 967, STRINGER 21L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042589Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 540, STRINGER 12L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042579Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT L2 DOOR UPPER HINGE CUTOUT, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042578Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA042208Slide · looseR2 DOOR EVAC SLIDE LOOSE. SECURED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041275Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 951, LOWER RT LAP SEAM, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040403Light · inoperativeDURING SCHEDULED RON, FOUND LEFT EXIT SIDE WALL PANEL LIGHT INOP AT EMERGENCY EXIT DOOR. RELAMPED PER MM.SDR SWAA031851Flap · delaminatedRT OUTBD AFT T/E FLAP PREVIOUS REPAIR CAME APART. REMOVED AND REPLACED RT OUTBD AFT T/E FLAP PER MM.SDR SWAA031770Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED (3 EA) BS 915 AT STR 23L, BS 915 AT STR 24L AND BS 975 AT STR 21L. REPAIRED SKIN PER SRM.SDR SWAA031444Latch · inoperativeCAPT'S ESCAPE ROPE COVER LATCH INOP. REMOVED AND REPLACED ROPE COVER LATCH PER MM.SDR SWAA030896Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 943, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA030253Torque Tube · brokenT/E FLAPS INDICATED 5 DEGREE SPLIT ON APPROACH AND WOULD NOT RETRACT AFTER LANDING. FOUND LEFT FLAPS INBD TORQUE TUBE BROKEN, REMOVED AND REPLACED LEFT INBD TORQUE TUBE PER MM.SDR SWAA030038Web · crackedDURING SCHEDULED BC CHECK, FOUND NLG WHEEL WELL RT SIDE WEB CRACKED AT BS 259, WL 174. REPAIRED WEB PER SWA EA.SDR SWAA030042Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021906Lens · brokenDURING SCHEDULED 1/2D CHECK, FOUND BOTH AFT CABIN DOOR OVERHEAD EMERGENCY EXIT LIGHT LENSES BROKEN. REMOVED AND REPLACED LENSES PER MM.SDR SWAA021897Slat · delaminatedDURING SCHEDULED 1/2D CHECK, FOUND NR 5 L/E SLAT DELAMINATED AT T/E OTBD END. REPAIRED NR 5 L/E SLAT PER SRM.SDR SWAA021857Structure · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR CRACKED AT LOWER HINGE AREA, BS 316 AND WL 236. REPAIRED DOOR PER BOEING SB.SDR SWAA021797Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER SPLICES CRACKED AT BS 360, STR 4R AND STR 4L. REMOVED AND REPLACED STR SPLICES PER SRM.SDR SWAA021653Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER SPLICE'S CRACKED (2 EA) AT BS 908, STR 4R AND STR 4L. REPAIRED SPLICE'S PER SRM.SDR SWAA021308Slide · deployedDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA013368Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD LT SIDE CHORD CRACKED, WL 207. REMOVED AND REPLACED CHORD PER SWA ACO.SDR SWAA013354Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178, BOTH LT AND RT LOWER VERTICAL WEBS CRACKED. REMOVED AND REPLACED BOTH WEBS PER SRM.SDR SWAA013223Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA012811Spoiler · delaminatedDURING SCHEDULED C4 CHECK, FOUND # 9 SPOILER DELAMINATED AT UPPER SIDE. R&R SPOILER PER MM.SDR SWAA011971Lens · brokenDURING SCHEDULED C3 CHECK, FOUND SIDE WALL EMERGENCY LIGHT LENS BROKEN AT FWD ENTRY. R&R LENS PER MM.SDR SWAA011377Stiffener · crackedDURING SCHEDULED SERVICE CHECK, FOUND VERTICAL STIFFENER CRACKED AT MLG WHEEL WELL, BS 663, RBL 6.5. REPAIRED PER SWA RA.SDR SWAA002720Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC & AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDS OUT OF VIEW. ADJUSTED SLIDE ASSY PER MM.SDR SWAA002719Lens · looseDURING SCHEDULED C1 CHECK, FOUND BULL NOSE EGRESS LIGHT LENS LOOSE AT ROW 22 DEF. SECURED LENS PER MM.SDR SWAA002718Battery Pack · dischargedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR OVERHEAD EMERGENCY EXIT SIGN INOP. R&R BATTERY PACK PER MM.SDR SWAA002397Bottle · dischargedAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA002235Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING INBOARD TRAILING EDGE AFT FLAP DELAMINATED AT LOWER INBOARD SECTION. REMOVED AND REPLACED FLAP PER MM.SDR SWAA001742Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RT HORIZ STAB LOWER SKIN CRACKED, STA 128 ABOVE REAR SPAR. REPAIRED SKIN PER SRM.SDR SWAA001081Light · looseDURING SCHEDULED C3 CHECK, FOUND EEPLS TRACK LOOSE AT FWD END. RESECURED TRACK ASSY PER MM.SDR SWAA001043Sensor · inoperativeAIR TURNBACK, RT MLG WOULD NOT FULLY RETRACT. VISUAL INSPECTION CONFIRMED PARTIAL RETRACTED ONLY. REMOVED AND REPLACED RT MLG UPLOCK SENSOR PER MM.SDR SWAA001010Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000176Strap · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 1138, FUSELAGE SKIN STRAP CRACKED, STRINGER 12L. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA000184Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, WL 234, RBL12. REPAIRED BULKHEAD PER SRM.SDR SWAA991615Girt Bar · out of positionAFT ENTRY DOOR EVACUATION SLIDE GIRT BAR OUT OF HANGERS. REPOSITIONED GIRT BAR PER MM.SDR SWAA991275Slide · detachedAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA990004Slide · deployedDURING SCHEDULED SC CHECK, FWD SERVICE DOOR EMERGENCY ESCAPE SLIDE WAS INADVERTANTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER BOEING M/M.SDR SWAA982985Rod · brokenRETURNED TO PHX DUE TO AFTER TAKEOFF LANDING GEAR WOULD NOT RAISE. ALL COCKPIT INDICATIONS POINTED TO A AIR/GROUND SENSOR PROBLEM. FOUND GROUND SPOILER INTERLOCK CABLE LOWER ROD END BROKEN. REPLACED AND RIGGED CABLE AS REQUIRED PER M/M. CYCLED GEAR, OPS NOSDR SWAA981835Skin · crackedDURING SCHEDULED C4 CHECK, FOUND LEADING EDGE SKIN CRACKED AT I/B END OF HINGE CUTOUT OF SPRING LOADED DOOR. REPAIRED PER ACO NR 6820-57.SDR SWAA981334Slide · deployedDURING WALKAROUND CHECK, FOUND FORWARD ENTRY DOOR SLIDE DEPLOYED. REMOVED AND REPLACED FWD ENTRY DOOR SLIDE ASSY PER BOEING MM.SDR SWAA980972Intercostal · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND CRACKED INSIDE INTERCOSTAL AT BS 178 LBL 26, WL 195 FWD END. REMOVED AND REPLACED PER BOEING SRM.
Back to N330SW, cancelled Apr 23, 2012