N661SW, cancelled Jul 20, 2012
Service difficulty reports · 408
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 = 'N661SW' AND deregistration_id = 'N661SW-2012-07-20' 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 = 'N661SW' AND deregistration_id = 'N661SW-2012-07-20' 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 SWAA982277Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT BS 967, RBL 5-41.5, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982276Support · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 950, RBL 46 TO 52, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982275Support · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 950, RBL 26 TO 44, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982274Floorbeam · misdrilledDURING SCHEDULED TRAN CHECK, FOUND MISDRILLED HOLE ON FLOORBEAM AT BS 7270+5, LBL 17, WL 160. REPAIRED PER BOEING SRM.SDR SWAA982273Shear Tie · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED ON SHEAR TIE BS 727E, LBL 3. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982272Shear Tie · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED ON SHEAR TIE UNDER FRAME TO KEEL BEAM CLIP AT BS 767, RBL 8, WL 150. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982271Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED CARGO FLOORBEAM AT FASTENER HOLES BS 727 TO 773, LBL 12, WL 10. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982270Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED CARGO FLOORBEAM AT FASTENER HOLES BS 727 TO 773, RBL 8, WL 160. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982269Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FASTENERS ON FLOORBEAM SUPPORT STRAP AT BS 860, WL 160, RBL 20 TO LBL 20. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982268Skin · crackedDURING SCHEDULED TRAN CHECK, FOUND COMBINED TWO PREVIOUS SKIN REPAIRS INTO ONE REPAIR AT BS 867-877, STR 18R-20R. REPAIRED PER BOEING SRM.SDR SWAA982267Doubler · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FWD UPPER CORNER OF AFT CARGO DOOR CUTOUT BS 798, RBL 70, WL 195. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982266Frame · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED AFT CARGO DOOR CUTOUT FWD FRAME AT BS 794, RBL 42 TO 47, WL 167 TO 171 AROUND LATCH FITTING. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982230Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT FASTENER HOLES BS 727 TO 773, RBL 3, WL 160. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982229Crease Beam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED CREASE BEAM WEB AT BS 947-987 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982228Standoff · brokenDURING SCHEDULED TRAN CHECK, FOUND BROKEN STANDOFF ON LWR FLANGE AT BS 987 FLOORBEAM LBL 8, WL 200. REPAIRED PER BOEING SRM.SDR SWAA982227Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED AT BS 986.5 FLOORBEAM FASTENER HOLES LBL 5, 35.5 RBL 4.5, 31, 39, WL 208 AND 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982119Angle · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED ANGLE ON INTERIOR OF RT TORQUE BOX AT BS 1088 JUST ABOVE CUTOUT FOR APU AIR INLET DUCT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982095Rib · damagedDURING SCHEDULED TRAN CHECK, FOUND CORRODED RT HORIZONTAL STAB L/E HAS A DAMAGED RIB AT L/E BS 244.72. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982094Web · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED WEB AT BS 350- 354, WL 208 TO 223, LBL 63. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982093Skin · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED RT HORIZONTAL STAB O/B END WHERE STAB TIP MOUNTS TO STAB. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982092Doubler · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED TOP WEB DOUBLER FWD ENTRY DOOR SILL AT BS 306-315, WL 208, LBL 50-60. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982091Web · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED WEB BS 1016, LBL 41, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982090Support · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED AFT LT LAV FWD WALL SUPPORT AT BS 993, LBL 13.5- 40.5, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982089Stiffener · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED STIFFENER AT BS 328-344, LBL 55-60, WL 208 AROUND FASTENER HOLES. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982088Web · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED TOP AND BOTTOM OF WEB AROUND FASTENER HOLES AT BS 306-346, LBL 55-60, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982087Beam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED CREASE BEAM (AFT ENTRY DOOR AREA) AT BS 940-986, LBL 45-50 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982086Channel · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FWD ENTRY DOOR THRESHOLD SUPPORT CHANNEL AT BS 312 TO 344, LBL 60, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982085Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED BS 344 FLOORBEAM LBL 32 TO RBL 10, WL 208. REPAIRED PER BOEING SRM.SDR SWAA982033Bracket · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED BOTTOM SIDE OF BRACKET AT BS 696, RBL 67, WL 208. REMOVED AND REPLACED PER SRM.SDR SWAA982030Stiffener · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED HORIZONTAL STIFFENER BETWEEN BS 1112 AND BS 1124 LOWER SIDE OF APU AIR INLET CUTOUT ON TORQUE BOX RBL 13. REPAIRED PER SRM.SDR SWAA982029Stiffener · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED VERTICAL STIFFENER INTERIOR OF TORQUE BOX AT BS 1113 FWD SIDE OF APU AIR INLET CUTOUT RBL 12. REPAIRED PER SRM.SDR SWAA982028Web · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED AFT SUPPORT WEB AT BS 325, WL 208 FWD GALLEY DOOR. REMOVED AND REPLACED PER SRM.SDR SWAA982027Support · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED INTERCOSTAL AT BS 302, RBL 15, WL 208. REMOVED AND REPLACED PER SRM.SDR SWAA982026Support · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 328, LBL 11, WL 208. REMOVED AND REPLACED PER SRM.SDR SWAA982025Support · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 304, LBL 29, WL 208. REMOVED AND REPLACED PER SRM.SDR SWAA982024Intercostal · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED INTERCOSTAL AT BS 329 TO 332, RBL 24, WL 208. REMOVED AND REPLACED PER SRM.SDR SWAA982023Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT BS 312, RBL 23, WL 208. REMOVED AND REPLACED PER SRM.SDR SWAA982022Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT BS 328, LBL 49, TO RBL 45, WL 208. REMOVED AND REPLACED PER SRM.SDR SWAA982021Web · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED BOTTOM SIDE OF WEB AT BS 292, WL 207, RBL 52. REMOVED AND REPLACED PER SRM.SDR SWAA982020Stringer · crackedDURING SCHEDULED TRAN CHECK, FOUND STRINGER 16 RT AND 16 LT CRACKED AT BS 500 + 4. REPAIRED PER SRM.SDR SWAA981992Angle · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED ANGLE OF FLOOR SUPPORT FROM BS 500-520, BL 0, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981991Intercostal · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED INTERCOSTAL AT BS 967 TO 987, LBL 3, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981990Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT BS 360, WL 208, LBL 11. REPAIRED PER BOEING SRM.SDR SWAA981989Bracket · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED BRACKET AT BS 312, WL 208, LBL 54. REPAIRED PER BOEING SRM.SDR SWAA981988Skin · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED SKIN, LOWER FWD CORNER OF FWD CARGO DOOR CUTOUT, BS 442, RBL 32, WL 145. REPAIRED PER BOEING SRM.SDR SWAA981977Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT FASTENER HOLE BS 727 TO 847, LBL 3, WL 160. REPAIRED PER BOEING SRM.SDR SWAA981936Support · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 951, LBL 12.5, WL 208 AND BS 951, LBL 23, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981935Support · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 950, LBL 26 TO 44, WL 208; BS 947 TO 967, LBL 17, WL 208 AND BS 967 TO 987, LBL 17 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981934Angle · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED SUPPORT L-ANGLE FWD GALLEY DOOR SUB T-HOLD AT BS 330-332 BOTTOM SIDE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981933Web · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED WEB R1 DOOR AT BS 293-298, WL 208, RBL 55. REMOVED AND REPLACED PER BOEING SRM.
Back to N661SW, cancelled Jul 20, 2012