N130SW, cancelled Oct 27, 2003
Service difficulty reports · 156
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 = 'N130SW' AND deregistration_id = 'N130SW-2003-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 = 'N130SW' AND deregistration_id = 'N130SW-2003-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 SWAA982010Doubler · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND ULTRA SONIC CRACK INDICATIONS UNDER ANGLE STIFFENER FWD SIDE OF BULKHEAD RBL 12, WL 218. REPAIRED PER BOEING SRM.SDR SWAA981994Angle · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND LEFT GEAR FWD, DOOR CUTOUT ANGLE CRACKED AT BS 680. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981993Skin · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND SKIN CRACKED AT NR 3 SLAT CUTOUT FOR ACTUATOR. REPAIRED PER TI-257-017.SDR SWAA981818Engine · bird strikeAIR TURNBACK DUE TO BIRD STRIKE ON NR 2 ENGINE ON ROTATION. AIRCRAFT MADE AN UNEVENTFUL LANDING. INSPECTED PER BOEING MM, NO DAMAGED NOTED.SDR SWAA981714Angle · corrodedDURING SCHEDULED SERVICE CHECK, FOUND O/B STABILIZER BAR SUPPORT ANGLE CORRODED ON LUG FACE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981364Slide · low pressureDURING WALKAROUND CHECK, FOUND REAR ESCAPE SLIDE PRESS LOW. REMOVED AND REPLACED PER BOEING MM.SDR SWAA981088Skin · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND BULGING CORROSION ON FUSELAGE SKIN FWD AT BS 727-A, STR 27R. REPAIRED PER SWA RA 1-253-1829.SDR SWAA981076Bulkhead Chord · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND CRACKED VERTICAL CHORD AT BS 178, LBL 5.5 WL 184 AFT SIDE. REPAIRED PER BOEING TYPICAL REPAIR TI- 253-031.SDR SWAA981075Skin · gougedDURING SCHEDULED 1/4 D-CHECK, FOUND GOUGED SKIN AT BS 960 BELOW STR 19L. REPAIRED PER BOEING SRM.SDR SWAA981062Stringer · chafedDURING SCHEDULED 1/4 D-CHECK, FOUND STRINGER 26 RT IS CHAFE UNDER APU BLEED DUCT JUST AFT OF BS 1040. REPAIRED PER BOEING SRM.SDR SWAA981049Skin · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND CRACKED SKIN AT NR 5 SLAT TRACK O/B AUX. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981048Angle · wornDURING SCHEDULED 1/4 D-CHECK, FOUND T-ANGLE WORN I/B UPPER FLAP WELL PANEL. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981047Web · wornDURING SCHEDULED 1/4 D-CHECK, FOUND WEB FOR SLIPPER FAIRING I/B OF NR 3 SLAT WORN. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981046Threshold · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND CRACKED FWD CARGO DOOR THRESHOLD AT FWD END. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981045Skin · gougedDURING SCHEDULED 1/4 D-CHECK, FOUND GOUGED SKIN AT BS 947 BELOW STR 21R. REPAIRED PER BOEING SRM.SDR SWAA981044Skin · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND CRACKED SKIN AT BS 910, BELOW STR 21R. REPAIRED PER BOEING SRM.SDR SWAA981043Skin · damagedDURING SCHEDULED 1/4 D-CHECK, FOUND FUSELAGE SKIN HAS IMPROPER REPAIR AT BS 375 BELOW STR 15 LT. REPAIRED PER BOEING SRM.SDR SWAA981008Skin · damagedDURING SCHEDULED 1/4 D-CHECK, FOUND HOLE BURNED IN SKIN FROM LIGHTNING STRIKE AT BS 480, BELOW STR 4L. REPAIRED PER BOEING SRM.SDR SWAA980993Web · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND INNER FWD WEB CRACKED NEAR CENTER STOP FITTING. REPAIRED PER BOEING SRM.SDR SWAA980693Structure · crackedDURING SCHEDULED RON CHECK, FOUND CRACKED AFT FUSELAGE (APPROX 3) BEHIND CARGO DOOR AND IN FRONT OF PREVIOUS REPAIR. REPAIRED PER BOEING SRM.SDR SWAA980686Structure · crackedDURING SCHEDULED RON CHECK, FOUND CRACKED AFT FUSELAGE (APPROX 3) BEHIND DOOR AND IN FRONT OF PREVIOUS REPAIR. REPAIRED PER BOEING SRM.SDR SWAA980203Slide · low pressDURING WALKAROUND CHECK, FOUND AFT ENTRY DOOR ESCAPE SLIDE PRESS LOW. REPLACED PER BOEING M/M.SDR SWAA980122Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 996, UNDER STR 20L APPROX 2.5 IN LENGTH. REPAIRED PER BOEING SRM.SDR SWAA970925Lamp · inoperativeDURING SCHEDULED C3 CHECK, FOUND AFT ENTRYWAY FLOOR LIGHT INOP. RELAMPED PER BOEING M/M.SDR SWAA970678Skin · crackedDURING TERMINAL CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD ENTRY DOOR CUTOUT. REPAIRED PER SWA ACO 6317-53.SDR SWAA970648Skin · crackedDURING SCHEDULED TERM CHECK, FOUND A FUSELAGE SKIN CRACK JUST AFT OF OUTFLOW VALVE. REPAIRED PER BOEING SRM.SDR SWAA970627Skin · crackedDURING SCHEDULED TERMINAL CHECK, FOUND A .75 FUSELAGE SKIN CRACK RUNNING VERTICALLY AT BS 538, S14L. REPAIRED PER BOEING SRM.SDR SWAA970626Skin · crackedDURING WALKAROUND CHECK, FOUND A 3.5 FUSELAGE SKIN CRACK LEFT SIDE, AFT OF ICE LIGHT, AND A 3.5 CRACK ABOVE POTABLE WATER SERVICE DOOR. REPAIRED BOTH PER BOEING SRM.SDR SWAA970344Light · inoperativeDURING SCHEDULED A1 CHECK, FOUND EMERGENCY EXIT LIGHTING INOP AT FWD SERVICE DOOR. RELAMPED PER BOEING M/M.SDR SWAA970291Skin · gougedDURING SCHEDULED RON VISIT, FOUND FUSELAGE SKIN GOUGED 12 ABOVE APU INLET, RT AIRCRAFT. REPAIRED PER BOEING SRM.SDR SWAA970287Power Supply · inoperativeDURING SCHEDULED RON VISIT, FOUND RT OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED POWER SUPPLY UNIT PER BOEING M/M.SDR SWAA970150Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND A FUSELAGE SKIN CRACK 36 INCHES BELOW AFT ENTRY DOOR, 3.5 INCHES LONG. REPAIRED PER BOEING SRM.SDR SWAA970149Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND A FUSELAGE SKIN CRACK AT BS 932, AT S22R AND 12 INCHES FORWARD OF DRAIN MAST BETWEEN S22 AND 23L. REPAIRED BOTH PER BOEING SRM.SDR SWAA970101Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT AT FWD ENTRY DOOR INOP. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA970061Check Valve · failedF/A REPORTED LIGHT MIST (SMOKE) , HOT SMELL AND BURNING EYES IN CABIN. CLEANED HYD RESERVOIR PNEUMATIC CHECK, REPLACED NR 1 AND 2 WATER SEPARATORS BAGS AND RAN BOTH ENGINES PER BOEING M/M, NO DEFECTS NOTED.SDR SWAA970060Battery · dischargedDURING SCHEDULED TERMINAL CHECK, FOUND AFT SERVICE DOOR EXTERIOR LIGHT INOP. REPLACED BATTERY PACK, LIGHT SOCKET AND LENS COVER PER BOEING M/M.SDR SWAA961385Control Panel · malfunctionedCLIMBING THROUGH 25,000, CABIN ALTITUDE ALERT SOUNDED. ALL SWITCHES WERE IN NORM POSITIONS, CABIN PRESSURE READ 9,500 FT. AIRCRAFT RETURNED TO MDW AND MADE AN UNEVENTFUL LANDING. REPLACED CABIN PRESSURE CONTROL PANEL PER BOEING M/M.SDR SWAA960377Actuator · failedAFTER TAKEOFF, NR 5 L/E SLAT WOULD NOT RETRACT. AIRCRAFT RETURNED TO HOU AND MADE AN UNEVENTFUL LANDING. REPLACED SLAT ACTUATOR PER BOEING M/M.SDR SWAA960075Blkhd Angle · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND NUMBER 2 ENGINE PYLON, UPPER FWD BULKHEAD WEB TO SKIN ATTACH ANGLE CRACKED AT FWD FASTENER STA 222.7. REPAIRED PER SWA RA 1-257-030.SDR SWAA960048Stringer · crackedDURING SCHEDULED MAINT CHECK, FOUND S17L CRACKED AT END, BS 1088. REPAIRED PER BOEING SRM.SDR SWAA960040Bulkhead · crackedDURING SCHEDULED MAINT CHECK, FOUND BS 178 BULKHEAD CRACK INDICATIONS AROUND RIVET HEAD FWD SIDE, WL 234, RBL 0. REPAIRED PER BOEING SRM.SDR SWAA960034Web · crackedDURING SCHEDULED MAINT CHECK, FOUND WEB FWD FLANGE TO FRAME CRACKED AT S7L AT BS 294. REPAIRED PER BOEING SRM.SDR SWAA960033Splice · corrodedDURING SCHEDULED MAINT CHECK, FOUND STRINGER SPLICE AT S27L CORRODED AT BS 947.5 AND 967. REPAIRED PER BOEING SRM.SDR SWAA960032Bracket · crackedDURING SCHEDULED MAINT CHECK, FOUND BULKHEAD AT BS 351.2 ATTACH BRACKET CRACKED ON LEFT SIDE. REPAIRED PER BOEING SRM.SDR SWAA960029Skin · damagedDURING SCHEDULED MAINT CHECK, FOUND AFT CARGO DOOR WEB DAMAGED AT CUTOUT LOWER AFT SIDE. REPAIRED PER BOEING SRM.SDR SWAA960028Skin · corrodedDURING SCHEDULED MAINT CHECK, FOUND FUSELAGE SKIN LAP CORRODED AT BS 910 S27L. REPAIRED PER BOEING SRM.SDR SWAA960027Bracket · crackedDURING SCHEDULED MAINT CHECK, FOUND FWD ENTRY DOOR WEB TO FRAME ATTACH BRACKET CRACKED AT BS 294 S11L. REPAIRED PER BOEING SRM.SDR SWAA960026Floorbeam · corrodedDURING SCHEDULED MAINT CHECK, FOUND FWD GALLEY FLOORBEAM CORROSION UPPER TEE CAP FASTENER BS 294 LBL 11. REPAIRED PER BOEING SRM.SDR SWAA960025Seat Track · crackedDURING SCHEDULED MAINT CHECK, FOUND CABIN SEAT TRACK CRACKED AT SCREW HOLE. REPAIRED PER BOEING SRM.SDR SWAA960024Floorbeam · corrodedDURING SCHEDULED MAINT CHECK, FOUND AFT GALLEY FLOORBEAM CORROSION AROUND FASTENER HOLE AND MIGRATING UNDER WEB AT BS 1016, FWD FLANGE LBL 0 TO 39. REPAIRED PER SWA RA 1-253-1415.
Back to N130SW, cancelled Oct 27, 2003