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 SWAA054127Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD WEB CRACKED AT BL 0, WL 189. REPAIRED WEB PER SRM.SDR SWAA054126Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 734, STR 27L. REPAIRED STRINGER PER SWA EA.SDR SWAA054073Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054072Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054071Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 360, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA054070Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED PRESSURE WEB CRACKED BETWEEN BS 663 TO BS 665, LBL 32. REPAIRED WEB PER SWA EA.SDR SWAA054069Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER SWA EA.SDR SWAA054068Girt Bar · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD BRACKET CORRODED AT BS 312, LBL 56. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA054057Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND NLG W/W RIGHT FWD SIDE PRESSURE PANEL CRACKED AT BS 243.7, WL 168.5. REPAIRED WEB PER SWA EA.SDR SWAA054056Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND NLG W/W LEFT FWD SIDE PRESSURE PANEL CRACKED AT BS 240, WL 168.6. REPAIRED WEB PER SWA EA.SDR SWAA054055Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA054054Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, BETWEEN STR 20L TO STR 23L. REPAIRED SKIN PER SRM.SDR SWAA054053Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 12L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054031Keelbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT KEEL BEAM CORRODED AT BS 727. REPAIRED KEEL BEAM PER SRM.SDR SWAA054030Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847, BETWEEN STR 23L TO STR 24L. REPAIRED SKIN PER SRM.SDR SWAA054017Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA054016Floor Support · crackedDURING SCHEDULED D-CHECK, FOUND NR 3 LONGITUDINAL FLOORBEAM UPPER T-CHORD CRACKED AT BS 662, RBL 24.82. REPAIRED FLOORBEAM IAW EA.SDR SWAA054015Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOOR BEAM CORRODED AT BS 986.5, RBL 45. REMOVED AND REPLACED FLOORBEAM UPPER T-CHORD IAW SRM.SDR SWAA053775Light · wornDURING SCHEDULED C3 CHECK, FOUND EEPLS STRIP WORN AT ROW 1 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA053774Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 789, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA053773Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 739D TO BS 739E, STR 23L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA053772Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 504C, STR 15R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA053240Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 740, STR 18R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053239Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730, STR 18R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053238Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 741, STR 19R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053237Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 514, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA053236Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 12R. REPAIRED SKIN PER SWA EA.SDR SWAA052335Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, BL 0. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA051316Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 178 BULKHEAD, RBL 17.1, WL 225. REPAIRED WEB PER SRM.SDR SWAA050873Window · arcedARCING OBSERVED ON L1 COCKPIT WINDOW IN TOP RT CORNER. WINDOW HEAT SWITCHED OFF. OUTER PANE L1 COCKPIT WINDOW CRACKED. REMOVED AND REPLACED L1 COCKPIT WINDOW AND HEAT CONTROLLER.SDR SWAA043338Slide · out of adjustL1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA042907Skin · corrodedDURING SCHEDULED SERVICE CHECK, FOUND KEEL BEAM SKIN AT BS 500, CORRODED. REMOVED AND REPLACED SKIN SECTION PER EA.SDR SWAA042881Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 4 EACH FUSELAGE SKIN CRACKS AT BS 747, BS 755, STRINGER 24L, BS 727D, STRINGER 22R, BS 747, STRINGER 18R. REPAIRED SKIN PER EA AND SRM.SDR SWAA042880Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 500D, BS 520, STRINGER 12L.SDR SWAA042870Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND LT WING INBOARD T/E FOREFLAP DELAMINATED. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA042612Engine · vibrationAT CLIMB POWER, NR 2 ENGINE HAD VIBRATION AND HUM-VIBRATION METER AT 5.0, REDUCING N1 TO 83 PERCENT VIBRATION METER WAS AT 4.0, AND HUM-VIBRATION METER SLIGHTLY LOWER. HUM-VIBRATION ONLY WENT AWAY WITH N1 BELOW 48 PERCENT. REMOVED AND REPLACED NR 2 ENGINE PESDR SWAA041952Lamp · inoperativeDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED EMERGENCY EXIT LIGHT PER MM.SDR SWAA041328Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 970, STRINGER 21L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040737Bracket · missingDURING PREFLIGHT CK, FOUND L1 DOOR EVACUATION SLIDE GIRT BAR AFT MOUNTING FLOOR BRACKET MISSING. INSTALLED BRACKET PER MM.SDR SWAA040601Glowstrip · missingPHOTOLUMINESCENT STRIP MISSING FROM ROW 6 TO ROW 8 LT SIDE. REINSTALLED NEW SECTION OF STRIP.SDR SWAA040297Battery Pack · dischargedDURING SCHEDULED SPECIAL VISIT AT SAT AEROSPACE, FOUND OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 2 DEF. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA040296Battery Pack · dischargedDURING SCHEDULED SPECIAL VISIT AT SAT AEROSPACE, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA032808Skin · crackedDURING SCHEDULED PMC CHECK, FOUND 2 FUSELAGE SKIN CRACKS AT BS 727E+3, STR 22L AND BS 727E+17, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA031893Lens · crackedDURING SCHEDULED C3 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED EXIT LIGHT LENS PER MM.SDR SWAA031894Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031497Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT UPPER FWD CORNER OF AIRSTAIR CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA031496Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED ON FO'S FWD WINDOW POST. REPAIRED SKIN PER SRM.SDR SWAA031488Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LT KEEL BEAM CORRODED BETWEEN BS 650 AND BS 663. REPAIRED KEEL BEAM PER SRM.SDR SWAA031354Controller · failedCABIN PRESSURE ALTITUDE WARNING HORN SOUNDED AT 35K, INITIATED PROCEDURES WITH EMERGENCY DESCENT. FOUND, PRESSURE CONTROLLER FAILURE. REMOVED AND REPLACED PRESSURE CONTROLLER PER MM.SDR SWAA030738Pin · corrodedDURING SCHEDULED SERVICE CHECK, SWA SI 11251-32, FOUND BOTH LT AND RT MLG TRUNNION PINS CORRODED. REMOVED AND REPLACED BOTH LT AND RT MLG TRUNNION PINS PER MM.
Back to N688SW, cancelled Nov 16, 2012