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 SWAA980954Bulkhead · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOOR TO BULKHEAD SUPPORT ANGLE AT BS 947, LBL 21, RBL 21 AND WL 180. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980948Intercostal · crackedDURING SCHEDULED D CHECK, FOUND CRACKED INTERCOSTAL AT BS 500A-500B, RBL 25 WL 156. REPAIRED PER BOEING SRM.SDR SWAA980947Skin · damagedDURING SCHEDULED D CHECK, FOUND DAMAGED SKIN AT BS 500 + 19, RBL 1, WL 148. REPAIRED PER BOEING SRM.SDR SWAA980946Angle · wornDURING SCHEDULED D CHECK, FOUND WORN T-ANGLE AT BS 727 TO 727B, STR 20 LT AND BS 727, STR 20 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980945Frame · crackedDURING SCHEDULED D CHECK, FOUND CRACKED FRAME AT BS 947, STR 24 RT WL 160. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980934Dorsal Fin · damagedDURING SCHEDULED D CHECK, FOUND DAMAGED DORSAL FIN OK TO CORE SPLICE. REPAIRED PER BOEING SRM.SDR SWAA980933Chord · crackedDURING SCHEDULED CHECK, FOUND CRACKED SIDE CHORD AT BS 178, RBL 29 WL 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980932Skin · chafedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CHAFFED AT BS 890 TO BS 945, RBL 4.5-9.5, WL 306.5. REPAIRED PER TRAMCO EO NR 98-0409.SDR SWAA980921Cover · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED DOOR FRAME COVER PLATE AT BS 792-794, RBL 41-48, WL 164-170. REPAIRED PER BOEING SRM.SDR SWAA980918Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AROUND NUTPLATE HOLES AT BS 947, WL 208, RBL 5 TO LBL 43. REPAIRED PER BOEING SRM.SDR SWAA980917Floorbeam · drilledDURING SCHEDULED D CHECK, FOUND HOLE DRILLED IN RADIUS OF FLOORBEAM AT BS 1006, WL 208, RBL 30. REPAIRED PER BOEING SRM.SDR SWAA980916Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CRACKED FLOORBEAM STIFFENER AT BS 328, RBL 32, WL 200. REPAIRED PER BOEING SRM.SDR SWAA980915Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AT BS 294, RBL 39, 45 TO 52, WL 208 AND WL 207. REPAIRED PER BOEING SRM.SDR SWAA980914Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED SHEAR WEB UPPER ATTACH L ANGLE AT BS 500D-11, WL 208, BL 0. REPAIRED PER BOEING SRM.SDR SWAA980913Stringer · crackedDURING SCHEDULED D CHECK, FOUND CRACKED STRINGER SPLICE AT BS 907, STR 4LT. REPAIRED PER BOEING SRM.SDR SWAA980912Frame · crackedDURING SCHEDULED D CHECK, FOUND CRACKED FRAME AT HAT RACK ATTACH BRACKET BETWEEN STRINGERS 9LT AND 8LT, AT BS 867; BS 787, STRINGERS 9RT AND 8RT. REPAIRED PER BOEING SRM.SDR SWAA980911Frame · crackedDURING SCHEDULED D CHECK, FOUND CRACKED FRAME AT HAT RACK ATTACH BRACKET BETWEEN STRINGERS 9RT AND 8RT, AT BS 827; BS 907, STRINGERS 9LT AND 8LT; AND BS 887, STRINGERS 9LT AND 8LT. REPAIRED PER BOEING SRM.SDR SWAA980910Frame · crackedDURING SCHEDULED D CHECK, FOUND CRACKED FRAME AT HAT RACK ATTACH BRACKET BETWEEN STRINGERS 9LT AND 8LT, AT BS 847; BS 827, STRINGERS 9LT AND 8LT; AND BS 767, STRINGERS 9LT AND 8LT. REPAIRED PER BOEING SRM.SDR SWAA980909Web · crackedDURING SCHEDULED D CHECK, FOUND CRACKED WEB AT BS 178, BL 0, WL 188-189. REPAIRED PER BOEING SRM.SDR SWAA980908Channel · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED CHANNEL AT BS 500-500A, LBL 25, WL 156; BS 500B-500C, RBL 25, WL 156; AND BS 500C-500D, RBL 25, WL156. REPAIRED PER BOEING SRM.SDR SWAA980907Seal · collapsedDURING SCHEDULED D CHECK, FOUND EMERGENCY EXIT DOOR HANDLE PRESSURE SEAL COLLAPSED LT. REMOVED AND INSTALLED NEW EMERGENCY EXIT DOOR HANDLE PRESSURE SEAL PER BOEING MM.SDR SWAA980853Panel · gougedDURING SCHEDULED D CHECK, FOUND GOUGE AT RT HORIZ STAB LEADING EDGE PANEL LE BS 100.56. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980852Skin · gougedDURING SCHEDULED D CHECK, FOUND GOUGE AT RT HORIZ STAB LEADING EDGE PANEL LE BS 149.75. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980847Tie Strap · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOOR PANEL TIE STRAP AT BS 859, RBL 18.5, LBL 21, WL 168. REMOVED AND REPLACED PER BOEING MM.SDR SWAA980845Bulkhead Web · crackedDURING SERVICE CHECK, FOUND CRACKED BULKHEAD WEB AT BS 178, WL 198.25 TO 199.25, WL 200.25 - 201.25, RBL 4.7; BS 178, WL 208.5- 209, LBL 6.7 AND WL 211.375 -211.75, LBL 6.7; AND BS 178, WL 201.5-202, LBL 6.7. REPAIRED PER BOEING SRM.SDR SWAA980843Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL TO FRAME SUPPORT ANGLE AT BS 380, LBL 25, WL 254. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980842Bulkhead Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED SIDEWALL TO BULKHEAD SUPPORT ANGLE AT BS 500D, RBL 25, WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980841Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 500D, STR 19 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980840Bulkhead Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOOR TO BULKHEAD SUPPORT ANGLE AT BS 500D, RBL 23, LBL 23, WL 156. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980839Skin · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED SKIN AROUND NR 1 DME ANTENNA AT BS 469, BL0, WL 148. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980838Frame · dentedDURING SCHEDULED D-CHECK, FOUND DENTED FRAME AT BS 460, LBL 35, WL 161. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980836Intercostal · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED INTERCOSTAL AROUND NUTPLATE LOC AT BS 500C-500D, LBL 25, WL 156; BS 500B PLUS 18, LBL 25, WL 156; AND BS 500A PLUS 2 LBL 25 WL 156. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980834Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 663, STR 10RT. REPAIRED PER BOEING SRM.SDR SWAA980833Frame · dentedDURING SCHEDULED D CHECK, FOUND DENTED FRAME AT BS 727 E LBL 44, WL 166; AND\NBS 807, LBL 49, WL 173. REPAIRED PER BOEING SRM.SDR SWAA980832Bulkhead Web · crackedDURING SCHEDULED D CHECK, FOUND CRACKED BULKHEAD WEB AT BS 178, WL 199-200 AND WL 201.5-202.25, LBL 47; WL 198.50-199.25, RBL 6.7 AND WL 212-213, RBL 47. REPAIRED PER BOEING SRM.SDR SWAA980825Intercostal · crackedDURING SCHEDULED D CHECK, FOUND CRACKED INTERCOSTAL AT BS 639, RBL 68.5 WL 221. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980824Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED SHEAR WEB UPPER ATTACH L-ANGLE AT BS 387 BL 0 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980823Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED ANGLE STIFFENER AT BS 947 BELOW STR 14 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980822Clip · crackedDURING SCHEDULED D CHECK, FOUND CRACKED STRINGER CLIP AT BS 663, STR 10 LT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980821Angle · crackedDURING CHEDULED D CHECK, FOUND CRACKED LT SKATE ANGLE AT BS 569, LBL 48 WL 173. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980820Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED RT SKATE ANGLE AT BS 569, RBL 48 WL 173. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980811Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FRAME AT BS 794, RBL 26, WL 158. REPAIRED PER BOEING SRM.SDR SWAA980810Frame · dentedDURING SCHEDULED D-CHECK, FOUND DENTED FRAME AT BS 500, RBL 41, WL 164. REPAIRED PER BOEING SRM.SDR SWAA970852Lamps · failedDURING SCHEDULED C1 CHECK, FOUND SEVERAL LAMPS INOP NEAR FWD ENTRY DOOR. RELAMPED PER BOEING M/M.SDR SWAA961106Light · brokenDURING SCHEDULED 3C1 CHECK, FOUND EMERGENCY LIGHTING AT FWD F/A STATION BROKEN. REPLACED LIGHT ASSEMBLY PER BOEING M/M.SDR SWAA961073Indicator · inaccurateDIVERTED TO ABQ DUE TO TOTAL FUEL QUANTITY FLUCTUATING, +/- 2,000 LBS. INSPECTED FOR LEAKS AND CHECKED FUEL QUANITITY, DEFERRED NR 2 FUEL TANK INDICATION AND CONTINUED PER MEL 28-6.SDR SWAA960313Battery Pack · dischargedDURING SCHEDULED RON CHECK, FOUND LEFT AFT DOOR EMERGENCY EXIT LIGHTS INOP. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA960266Web · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND WEB CRACKED AT AFT CARGO DOOR BS 787 TO 794, S 24 TO 25. REPLACED PER BOEING SRM.SDR SWAA960237Floor Beam · crackedDURING SCHEDULED 1/4 D-CHECK, FOUND FLOOR BEAM STRAP CRACKED AT BS 315 LBL 12. REPLACED PER BOEING SRM.SDR SWAA960312Battery Pack · dischargedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EXIT LIGHTS INOP. REPLACED BATTERY PACK PER BOEING M/M.
Back to N670SW, cancelled Jan 8, 2022