N689SW, cancelled Mar 16, 2018
Service difficulty reports · 360
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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-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 SWAA021768Slide · unserviceableDURING SCHEDULED RON, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020277Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED 1.5 INCHES LONG AT BS 727D+10, STR 19R. REPAIRED SKIN PER SRM..SDR SWAA020272Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA020258Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 745, ABOVE STR 21L. REPAIRED SKIN PER SRM.SDR SWAA012957Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA012949Lens · looseDURING SCHEDULED C4 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA012911Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 360, BETWEEN STR'S 28L & 28R. REPAIRED SHEAR TIE PER SRM & BFG ER 01-0911.SDR SWAA012904Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, BETWEEN STR 8R & 9R. REPAIRED FRAME PER BFG ER 01-0885.SDR SWAA012907Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. R&R SHEAR TIE PER BFG ER 01-0908.SDR SWAA012906Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 987, RBL 21 TO RBL 44, WL 208. REPAIRED FLOORBEAM PER BFG ER 01-0891.SDR SWAA012883Keelbeam · corrodedDURING SCHEDULED D-CHECK, FOUND RT KEEL BEAM CORRODED AT BS 540. REPAIRED KEEL BEAM PER BFG ER 01-0905.SDR SWAA012882Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 1018, RBL 1 & WL 191. REPAIRED FRAME PER SRM.SDR SWAA012881Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 847, RBL 2 & WL156. R&R SHEAR TIE PER SRM.SDR SWAA012856Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 7 EA ) BETWEEN STR 8L & 9L, BS 807, 827, 847, 867, 907, 887 & 480. REPAIRED FRAMES PER BFG ER.SDR SWAA012855Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 4 EA ) BETWEEN STR 8R & 9R, BS 440, 480, 827 & 887. REPAIRED FRAMES PER BFG ER.SDR SWAA012833Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 1018, LBL 1 & WL 191. REPAIRED FRAME PER SRM.SDR SWAA012820Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (4 EA) AT BS 597, STR 7L & STR 8R, BS 767, STR 10L, BS 706, STR 10L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA012812Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 987, RBL 51 & WL 199. R&R SHEAR TIE PER SRM.SDR SWAA012793Web · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 637, STR 17R. R&R WEB SECTION PER SRM.SDR SWAA012795Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 967, LBL 2 & WL 171. REPAIRED FRAME PER SRM.SDR SWAA012788Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA012786Web · corrodedDURING SCHEDULED D CHECK, FOUND WEB CORRODED AT BS 296, RBL 50 & WL 208. REPAIRED WEB PER MM.SDR SWAA012778Web · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 637, STR 17L. R&R WEB PER SRM.SDR SWAA012787Splice · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER SPLICE AT BS 907, STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA012777Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 1006, LBL 9 & WL 208. REPAIRED FLOORBEAM PER SRM.SDR SWAA011722Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA011558Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED EMERGENCY EVAC GIRT ASSY PER MM.SDR SWAA010869Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND NR 2 L/E SLAT SKIN DISBONDED. REMOVED AND REPLACED NR 2 SLAT PER MM.SDR SWAA010817Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AND DOUBLER CRACKED AT FWD ENTRY DOOR LOWER AFT CUTOUT CORNER. REPAIRED SKIN AND DOUBLER PER SWA RA.SDR SWAA010816Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 2.5 INCH LONG CRACK AT RT HORIZ STAB SKIN, BS 147.90, REAR SPAR. REPAIRED SKIN PER SRM.SDR SWAA002712Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 4.5 EXTERNAL FUSELAGE SKIN CRACK AT BS 897, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA002686Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA. BS 178 BULKHEAD WEB CRACKS AT WL 230, LBL 17.1 & RBL 17.1. REPAIRED BULKHEAD PER SRM.SDR SWAA002517Skin · crackedDURING SCHEDULED C1 CHECK, FOUND NR 5 L/E SLAT SKIN CRACKED AT LOWER SURFACE, AFT RIVET ROW, OTBD DETENT CUTOUT. REPAIRED SLAT PER SRM.SDR SWAA002519Slide · unserviceableDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY WORN. R&R EVAC SLIDE ASSY PER MM.SDR SWAA002518Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001930Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING OTBD T/E FLAP DELAMINATED. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA001596Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 727E, STR 25R, BS 727D, STR 25L AND BS 747, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA001258Bushing · wornAIRFRAME VIBRATION FELT ABOVE 250 KNOTS. MX FERRY TO HOU AND FOUND LT ELEV I/B TAB HINGE BOLTS AND BUSHINGS WORN. REMOVED AND REPLACED LT ELEV TAB AND I/B ATTACH FITTING BUSHINGS AND BOLT PER MM.SDR SWAA000850Actuator · inoperativeRIGHT MLG HAD AN UNCOMMANDED EXTENSION DURING CLIMB. GEAR HANDLE PLACED IN UP POS AND GEAR REMAINED RETRACTED THROUGH OUT THE FLIGHT. REMOVED AND REPLACED RIGHT MLG UPLOCK ACTUATOR PER MM.SDR SWAA000079Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE EXTERNAL SKIN HAS 2 EACH CRACKS, STRINGER 19R, BS 747 AND BS 757. REPAIRED SKIN PER SRM.SDR SWAA991942Line · rupturedAIR TURNBACK, NLG FAILED TO RETRACT DURING TAKEOFF. FOUND RUPTURED NLG DOWNLOCK ACTUATOR HYDRAULIC PRESS LINE. REMOVED AND REPLACED LINE PER MM.SDR SWAA991906Web · crackedDURING SCHEDULED RON, NLG WEB CRACKED INBD AFT RADIUS OF LT SIDE ACCESS PANEL. REMOVED AND REPLACED WEB ASSY PER TR NR T1-253-001.SDR SWAA991407Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, UT INSPECTION INDICATES 5 EACH CRACKS ON BS 178 BULK HEAD, RBL 5 - LBL 57. REPAIRED BULKHEAD PER SRM.SDR SWAA991387Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR UPPER HINGE FUSELGE SKIN CUT OUT CRACKED (VERIFIED WITH HFEC INSP). REPAIRED SKIN PER SRM.SDR SWAA990846Slide · damagedFWD ENTRY DOOR GIRT VELCRO TORN ON ESCAPE SLIDE ASSY. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990722Tab · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LEFT AILERON TAB DELAMINATED. REMOVED AND REPLACED TAB PER MM.SDR SWAA990326Seal · out of positionFWD ENTRY DOOR DEVELOPED AN EXTREMELY LOUD AIR LEAK IN THE VICINITY OF UPPER HINGE. PRESSURIZATION REMAINED NORMAL. REPOSITIONED FWD ENTRY DOOR UPPER HINGE SEAL COVER (INTERIOR COVER) PER M/M, OPS CK'D OK.SDR SWAA990234Controller · malfunctionedLOSS OF PRESSURIZATION ON ARRIVAL INTO SEA AT 4000 AGL AFTER SLOW DESCENT. DESCENT INTO SEA WAS NORMAL WITH NORMAL CABIN INDICATIONS UNTIL 4000 AGL. REMOVED AND REPLACED CABIN PRESS CONTROLLER PER M/M.SDR SWAA990103Skin · crackedDURING SCHEDULED SC CHECK, FOUND A 3 INCH CRACK IN FUSELAGE SKIN LOCATED SEC 46 BETWEEN BS 727E AND 747 AT STRINGER 18R. REPAIRED PER BOEING SRM.SDR SWAA983064Skin · crackedDURING SCHEDULED SC CHECK, FOUND A 2 INCH LONGITUDINAL FUSELAGE SKIN CRACK, AT BS 727D, STRINGER 23R. REPAIRED PER BOEING SRM.
Back to N689SW, cancelled Mar 16, 2018