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 SWAA043374Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FUSELAGE SKIN AT LOWER HINGE CUTOUT, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043365Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 727E, STRINGER 18L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043349Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT FRAME WEB CRACKED AT BS 303, FWD LOWER STOP FITTING. REMOVED AND REPLACED FRAME WEB PER SRM.SDR SWAA043337Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 771, LBL 13, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA043233Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN AT BS 933, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042651Lamp · inoperativeDURING SCHEDULED A1 CHECK, FOUND 2 EACH SERVICE DOORS EGRESS LIGHTS INOP. RELAMPED EGRESS LIGHTS PER MM.SDR SWAA042390Skin · delaminatedDURING SPINDLE INSPECTION, FOUND AREA OF DELAMINATION ON OUTBOARD T/E FLAPS. REPAIRED OUTBOARD T/E FLAPS PER SRM.SDR SWAA042259Battery · inoperativeR2 & L2 DOOR EMERGENCY EXIT LIGHTS STAY ON IN ARMED POSITION. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PER MM.SDR SWAA041635Lens · brokenDURING SCHEDULED SERVICE CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT LIGHT LOWER LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA041444Bushing · wornDURING SCHEDULED C1 CHECK, RIGHT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RIGHT ELEVATOR HINGE BUSHING PER MM.SDR SWAA041438Door Frame · crackedDURING SCHEDULED C1 CHECK, FOUND AFT CARGO DOOR, FWD FRAME AT SPRING TENSION PLATE, CRACKED. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA041395Flap · delaminatedLEFT WING INBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED T/E AFT FLAP PER MM.SDR SWAA040429Sign · looseDURING SCHEDULED C4 CHECK, FOUND OVERWING OVERHEAD EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA040428Stringer · crackedDURING SCHEDULED C4 CHECK, FOUND STRINGER 18L CRACKED AT BS 750. REPAIRED STRINGER PER SRM.SDR SWAA040272Skin · delaminatedNR 2 FLIGHT SPOILER DEVELOPS BULGE ON TOP OF SPOILER DURING FLIGHT. REMOVED AND REPLACED NR 2 FLIGHT SPOILER PER MM.SDR SWAA032452Structure · crackedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR FWD LOWER CORNER CUTOUT CRACKED 2.0 IN. REPAIRED PER EA.SDR SWAA032438Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER FWD CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA031859Handle · looseAFT SVC DOOR EMERGENCY EVAC SLIDE PULL HANDLE LOOSE. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031254Slat · out of rigNR 4 L/E SLAT VISUALLY NOT ALIGNED WITH OTHER SLATS. REMOVED AND REPLACED NR 4 L/E SLAT AND OUTBD GUIDE STOP.SDR SWAA030970Light · looseDURING SCHEDULED C1 CHECK, FOUND OVERHEAD CEILING EMERGENCY EXIT LIGHT LOOSE AT OVERWING EXITS. SECURED CEILING EMERGENCY EXIT LIGHT PER MM.SDR SWAA030969Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND BOTH AFT ENTRY & AFT SVC DOOR OVERHEAD EMERGENCY EXIT LIGHTS INOP. RELAMPED BOTH AFT ENTRY AND AFT SVC DOOR OVERHEAD EMERGENCY EXIT LIGHTS PER MM.SDR SWAA030968Girt Bar · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030960Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030959Girt Bar · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH FWD ENTRY AND FWD SERVICE DOOR EMERGENCY EVACUATION SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA030724Cover · missingDURING SCHEDULED RON, FOUND EEPLS COVER MISSING IN FWD CABIN. REMOVED AND REPLACED EEPLS LIGHT ASSY SECTION PER MM.SDR SWAA030208Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG FWD WALKING BEAM SUPPORT FITTING CORRODED. REMOVED AND REPLACED LT MLG FWD WALKING BEAM SUPPORT FITTING PER MM.SDR SWAA030082Skin · crackedDURING SCHEDULED C4 CHECK, FOUND LT/RT EXTERNAL A/C COMPT DOOR CUTOUTS CRACKED AT FWD OUTBD EDGES. REPAIRED SKIN CUTOUTS PER SRM.SDR SWAA022384Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 748, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA021276Tab · wornDURING SCHEDULED A1 CHECK, SWA SI 11111-55, LEFT ELEVATOR NR 1, 2 AND 4 TAB HINGE BEARINGS WORN. REMOVED AND REPLACED LT ELEVATOR TAB PER MM.SDR SWAA021240Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA021197Tie Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TIE CLIPS CRACKED (2 EA) AT BS 787, STR 21R AND BS 727E, STR 25R. REMOVED AND REPLACED TIE CLIPS PER SRM.SDR SWAA021180Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, BETWEEN STR'S 20R AND 21R. REPAIRED FRAME PER SRM.SDR SWAA021120Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER SPLICE AND TIE CLIP CRACKED AT BS 663.75, STR 10. REPAIRED STR SPLICE AND REMOVED AND REPLACED TIE CLIP PER SRM.SDR SWAA020264Web · crackedDURING SCHEDULED C1 CHECK, FOUND NLG ACTUATOR SUPPORT BEAM WEB CRACKED AT FWD END. REPAIRED WEB PER SRM.SDR SWAA013339Skin · crackedDURING WALKAROUND INSPECTION, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 500D, STRINGER 16R. REPAIRED SKIN PER SRM.SDR SWAA013137Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEBS CRACKED (2 EA) AT BS 178, WL 183, RBL 17.1 AND LBL 17.1. REPAIRED WEBS PERSWA RA.SDR SWAA011188Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING INBD AFT FLAP DELAMINATED AT INBD END. R&R AFT FLAP PER MM.SDR SWAA010042Stiffener · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 663 BULKHEAD VERTICAL STIFFENER CRACKED AT LWR GROUND STUD, FWD OF INBOARD END OF A SYS ELEC HYD PUMP. REMOVED AND REPLACED VERTICAL STIFFENER PER SRM.SDR SWAA010041Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 EXTERNAL FUSELAGE SKIN CRACK AT BS 944, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA001109Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER DUE TO GIRT BAR NOT PROPERLY STOWED TO CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA992044Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD LEFT AND RIGHT OUTBOARD CHORDS CRACKED AT WL 207. REMOVED AND REPLACED BOTH CHORD SECTIONS PER SRM.SDR SWAA992023Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD HORIZONTAL CHORD CRACKED, LBL 28. REPAIRED CHORD PER SWA RA NR 1-353-2184.SDR SWAA992024Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND BS 794 FLOORBEAM CORRODED, RBL 8. REPAIRED BEAM PER SWA RA NR 1-353-2182.SDR SWAA992022Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 12. REPAIRED BULKHEAD PER SRM.SDR SWAA992021Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 HORIZONTAL CHORD CRACKED, RBL 28. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA991604Slide · detachedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT DURING DOOR OPENING. (DID NOT DEPLOYED). REINSTALLED SLIDE ASSY PER MM.SDR SWAA991111Battery · dischargedFWD UPPER EMERGENCY FLASHLIGHT BATTERY WEAK. REMOVED AND REPLACED EMERGENCY FLASHLIGHT BATTERY PER MM.SDR SWAA970754Longeron · crackedDURING SCHEDULED D-CHECK, FOUND LONGERON ON LOWER I/B SIDE OF NR 1 PYLON CRACKED. REPLACED PER BOEING SRM.SDR SWAA970753Longeron · crackedDURING SCHEDULED D-CHECK, FOUND LONGERON ON LOWER I/B SIDE OF NR 2 PYLON CRACKED. REPLACED PER BOEING SRM.SDR SWAA970752Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CHANNEL CRACKED AT BS 360, AT S4L. REPLACED PER BOEING SRM.
Back to N328SW, cancelled Oct 26, 2017