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 SWAA002132Cap · missingDURING SCHEDULED C3 CHECK, FOUND EEPLS AFT END CAP MISSING. INSTALLED END CAP PER MM.SDR SWAA001901Bracket · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LWR GIRT BAR BRACKET LOOSE. RE-SECURED BRACKET PER MM.SDR SWAA001784Support Bracket · brokenFWD ENTRY DOOR EVACUATION SLIDE GIRT BAR SUPPORT BROKEN. REPAIRED GIRT BAR SUPPORT PER MM.SDR SWAA001640Bottle · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000849Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 760, STRINGERS 19R AND 25R AND BS 757, STRINGER 23L. REPAIRED SKIN PER SRM.SDR SWAA000323Skin · crackedDURING WALKAROUND INSPECTION FOUND, FUSELAGE EXTERNAL SKIN CRACKS, BS 727D, STRINGER 23R, BS 887, STRINGER 25R, BS 775, STRINGER 20L, AND BS 737, STRINGER 22L. REPAIRED SKIN PER SRM.SDR SWAA991466Skin · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND LEFT ELEVATOR TAB DELAMINATED. REMOVED AND REPLACED ELEVATOR TAB PER MM.SDR SWAA991450Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON STRINGER 26R, BS 500D. REPAIRED STRINGER PER SRM.SDR SWAA991448Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, RBL 8 -RBL 10. REPAIRED BULKHEAD PER SWA RA NR 1-353-2152.SDR SWAA991449Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON STRINGER 25L, BS 827,BS 500B, BS 804. REPAIRED STRINGER PER SRM.SDR SWAA991434Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON BS 727D FLOORBEAM UPPER FLANGE, LBL 17- RBL 3. REPAIRED BEAM PER SWA RA NR 1-A53-2021.SDR SWAA991433Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON STRINGER 22R, BS 500C. REPAIRED STRINGER PER SRM.SDR SWAA991432Skin · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION AT BELLY SKIN, BS 907 TO 1106, STRINGERS 25L-25R. REMOVED AND REPLACED BELLY SKIN SECTION PER SRM.SDR SWAA991428Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 663 PRESSURE WEB CRACKED, LBL 32. REPAIRED PER SWA RA NR 1-353-2150.SDR SWAA991410Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 663 BEADED PRESS WEB CRACKED, LBL 30. REPAIRED WEB PER SWA RA NR 1-353-2150.SDR SWAA991403Stops · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT EMERGENCY OVERWING EXIT DOOR LOWER STOPS CRACKED. REMOVED AND REPLACED STOPS PER MM.SDR SWAA990454Light · looseEMERGENCY EXIT ROW LIGHT (RT SIDE) IN OVERHEAD LUGGAGE BIN LOOSE. RESECURED LIGHT PER MM.SDR SWAA981114Skin · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED FWD CARGO DOORWAY HAS BIG HOLE IN FUSELAGE BETWEEN STR 25R AND 26R AT BS 395 TO 420. REPAIRED PER BOEING SRM.SDR SWAA970830Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED, AFT OF RT WING/BODY FAIRING. REPAIRED PER BOEING SRM.SDR SWAA970796Csd · reqd serviceIN FLIGHT, NR 2 ENGINE HAD A PERIOD OF UNRESPONSE WHEN NR 2 ENGINE GENERATOR TRIPPED OFF LINE. REMAINED OFF LINE UNTIL PASSING THROUGHT 10,000 FT, ENGINE RETURNED BACK TO SPEED. AIRCRAFT MADE AN UNEVENTFUL LANDING. INSPECTED AND SERVICED NR 2 CSD, GROUND OPSDR SWAA970458Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SHEAR TIE CRACKED AT BS 358, AT S14L. REPAIRED PER BOEING SRM.SDR SWAA970457Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE INNER FRAME CHORD CRACKED AT BS 616, LBL 64. REPAIRED PER BOEING SRM.SDR SWAA970456Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500D, BETWEEN S26L AND 24L. REPAIRED PER BOEING SRM.SDR SWAA970455Skin · crackedDURING SCHEDULED D-CHECK, FOUND AFT ENTRY DOORWAY OUTER SKIN CRACKED AT LOWER FWD CORNER. REPAIRED PER BOEING SRM.SDR SWAA970454Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED AT BS 1006, AT S12R. REPAIRED PER BOEING SRM.SDR SWAA970405Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD CRACKED AT RBL 4.7, WL 199 TO 197.75. REPAIRED PER TRAMCO EWO 97-0198.SDR SWAA970404Clip · damagedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP DAMAGE AT BS 460, S28L. REPLACED PER BOEING SRM.SDR SWAA970314Fitting · crackedDURING SCHEDULED D-CHECK, FOUND A 2 INCH CRACK IN RADIUS OF SUPPORT FITTING MEMBER AT HORZ STAB CENTER SECTION UPPER SUPPORT, O/B SIDE OF BEAM, 25 AFT OF FWD SPAR, 20 I/B OF RT SIDE INTERNAL FUSE SKIN. REPAIRED PER BOEING SRM.SDR SWAA960812Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKS AT BS 727E, AT S23R, AT 500C, LBL 24.74. REPAIRED PER BOEING SRM.SDR SWAA960811Floor Beam · crackedDURING SCHEDULED C2 CHECK, FOUND FLOOR BEAM CRACKED AT BS 520, RBL 26. REPAIRED PER BOEING SRM.SDR SWAA960316Battery Pack · dischargedDURING SCHEDULED C4 CHECK, FOUND CENTER AISLE AND LT EMERGENCY EXIT LIGHTS INOP. REPLACED BATTERY PACK AND CONNECTOR PINS PER BOEING M/M.SDR SWAA960003Engine · bird strikeAFTER TAKEOFF, EXPERIENCED BIRD STRIKE TO NUMBER 2 ENGINE. AIRCRAFT RETURNED TO SMF AND MADE AN UNEVENTFUL LANDING. REPLACED NUMBER 2 ENGINE PER PER BOEING M/M.SDR SWAA950176Skin · dentedDURING SCHEDULED TRANSITION CHECK, FOUND FUSELAGE SKIN DENTED AT BS 328, S21R. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950168Door · crackedDURING SCHEDULED TRANSITION CHECK, FOUND CRACK ON FWD UPPER CORNER OF FWD GALLEY DOOR AT FASTENER HOLE. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950167Frame · damagedDURING SCHEDULED TRANSITION CHECK, FOUND FUSELAGE FRAME DAMAGE AT BS 787, RBL 22, WL 156. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950166Skin · oil canningDURING SCHEDULED TRANSITION CHECK, FOUND FUSELAGE SKIN OIL CANNING AT BS 727E+3, BETWEEN S22 AND 23L. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950165Floor · crackedDURING SCHEDULED TRANSITION CHECK, FOUND CRACK IN COCKPIT FLOOR AT BS 248, LBL 12, WL 208. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950164Floor Beam · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND FLOOR BEAM LOWER HORIZONTAL CHORD CORRODED FROM BS 1112 TO 1121, RBL 22, WL 216. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950163Floor Beam · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND FLOOR BEAM CORRODED BS 328, WL 208, RBL 7 TO 56, AT BS 312, WL 208, LBL 15, AND AT BS 344, WL 208, LBL 60. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950162Floor Beam · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND FLOOR BEAM UPPER CHORD CORROSION AT BS 1112 TO 1121, RBL 22, WL 228, AT BS 986.5, LBL 55 TO RBL 55, WL 208 AND AT BS 1016, RBL 45 TO LBL 45, WL 208. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950161Skin · crackedDURING SCHEDULED TRANSITION CHECK, FOUND NUMBER 6 SLAT CRACKED AT LOWER L/E OF SLAT. REPAIRED PER BOEING STRUCTURAL REPAIR MANUAL.SDR SWAA950160Skin · dentedDURING SCHEDULED TRANSITION CHECK, FOUND FUSELAGE SKIN DENTED AT FOLLOWING LOCATIONS: BS 1020, BETWEEN S12 AND 13L, AT BS 1000, WL 220, LEFT SIDE BEHIND AFT ENTRY DOOR, AT BS 356, BETWEEN S18 AND 19R, AT BS 193, WL 192, LEFT SIDE, AT BS 1040, LBL 188, BS 972, SDR SWAA950159Intercostal · corrodedDURING SCHEDULED TRANSITION CHECK, FOUND INTERCOSTAL CORRODED BETWEEN BS 294.5 AND 312. REPLACED PER BOEING STRUCTURAL REPAIR MANUAL.
Back to N693SW, cancelled Dec 8, 2014