N657SW, cancelled Mar 15, 2018
Service difficulty reports · 446
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 = 'N657SW' AND deregistration_id = 'N657SW-2018-03-15' 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 = 'N657SW' AND deregistration_id = 'N657SW-2018-03-15' 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 SWAA002109Splice · crackedDURING SCHEDULED D-CHECK, FOUND STR SPLICE CRACKED AT BS 907, STR 5R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA002085Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FASTENER HOLES CORRODED AT BS 874 AND 877.5, LBL 64, WL 208. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA002075Web · corrodedDURING SCHEDULED D-CHECK, FOUND WEB CORRODED AT BS 727D, LBL 69, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA002060Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CHORD CORRODED ON APU TORQUE BOX, BS 1088, RBL 21, WL 245. REPAIRED CHORD PER SRM.SDR SWAA002076Web · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 991, LBL 47.5, WL 208. FABRICATED NEW WEB PER SRM.SDR SWAA002059Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM ANGLE CORRODED AT BS 991, LBL 49.5, WL 208. FABRICATED ANGLE PER DRWG 69-41226 AND INSTALLED PER SRM.SDR SWAA002058Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT BS 294.5 STR 7L, BS 559 STR 11L, BS 578 STR 11L, BS 597 STR 11L, BS 907 STR 15L AND BS 986 STR 5L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA002048Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT MLG BEAM STAB LINK FITTING CORRODED. DRILLED STAB LINK FITTING PER DWG 65-82770 AND REPLACED FITTING PER MM.SDR SWAA002047Bushing · corrodedDURING SCHEDULED D-CHECK, FOUND RT HORIZ STAB AFT SPAR LOWER ATTACH LUG AFT FACE CORRODED. REPAIRED AFT SPAR LOWER ATTACH FACE AND REMOVED AND REPLACED BUSHINGS PER SRM.SDR SWAA002037Skin · damagedDURING SCHEDULED D-CHECK, FOUND SKIN CREASED AT BS 839, STR 25R AND 26R. REPAIRED SKIN PER SRM.SDR SWAA002049Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND RT MLG SUPPORT BEAM STAB LINK FITTING CORRODED. REMOVED AND REPLACED LINK FITTING PER MM.SDR SWAA002036Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT MLG STAB LINK FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA002035Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT BS 663 STR 10L, BS 887 STR 15L AND 14L AND BS 578 STR 11R. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA002013Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA001972Frame · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD LT AND RT SIDE CHORDS CRACKED ABOVE AND BELOW WL 207. REMOVED AND REPLACED SIDE CHORDS PER ACO 7338-53 & 7342-53.SDR SWAA001940Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR GIRT BAR FLOOR BRACKET ATTACHMENT PLATES CORRODED AT BS 312 & 344, LBL 50.SDR SWAA001162Tire · failedABORTED TAKE-OFF. NR 1 NLG TIRE TREAD SEPARATED DURING TAKE-OFF ROLL AT APPROX 130 KNOTS, DAMAGING NLG SAFETY SENSOR ASSY AND WIRING, ALSO DAMAGING THE E&E COMPT DOOR. R&R BOTH NLG TIRES AND NLG SAFETY SENSOR ASSY / WIRING AND R&R E&E COMPT DOORSDR SWAA991442Hyd Sys · reqd serviceHYD LOW PRESSURE A-SYSTEM INDICATON, QTY DECREASED TO 1/4 FULL. PREVIOUSLY REMOVED AND REPLACED NR 1 ENG T/R ISOLATION VALVE AND SUSPECT AIR IN SYSTEM. SERVICED HYD A-SYSTEM, ACTUATED FLIGHT CONTROLS AND NR 1 ENG T/R. ALL INDICATIONS CHECKED GOOD.SDR SWAA990912Bracket · looseAFT GIRT BAR BRACKET LOOSE AT RT AFT SERVICE DOOR. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA981074Slide Door · looseDURING WALKAROUND CHECK, FOUND FWD SERVICE DOOR EMERGENCY SLIDE LOOSE. REINSTALLED FWD SERVICE DOOR EMERGENCY SLIDE PER BOEING MM.SDR SWAA980983Intercostal · damagedDURING SERVICE CHECK, FOUND INTERCOSTAL SUPPORT ANGLE HAS ELONGATED FASTENER HOLES AT BS 359, BL 0, WL 149 TO 154. REPAIRED PER BOEING SRM.SDR SWAA980982Skin · dentedDURING SERVICE CHECK, FOUND DENTED SKIN AT BS 877 TO 907, STR 14 LEFT WL 230. REPAIRED PER BOEING SRM.SDR SWAA980981Skin · dentedDURING SERVICE CHECK, FOUND DENTED SKIN AT BS 432, RBL 45, WL 164. REPAIRED PER BOEING SRM.SDR SWAA980980Chord · corrodedDURING SERVICE CHECK, FOUND CORRODED UPPER CHORD AT BS 325, LBL 9 TO 14, WL 155. REPAIRED PER BOEING SRM.SDR SWAA980979Web · crackedDURING SERVICE CHECK, FOUND CRACKED WEB AT BS 352, RBL 1, WL 135. REPAIRED PER BOEING SRM.SDR SWAA980978Floorbeam · corrodedDURING SERVICE CHECK, FOUND CORRODED CARGO FLOORBEAM AROUND NUT PLATE AT BS 794, LBL 2.5 WL 158. REPAIRED PER BOEING SRM.SDR SWAA980977Floorbeam · corrodedDURING SERVICE CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 879, LBL 2.5, WL 166. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980976Intercostal · crackedDURING SERVICE CHECK, FOUND CRACKED INTERCOSTAL UPPER FWD CORNER AT BS 827.5 RBL 5.5 WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980975Frame · crackedDURING SERVICE CHECK, FOUND CRACKED FWD SIDE OF FWD DOOR FRAME AFT SERVICE DOOR CUTOUT AT BS 954, RBL 55, WL 265. REMOVED PER BOEING SRM.SDR SWAA980906Skin · dentedDURING SERVICE CHECK, FOUND LEFT O/B FOREFLAP 24.5 FROM I/B END DENTED AND PUNTURE ON LWR T/E SURFACE. REPAIRED PER BOEING SRM.SDR SWAA980905Skin · gougedDURING SERVICE CHECK, FOUND RIGHT WING INBOARD FOREFLAP HAS A GOUGE AT LOWER SURFACE NEXT TO BULL NOSE 49 FROM I/B END 12 FROM T/E. REPAIRED PER BOEING SRM.SDR SWAA980904Angle · crackedDURING SERVICE CHECK, FOUND NR 2 PYLON I/B AND O/B ACCESS CUTOUT PANEL SUPPORT ANGLE CRACKED. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980844Stiffener · damagedDURING SERVICE CHECK, FOUND STIFFENER BETWEEN NR 2 AND NR 2 RIB ON FWD CARGO DOOR DAMAGED AREA. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980809Frame · crackedDURING SERVICE CHECK, FOUND CRACKED UPPER FWD INNER SKIN FRAME BETWEEN STOP FITTINGS NR 2 AND NR 3 ON FWD CARGO DOOR. REPAIRED PER BOEING SRM.SDR SWAA980808Frame · corrodedDURING SERVICE CHECK, FOUND CORRODED FRAME AT BS 312, LBL 50, WL 182 ABOVE STR 20L. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980771Angle · crackedDURING SERVICE CHECK, FOUND CRACKED EZ-4 RACK SUPPORT ANGLE AT BS 438, LBL 6 TO 28, WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980770Intercostal · corrodedDURING SERVICE CHECK, FOUND CORRODED INTERCOSTAL WEB AT BS 294.5 TO 310, LBL 41 TO 46, WL 161. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980722Stringer · crackedDURING SERVICE CHECK, FOUND CRACKED STRINGER CLIP AT FWD CARGO BAY BS 500C, STR 23L, LBL 45, WL 164. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980721Floorbeam · dentedDURING SERVICE CHECK, FOUND DENTED FLOORBEAM AT BS 500B, WL 150. REPAIRED PER BOEING SRM.SDR SWAA980720Support Angle · damagedDURING SERVICE CHECK, FOUND INTERCOSTAL SUPPORT ANGLE HAS ELONGATED FASTENER HOLES AT BS 352 TO 360, RBL 1, WL 149. REMOVED AND REPLACED DAMAGE INTERCOSTAL SUPPORT ANGLE PER BOEING SRM.SDR SWAA980719Press Panel · corrodedDURING SERVICE CHECK, FOUND CORRODED AT BS 663, RBL 47, WL 197 ON WHEEL WELL BULKHEAD. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980718Floorbeam · corrodedDURING SERVICE CHECK, FOUND CORRODED CARGO FLOORBEAM AROUND NUT PLATE LOCATIONS AT BS 813 AND 825, LBL 2.5 WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980717Bulkhd Support · wrinkledDURING SERVICE CHECK, FOUND WRINKLED SIDE BULKHEAD SUPPORT AT BS 380, STR 25L TO 19L, LBL 29 TO 55, WL 194 TO 160. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980690Skin · dentedDURING SCHEDULED SERVICE CHECK, FOUND DENTED SKIN AT BS 868-873 ABOVE STR 24 RT. REPAIRED PER BOEING SRM.SDR SWA980684Skin · dentedDURING SCHEDULED CHECK, FOUND DENTED SKIN AT BS 500BT17, LBL 41, WL161. REMOVED AND REPLACED PER BOEING SRM.SDR SWA980652Skin · dentedDURING SCHEDULED TRAN CHECK, FOUND DENTED SKIN AT BS 904 2 ABOVE STR 21 RT; AND BS 938 3.5 ABOVE STR 24 RT. REPAIRED PER BOEING SRM.
Back to N657SW, cancelled Mar 15, 2018