N661SW, cancelled Jul 20, 2012
Service difficulty reports · 408
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 = 'N661SW' AND deregistration_id = 'N661SW-2012-07-20' 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 = 'N661SW' AND deregistration_id = 'N661SW-2012-07-20' 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 SWAA012749Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA012132Bushing · wornDURING SCHEDULED C2 CHECK, RH ELEVATOR TAB FAILED FREE PLAY CHECK. R&R INBD ELEVATOR TAB HINGE BUSHING PER MM.SDR SWAA011907Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED, BS 727D, AFT OF RH WING BODY FAIRING EMERGENCY EXIT LIGHT. REPAIRED SKIN PER SRM.SDR SWAA011420Keelbeam · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND KEEL BEAM STRUCTURE CORRODED FROM BS 500D TO BS 523, STR 28R. REPAIRED KEEL BEAM PER BFG ER.SDR SWAA011412Slide · unserviceableDURING SCHEDULED 1/4D CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011399Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD SVC DOOR SKIN CUTOUT, LOWER AFT CORNER. REPAIRED SKIN PER MM.SDR SWAA011373Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, WL 234, LBL 7.0. REPAIRED WEB PER SRM.SDR SWAA011163Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT CABLE ASSY MISROUTED. REPOSITIONED CABLE ASSY PER MM.SDR SWAA011176Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 1.25 CRACK AT LT HORIZ STAB LOWER SKIN, FWD OF REAR SPAR ACCESS PANEL NR 9107L. REPAIRED SKIN PER SRM.SDR SWAA011162Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND 3 EA. BULBS INOP IN AFT ENTRY DOOR EMERGENCY EXIT LIGHT. RELAMPED LIGHT ASSY PER MM.SDR SWAA011161Wedge · delaminatedDURING SCHEDULED C1 CHECK, FOUND LT WING INBD MID FLAP T/E WEDGE PANEL DISBONDED. R&R T/E WEDGE PER MM.SDR SWAA011150Skin · crackedDURING SCHEDULED C1 CHECK, FOUND NR3 L/E SLAT LOWER SKIN CRACKED AT INBD AUX TRACK. REPAIRED SLAT SKIN PER SRM.SDR SWAA010274Cover · looseEEPLS TRACK COVER LOOSE AT ROW 18 TO ROW 20. SECURED TRACK COVER PER MM.SDR SWAA010285Cover · looseEEPLS TRACK COVER LOOSE BETWEEN ROW 18 & 20. SECURED TRACK COVER PER MM.SDR SWAA010120Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND RT MLG ACTUATOR BEAM SUPPORT FWD FITTING, AT AFT SPAR, CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA010001Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING T/E AFT FLAP DELAMINATED AT INBOARD AFT CORNER. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWA010001Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING T/E AFT FLAP DELAMINATED AT INBOARD AFT CORNER. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWA002790Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING L/E OUTBOARD FORE FLAP DELAMINATED AT INBOARD T/E. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA001799Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND TWO CRACKS AT BS 178 INNER WEB, BETWEEN RBL 1 AND LBL 1, WL 181.5. REPAIRED WEB PER SRM.SDR SWAA001798Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 RT AND LT O/B CHORD ANGLES CRACKED. REMOVED AND REPLACED CHORD ANGLES PER ACO 7342-53.SDR SWAA001769Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEBS CRACKED AT WL 195, RBL 23, RBL 1, TO LBL 1, WL 181.5 & WL 207, LBL 23. REMOVED AND REPLACED WEB PER SRM.SDR SWAA000836Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA000835Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY THRESHOLD EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA000519Slide · looseDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000518Lens · missingDURING SCHEDULED C1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA000495Ballast · inoperativeSMOKE AND ELECTRICAL SMELL AT ROW 2 ABC.. FOUND SIDEWALL LIGHT BALLAST INOP, DEFERRED PER MEL AND LATER ON AT PHX. REMOVED AND REPLACED SIDEWALL LIGHT BALLAST PER MM.SDR SWAA992025Bolt · shearedLT MLG TORQUE LINK BOLT SHEARED IMMEDIATELY AFTER LANDING. SHIMMY DAMPER DEPARTED FROM GEAR, WALKING BEAM OUTBD ATTACH FITTING CRACKED, OUTER CYL TRUNION ATTACH LUGS CHAFED. MX FERRY TO DAL. REPLACED LT MLG TORQUE LINK BOLT. REPLACED SHIMMY DAMPER. REMOVESDR SWAA991933Line · rupturedLOSS OF B-SYSTEM HYD PRESS DURING FLIGHT. LOW PRESS LIGHT ILLUMINATED AND HYD QTY IND DECREASED TO 1/8 FULL. DISCOVERED RUPTURED NR 2 ENG T/R LOCKING ACTUATOR PRESS LINE. REMOVED AND REPLACED FLEX LINE PER MM. LEAK AND OPS CHECKED GOOD.SDR SWAA991406Skin · corrodedDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR LOWER HINGE CUT OUT FUSELAGE SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA991371Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR LOWER HINGE FUSELAGE SKIN CUT OUT CRACKED. REPAIRED SKIN PER SRM.SDR SWAA991261Air Dist · odorDURING CRUISE AND DESCENT, A STRONG ODOR IN COCKPIT (HOT RUBBER). PERFORMED INSPECTION OF FWD AND AFT E/E COMPARTMENT AND COCKPIT AREA. NO DEFECTS NOTED.SDR SWAA982835Wire · frayedDURING SCHEDULED TRANSITION CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT AT BS 907 TO HAVE FRAYED WIRES ON BACK OF LIGHT. REPAIRED FRAYED WIRES ON OVERHEAD EMERGENCY EXIT LIGHT PER BOEING MM.SDR SWAA982832Skin · gougedDURING SCHEDULED TRANS CHECK, FOUND LT WING T/E LOWER WING SKIN JUST BELOW BEAM TO SPAR FITTING IS GOUGED AROUND FASTENERS. REPAIRED LOWER WING SKIN BELOW BEAM TO SPAR FITTING PER TRAMCO ER 98-0940.SDR SWAA982698Fairing · crackedDURING SCHEDULED TRANSITION CHECK, WHILE WORKING DELAMINATION ON BODY FAIRING JUST FWD OF THE RT WHEEL WELL, FOUND RT WING ROOT FAIRING JUST FWD OF RT MLG WHEEL WELL HAS SEVERAL CRACKS BETWEEN FASTENER HOLES ON T/E. REPAIRED CRACKS BETWEEN FASTENER HOLES ON RSDR SWAA982697Intercostal · crackedDURING SCHEDULED TRANSITION CHECK, FOUND CRACKED INTERCOSTAL AT BS 269, RBL 2, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982641Shear Tie · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND SHEAR TIE CORRODED BETWEEN STRINGERS 27 AND 28L, BS 330. REPLACED SECTION PER BOEING SRM.SDR SWAA982622Skin · damagedDURING SCHEDULED TRAN CHECK, FOUND LT HORIZONTAL STAB L/E SKIN IS DAMAGED AT UPPER SURFACE FASTENER L/E BS 98.66. REMOVED DAMAGE FROM HORIZONTAL STAB. REPAIRED L/E SKIN PER ER 98-0863.SDR SWAA982621Skin · damagedDURING SCHEDULED TRAN CHECK, FOUND DAMAGED TO INTERIOR SKIN AT BS 303 WL 305 LBL 11. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982613Skin · gougedDURING SCHEDULED TRAN CHECK, FOUND LT WING LEADING EDGE IS GOUGED IN SEVERAL AREAS ABOVE NR 1 K-FLAP BETWEEN 15 AND 32 I/B OF NR 1 PYLON. REPAIRED DAMAGED LEADING EDGE SKIN PER ER 98-0785.SDR SWAA982612Stringer · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED STRINGER 25L, AT BS 347, LBL 34. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982611Angle · crackedDURING SCHEDULED TRAN CHECK, FOUND LT WING ANGLE CRACKED ON FIXED LEADING EDGE O/B END OF K-FLAP AT AIRLOAD RIB. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982610Stringer · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED STRINGER 26 RT FROM BS 268 TO 290. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982620Support · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED SUPPORT STRUCTURE AT BS 540, RBL 70.5, JUST ABOVE FWD O/B CORNER OF RT A/C BAY DOOR. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982619Stringer · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED STRINGER 27R AT BS 363. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982618Shear Tie · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED SHEAR TIE AT BS 344, RBL 17 TO 18, WL 153. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982617Skin · damagedDURING SCHEDULED TRAN CHECK, FOUND DAMAGED SKIN AT BS 259.5 TO 360, BL 0 TO STR 24R. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982616Stringer · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED STRINGER TIE AT BS 360, STR 25L. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982615Shear Tie · damagedDURING SCHEDULED TRAN CHECK, FOUND SHEAR TIE WITH EIGHT BALLED HOLE ABOVE STR 24 AT BS 267. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982599Intercostal · crackedDURING SCHEDULED TRAN CHECK, FOUND LOWER HORIZONTAL WEB CRACKED AT APPROX NAC BS 350 TO 356. REMOVED AND REPLACED INTERCOSTAL PER BOEING SRM.SDR SWAA982598Stringer · crackedDURING SCHEDULED TRAN CHECK, FOUND FUSELAGE 367 CRACKED STRINGER 25 LT AT BS 324 TO 331. TRAMCO RESPONSIBILITY. REMOVED AND REPLACED PER BOEING SRM.
Back to N661SW, cancelled Jul 20, 2012