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 SWAA030696Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED (3 EA) AT BS 750 AT STR 19R, BS 755 AT STR 21R AND BS 763 AT STR 19R. REPAIRED SKIN PER SRM.SDR SWAA030511Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEB CRACKED AT WL 201, AT LBL 4.75, RBL 4.75, WL 209, AT LBL 4.75 AND WL 234, AT RBL 12. REPAIRED WEB PER SRM.SDR SWAA030230Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDES GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA022982Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY PER MM.SDR SWAA022517Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 24L, BS 727E AND BS 737. REPAIRED SKIN PER SRM.SDR SWAA022190Duct Clamp · leakingDECLARED EMERGENCY, DIVERSION, DURING CLIMB LOST CABIN PRESSURATION, MASKS DEPLOYED. FOUND DUCT AT AFT MLG W/W LEAKING. TIGHTENED CLAMP PER MM.SDR SWAA021593Battery · dischargedDURING SCHEDULED C3 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT IN AFT CEILING INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PER MM.SDR SWAA021594Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021488Actuator · failedAIR TURNBACK, AFTER TAKEOFF NR 2 KRUEGER FLAP WOULD NOT RETRACT. REMOVED AND REPLACED NR 2 KRUEGER FLAP ACTUATOR PER MM.SDR SWAA021342Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA012765Slat · crackedDURING SCHEDULED C4 CHECK, FOUND # 2 L/E SLAT CRACKED .75 INCH LONG AT INBD LOWER T/E. REPAIRED # 2 SLAT PER SWA RA 1-357-1114.SDR SWAA012767Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACK (2 EA) AT BS 727E, STR 18R & BS 747, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA011581Lens · missingDURING SCHEDULED SERVICE CHECK, FOUND OVERHEAD BIN BULL NOSE EMERGENCY EXIT LENS MISSING AT RT OVERWING EXIT. REPLACED BULL NOSE LIGHT ASSY PER MM.SDR SWAA010882Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 1.5 INCH LONG EXTERNAL FUSELAGE SKIN CRACK AT BS 727E, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA010405Stiffener · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 663 VERTICAL STIFFENERS CRACKED AT LBL 6.5 & RBL 6.5. REMOVED AND REPLACED VERTICAL STIFFENERS PER SRM.SDR SWAA010290Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STR 27L CORRODED FROM BS 500B TO BS 500D. REPAIRED STR PER SRM & ER.SDR SWAA010289Keelbeam · corrodedDURING SCHEDULED D-CHECK, FOUND KEEL BEAM CORRODED AT BS 721, RBL 7 & BS 500D, LT SIDE. REPAIRED KEEL BEAM PER ER''S & SRM.SDR SWAA010264Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD VERTICAL BEAM CRACKED AT RBL 17.1, WL 191. REPAIRED VERTICAL BEAM PER ER.SDR SWAA010255Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, BETWEEN STR 1L & 2L. REPAIRED FRAME PER SRM.SDR SWAA010254Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, BETWEEN STR 8R & 9R. REPAIRED FRAME PER ER.SDR SWAA010253Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, RBL 68, WL 268. REPAIRED FRAME PER ER & SRM.SDR SWAA010252Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 787 & 727C, BETWEEN STR 8R & 9R, BS 767& 827 BETWEEN STR 8L & 9L, & BS 887, BETWEEN STR 8L & 9L. REPAIRED FRAMES PER ER & SRM.SDR SWAA010251Splice · crackedDURING SCHEDULED D-CHECK, FOUND STR SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STR SPLICE PER SRM & T1-A51-002.SDR SWAA010250Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGERS CRACKED AT BS 400, STR 4R, BS 440, STR 16L. REPAIRED STRINGERS PER SRM.SDR SWAA010249Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT BS 400, STR 4R, BS 440, STR 16L, BS 616, STR 5L & BS 727C, STR 3L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA010244Keelbeam · corrodedDURING SCHEDULED D-CHECK, FOUND KEEL BEAM CORRODED AT BS 723, LBL 7. REPAIRED KEEL BEAM PER ER.SDR SWAA010243Beam · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD VERTICAL BEAMS CRACKED AT LBL 17.1, WL 184 & RBL 5.7, WL 184. REPAIRED VERTICAL BEAMS PER ER.SDR SWAA010248Rib · crackedDURING SCHEDULED D-CHECK, FOUND LT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN S-2 & S-3. REPAIRED RIB LOWER CHORD PER ER.SDR SWAA010235Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND RT MLG STABILIZER BEAM FITTING CORRODED. REMOVED AND REPLACED STABILIZER FITTING PER MM.SDR SWAA010200Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT BS 727, STR 6R, BS 727A STR 3R, 727C STR 5R & STR 6R, BS 727D, STR 1, STR 2L, STR 5L/R, STR 6L, STR 7L, STR 8L & STR 9L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA010199Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CORRODED FROM BS 950 TO BS 996, RBL 48 TO RBL 52. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA010198Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT BS 500A, STR 16L, BS 380, STR 1, BS 277 STR 15R & BS 616, STR 8L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA010197Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STR CRACKED AT BS 400, STR 4L. REPAIRED STR PER SRM.SDR SWAA010196Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BRACKET CORRODED. REMOVED AND REPLACED GIRT BRACKET PER SRM.SDR SWAA010172Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIP CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA010148Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STR 14L CRACKED AT BS 360, WL 230. REPAIRED STR PER SRM.SDR SWAA010149Splice · crackedDURING SCHEDULED D-CHECK, FOUND STR SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA010087Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BL 0, WL 148. REPAIRED SHEAR TIE PER SRM.SDR SWAA010071Stringer · crackedDURING SCHEDULED D-CHECK, FOUND 2 STRINGERS CRACKED AT BS 381, STR 4L & BS 420, STR 4L. REPAIRED STRINGERS PER SRM.SDR SWAA002292Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND LT WING I/B TRAILING EDGE AFT FLAP DELAMINATED AT O/B TRAILING EDGE.SDR SWAA001175Battery · dischargedDURING SCHEDULED SPECIAL VISIT, FOUND AFT UPPER EMERGENCY FLASHLIGHT BATTERY LOW. R&R FLASHLIGHT BATTERY PER MM.SDR SWAA000214Battery · dischargedAFT LOWER EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA991940Wire · failedABORTED TAKEOFF, TAKE-OFF WARNING HORN SOUNDED AND NR 4 L/E FLAP TRANSIT LIGHT INOP. REPAIRED WIRING CONNECTING TO NR 4 L/E FLAP DOWN POS INDICATOR SWITCH PER MM.SDR SWAA991823Transmitter · erraticAIR TURNBACK, AFTER TAKEOFF T/E FLAPS WOULD NOT FULLY RETRACT. REPAIRED WIRE AT 5C ON FLAP ASYMMETRY SWITCH. REMOVED AND REPLACED FLAP POSITION INDICATOR. REMOVED AND REPLACED R123 RELAY AND REMOVED AND REPLACED RT FLAP TRANSMITTER PER MM.SDR SWAA991235Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT AILERON TAB DELAMINATED INBD OF PUSHRODS. REMOVED AND REPLACED AILERON TAB PER MM.SDR SWAA983070Overheat Loop · inopDURING DESCENT, RT WING OVERHEAT LIGHT ILLUMINATED, PERFORMED QRH ITEMS AND LIGHT REMAINED ON UNTIL AFTER ENG SHUT DOWN. OPENED AND INSPECTED A/C BAY AND L/E FLAP AREA, FOUND NO LEAKS. RECLOSED A/C BAY DOOR. REPLACED M488 ENG/PYLON LOOP PER M/M.SDR SWAA982067Web · damagedDURING SCHEDULED 1/4 D-CHECK, FOUND WEB DAMAGED AT FWD LOWER CORNER OF AFT CARGO DOORWAY. REPAIRED PER TII-A53-35.SDR SWAA982044Floorbeam · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND CORRODED FLOORBEAM AND SEVERAL HOLES AT BS 770, RBL 3. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982043Angle · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND FWD BULKHEAD DIAGONAL SUPPORT CRACKED AT BS 727, BL 0. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982042Bow Tie · wornDURING SCHEDULED 1/4 D-CHECK, FOUND LT BOW TIE WORN. REMOVED AND REPLACED PER BOEING SRM.
Back to N688SW, cancelled Nov 16, 2012