N693SW, cancelled Dec 8, 2014
Service difficulty reports · 443
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 = 'N693SW' AND deregistration_id = 'N693SW-2014-12-08' 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 = 'N693SW' AND deregistration_id = 'N693SW-2014-12-08' 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 SWAA040328Lens · brokenFORWARD F/A STATION EMERGENCY LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY PER MM.SDR SWAA031843Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, ABOVE STR 10R. REPAIRED SKIN PER SRM.SDR SWAA031655Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (3 EA) BELOW STR 4L, BS 661, BS 648 AND BS 667. REPAIRED SKIN PER SRM.SDR SWAA031654Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (2 EA) AT BS 178, WL 234, LBL 7.7 AND WL 195, RBL 0.5. REPAIRED SKIN PER SRM.SDR SWAA031200Skin · crackedDURING SCHEDULED A2 CHECK, FOUND 2 LONG FUSELAGE SKIN CRACK, BS 349, STRINGER 18R. REPAIRED SKIN PER SRM.SDR SWAA031051Skin · crackedDURING SCHEDULED C4 CHECK, FOUND NR 6 L/E SLAT CRACKED AT LOWER T/E AFT ROW OF FASTENERS. REPAIRED NR 6 L/E SLAT PER SWA EA.SDR SWAA031065Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LEFT INBOARD T/E FORE FLAP DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED LEFT INBOARD T/E FORE FLAP PER MM.SDR SWAA031064Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RIGHT OUTBOARD AFT T/E FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED RIGHT OUTBOARD AFT T/E FLAP PER MM.SDR SWAA030008Battery · dischargedAFT CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA022782Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND RT MLG FWD WALKING BEAM HANGER ATTACH LUG CORRODED. REMOVED AND REPLACED HANGER FITTING PER MM.SDR SWAA022565Web · gougedDURING SCHEDULED C2 CHECK, FOUND KEEL BEAM WEB GOUGED ADJACENT TO LT A/C PACK VALVE. REPAIRED WEB PER SWA EA.SDR SWAA022562Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELSGE SKIN CRACKED 2.5 IN LONG, BS 747+7, STR 19R. REPAIRED SKIN PER SWA SAM FORM 326.SDR SWAA022532Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022225Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022123Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA021820Motor · failedAIR TURNBACK, AFTER TAKEOFF T/E FLAPS WOULD NOT RETRACT HYDRAULICALLY. REMOVED AND REPLACED T/E FLAP HYDRAULIC MOTOR PER MM.SDR SWAA021778Relay · failedNOSE GEAR RED UNSAFE LIGHT DID NOT EXTINGUISH AFTER TAKEOFF. REMOVED AND REPLACED NOSE GEAR LATCHING RELAY R 374 PER MM.SDR SWAA021666Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 737, BETWEEN STR 20L AND 21L. REPAIRED SKIN PER SRM.SDR SWAA021663Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021368Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021314Slide · looseSVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA020867Bushing · wornDURING SCHEDULED C4 CHECK, FOUND LT ELEVATOR TAB HAS EXCESSIVE AXIAL PLAY. REMOVED AND REPLACED TAB HINGE BUSHING PER MM.SDR SWAA020764Valve · damagedAIR TURNBACK, AFTER TAKEOFF LANDING GEAR WOULD NOT RETRACT. FOUND INNER STRUT SUPPORT VALVE DAMAGED, WOULD NOT LET STRUT FULLY EXTEND AND ACTUATE AIR SENSOR. REPACKED INNER STRUT AND REMOVED AND REPLACED SUPPORT VALVE PER MM.SDR SWAA020728Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020609Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020170Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSE SKIN CRACKED (3 EA) AT BS 727E, STR 21R, BS 735, STR 18R AND BS 870, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA013264Spar · crackedDURING SCHEDULED D CHECK, FOUND VERTICAL FIN FRONT SPAR CRACKED AT SLING ATTACH POINT FASTENER HOLE. REPAIRED SPAR PER ER 01-5587.SDR SWAA013192Beam · corrodedDURING SCHEDULED D CHECK, FOUND KEEL BEAM CORRODED, BS 500D PLUS 6, LT SIDE, OUTBD FLANGE. REPAIRED KEEL BEAM PER SRM.SDR SWAA013191Spar · corrodedDURING SCHEDULED D CHECK, FOUND RT HORIZONTAL STAB UPPER REAR SPAR CHORD CORRODED BETWEEN STA 279 AND STA 305. REPAIRED SPAR PERSRM.SDR SWAA013179Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 767, RBL 7 TO RBL 10, WL 146. REPAIRED SHEAR TIE PER SRM.SDR SWAA013178Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 767, LBL 3 TO LBL 5, WL 146 AND WL 147. REPAIRED SHEAR TIE PER SRM.SDR SWAA013190Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND 2 EA AFT CARGO COMPT SHEAR TIES CORRODED, BS 747, RBL 1-7, AND BS 767, LBL 7-10. REPAIRED SHEAR TIES PER SRM.SDR SWAA013081Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 495, STR 22R. REPAIRED STR PER SRM.SDR SWAA013071Splice · crackedDURING SCHEDULED D-CHECK, FOUND STR SPLICE'S CRACKED (2 EA) AT BS 908, STR 4L & 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA013055Stiffener · crackedDURING SCHEDULED D CHECK, FOUND CRACKED STIFFENER AT BS 328, RBL 32 & WL 201. REPAIRED STIFFENER PER SRM.SDR SWAA013082Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SVC DOOR UPPER HINGE UPPER CORNER OF CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA013015Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 328, WL 208 & RBL 20 TO RBL 49. REPAIRED FLOORBEAM PER SRM.SDR SWAA013034Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (3 EA) AT BS 727A, STR 3R, BS 600, STR 8R & BS 560, STR 10R. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA012912Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED ( 2 EA ) AT BS 727, STR 20L, 3 INCHES LONG & BS 767, STR 19R, 2 INCHES LONG. REPAIRED SKIN PER SRM.SDR SWAA012463Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012374Battery · erraticEEPLS ILLUMINATING ERRATICALLY AFT OF ROW # 10. R&R BATTERY PACK PER MM.SDR SWAA012055Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY LIGHTS INOP AT AFT CABIN. REMOVED AND REPLACED LIGHT BATTERY PACK PER MM.SDR SWAA011655Screw · looseAIR TURNBACK. DURING CLIMB F/A HEARD LOUD POP and HIGH SQUEAL STARTED IN COCKPIT. FOUND CAPT AUX PITOT TUBE SCREWS LOOSE, TIGHTEN SCREWS PER MM.SDR SWAA011466Track · looseDURING SCHEDULED C1 CHECK, FOUND EEPLS TRACK LIGHTING LOOSE AT ROW 24. SECURED EEPLS PER MM.SDR SWAA011345Skin · crackedDURING SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 727E+17, STR 21L. REPAIRED SKIN PER SWA RA.SDR SWAA010901Fitting · wornDURING SCHEDULED SERVICE CHECK, FOUND LT MLG WALKING BEAM FWD ATTACH FITTING ON REAR SPAR WORN AT WBL 135.505. REMOVED AND REPLACED BEAM FITTING PER MM.SDR SWAA010652Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY LOOSE. SECURED SLIDE ASSY PER MM.SDR SWAA010502Battery · dischargedLEFT AFT CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA010316Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 2 EXTERNAL FUSELAGE SKIN CRACK AT BS 727D, BETWEEN STR 19R & STR 20R. REPAIRED SKIN PER SRM.SDR SWAA010306Light · looseDURING SCHEDULED C4 CHECK, FOUND MID CABIN OVERHEAD EMERGENCY EXIT LIGHT LOOSE. SECURED LIGHT ASSY PER MM.
Back to N693SW, cancelled Dec 8, 2014