N671SW, cancelled Jan 3, 2013
Service difficulty reports · 308
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 = 'N671SW' AND deregistration_id = 'N671SW-2013-01-03' 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 = 'N671SW' AND deregistration_id = 'N671SW-2013-01-03' 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 SWAA981531Track · gougedDURING SCHEDULED D-CHECK, FOUND GOUGED CARGO TRACK AT ANCHORD POINT AT BS 851 LBL 17 WL 116. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981530Intercostal · dentedDURING SCHEDULED D-CHECK, FOUND DENTED INTERCOSTAL AT BS 847 TO 867 LBL 30 WL 163. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981515Strap · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED STRAP AT BS 790 TO 847 RBL 20 WL 157. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981514Plate · crackedDURING SCHEDULED D-CHECK, FOUND CRACK ON ANCHORD PLATE AT BS 791 LBL 40 WL 167 AND LBL 48 WL 172. REPAIRED PER BOEING SRM.SDR SWAA981513Chord · crackedDURING SCHEDULED D-CHECK, FOUND CRACK ON RT SIDE CHORD AT BS 178 WL 207 AND LT SIDE CHORD AT BS 178 WL 207. REPAIRED PER BOEING SRM.SDR SWAA981512Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED FUSELAGE SKIN AT BS 943, 2 INCHES BELOW STR 22R. REPAIRED PER BOEING SRM.SDR SWAA981510Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED THRESHOLD WEB AT BS 794-847 RBL 25 WL 157. REPAIRED PER BOEING SRM.SDR SWAA981509Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INDICATIONS AT BS 178 BULKHEAD WEB RBL 5.0 WL 197-198 AND 200-201 AND WL 198-198.5 RBL 67. REPAIRED PER BOEING SRM.SDR SWAA981508Bulkhead Web · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED AT BS 178 BULKHEAD WEB LBL 50 WL 200-201 AND 197-198. REPAIRED PER BOEING SRM.SDR SWAA981502Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED RIGHT HORIZONTAL REMOVABLE L/E AT BS 124.5. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981496Angle · damageDURING SCHEDULED D-CHECK, FOUND AFT FUSELAGE TO VERTICAL FIN SKATE ANGLE HAS CHAFING DAMAGE ON RT SIDE. REPAIRED PER BOEING SRM.SDR SWAA981495Angle · damageDURING SCHEDULED D-CHECK, FOUND FWD FUSELAGE TO VERTICAL FIN SKATE ANGLE HAS CHAFING DAMAGE ON RT SIDE. REPAIRED PER BOEING SRM.SDR SWAA981494Angle · damageDURING SCHEDULED D-CHECK, FOUND AFT FUSELAGE TO VERTICAL FIN SKATE ANGLE HAS CHAFING DAMAGE ON LT SIDE. REPAIRED PER BOEING SRM.SDR SWAA981493Angle · damageDURING SCHEDULED D-CHECK, FOUND FWD FUSELAGE TO VERTICAL FIN SKATE ANGLE HAS CHAFING DAMAGE ON LT SIDE. REPAIRED PER BOEING SRM.SDR SWAA981492Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOORBEAM STIFFENER AT BS 294.5 RBL 4653 WL 207. REPAIRED PER BOEING SRM.SDR SWAA981491Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 344 TO 360 LBL 1 WL 208. REPAIRED PER BOEING SRM.SDR SWAA981490Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOORBEAM AT BS 344 LBL 25 RBL 11 WL 207-208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981489Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 312 TO 328 LBL 12 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981488Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED AT BS 330 BETWEEN STR 21R AND 22R. REPAIRED PER BOEING SRM.SDR SWAA981487Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 328 RBL 58 WL 184. REPAIRED PER BOEING SRM.SDR SWAA981469Beam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED RT MAIN LANDING GEAR BEAM FITTING. REPAIRED PER BOEING SRM.SDR SWAA981468Skin · lightning strikeDURING SCHEDULED D-CHECK, FOUND LIGHTNING STRIKE ON FUSELAGE SKIN AT BS 904 STR 15L. REPAIRED PER BOEING SRM.SDR SWAA981467Intercostal · corrodedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AND HAVE ELONGATED FASTENER HOLES AT BS 1016 TO 1033 RBL 940 WL 210. REPAIRED PER BOEING SRM.SDR SWAA981466Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED WEB AT BS 973 RBL 50 WL 208. REPAIRED PER BOEING SRM.SDR SWAA981465Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 887 STR 9R, BS 807 STR 9R AND BS 727E STR 9R. REPAIRED PER BOEING SRM.SDR SWAA981464Skin · lightning strikeDURING SCHEDULED D-CHECK, FOUND LIGHTNING STRIKE FUSELAGE SKIN AT BS 757 AT STR 10R AND AT BS ON LOWER ROW OF FASTENERS OF STR 4R LAP. REPAIRED PER BOEING SRM.SDR SWAA981463Skin · gougedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN IS GOUGED AND DENTED FROM BS 995 TO 1005 BETWEEN STRINGER 3L AND 4L AND BS 940 TO 949, 2 INCHES BELOW STR 13L. REPAIRED PER BOEING SRM.SDR SWAA981462Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 887 STR 9L, BS 847 STR 9L AND BS 827 STR 9L. REPAIRED PER BOEING SRM.SDR SWAA981430Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD GALLEY SERVICE DOORWAY UPPER FWD STUB FRAME CRACKED AT NR 1 STOP FITTING. REPAIRED PER BOEING SRM.SDR SWAA981429Skin · crackedDURING SCHEDULED D-CHECK, FOUND APU DOOR FWD HINGE CUTOUT CRACKED. REPAIRED PER BOEING SRM.SDR SWAA981428Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 328 TO 344 LBL 47 WL 208. REPAIRED PER BOEING SRM.SDR SWAA981427Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AROUND NUT PLATE HOLE AT BS 986 FLOORBEAM UPPER CHORD LBL 22 WL 208 AND BS 986.5 LBL 22 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981426Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED TOP OF SHEAR WEB AT BS 1016 RBL 526 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981420Intercostal · crackedDURING SCHEDULED D CHECK, FOUND UPPER FLANGE OF FLOORBEAM CORRODED AT FASTENER HOLES AT BS 344 RBL 12 TO LBL 12 TOP AND BOTTOM SIDES; AND BS 344 LBL 12 - LBL 58. REPAIRED PER BOEING SRM.SDR SWAA981417Intercostal · crackedDURING SCHEDULED D CHECK, FOUND INTERCOSTAL WEB CRACKED AT STRINGER 12, WL 244, LBL 62, BETWEEN BS 294.5-303.9. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981416Support · crackedDURING SCHEDULED D CHECK, FOUND CRACKED NR1 PYLON 'L' ANGLE SUPPORT ON I/B AFT SIDE ON LWR SIDE OF FLAP CUTOUT IS GOUGED BEYOND LIMITS. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981415Support · crackedDURING SCHEDULED D CHECK, FOUND CRACKED NR 1 PYLON LWR AFT END L SUPPORT ON I/B SIDE OF PYLON. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981414Bracket · crackedDURING SCHEDULED D CHECK, FOUND CRACKED NR 1 PYLON UPR AFT END, L BRACKET ON I/B SIDE OF SUPPORT BETWEEN ACCESS PANELS 5735L AND 5736L AND AFT SIDE PANEL SUPPORT AT THE AFT END OF ACCESS PANEL 5736L. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981413Skin · dentedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN DENTED AT BS 381 BELOW STR 15L. REPAIRED PER BOEING SRM.SDR SWAA981403Chord · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED Z CHORD AT BS 270, LBL 11 RBL 11, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981399Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AT BS 312, LBL 45, RBL 12, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981398Web · crackedDURING SCHEDULED D CHECK, FOUND CRACKED WEB AT BS 277-291, RBL 59-63, WL 253. REPAIRED PER BOEING SRM.SDR SWAA981397Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED ANGLE AT BS 290, RBL 63, WL 253. REPAIRED PER BOEING SRM.SDR SWAA981396Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED ATTACH ANGLE AT BS 291.5- 295.5, WL208, RBL 54 THAT ATTACHED FLOORBEAM TO MOPSILL. REPAIRED PER BOEING SRM.SDR SWAA981395Intercostal · crackedDURING SCHEDULED D CHECK, FOUND CRACKED INTERCOSTAL WEB AT LBL 62, STR 16, WL 216, BETWEEN BS 294.5-303.9; AND BS 277+1, RBL 54 STR 14. REPAIRED PER BOEING SRM.SDR SWAA981383Support · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 294.5-312, RBL 12, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981382Intercostal · crackedDURING SCHEDULED D CHECK, FOUND CRACKED INTERCOSTAL AT BS 312-328, LBL 47, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981381Web · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOOR WEB AT BS 991, RBL 45, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981380Shear Web · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED SHEAR WEB AT BS 1016, LBL 27 WL 208; AND 500A-500B, LBL 65, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981379Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED AROUND NUTPLATE HOLES UPPER CHORD FLOORBEAM AT BS 967, RBL 5, 28 + 37, WL 208; AND DOUBLE HOLE AT BS 947, WL 208, LBL 42. REPAIRED PER BOEING SRM.
Back to N671SW, cancelled Jan 3, 2013