N502SW, cancelled Jan 29, 2014
Service difficulty reports · 246
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 = 'N502SW' AND deregistration_id = 'N502SW-2014-01-29' 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 = 'N502SW' AND deregistration_id = 'N502SW-2014-01-29' 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 SWAA030710Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 799, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA030178Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021842Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA021808Slat · crackedDURING SCHEDULED D CHECK, FOUND NR 1 SLAT CRACKED BELOW INBD AUX TRACK CUTOUT. REPAIRED NR 1 SLAT PER SRM.SDR SWAA021608Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN DOOR WAS OPENED. REINSTALLED SLIDE PER MM.SDR SWAA021544Light · looseDURING SCHEDULED C4 CHECK, FOUND EEPLS LOOSE AT ROW NR 17. SECURED EEPLS PER MM.SDR SWAA021446Slide · unserviceableDURING SCHEDULED PM CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020660Cover · looseEEPLS COVER LOOSE. SECURED COVER PER MM.SDR SWAA013214Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEB CRACKED AT BS 178, WL 234 AND LBL 10. REPAIRED WEB PER SRM.SDR SWAA013216Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, WL 226 AND RBL 17.1. REMOVED AND REPLACED WEB PER SRM.SDR SWAA013215Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND HORIZONTAL WEBS CRACKED (2 EA) AT BS 179, WL 207, LBL 27.0 AND RBL 27.0. REMOVED AND REPLACED WEBS PER SRM.SDR SWAA012536Light · brokenDURING SCHEDULED C1 CHECK, FOUND CENTER EMERGENCY OVERHEAD EXIT LIGHT WIRES BROKEN. REPAIRED BROKEN WIRES PER MM.SDR SWAA012082Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA011608Cover · looseEEPLS TRACK COVER LOOSE AT MID CABIN. INSTALLED EEPLS TRACK COVER PER MM.SDR SWAA010999Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP AT AFT 7 ROWS. REMOVED AND REPLACED EEPLS CHARGER ASSY PER MM.SDR SWAA010425Light · brokenEEPLS BROKEN AT OVERWING EXIT. REPLACED LIGHT ASSY PER MM.SDR SWAA001685Cover · missingEEPLS TRACK COVER MISSING AT ROW 14. INSTALLED COVER PER MM.SDR SWAA001314Light · looseEEPLS TRACKS LOOSE. RE-INSTALLED TRACKS PER MM.SDR SWAA001020Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001019Skin · crackedDURING SCHEDULED C4 CHECK, FOUND NR 1 L/E SLAT LOWER SKIN CRACKED NEAR AFT RIVET ROW OF MID O/B AUX TRACK. REPAIRED SLAT PER SWA RA NR 1-A57-001.SDR SWAA000767Warning Light · illuminatedABORTED TAKEOFF, NR 1 ENG T/R OVERHEAD LIGHT ILLUMINATED DURING TAKEOFF. RESEATED NR 1 ENG T/R FAULT BOX. OPERATED T/R. NO DEFECT NOTED.SDR SWAA000549Skin · delaminatedDURING SCHEDULED SERVICE CHECK, F OUND RT ELEVATOR LOWER SKIN DELAMINATED IN 2 AREAS, APPROX STA 94.1, 8.5 INCHES AFT OF FRONT SPAR. REPAIRED SKIN PER SRM.SDR SWAA000502Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO DOOR CUTOUT LOWER FRAME CRACKED, BS 452 AT LOWER DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA000449Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 986 FLOORBEAM UPPER SURFACE CORRODED, LBL 53-RBL 53. REPAIRED BEAM PER ER NR OO-0212 AND SRM.SDR SWAA000448Frame · crackedDURING SCHEDULED D CHECK, FOUND 5 FUSELAGE FRAMES CRACKED, BS 827, BS 907, STRINGER 8L, BS 727B, BS 747, BS 787, STRINGER 8R. REPAIRED FRAMES PER ER NR 00-210A AND SRM.SDR SWAA000447Frame · crackedDURING SCHEDULED D CHECK, FOUND 5 FUSELAGE FRAMES CRACKED, BS 400, STRINGERS 8L-9L AND 8R-9R, BS 440, BS 482, AND BS 482A, BETWEEN STRINGERS 8R-9R. REPAIRED FRAMES PER ER NR 00-210A AND SRM.SDR SWAA000316Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD 10 CRACKS, LBL 5 TO RBL 7. REPAIRED BULKHEAD PER SRM.SDR SWAA000315Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CORRODED, BS 727B-727C, BBL 70. REPAIRED BEAM PER SRM.SDR SWAA991246Light · missingDURING SCHEDULED C1 CHECK, FOUND EEPLS TRACK CAP END MISSING AT FWD END. REPLACED CAP END PER MM.SDR SWAA991245Lens · missingDURING SCHEDULED C1 CHECK, FOUND EEPLS TRACK LENS MISSING AT FWD AND AFT ENDS. REPLACED LENSES PER MM.SDR SWAA991244Light · brokenDURING SCHEDULED C1 CHECK, FOUND EEPLS TRACK COVER BROKEN AT ROW 1. REMOVED AND REPLACED COVER PER MM.SDR SWAA991243Lens · crackedDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT LIGHT LENS CRACKED AT MID CABIN. REMOVED AND REPLACED LENS PER MM.SDR SWAA982685Ballast · failedON TAXI OUT, THE FLIGHT ATTENDANTS REPORTED A SMELL IN THE CABIN LIKE BURNING INSULATION (ELEC). CEILING LIGHT INOPERATIVE-ROW 11. REMOVED AND REPLACED LIGHT BALLAST PER BOEING MM. OPS CHECK GOOD.SDR SWAA981693Wire · exposedDURING WALKAROUND CHECK, FOUND EMERGENCY TRACK LIGHTING AT ROW 5 HAS EXPOSED WIRES. REPAIRED PER BOEING MM.SDR SWAA981594Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHT INOP AT MID CABIN. RECONNECTED EMERGENCY FLOOR TRACK LIGHT PER BOEING MM.SDR SWAA980791Light · looseDURING WALKAROUND CHECK, FOUND EMERGENCY EXIT ROW TRACK LIGHTING LOOSE. SECURED FLOOR TRACK LIGHTING PER BOEING MM.SDR SWAA980763Light · looseDURING WALKAROUND CHECK, FOUND EMERGENCY EXIT ROW TRACK LIGHTING LOOSE. SECURED FLOOR TRACK LIGHTING PER BOEING MM.SDR SWAA970687Wire · exposedDURING WALKAROUND CHECK, FOUND WIRES EXPOSED ON FLOOR TRACK LIGHTING. REPAIRED AND SECURED WIRING PER BOEING M/M.SDR SWAA970935Wire · brokenDURING SCHEDULED RON CHECK, FOUND A SECTION OF FLOOR TRACK LIGHTING INOP. REPAIRED A BROKEN WIRE PER BOEING M/M.SDR SWAA961075Acm · failedAFTER PUSHBACK FROM GATE, EXPERIENCED SMOKE IN CABIN. RETURNED TO GATE. INSPECTED, REPLACED RIGHT AIR CYCLE MACHINE AND AIR CONDITION RELAY MODULE PER BOEING M/M.SDR SWAA950680Sensor · malfunctionAFTER TAKEOFF, NR 2 KRUGER FLAP INDICATED NO RETRACTION. AIRCRAFT RETURNED TO HOU AND MADE AN UNEVENTFUL LANDING. INSPECTED AREA. REPLACED FLAP FULL UP PROXIMITY SENSOR PER BOEING M/M.SDR SWAA950300Floor Beam · crackedDURING SCHEDULED 1/2 D CHECK, FOUND FWD CARGO FLOOR BEAM CRACKED AT BS 400, LBL 21.0. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950299Web · crackedDURING SCHEDULED 1/2 D CHECK, FOUND FWD CARGO DOOR CUTOUT WEB CRACKED AT BS 460, LWR AFT CORNER. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950298Beltframe · crackedDURING SCHEDULED 1/2 D CHECK, FOUND BELTFRAME CRACKED .125 INCHES AT RIVET HOLE, BS 482, RBL 1. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950297Skin · crackedDURING SCHEDULED 1/2 D CHECK, FOUND RIGHT FUSELAGE SKIN CRACKED AT STRINGER S16R AT WING SCANNING LIGHT CUTOUT, AT AFT END OF FWD SECTION. REPAIRED PER SWA ACO 6405-53.SDR SWAA950296Door Frame · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND FWD CARGO DOOR FRAME CRACKED AT FWD LWR SIDE NEXT TO RELEASE UPLOCK HOOK. REPAIRED PER SWA ACO 3194-52.
Back to N502SW, cancelled Jan 29, 2014