N697SW, cancelled Oct 5, 2019
Service difficulty reports · 430
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 = 'N697SW' AND deregistration_id = 'N697SW-2019-10-05' 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 = 'N697SW' AND deregistration_id = 'N697SW-2019-10-05' 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 SWAA091989Door Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR LOWER FRAME AT LOWER STOP CRACKED. REMOVED AND REPLACED R1 FRAME PER MM.SDR SWAA091988Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA086765Motor · faultyDURING SCHEDULED OTS CHECK, FOUND NR 1 ENG UNABLE TO MAKE CLIMB POWER. REMOVED AND REPLACED VBV GEAR DRIVE MOTOR ASSY PER MM.SDR SWAA081326Slide · out of adjustDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081325Slide · low pressureDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA08041Cable · frayedDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED EVAC SLIDE CABLE PER MM.SDR SWAA080965Rod End · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT ELEVATOR TAB CONTROL ROD ENDS CORRODED. REMOVED AND REPLACED ROD ENDS PER MM.SDR SWAA080966Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CRACKED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA080944Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT WING OUTBOARD FORE FLAP TRACK ATTACH FITTING CORRODED.SDR SWAA080839Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 125. REPAIRED SKIN PER ER.SDR SWAA080849Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 500, STR 20L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080848Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 500, STR 18L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080847Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 19L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080846Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 807, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080845Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA080844Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA080843Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 19R. REPAIRED FRAME PER SRM.SDR SWAA080842Cable · frayedDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA080840Fitting · looseDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA080836Carriage · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP NR 2 CARRIAGE LOWER SPINDLE CORRODED. REMOVED AND REPLACED CARRIAGE PER MM.SDR SWAA080841Fitting · looseDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA080821Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT AND LT HORIZONTAL STABILIZER FITTING CLEVIS LUG FACES CORRODED. REPAIRED FITTING PER SRM.SDR SWAA080680Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, BETWEEN STR 2R AND STR 3R. REPAIRED FRAME PER SRM.SDR SWAA080679Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 13L. REPAIRED FRAME PER SRM.SDR SWAA080678Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 410, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080677Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 500, STR 24R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080676Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 967, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080675Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 986, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080674Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 947, STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080667Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080668Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080669Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080542Stiffener · crackedDURING SCHEDULED 16Y CHECK, FOUND LT HORIZONTAL STABILIZER VERTICAL STIFFENER CRACKED AT STA 120. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA080544Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 22L CRACKED AT BS 505. REPAIRED STRINGER PER SRM.SDR SWAA080543Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080521Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080444Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 15R. REPAIRED SHEAR TIE PER SRM.SDR SWAA080445Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 9R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA080446Slat · crackedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 6 L/E SLAT CRACKED AT OUTBOARD T/E EDGE. REPAIRED SLAT PER SRM.SDR SWAA080344Bushing · corrodedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL FIN LT REAR SPAR FITTING LUG BUSHING CORRODED. REMOVED AND REPLACED BUSHING PER BOEING DRAWING.SDR SWAA080345Bushing · corrodedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL FIN LEFT REAR SPAR FAIL SAFE FITTING LUG BUSHING CORRODED. REMOVED AND REPLACED BUSHING PER BOEING DRAWING.SDR SWAA080334Flap · debondedDURING SCHEDULED 20Y CHECK, FOUND RT WING FORE FLAP T/E DISBONDED. REPAIRED FLAP PER SRM.SDR SWAA080281Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, LBL 65. REPAIRED FRAME PER SRM.SDR SWAA080280Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 65. REPAIRED FRAME PER SRM.SDR SWAA080246Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA080245Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA080220Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 417, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080154Tab · debondedDURING SCHEDULED 20Y CHECK, FOUND LT WING AILERON BALANCE TAB T/E DISBONDED. REPAIRED TAB PER SRM.SDR SWAA080001Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 616 TO BS 639, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080055Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING INBOARD MID FLAP DELAMINATED AT T/E. REPAIRED FLAP PER SRM.
Back to N697SW, cancelled Oct 5, 2019