N669SW, cancelled Aug 19, 2016
Service difficulty reports · 491
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 = 'N669SW' AND deregistration_id = 'N669SW-2016-08-19' 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 = 'N669SW' AND deregistration_id = 'N669SW-2016-08-19' 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 SWAA980170Skate Angle · crackedDURING SCHEDULED D-CHECK, FOUND LT SKATE ANGLE CRACKED AT BS 569, LBL 48, WL 173. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980169Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB AT BS 794.5, RBL 67, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980168Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB AT BS 699, LBL 70, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980167Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON O/B CREASE BEAM CHORD AT BS 668, LBL 70, WL 209. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980166Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB AT BS 701 AND 703, RBL 70, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980165Strap · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FLOOR SUPPORT STRAP AT BS 1016, 1014 AND 1006 LBL 2.5 AND 7.5, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980164Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 908, BETWEEN STR 8 AND 9L. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980163Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 887, BETWEEN STR 8 AND 9R. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980162Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 887, BETWEEN STR 8 AND 9 LT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980161Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 867, BETWEEN STR 8 AND 9L. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980160Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME IS CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 827, BETWEEN STR 8 AND 9 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980159Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 827, BETWEEN STR 8 AND 9 LT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980158Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 480, BETWEEN STR 8 AND 9 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980157Skin · crackedDURING SCHEDULED D-CHECK, FOUND CRACK INDICATION ON FUSELAGE SKIN AT BS 328, RBL 65, WL 211. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980156Web · dentedDURING SCHEDULED D-CHECK, FOUND SUB THRESHOLD SUPPORT WEB DENTED AT BS 802, RBL 20, WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980155Web · damagedDURING SCHEDULED D-CHECK, FOUND WEB WITH NUMEROUS DENTS AT BS 1106 TO 1150, LBL 15 TO 32, WL 248. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980154Web · dentedDURING SCHEDULED D-CHECK, FOUND WEB WITH NUMEROUS DENTS AT BS 1106 TO 1138, RBL 15 TO RBL 30, WL 248. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980153Angle · crackedDURING SCHEDULED D-CHECK, FOUND ANGLE CRACKED AT BS 294 AT STR 23 LT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980152Angle · crackedDURING SCHEDULED D-CHECK, FOUND RT SKATE ANGLE CRACKED AT BS 569, RBL 48, WL 173. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980151Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, RBL 6.7, WL 202 TO 203. REPAIRED PER BOEING SRM.SDR SWAA980150Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, RBL 4.7, WL 199 TO 199.75 AND WL 201.5 TO 202.25. REPAIRED PER BOEING SRM.SDR SWAA980149Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, RBL 4.7, WL 201.75 TO 202.75. REPAIRED PER BOEING SRM.SDR SWAA980148Frame · dentedDURING SCHEDULED D-CHECK, FOUND DENT IN FRAME BS 827, LBL 28, WL 163. REPAIRED PER BOEING SRM.SDR SWAA980147Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON VERTICAL SUPPORT WEB BS 767 TO 787, RBL 20, WL 156. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980146Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, RBL 6.7, WL 209.75. REPAIRED PER BOEING SRM.SDR SWAA980179Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORRODED BS 727 TO 947, RBL 2.5, WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980178Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORRODED BS 727 TO 947, LBL 12, WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980177Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORRODED BS 727 TO 947, LBL 7.5, WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980145Frame · dentedDURING SCHEDULED D-CHECK, FOUND DENT IN FRAME AT BS 867, RBL 31, WL 168. REPAIRED PER BOEING SRM.SDR SWAA980144Web · corrodedDURING SCHEDULED D-CHECK, FOUND VERTICAL SUPPORT WEB HAS CORROSION AT BS 847 TO 867, RBL 18.5, WL 163 IS OUT OF LIMITS. REMOVED AND REPLACED WEB PER BOEING SRM.SDR SWAA980143Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORROSION AROUND NUT PLATE LOCATIONS, BS 727 TO 947, RBL 7.5, WL 158. REMOVED FLOORBEAM AND INSTALLED NEW FLOORBEAM PER BOEING SRM.SDR SWAA980142Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM HAS CORROSION AROUND NUT PLATE LOCATIONS, BS 727 TO 947, LBL 2.5, WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980141Tie Strap · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON PRIMARY SILL WEB TIE STRAP BS 774 TO 858, RBL 19, WL 164. REPAIRED PER BOEING SRM.SDR SWAA980140Frame · dentedDURING SCHEDULED D-CHECK, FOUND DENT IN FRAME BS 787, RBL 27, WL 159. REPAIRED PER BOEING SRM.SDR SWAA980139Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND CRACKS ON BS 178 BULKHEAD AT WL 188, LBL 0.5 AND RBL 0.5. REPAIRED PER BOEING SRM.SDR SWAA980054Skin · dentedDURING SCHEDULED B/C4 CHECK, FOUND FUSELAGE SKIN DENTED AT BS 478, AT S26R, AT BS 1020, AT S13L, AT BS 1006, AT S14L, AND AT BS 993, A14L. REPAIRED ALL PER BOEING SRM.SDR SWAA970157Battery · dischargedDURING SCHEDULED SV CHECK, FOUND EMERGENCY EXIT LIGHTING INOPERATIVE. REPLACED LEFT FORWARD BATTERY PACK AND CHARGER PER BOEING M/M.SDR SWAA961076Battery · dischargedDURING SCHEDULED TERMINAL CHECK, FOUND AFT SECTION OF ESCAPE PATH LIGHTING VERY DIM. REPLACED BATTERY PACK AND CHARGER PER BOEING M/M.SDR SWAA960936Lights · inoperativeDURING SCHEDULED A1 CHECK, FOUND EMERGENCY LIGHTS INOP ABOVE FWD AND AFT SERVICE DOORS. CLEANED AND RESEATED CANNON PLUG PER BOEING M/M.SDR SWAA960768Battery · dischargedAT GATE, FOUND FLOOR EMERGENCY TRACK LIGHTS INOPERATIVE AT MID-CABIN AREA. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA960368Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND RT AFT SERVICE DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK HOUSING PER BOEING M/M.
Back to N669SW, cancelled Aug 19, 2016