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 SWAA981453Stringer · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED STRINGER 25L AT BS 850 LBL 23, BS 871, BS 864 AND STR 28L BS 503. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981452Tie Down · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED HOLE IN CARGO TIE DOWN AT BS 867 RBL 14. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981451Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORROSION AROUND HOLE IN FLOORBEAM AT BS 907 RBL 8. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981450Stringer · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED STRINGER 25L BS 787 TO 791. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981449Web · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED SURFACE WEB FROM BS 794 TO 847 RBL 25. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981448Tiedown · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED CARGO TIE DOWN AT BS 787 RBL 14, BS 792 TO 847 RBL 21 AND BS 792 RBL 14. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981446Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM EXFOLIATED BETWEEN AT BS 792 TO 827. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981445Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM AT BS 772 RBL 12, BS 774 RBL 3 AND BS 747-767 RBL 3. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981444Angle · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CRACKED ANGLE BELOW TORQUE BOX FWD I/B CORNER. REPAIRED PER BOEING SRM.SDR SWAA981443Web · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED WEB AFT OF DOOR CUTOUT AT BS 847 RBL 25. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981442Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORROSION AROUND HOLE IN FLOORBEAM AT BS 844 RBL 8 AND AT BS 844 RBL 3. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981441Floorbeam · corrodedDURING SCHEDULED 1/2 D CHECK, FOUND CORRODED FLOORBEAM AT BS 837 STR 25L LBL 22. REMOVED AND REPLACED PER BOEING MM.SDR SWAA981440Floorbeam · corrodedDURING SCHEDULED 1/2 D CHECK, FOUND CORRODED FLOORBEAM AT BS 827-847 RBL 14. REMOVED AND REPLACED PER BOEING MM.SDR SWAA981439Light · brokenDURING SCHEDULED 1/2 D CHECK, FOUND EMERGENCY LIGHT LENSE OVER AFT ENTRY DOOR BROKEN. REMOVED AND REPLACED PER BOEING MM.SDR SWAA981438Floorbeam · corrodedDURING SCHEDULED 1/2 D CHECK, FOUND CORROSION IN AND AROUND SCREW HOLES AT FLOORBEAM BS 947.5 RBL 3 TO NR 3 SEAT TRACK. REPAIRED PER BOEING MM.SDR SWAA981425Intercostal · corrodedDURING SCHEDULED 1/2D CHECK, FOUND INTERCOSTAL AT BS 950 POS 25-40L CORRODED AND WORN SCREW HOLES; BS 950 POS 18L-20L AND BS 947-967 POS 17L. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981424Bulkhead · damagedDURING SCHEDULED 1/2D CHECK, FOUND FWD LAV FWD BULKHEAD COMPOSITE DAMAGED SEVERAL AREAS. REPAIRED PER BOEING SRM.SDR SWAA981422Intercostal · corrodedDURING SCHEDULED 1/2D CHECK, FOUND INTERCOSTAL CORRODED AT FLOOR PANEL HOLES LBL 11 AT BS 294.5 TO 312. REPAIRED PER BOEING SRM.SDR SWAA981421Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND UPPER FLANGE OF FLOORBEAM CORRODED AT PANEL HOLES TOP AND BOTTOM AT BS 312 LBL 15 TO RBL 22. REPAIRED PER BOEING SRM.SDR SWAA981419Intercostal · crackedDURING SCHEDULED 1/2D CHECK, FOUND LWR FLOOR BEAM FLANGE INTERCOSTAL CRACKED, LBL 12 AT BS 312 ON INBD AND O/B EDGES, AND LBL 12 AT BS 328 O/B EDGE. REPAIRED PER BOEING SRM.SDR SWAA981418Intercostal · corrodedDURING SCHEDULED 1/2D CHECK, FOUND INTERCOSTAL CORRODED AT FLOOR PNL HOLES AT LBL 11 BS 277 TO 294.5. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981034Skin · crackedDURING SCHEDULED C2 CHECK, FOUND CRACKED BOTTOM SKIN OF NR 1 SLAT IN ACTUATOR AREA. REPAIRED PER BOEING NR T1-A57-015.SDR SWAA980731Fire Loop · failedDURING WALKAROUND CHECK, FOUND NR 2 ENG FIRE LOOP WILL NOT TEST. REMOVED AND REPLACED NR 2 ENG FIRE LOOP UNIT PER BOEING MM.SDR SWA980558Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND R-2 EXTERIOR EMERGENCY LIGHT AND L-2 INTERIOR EMERGENCY LIGHT INOP. REPLACED BATTERY PACK PER BOEING MM.SDR SWA980218Web · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND RT 18 A WEB AT BS 727 HAS CRACK AT I/B FASTENER HOLE. REPAIRED PER SWA RA 1-353-1767.SDR SWAA980187Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORRODED AT BS 862, RBL 14. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980180Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 14. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980175Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION IN AND AROUND FLOORBEAM HOLE AT BS 857, RBL 14. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980174Floorbeam · exfoliatedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM IS EXFOLIATED BETWEEN BS 792 AND 872. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980036Slide · deployedAT GATE, FWD SERVICE DOOR SLIDE ACCIDENTALLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR SWAA970089Skin · crackedDURING SCHEDULED TERMINAL CHECK, FOUND A 1.75 INCH CRACK IN FUSELAGE SKIN AT BS 727B AT S16L. REPAIRED PER BOEING SRM.SDR SWAA961444Skin · dentedDURING SCHEDULED CHECK, FOUND FUSELAGE SKIN DENTED ABOVE AND SLIGHTLY AFT OF R2 DOOR CUTOUT. REPAIRED PER SWA RA 1-353-1576.SDR SWAA960956Engine · bird strikeEXPERIENCED BIRD STRIKE TO NUMBER 1 ENGINE AFTER TAKEOFF, ACCOMPANIED BY EGT RISE AND ODOR IN CABIN. AIRCRAFT RETURNED TO OAK AND HAD AN UNEVENTFUL LANDING. PERFORMED BIRD STRIKE INSPECTION PER BOEING M/M, NO DEFECTS NOTED. ENGINE PLACED ON 10 CYCLE BORESCSDR SWAA960702Line · rupturedAFTER TAKEOFF, NOSE GEAR WOULD NOT RETRACT. RECYCLED GEAR, NO HELP. RETURNED TO BHM AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND HYDRAULIC FLUID AROUND SWIVEL. REMOVED AND REPLACED RETRACT LINE TO LOCK ACTUATOR, RESERVICED SYSTEM, AND RETRACTION TESSDR SWAA96688Hyd Hose · leakingAFTER TAKEOFF, NOSE GEAR WOULD NOT RETRACT. AIRCRAFT RETURNED TO BHM AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND NOSE GEAR MAIN ACTUATOR HYD HOSE LEAKING. REPLACED PER BOEING M/M.SDR SWAA960106Belt Frame · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND BELT FRAME CRACKED AT BS 807 BL 0. REPAIRED PER BOEING SRM.SDR SWAA950656Post · crackedDURING SCHEDULED CHECK, FOUND CAPTAIN'S NUMBER 1 WINDOW POST CRACKED .156 INCH. REPAIRED PER SWA RA 1-A53-1156.SDR SWAA0659Post · crackedDURING SCHEDULED B/C CHECK, FOUND CAPTAIN'S NUMBER 1 WINDOW POST CRACKED .156 INCH. REPAIRED PER RA 1-A53-1156.
Back to N686SW, cancelled Feb 16, 2018