N688SW, cancelled Nov 16, 2012
Service difficulty reports · 306
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 = 'N688SW' AND deregistration_id = 'N688SW-2012-11-16' 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 = 'N688SW' AND deregistration_id = 'N688SW-2012-11-16' 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 SWAA084094Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084095Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083626Lens · looseBULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 22 ABC. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA083277Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA082506Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA081408Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080428Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA080339Skin · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA080340Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RIGHT WING NR 5 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075827Hinge · brokenDURING SCHEDULED MV1 CHECK, FOUND LT WING NR 4 GROUND SPOILER INBOARD HINGE BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA074826Glowstrip · looseEEPLS PHOTOLUMINESCENT STRIP LOOSE BETWEEN ROW 5 ABC AND ROW 8 ABC. REMOVED AND REPLACED STRIP PER MM.SDR SWAA074630Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 516 AND BS 500D, STR 16L AND STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA073620Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 740D, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA073122Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 740D, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA073121Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 733, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA073120Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 745, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA071849Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA071316Bulb · inoperativeDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT BULBS INOP. RELAMPED PER MM.SDR SWAA071317Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 251.5, STR 24L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA064750Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND RIGHT AFT CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA063051Panel · crackedDURING SCHEDULED C1 CHECK, FOUND KEELBEAM PANEL CRACKED AT LOWER LT SIDE BS 695. REPAIRED KEEL BEAM PANEL PER SRM.SDR SWAA062936Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 27R, CORRODED AT BS 500D. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA062935Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER CUTOUT, BS 410, RBL 2. REPAIRED SKIN PER ER.SDR SWAA062934Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 737D, STR 21L. REPAIRED SKIN PER ER.SDR SWAA062922Support Fitting · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING MLG BEAM OUTBOARD FITTING CRACKED AT STA 222. REPAIRED LT MLG FITTING PER ER.SDR SWAA062823Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA062822Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 943, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA062786Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 9L CRACKED AT BS 787. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA062785Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 13L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062596Vertical Beam · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL BEAM CRACKED AT BS 178, LBL 5.7, WL 186. REPAIRED VERTICAL CHORD PER SRM.SDR SWAA062571Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA061930Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA061863Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 22R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061311Connector · looseDURING SCHEDULED SERVICE CHECK, FOUND COCKPIT EMERGENCY EXIT LIGHT INOP. RESEATED LIGHT ASSY CONNECTOR PER MM.SDR SWAA060729Window · missingR2 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR VIEWER WINDOW MISSING. INSTALLED VIEWER WINDOW PER MM.SDR SWAA060576Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941.5, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA060456Wire · chafedAIR TURNBACK, SMOKE SMELL IN COCKPIT. FOUND WIRE 268-010-08 CHAFED AT CONNECTOR D13730, AFT OF P5 PANEL. SPLICED WIRE PER WDM.SDR SWAA060104Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 500B, STR 19L & STR 19R. REPAIRED BELTFRAME PER SWA EA'S.SDR SWAA060041Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED PRESSURE WEB CRACKED BETWEEN BS 663 TO BS 665, LBL 43. REPAIRED WEB PER SWA EA.SDR SWAA060032Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED BETWEEN BS 927 TO BS 947.5, RBL 13.8. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA060021Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR CUTOUT, FWD FRAME NR 4 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA060020Keelbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT KEEL BEAM LOWER CHORD CRACKED AT BS 542. REPAIRED KEEL BEAM PER SRM.SDR SWAA060019Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR CUTOUT, FWD FRAME NR 3 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA054172Strap · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BS 178 BULKHEAD VERTICAL STRAP CRACKED AT BL 0, WL 188. REPAIRED STRAP PER SWA EA.SDR SWAA054154Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 747, STR 20R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054132Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 747, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA054131Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727B, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054130Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA054129Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT E/E COOLING EXHAUST OUTLET INTERNAL DOUBLER, BS 373 AND BS 378, LBL 2.8. REPAIRED SKIN PER SWA EA.SDR SWAA054128Tee Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 AFT PRESSURE BLKHD UPPER T-CHORD CORRODED AT RBL 24.75. REMOVED AND REPLACED T-CHORD PER SRM.
Back to N688SW, cancelled Nov 16, 2012