N328SW, cancelled Oct 26, 2017
Service difficulty reports · 281
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 = 'N328SW' AND deregistration_id = 'N328SW-2017-10-26' 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 = 'N328SW' AND deregistration_id = 'N328SW-2017-10-26' 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 SWAA970751Angle · crackedDURING SCHEDULED D-CHECK, FOUND ANGLE CRACKED AT BS 328, LBL 54, WL 182. REPLACED PER BOEING SRM.SDR SWAA970750Web · crackedDURING SCHEDULED D-CHECK, FOUND WEB CRACKED AT BS 351, RBL 1, WL 153. REPAIRED PER BOEING SRM.SDR SWAA970749Skin · gougedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 516, ABOVE S22R. REPAIRED PER BOEING SRM.SDR SWAA970748Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED AT BS 498, AT S23L. REPAIRED PER BOEING SRM.SDR SWAA970747Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED AT BS 500A+4, BELOW S16L. REPAIRED PER BOEING SRM.SDR SWAA970746Strap · crackedDURING SCHEDULED D-CHECK, FOUND STABILIZER STRAP CRACKED AT BS 314, AND RBL 32. REPLACED PER BOEING SRM.SDR SWAA970745Web · crackedDURING SCHEDULED D-CHECK, FOUND WEB CRACKED AT BS 279, AT RBL 54. REPLACED PER BOEING SRM.SDR SWAA970724Keelbeam · corrodedDURING SCHEDULED D CHECK, FOUND KEEL BEAM CORROSION AT BS 712 TO 727. REPAIRED PER TRAMCO EWO 97-0544.SDR SWAA970723Angle · corrodedDURING SCHEDULED D CHECK, FOUND FLOOR TO SIDEWALL SUPPORT ANGLE CORRODED AT BS 947, RBL 21-LBL21. REPLACED PER BOEING SRMSDR SWAA970719Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT S19R, BS 500D. REPAIRED PER BOEING SRM.SDR SWAA970718Bulkhead Web · crackedDURING SCHEDULED D CHECK, FOUND BS 178 WEB CRACKED AT WL 212 TO 212.5, WL 201 TO 202, 197.5 TO 199, 209.75 TO 210.25, 211.75 TO 213, 200.25 TO 201.25, 198.75 TO 199.25. REPAIRED PER BOEING SRM.SDR SWAA970717Frame · dentedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME DENTED AT BS 500, RBL 35 AND 39, WL 162. REPAIRED PER BOEING SRM.SDR SWAA970716Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER 5R CRACKED AT BS 1140. REPAIRED PER BOEING SRM.SDR SWAA970715Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORROSION AT BS 986.5, LBL 25, BL 0 RBL 5, 9, 31.5 AND 35.5, AND 39.5, AT BS 727-947, RBL 25, AND LBL 8, 25, AND 12. REPAIRED PER BOEING SRM.SDR SWAA970714Skin · dentedDURING SCHEDULED D CHECK, FOUND MULTIPLE FUSELAGE SKIN DENTS AT BS 336, ABOVE S12R. REPAIRED PER BOEING SRM.SDR SWAA970713Skin · dentedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN DENTED AT BS 398, ABOVE S16L, AND AT BS 827 BETWEEN S16 AND 17L, AT BS 303, BETWEEN S22 AND 23R, AT BS 316, BETWEEN S19 AND 20R, BS 269, ABOVE S25R, AT BS 328 TO 348, BETWEEN S22 AND 23R. REPAIRED PER BOEING SRM.SDR SWAA970712Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED L ANGLE AT BS 294, RBL 55, WL 208. REPLACED PER BOEING SRM.SDR SWAA970711Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED SHEAR WEB UPPER ATTACH L ANGLE AT BS 390. REPLACED PER BOEING SRM.SDR SWAA970710Angle · corrodedDURING SCHEDULED D CHECK, FOUND Z ANGLE CHORD BODY CORRODED AT BS 270, LBL 9. REPLACED PER BOEING SRM.SDR SWAA970709Strap · crackedDURING SCHEDULED D CHECK, FOUND STABILIZER STRAP CRACKED AT BS 328 RBL46, AND AT BS 314, RBL 32. REPLACED PER BOEING SRM.SDR SWAA970708Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT HAT RACK ATTACH BRACKET BETWEEN S8 AND 9R OF BS 747, 727D, 787 AND 827. REPAIRED PER BOEING SRM.SDR SWAA970707Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 296, LBL 54. REPAIRED PER BOEING SRM.SDR SWAA970706Web · crackedDURING SCHEDULED D CHECK, FOUND WEB CRACKED AT BS 295, LBL 56, WL 217. REPAIRED PER BOEING SRM.SDR SWAA970705Frame · crackedDURING SCHEDULED D CHECK, FOUND STUB FRAME AT BS 294, WL 209, FWD SERVICE DOORWAY FWD FRAME CRACKED. REPAIRED PER BOEING SRM.SDR SWAA970704Skin · crackedDURING SCHEDULED D CHECK, FOUND 1.5 FUSELAGE SKIN CRACKED AT BS 328, AT WL 209 AT FWD SERVICE DOORWAY AFT LOWER CORNER. REPAIRED PER BOEING SRM.SDR SWAA970703Skin · gougedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 263, BETWEEN S15 AND 16L, AT BS 298, BETWEEN S17 AND 18R, AND AT BS 1058, 1.5 ABOVE S15L. REPAIRED PER BOEING SRM.SDR SWAA961376Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FORWARD ENTRY DOOR UPPER HINGE CUTOUT UPPER CORNER CRACKED. REPAIRED PER SWA RA 1-352-0261.SDR SWAA961375Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FORWARD SERVICE DOOR UPPER CUTOUT LOWER CORNER CRACKED. REPAIRED PER SWA RA 1-352-0260.SDR SWAA961018Skin · crackedDURING SCHEDULED A1 CHECK, FOUND CRACK FORWARD OF SHEAR WEB BEAM STRINGER 18A. REPAIRED PER ACO 6580-56 AND RA 1-353-1518.SDR SWAA960968Battery · dischargedDURING SCHEDULED TERMINAL CHECK, FOUND FWD CABIN EMERGENCY LIGHTS ERRATIC. REPLACED BATTERY PACK AND CHARGER PER BOEING M/M.SDR SWAA960167Skin · crackedDURING SCHEDULED B/C2 CHECK, FOUND FWD SERVICE DOOR LOWER HINGE CUTOUT CRACKED .25 INCHES AT UPPER CORNER. REPAIRED PER SWA RA 1-352-242.
Back to N328SW, cancelled Oct 26, 2017