N505SW, cancelled Oct 27, 2017
Service difficulty reports · 313
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 = 'N505SW' AND deregistration_id = 'N505SW-2017-10-27' 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 = 'N505SW' AND deregistration_id = 'N505SW-2017-10-27' 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 SWAA031009Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND EEPLS SECTION INOP IN AFT CABIN. RELAMPED EEPLS PER MM.SDR SWAA030180Cover · crackedDURING SCHEDULED C3 CHECK, FOUND EEPLS COVER CRACKED AT ROW NR 1. REMOVED AND REPLACED EEPLS COVER PER MM.SDR SWAA030085Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACK 4 INCHES LONG AT BS 750, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA022389Cover · crackedDURING SCHEDULED C2 CHECK, FOUND EEPLS COVER CRACKED AT ROW NR 1. REMOVED AND REPLACED EEPLS COVER PER MMSDR SWAA021813Light · looseOVERHEAD BIN BULLNOSE EMERGENCY EXIT LIGHT LOOSE AT ROW NR 19 ABC. SECURED LIGHT ASSY PER MM.SDR SWAA021420Door · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SVC DOOR FRAME CRACKED AT AFT LOWER DOOR STOP. REMOVED AND REPLACED FWD SVC DOOR PER MM.SDR SWAA021417Battery · dischargedDURING SCHEDULED 1/4D CHECK, FOUND EEPLS INOP IN FWD CABIN. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA021041Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA020907Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020530Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515, 1 INCH ABOVE STR 10L. REPAIRED SKIN PER SWA RA.SDR SWAA020498Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA020494Cover · crackedDURING SCHEDULED C4 CHECK, FOUND EEPLS COVERS CRACKED AT ROWS 4, 11, 14, 15, 17, 18 AND 19. REMOVED AND REPLACED COVERS PER MM.SDR SWAA020484Cover · crackedDURING SCHEDULED C4 CHECK, FOUND EEPLS COVER CRACKED AT ROW NR 7. REMOVED AND REPLACED COVER PER MM.SDR SWAA013222Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR SWAA012642Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEBS CRACKED (2 EA) AT BS 178, WL 207 & LBL 26.5, WL 234 & LBL 9.0. REMOVED AND REPLACED WEBS PER SRM & SWA ACO 7338-53.SDR SWAA012594Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL WEBS CRACKED ( 2 EA ) AT BS 180, WL 207 & RBL 26, BS 178, WL 219 & LBL 12. REPAIRED WEBS PER SRM.SDR SWAA012593Beam · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAMS CRACKED ( 2 EA ) AT BS 183, WL 183 & RBL 5.7, WL 223 & RBL 17.1. R&R VERTICAL BEAMS PER SWA RA 1-353-2655.SDR SWAA012250Structure · crackedDURING SCHEDULED SERVICE CHECK, FOUND LT WING L/E CRACKED NEAR NR 1 KRUEGER FLAP, CRACK IS .4375. REPAIRED L/E PER SWA RA.SDR SWAA011526Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND SEVERAL EMERGENCY LIGHTS INOP AT AFT CABIN. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA011305Cover · missingDURING RON, FOUND EEPLS TRACK COVER MISSING AT MID CABIN. INSTALLED TRACK COVER PER MM.SDR SWAA002100Solenoid · looseDECLARED EMERGENCY, DURING LANDING, GEAR EXTENDED, RECEIVED 3 GREEN AND 3 RED LIGHT INDICATIONS. ACOMMPLISHED QRH MANUAL EXTENSION WHICH RESULTED IN 3 GREEN LIGHTS. LOOSE WIRE FOUND ON GEAR HANDLE SOLENOID. SECURED WIRE, CLEANED WIRE AND LUBED GEAR HANDLE PSDR SWAA001380Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND LT EXTERNAL EMERGENCY LIGHT AT WING ROOT INOP. RELAMPED PER MM.SDR SWAA001379Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED, BS 940 TO 944, STRINGER 23L. REPAIRED SKIN PER SRM.SDR SWAA000572Cover · looseEEPLS TRCK LOOSE AT MID CABIN. SECURED TRACK COVER PER MM.SDR SWAA992139Light · inoperativeDURING SCHEDULED D CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REPAIRED WIRING AT LIGHT'S PIN CONNECTOR PER MM.SDR SWAA992092Spar · crackedDURING SCHEDULED D-CHECK, FOUND RT HORIZONTAL STAB FRONT SPAR CHORD CRACKED, STA 57.93. REPAIRED SPAR CHORD PER ER NR 99-6467.SDR SWAA992091Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 5L CRACKED, BS 360-386. SPLICED STRINGER SECTION PER SRM.SDR SWAA992090Frame · crackedDURING SCHEDULED D-CHECK, FOUND 6 FUSELAGE FRAME CRACKS, BS 747, LBL 60, BS 827, LBL 60 AND RBL 60, BS 867 LBL 60 AND RBL 60, AND BS 907, LBL 60. REPAIRED FRAMES PER ER NR 99-6438.SDR SWAA992081Post · crackedDURING SCHEDULED D-CHECK, FOUND L1 COCKPIT WINDOW POST CRACKED, UPPER LT SECTION. REPAIRED PER SWA RA NR 1-A53-1156.SDR SWAA992054Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED, BS 616, RBL 64, WL 201. REPAIRED FRAME PER SRM.SDR SWAA992049Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED, BS 685, STRINGER 11L, AND BS 706, STRINGERS 11L AND 11R. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA992036Clip · crackedDURING SCHEDULED D CHECK, FOUND 2 EACH STRINGER CLIPS CRACKED, BS 400, STRINGER 15L, AND BS 277, STRINGER 15R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA992030Skin · delaminatedDURING SCHEDULED D CHECK, FOUND NR 3 L/E SLAT INBOARD END DELAMINATED. REPAIRED SLAT PAR ER NR 99-6418 AND SRM.SDR SWAA992029Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 616 FUSELAGE FRAME CRACKED, LBL 64. REPAIRED FRAME PER SRM.SDR SWAA992028Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 270 FLOORBEAM UPPER SURFACE CORRODED, LBL 11-RBL 11. REMOVED AND REPLACED UPPER CHORD SECTION PER SRM.SDR SWAA992019Skin · creasedDURING SCHEDULED D CHECK, FOUND FUSELAGE EXTERNAL SKIN CREASED BETWEEN BS 183-188, WL 190 RH SIDE. REPAIRED SKIN PER SRM.SDR SWAA992018Bracket · corrodedDURING SCHEDULED D CHECK, FOUND FWD ENTRY DOOR BOTH EVACUATION SLIDE ATTACH FLOOR BRACKETS CORRODED. REMOVED AND REPLACED BOTH BRACKETS PER SRM.SDR SWAA992017Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICES CRACKED, BS 907, STRINGERS 4L AND 4R. REPAIRED SPLICES PER SRM.SDR SWAA992012Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND BS 178 BULKHEAD CRACKED AT 5 EACH PLACES, BETWEEN LBL 7 AND RBL 7. REPAIRED BULKHEAD PER SRM.SDR SWAA992009Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED, BS 312, STRINGER 6L. REPAIRED FRAME PER SRM.SDR SWAA991989Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 328 FLOORBEAM CORRODED ON UPPER SURFACE, LBL 27 TO RBL 49. REPAIRED BEAM PER SRM.SDR SWAA992001Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 312 FLOORBEAM UPPER SURFACE CORRODED, LBL 1 TO LBL 19. REPAIRED BEAM PER SRM.SDR SWAA991760Slide · looseDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT DRAGGING ON FLOOR. REINSTALLED SLIDE ASSY PER MM.SDR SWAA991724Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND LT MLG WHEEL WELL PRESSURE WEB CRACKED NEXT TO TOWER SHAFT. REPAIRED WEB PER ER NR 99-6239.SDR SWAA990467Wire · exposedESCAPE PATH LIGHTING HAS EXPOSED WIRES AT MID CABIN. RESECURED TRACK LIGHTING COVER PER MM.SDR SWAA970549Frame · damagedBELTLOADER CONTACTED FUSELAGE SKIN UNDER AFT CARGO DOOR CAUSING BELTFRAME AND SHEAR TIE DAMAGE AT BS 827. REPAIRED PER BOEING SRM.SDR SWAA961331Indicator · inoperativeRIGHT WING FUEL QUANTITY BEGAN DROPPING DURING FLIGHT CAUSING THE INABILITY TO MAINTAIN BALANCED FUEL LOAD. AIRCRAFT DIVERTED TO CLE AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND RT MAIN FUEL QUANTITY INDICATOR INOP. REPLACED PER BOEING M/M.SDR SWAA961250Lights · inoperativeDURING BOARDING, PASSENGER KICKED FLOOR TRACK LIGHTING COVER AND ASSOCIATED WIRING LOOSE, DISABLING 4 WHITE LIGHTS. REPAIRED WIRES AND REPLACED COVER PER BOEING M/M.SDR SWAA961028Light · inoperativeAT GATE FOUND AN EMERGENCY EXIT LIGHT INOP. RELAMPED AND RESECURED LIGHT ASSEMBLY PER BOEING M/M.SDR SWAA960940Light · inoperativeAT GATE, FOUND EMERGENCY TRACK LIGHTING INOP AT ROWS 6, 7 AND 8. REPLACED EXIT LIGHT LOWER SUPPLY BASE PER BOEING M/M.
Back to N505SW, cancelled Oct 27, 2017