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 SWAA022164Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727A + 17, WL 208 AND LBL 25. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA022163Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 747, BETWEEN STR 25R AND STR 26R. REPAIRED FRAME PER SRM.SDR SWAA022181Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 19L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA022162Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 460, RBL 2. REPAIRED FRAME PER SRM.SDR SWAA022097Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA022095Rib · crackedDURING SCHEDULED D CHECK, FOUND LT HORIZONTAL STABILIZER UPPER RIB CHORD CRACKED (2 EA) AT STA 166.30 AND STA 193.9. REPAIRED UPPER RIBS PER SRM.SDR SWAA022094Skin · bulgedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN BULGED AT BS 500D TO BS 526, STR 28L. REPAIRED SKIN PER SRM.SDR SWAA022053Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND PRESSURE BULKHEAD CRACKED (2 EA) AT BS 1016, STR 6R AND STR 6L. REPAIRED BULKHEAD PER SRM.SDR SWAA021967Web · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 616 AND BS 639, STR 17L. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA021471Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 820, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA020137Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER WHEN DOOR CLOSED. REINSTALLED SLIDE PER MM.SDR SWAA020128Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA013442Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 727D AND BS 727E, STR 20L. REPAIRED SKIN PER SRM AND SWA RA.SDR SWAA013441Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D + 8, STR 10R. REPAIRED SKIN PER SWA RA.SDR SWAA012979Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012806Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA012510Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012205Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT & RT MLG WALKING BEAM HANGER FITTINGS CORRODED. REMOVED AND REPLACED LT & RT HANGER FITTING'S PER ALM WORK CARDS & MM.SDR SWAA011448Skin · crackedDURING WALKAROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 963, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA011447Skin · crackedDURING WALKAROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 722, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA011446Skin · crackedDURING WALKAROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT STR 19R, BS 767, BS 759 AND BS 727D+3. REPAIRED SKIN PER SRM.SDR SWAA011426Skin · crackedDURING WALKAROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT UPPER RIGHT CORNER OF AFT CARGO BIN OPENING. REPAIRED SKIN PER SRM.SDR SWAA010158Battery · dischargedFWD SECTION OUTBOARD EMERGENCY FLASHLIGHT HAS LOW BATTERY INDICATION. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA002652Skin · crackedDURING SCHEDULED C4 CHECK, FOUND APPROX 4 EXTERNAL FUSELAGE SKIN CRACK AT BS 500D, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA002511Flashlight · inoperativeFORE & AFT VERTICAL FLASHLIGHTS INOP. R&R FLASHLIGHTS PER MM.SDR SWAA002453Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOP. R&R EXIT LIGHT ASSY PER MM.SDR SWAA002405Battery Pack · inoperativeDURING SCHEDULED RON CHECK, FOUND EEPLS INOP. REMOVED AND REPLACED EEPLS BATTERY PACK PER MM.SDR SWAA002360Battery · inoperativeAFT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA001671Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA001546Strap · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR LOWER HINGE CUTOUT STRAP CRACKED. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA001522Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 727E SHEAR TIE CRACKED NEXT TO KEEL BEAM, RBL 9. REPAIRED SHEAR TIE PER SRM.SDR SWAA001521Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD RT SIDE CHORD CRACKED, RBL 28. REMOVED AND REPLACED CHORD SECTION PER ACO.SDR SWAA001514Light · inoperativeDURING SCHEDULED 1/4D CHECK, FOUND EEPLS INOP AT MID CABIN. REMOVED AND REPLACED LAMP HOLDERS PER MM.SDR SWAA001507Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, RBL 28. REPAIRED BULKHEAD PER SRM.SDR SWAA001426Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP. REMOVED AND REPLACED BATTERY ASSY PER MM.SDR SWAA000299Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER WHEN DOOR CLOSED AT SLC AND AGAIN AT LAS. REINSTALLED FWD ENTRY DOOR SLIDE ASSY AFTER THE TWO INCIDENTS PER MM.SDR SWAA000307Cable · brokenDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR ATTACH CABLE ASSY BROKEN. REMOVED AND REPLACED CABLE ASSY PER MM.SDR SWAA000260Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA982995Skin · crackedDURING SCHEDULED SC CHECK, FOUND A 1 INCH FUSELAGE SKIN CRACK AT BS 867, AT S18R. REPAIRED PER BOEING SRM.SDR SWAA982970Skin · crackedDURING SCHEDULED BC4 CHECK, FOUND A 2.5 FUSELAGE SKIN CRACK AT BS 775, S23. REPAIRED PER BOEING SRM.SDR SWAA981549Intercostal · corrodedDURING SCHEDULED 1/2D CHECK, FOUND INTERCOSTAL CORRODED TOP AND BOTTOM SURFACE BETWEEN BS 986.5 AND 1006 LBL 15. REPAIRED PER BOEING SRM.SDR SWAA981546Tie Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED TIE CLIP AT BS 663 STR 10L. REPAIRED PER BOEING SRM.SDR SWAA981545Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED SHEAR TIE WEB AT BS 615 STR 15R AND BS 640 STR 15R. REPAIRED PER BOEING SRM.SDR SWAA981540Intercostal · corrodedDURING SCHEDULED 1/2D CHECK, FOUND INTERCOSTAL CORRODED BETWEEN BS 986.5 AND 1006 BL 0 AND BETWEEN BS 967 AND 986.5 LBL 17. REPAIRED PER BOEING SRM.SDR SWAA981538Intercostal · corrodedDURING SCHEDULED 1/2D CHECK, FOUND INTERCOSTAL CORRODED BETWEEN BS 967 AND 986.5 RBL 18. REPAIRED PER BOEING SRM.SDR SWAA981537Intercostal · corrodedDURING SCHEDULED 1/2D CHECK, FOUND INTERCOSTAL CORRODED BETWEEN BS 286.5 AND BS 1006 LBL 36. REPAIRED PER BOEING SRM.SDR SWAA981458Tie Down · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED CARGO TIE DOWN AT BS 854 RBL 14. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981456Angle · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND WEB UPPER ANGLE CRACKED AT BS 380 TO 400 BL 0. REPAIRED PER BOEING SRM.SDR SWAA981455Angle · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND SUPPORT ANGLE ON STRINGER 11L CRACKED AT BS 294 TO 305. REPAIRED PER BOEING SRM.SDR SWAA981454Bulkhead Panel · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND BULKHEAD PANEL AT BS 380 RT SIDE GOUGED AND CRACKED. REPAIRED PER BOEING SRM.
Back to N686SW, cancelled Feb 16, 2018