N658SW, cancelled Mar 15, 2018
Service difficulty reports · 512
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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 SWAA072026Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072025Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 1112, RBL 20, WL 202. REPAIRED FRAME PER SRM.SDR SWAA072028Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072027Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071941Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071940Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071920Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071919Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 967, LBL 26 TO RBL 43. REMOVED AND REPLACED UPPER CHORD PER SRM.SDR SWAA071922Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT LEFT BS 616, WL 202. REPAIRED FRAME PER SRM.SDR SWAA071921Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT RIGHT BS 616, WL 202. REPAIRED FRAME PER SRM.SDR SWAA071918Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LEFT WING OUTBOARD AFT FLAP DELAMINATED UPPER INBOARD SURFACE. REPAIRED FLAP PER SRM.SDR SWAA070676Strip · wornDURING SCHEDULED C3 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 5 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA063197Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 360, LBL 10. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA063196Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 28L CORRODED AT BS 360. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA063195Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063194Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063193Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 511, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA063192Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 509, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA063185Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED BS 847, RBL 22. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063184Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 504A STR 10R. REPAIRED SKIN PER ER.SDR SWAA062856Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA061601Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA061134Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA061062Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 328, STR 22R. REPAIRED SKIN PER SWA EA.SDR SWAA061014Lens · crackedR1 DOOR UPPER EMERGENCY EXIT LIGHT LENS FRAME CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA060568Bushing · looseAIRFRAME VIBRATION, FOUND RT ELEVATOR TRIM TAB NR 1 HINGE BOLT LOOSE. REMOVED AND REPLACED NR 1 HINGE BUSHINGS AND PUSH RODS HARDWARE PER MM.SDR SWAA060512Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING INBD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA052761Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA051694Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS AT AFT CARGO DOOR HANDLE CUTOUT. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA051532Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 500D + 3, STR 12R. REPAIRED SKIN PER BFG ER.SDR SWAA042945Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 772, LBL 12, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA042046Keelbeam · corrodedDURING SCHEDULED C2 CHECK, FOUND LT AND RT KEEL BEAM AT RT BS 540, GROUND A/C DUCT CENTERLINE, CORRODED. REPAIRED RT & LT KEEL BEAM CHORDS PER EA.SDR SWAA041994Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EVAC SLIDE GIRT BAR CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE GIRT BAR CABLE PER MM.SDR SWAA041046Pressure Panel · crackedDURING SCHEDULED C1 CHECK, FOUND FORWARD TEE STIFFENER WEB AT NLG W/W CEILING CRACKED. REPAIRED WEB PER SRM.SDR SWAA041041Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040239Strip · crackedDURING SCHEDULED SPV, FOUND EEPLS PHOTO LUMINESCENT STRIP CRACKED AT RT, BS 833.45 TO BS 847.45. REMOVED AND REPLACED STRIP PER MM.SDR SWAA040075Light · inoperativeDURING SPV, FOUND R2 DOOR EMERGENCY EXTERIOR EXIT LIGHT INOP. REMOVED AND REPLACED R2 DOOR EMERGENCY EXIT LIGHT ASSEMBLY PER MM.SDR SWAA032770Strip · brokenDURING SCHEDULED C4 CHECK, FOUND AFT LEFT EEPLS STRIP BROKEN. REMOVED AND REPLACED EEPLS STRIP PER SRM.SDR SWAA031956Skin · crackedDURING SCHEDULED C3 CHECK, FOUND NR 5 L/E SLAT CRACKED NEAR OUTBD END. REPAIRED NR 5 L/E SLAT PER SWA EA.SDR SWAA031162Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030892Flashlight · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN LOWER EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED EMERGENCY FLASHLIGHT PER MM.SDR SWAA030349Skin · crackedDURING SCHEDULED CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT RADIUS OF EQUIPTMENT COOLING EXHAUST PORT, BS 378.5 AND LBL 2.8. REPAIRED SKIN PER SWA EA.SDR SWAA030131Blade · crackedDURING POST FLIGHT, FOUND NR 2 ENG FAN BLADES NR 2 CRACKED AND NR 4 TIP CURLED. REMOVED AND REPLACED NR 2 ENG FAN BLADES NR 2, NR 4, NR 21 AND NR 23 PER MM.SDR SWAA022461Ballast · shortedBEFORE DESCENT INTO LAX, ELECTRICAL SMELL DETECTED BETWEEN ROWS 17 AND 22. FOUND SIDEWALL LIGHT BALLAST SHORTED AT ROWS 20 AND 21 RT. REMOVED AND REPLACED BALLAST PER MM.SDR SWAA020757Cap · looseDURING SCHEDULED 1/4D CHECK, FOUND EEPLS END CAP LOOSE AT AFT CABIN. SECURED END CAP PER MM.SDR SWAA020731Stiffener · corrodedDURING SCHEDULED 1/2D CHECK, FOUND STIFFENER CORRODED AT BS 1088, RBL 30 ABOVE APU INTAKE CUTOUT. REPAIRED STIFFENER PER SRM.SDR SWAA020694Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR'S 14L AND 15L. REPAIRED SHEAR TIE PER SRM.SDR SWAA020693Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 578, STR 10L. REMOVED AND REPLACED TIE CLIP PER SRM.SDR SWAA020592Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, WL 228 AND RBL 17.1. REPAIRED WEB PER SRM.SDR SWAA020575Tie Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 947, STR 25R. REMOVED AND REPLACED TIE CLIP PER SRM.
Back to N658SW, cancelled Mar 15, 2018