N670SW, cancelled Jan 8, 2022
Service difficulty reports · 454
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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-08' 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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-08' 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 SWAA002532Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND CENTER SECTION BS 665 BEADED WEB CRACKED, LBL 32.5. REPAIRED WEB PER TI-353-046.SDR SWAA002490Light · looseDURING SCHEDULED 1/4D CHECK, FOUND EEPLS LOOSE AT ROW 16. SECURED EEPLS PER MM.SDR SWAA001453Light · looseDURING SCHEDULED C4 CHECK, FOUND EEPLS TRACK LOOSE AT ROW 8. SECURED TRACK PER MM.SDR SWAA001042Turbine · failedAIR TURNBACK, AFTER TAKEOFF NR 2 ENG BEGAN A LOUD NOISE AND SURGE. REDUCED THRUST AT 60 PERCENT N1 AND ENG STABILIZED. SUSPECTED TURBINE FAILURE. REMOVED AND REPLACED NR 2 ENG PER MM.SDR SWAA001015Engine · surgesAIR TURNBACK, AFTER TAKEOFF NR 2 ENG BEGAN A LOUD NOISE AND SURGE. REDUCED THRUST AT 60 PERCENT N1 AND ENG STABILIZED. SUSPECTED TURBINE FAILURE. REMOVED AND REPLACED NR 2 ENG PER MM.SDR SWAA000147Cover · looseDURING SCHEDULED C2 CHECK, FOUND EEPLS TRACK COVER LOOSE AT ROW 8. RESECURED TRACK COVER PER MM.SDR SWAA000146Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING OUTBOARD AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA991478Inner Cylinder · gougedDURING RON, FOUND NR 1 MLG AXLE SLEEVE ROTATED 90 DEGREES AND HAS SMALL GOUGES WITH PAINT DISCOLORATION ON AXLE. REMOVED AND REPLACED NR 1 MLG INNER CYLINDER ASSY PER MM. (THIS IS A CONTINUATION OF SDR FORM NR SWAA99-1459, SUBMITTED SEPT 3, 1999).SDR SWAA991459Bearing · failedON DEPARTURE OUT OF BUR, TOWER NOTIFIED ACFT LOST OF NR 1 WHEEL ASSY AND ACFT DIVERTED TO ONT. FOUND NR 1 AXLE NUT STILL ATTACHED AND TIGHT, THE INNER BEARING STILL ON THE AXLE AND UNDAMAGED. THE OUTER BEARING INNER RACE ON AXLE SEVERELY SCARRED, MUTILATED ASDR SWAA991222Tab · crackedDURING SCHEDULED BC4 CHECK, FOUND LT ELEVATOR TAB CRACKED. REMOVED AND REPLACED LT ELEVATOR TAB ASSY PER MM.SDR SWAA991009Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SECTION OF EMERGENCY ESCAPE FLOOR TRACK LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA981408Retract Mech · out of adjustNR 4 LEADING EDGE SLAT SHOWED UNSAFE INFLIGHT. COULD SEE NR 4 SLAT DROOPING ABOUT ONE INCH. AIRCRAFT MADE AN UNEVENTFUL LANDING. INSPECTED AND PERFORMED OPERATIONAL CHECK ON FLAP AND LEADING EDGE DEVICES SYSTEM PER BOEING MM. OPS CH OK.SDR SWAA981081Flap Indication · splitAFTER TAKEOFF, RETRACTING THE FLAPS FROM POSITION 5 TO 1, FLAPS SPLIT. THE RIGHT FLAP STOPPED AT 2 AND THE LEFT FLAP STOPPED AT 1. A/C TURNBACK, MADE AN UNEVENTFUL LANDING. PERFORMED ASSEMITY CHECK. UNLOCKED FLAP INDICATE. OPS CHECKS NORMAL, FLAP CYCLED SSDR SWAA981095Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FRAME AT BS 847, RBL 19, WL 165. REPAIRED PER BOEING SRM.SDR SWAA981094Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB ON I/B SIDE OF HOLES STAB APPROX 12 AFT OF REAR SPAR ATTACH FITTINGS. REPAIRED PER BOEING SRM.SDR SWAA981093Skin · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED SKIN .2 LONG AT E AND E BAY DOOR FWD RIGHT CORNER. REPAIRED PER BOEING SRM.SDR SWAA981033Cover · dentedDURING SCHEDULED D-CHECK, FOUND DOOR FRAME COVER PLATE DENTED AND GOUGED AT BS 492 TO 496, RBL 25 TO 30, WL 156 TO 158. REPAIRED PER BOEING SRM.SDR SWAA981032Skin · gougedDURING SCHEDULED D-CHECK, FOUND GOUGED SKIN AT BS 1010 2 BELOW STRINGER 5 LT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981031Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED SKIN AT BS 274, RBL 53, WL 247. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981030Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED L-ANGLE STIFFENER AT BS 270 LBL 47, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981029Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED Z-ANGLE CHORD AT BS 270, LBL 9, 6, 3, 5, BL 0, RBL 10, 6, 3, 5, WL 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981028Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 268, LBL 10, WL 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981027Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED THRESHOLD Z-ANGLE SUPPORT AT BS 339 TO 317, LBL 63.5 TO LBL 60, WL 209. REPAIRED PER BOEING SRM.SDR SWAA981026Skin · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FUSELAGE SKIN AT BS 328, RBL 66, WL 210. REPAIRED PER BOEING SRM.SDR SWAA981025Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 277, WL 231, RBL 54. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981024Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED LOWER STUB FRAME AT BS 295, WL 209, RBL 55. REPAIRED PER BOEING SRM.SDR SWAA981023Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT HAT RACK ATTACH BRACKET BETWEEN STRINGER 9RT AND 8RT AT BS 887. REPAIRED PER BOEING SRM.SDR SWAA981022Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 400 TO 420, LBL 25 WL 156. REPAIRED PER BOEING SRM.SDR SWAA981021Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED VERTICAL SUPPORT WEB AT 767 TO 787, RBL 19, WL 156. REPAIRED PER BOEING SRM.SDR SWAA981020Frame · dentedDURING SCHEDULED D-CHECK, FOUND DENTED FRAME AT BS 767, RBL 29, WL 158. REPAIRED PER BOEING SRM.SDR SWAA981018Intercostal · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED INTERCOSTAL AT BS 787 TO 794, RBL 23, WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981017Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED VERTICAL SUPPORT WEB AT BS 794 TO 847, RBL 19, WL 164. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981016Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, LBL 12.5, WL 159 LBL 8, WL 159 AND LBL 3 WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981015Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, RBL 8, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981014Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, RBL 3, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981013Strap · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED LOWER VERTICAL TIE STRAP AT BS 840 TO 852, RBL 19, WL 161. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981012Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED VERTICAL SUPPORT WEB TIE STRAP AT BS 787 TO 847, RBL 19, WL 157 TO 162. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981011Beam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED CREASE BEAM AT BS 178, RBL 29, WL 207. REPAIRED PER BOEING SRM.SDR SWAA981010Bulkhead · dentedDURING SCHEDULED D-CHECK, FOUND DENTED BULKHEAD PANEL SUPPORT ANGLE AT BS 727+3 RBL 53 WL 191. REPAIRED PER BOEING SRM.SDR SWAA981006Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER AT BS 1007, STR 16 LT. REPAIRED PER BOEING SRM.SDR SWAA981005Web · gougedDURING SCHEDULED D-CHECK, FOUND GOUGED WEB AT BS 1028, RBL 2, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981004Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED WEB AT BS 987 TO 1016, RBL 39 TO 46, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981003Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED L-ANGLE AT BS 301.9 WL 257.5, LT 54. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981002Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB INTERCOSTAL AT BS 295, WL 215, LBL 58 AND BS 295, WL 244, LBL 55. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981001Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED L-ANGLE AT DOOR STOP FITTING NR 9 AT BS 348, LBL 65, WL 223. REPAIRED PER BOEING SRM.SDR SWAA981000Doubler · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED SKIN DOUBLER OF FUSELAGE. REPAIRED PER BOEING SRM.SDR SWAA980999Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 380 STR 1, AND STR 2 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980987Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 294, WL 252, LBL 54. REPAIRED PER BOEING SRM.SDR SWAA980986Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB AT BS 178, WL 207, RBL 25 TO 29 AND LBL 25 TO 29. REPAIRED PER BOEING SRM.SDR SWAA980985Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 1146, RBL 18. REPAIRED PER BOEING SRM.
Back to N670SW, cancelled Jan 8, 2022