N699SW, cancelled Oct 30, 2013
Service difficulty reports · 338
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 = 'N699SW' AND deregistration_id = 'N699SW-2013-10-30' 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 = 'N699SW' AND deregistration_id = 'N699SW-2013-10-30' 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 SWAA040794Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R. REPAIRED FRAME PER SRM.SDR SWAA040793Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA040792Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CORRODED AT BS 947 TO BS 986, RT SIDE. REPAIRED CREASE BEAM PER SRM.SDR SWAA040776Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEBS CRACKED AT BS 576, LBL 71, WL 208 AND BS 637, LBL 71, WL 208. REMOVED AND REPLACED CREASE BEAM WEBS PER SRM.SDR SWAA040779Structure · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON RIGHT HORIZONTAL STAB CENTER SECTION FWD AND AFT SPAR, UPPER AND LOWER CLEVIS, FWD AND AFT LUG FACES. REPAIRED HORIZONTAL STAB PER SRM.SDR SWAA040778Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CHORD CRACKED AT BS 616 TO BS 639, RBL 63, WL 208. REMOVED AND REPLACED CREASE BEAM CHORD PER SRM.SDR SWAA040777Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STRINGER 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA040787Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 639, STRINGER 8L, BS 706, STRINGER 2L AND BS 616, STRINGER 4R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040769Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED A BS 907, STRINGER 4R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA040768Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 867, STRINGER 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA040757Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIPS CRACKED AT STRINGER 4L AND BS 706, BS 639, BS 616. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040400Skin · crackedDURING SCHEDULED SPV, FOUND FUSELAGE SKIN CRACKED AT BS 727 + 3, STRINGER 18R AND AT BS 766, STRINGER 22R. REPAIRED SKIN CRACKS PER SRM.SDR SWAA032464Strap · brokenDURING SCHEDULED C2 CHECK, FOUND FWD OB EMERGENCY LIGHT LOWER STRAP BROKEN. REMOVED AND REPLACED STRAP PER MM.SDR SWAA032236Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED 3.5 LONG AT BS 501D, STR 12R. REPAIRED SKIN PER SRM.SDR SWAA031890Lens · looseFWD ENTRY DOOR EMERGENCY OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED EXIT LIGHT ASSY PER MM.SDR SWAA031668Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED (3 EA) AT BS 520 AT STR 10L, BS 727D AT STR 22L AND BS 767 AT STR 18R. REPAIRED SKIN PER SRM.SDR SWAA030891Girt Bar · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030062Slat · crackedDURING SCHEDULED BC3 CHECK, FOUND NR 5 L/E SLAT CRACKED AT RIVETS ON LOWER SURFACE. REPAIRED SLAT PER SWA EA.SDR SWAA030061Slat · crackedDURING SCHEDULED C3 CHECK, FOUND NR 6 L/E SLAT T/E SKIN CRACKED AT AFT ROW OF RIVETS. REMOVED AND REPLACED NR 6 L/E SLAT PER MM.SDR SWAA022314Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, ABOVE STR 10L. REPAIRED SKIN PER SRM.SDR SWAA022311Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022223Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E PLUS 10, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA022103Wire · chafedBURN SMELL IN COCKPIT, SMELL IMMEDIATELY DISSIPATED. C/W INSPECTION IN MCI NO DEFECTS NOTED. LATER AT LAS, DID FOLLOW UP AND FOUND CHAFFED WIRE AT L1 WINDOW HEAT UNDER GLARE SHIELD. REPAIRED WIRE PER MM.SDR SWAA021066Lens · looseOVERHEAD BIN BULL NOSE EMERGENCY LIGHT LENS LOOSE AT ROW NR 23 DEF. SECURED LENS PER MM.SDR SWAA020751Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, BETWEEN STR 19L AND 20L. REPAIRED FRAME PER SRM.SDR SWAA020752Light · looseDURING SCHEDULED 1/4D CHECK, FOUND EMERGENCY EXIT NOT ARMED LIGHT ASSY LOOSE. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA020734Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 179, WL 227 AT LBL 17.1. REMOVED AND REPLACED WEB PER SRM.SDR SWAA020753Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 183, WL 233 AT RBL 17.1. REMOVED AND REPLACED WEB PER SRM.SDR SWAA020733Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR AFT FRAME CRACKED (3 EA) AT NR 3, NR 4 AND NR 5 STOP FITTINGS FROM BOTTOM. REPAIRED FRAME PER SRM.SDR SWAA020716Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED WEB CRACKED AT BS 663, LBL 33. REPAIRED WEB PER SWA RA.SDR SWAA020708Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 845, LBL 12. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA020705Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED 4 INCHES AT BS 769, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA020563Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED 3 INCHES AT BS 520D PLUS 13, ABOVE STR 10R. REPAIRED SKIN PER SRM.SDR SWAA020308Hose · failedDIVERSION, AFTER TAKEOFF NOSE GEAR WOULD NOT RETRACT. F0UND LOCKING ACTUATOR FLEX HOSE FAILURE AT SWEDGE AREA. REMOVED AND REPLACED HOSE. OPS CK OK PER MM.SDR SWAA020121Lens · looseLEFT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA013284Light · looseDURING SCHEDULED C3 CHECK, FOUND EEPLS LOOSE IN FWD CABIN. SECURED EEPLS PER MM.SDR SWAA013139Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED(6 EA) BETWEEN BS 727D AND BS 887, STR 19R TO STR 24R. REPAIRED SKIN PER SRM.SDR SWAA013138Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C PLUS 4, STR 10R. REPAIRED SKIN PER SWA RA.SDR SWAA013140Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED(2 EA) AT BS 752 AND BS 763, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA012487Tab · wornDURING SCHEDULED C2 CHECK, RH ELEVATOR TAB FAILED FREE PLAY CHECK. R&R RH ELEVATOR TAB PER MM.SDR SWAA012486Bearing · wornDURING SCHEDULED C2 CHECK, RH ELEVATOR FAILED FREE PLAY CHECK. R&R RH ELEVATOR CONTROL BEARING PER MM.SDR SWAA010494Slide · out of positionDURING SCHEDULED BC4 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA010032Circuit Breaker · trippedLANDING GEAR HANDLE WOULD NOT GO UP PAST OFF POSITION. FOUND LANDING GEAR LATCH PRESS WARN C/B TRIPPED. RESET C/B AND RAISED LAND GEAR AND CONTINUED. SYSTEM TEST OF LAND GEAR CONTROL LEVER LOCK GOOD AND C/B REMAINS CLOSED, NO FAULTS NOTED PER MM.SDR SWAA002724Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED AT JETWAY. R&R EVAC SLIDE ASSY PER MM.SDR SWAA002260Skin · crackedDURING SCHEDULED C3 CHECK, FOUND APPROX 2 INCH LONG EXTERNAL FUSELAGE SKIN CRACK AT BS 727E, BELOW STR 23R. REPAIRED SKIN PER SRM.SDR SWAA002259Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND RT WING INBOARD T/E FOREFLAP DELAMINATED ON UPPER SURFACE. REPAIRED FOREFLAP PER SRM.SDR SWAA001282Indicator · malfunctionedAIR TURNBACK, NR 1 ENG EGT INDICATOR INOP. REMOVED AND REPLACED NR 1 ENG EGT IND PER MM.SDR SWAA000003Battery Pack · dischargedDURING SCHEDULED RON, FOUND EEPLS INOP AT FWD END. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA991716Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOOR BEAM, BS 986.5, LBL 16 - LBL 60. REPAIRED BEAM PER TI-453-037.SDR SWAA991715Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIPS CRACKED, BS 294, STRINGERS 13L AND 11L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.
Back to N699SW, cancelled Oct 30, 2013