N686SW, cancelled Feb 16, 2018
Service difficulty reports · 388
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 = 'N686SW' AND deregistration_id = 'N686SW-2018-02-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 = 'N686SW' AND deregistration_id = 'N686SW-2018-02-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 SWAA053346Light · looseDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT LOOSE AT ROW 16 DEF. SECURED LIGHT ASSY PER MM.SDR SWAA052651Slide · out of limitsR1 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATED OUT OF LIMITS. REMOVED AND REPLAECD SLIDE PER MM.SDR SWAA051937Wire · brokenDURING SCHEDULED SPECIAL VISIT, FOUND AFT CABIN CENTER EMERGENCY EXIT SIGN WIRES BROKEN. REPAIRED WIRES PER SWPM & SOPM.SDR SWAA050840Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON STR 24L, BS 908. REPAIRED STRINGER PER SRM.SDR SWAA050824Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON SHEAR TIE AT BS 747, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA050794Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 445, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA050793Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE WEB CRACKED AT BS 1016 BULKHEAD, 1 O'CLOCK POSITION. REPAIRED WEB PER SWA EA.SDR SWAA050792Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 375, ABOVE STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA050791Floor Support · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL BEAM UPPER T-CHORD CRACKED AT BS 660.5, BL 0. REPAIRED T-CHORD PER SWA EA.SDR SWAA050790Stringer Clip · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON STRINGER CLIP AT BS 767, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA050789Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON STR 25L, BS 767. REPAIRED STRINGER PER SRM.SDR SWAA050769Frame · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO BELTFRAME CORRODED AT BS 887, LBL 1. REPAIRED BELTFRAME PER SRM.SDR SWAA050768Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 787, STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050750Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR SKIN CRACKED AT UPPER DOOR HINGE CUTOUT. REPAIRED SKIN PER SRM & SWA ACO.SDR SWAA050749Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 760, BELOW STR 18R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA050731Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 664.5, BETWEEN LBL 30.5 TO LBL 32.0. REPAIRED WEB PER SRM.SDR SWAA050453Lens · brokenDURING SCHEDULED C3 CHECK, FOUND R2 DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS, BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA050452Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS FROM BS 500D, BS 520, STRINGER 12R. REPAIRED SKIN PER EA.SDR SWAA050189Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 482, STRINGER 10R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042284Bulkhead · crackedDURING SPV, FOUND BS 1016, BULKHEAD WEB AT STR 7R AND STR 8R, CRACKED. REPAIRED BULKHEAD WEB PER EA.SDR SWAA042233Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA042232Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 500, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041895Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 316, STRINGER 18R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041894Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 513, STRINGER 10L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041873Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 513, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041251Wedge · debondedDURING SCHEDULED C4 CHECK, FOUND LT WING INBOARD MID FLAP T/E WEDGE PANEL DISBONDED. REMOVED AND REPLACED LT WING INBOARD MID FLAP PER MM.SDR SWAA041250Wedge · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 6 L/E SLAT UPPER WEDGE PANEL DELAMINATED. REMOVED AND REPLACED NR 6 L/E SLAT PER MM.SDR SWAA041249Wedge · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 5 L/E SLAT UPPER WEDGE PANEL DELAMINATED. REMOVED AND REPLACED NR 5 L/E SLAT PER MM.SDR SWAA041248Wedge · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 4 L/E SLAT UPPER WEDGE PANEL DELAMINATED. REMOVED AND REPLACED NR 4 L/E SLAT PER MM.SDR SWAA040556Slide · unserviceableR2 DOOR EVAC SLIDE LOW PRESSURE INDICATION. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040148Skin · crackedDURING SCHEDULED C3 CHECK, FOUND SKIN CRACKED BETWEEN BS 500C TO BS 500D, ABOVE STRINGER 10L. REPAIRED SKIN CRACK PER SRM.SDR SWAA032188Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) BS 780, STR 18L AND STR 18 R. REPAIRED SKIN PER SRM.SDR SWAA031579Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 4R, BS 697 AT BS 717. REPAIRED SKIN PER SRM.SDR SWAA030626Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED ( 3 EA ) AT BS 500 + 4 @ STR 10R, BS 500A @ STR 10R & BS 500D + 10 BETWEEN STR 10L & STR 13L. REPAIRED SKIN PER SRM.SDR SWAA022899Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA022898Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 735, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA022383Keelbeam · corrodedDURING SCHEDULED D CHECK, FOUND KEEL BEAM CORRODED AT BS 727, STR 27L. REPAIRED KEEL BEAM PER SRM.SDR SWAA022358Keelbeam · corrodedDURING SCHEDULED D CHECK, FOUND KEEL BEAM CORRODED FROM BS 690 TO BS 722, RBL 8. REPAIRED KEEL BEAM PER SRM.SDR SWAA022254Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500D, STR 27L. REPAIRED FRAME PER SRM.SDR SWAA022253Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 787, WL 148 AND BL O. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA022234Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA022213Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, STR 27L. REPAIRED FRAME PER SRM.SDR SWAA022212Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (4 EA) BETWEEN STR 8R AND STR 9R, BS 440, BS 480, BS 747 AND BS 827. REPAIRED FRAMES PER BFG ER.SDR SWAA022211Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (6 EA) BETWEEN STR 8L AND STR 9L, BS 480, BS 727, BS 807, BS 847, BS 867 AND BS 887. REPAIRED FRAMES PER BFG ER.SDR SWAA022210Splice · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA022209Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAMS CRACKED (2 EA) BETWEEN BS 706 AND BS 711, WL 202 AT RBL 25 AND LBL 25. REPAIRED FLOORBEAMS PER BFG ER.SDR SWAA022184Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 312, STR 5L. REPAIRED FRAME PER SRM.SDR SWAA022183Splice · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA022185Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 20R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA022182Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, WL 208 AND RBL 2. REPAIRED FLOORBEAM PER BFG ER.
Back to N686SW, cancelled Feb 16, 2018