N528SW, cancelled Mar 27, 2018
Service difficulty reports · 353
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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 SWAA042279Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE AT BS 807, STR 27L, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA042278Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA042277Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 772, RBL 8 TO LBL 3, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA042276Gusset · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178, BULKHEAD LOWER GUSSET AFT CORNER CRACKED. REMOVED AND REPLACED GUSSET PER BAC DRAWING.SDR SWAA042235Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT R2 DOOR CUTOUT AFT LOWER CORNER, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042234Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R2 DOOR AFT LOWER FRAME AT LOWER STOP, CRACKED. REMOVED AND REPLACED LOWER FRAME PER BAC DRAWING.SDR SWAA040655Switch · faultyNOSE LANDING GEAR UNSAFE LIGHT INDICATION AFTER TAKE OFF. REMOVED AND REPLACED S845 SWITCH PER MM.SDR SWAA032469Slide · out of adjustL1 DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA030461Slide · unserviceableDURING WALK AROUND INSP, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021960Battery · dischargedDURING SCHEDULED RON, FOUND AFT SVC DOOR AND RIGHT EXTERIOR LOWER FUSELAGE EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA021766Lens · missingOVERHEAD BIN BULL NOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 3 ABC. INSTALLED LENS PER MM.SDR SWAA021330Lens · looseOVERHEAD BIN EMERGENCY EXIT BULL NOSE LIGHT LENS LOOSE AT ROW NR 3 ABC. SECURED LENS PER MM.SDR SWAA020608Bracket · looseDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE FLOOR GIRT BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA020364Battery · dischargedDURING SCHEDULED D-CHECK, FOUND EMERGENCY EXIT LIGHTS BATTERY PACK M 1137 INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA020329Flap · delaminatedDURING SCHEDULED D CHECK, FOUND LT OTBD AFT T/E FLAP DELAMINATED AT AFT CORNER. REPAIRED T/E FLAP PER SRM.SDR SWAA020320Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (2 EA) AT STR 8R, BS'S 380 AND 440. REPAIRED FRAMES PER BFG ER.SDR SWAA020319Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (5 EA) AT STR 8L, BS'S 400, 440, 747, 867 AND 907. REPAIRED FRAMES PER BFG ER.SDR SWAA020332Slat · debondedDURING SCHEDULED D-CHECK, FOUND NR 3 L/E SLAT DISBONDED ON UPPER SURFACE AT THE T/E WEDGE ON INBOARD END AND OUTBOARD END. REPAIRED NR 3 L/E SLAT PER SRM.SDR SWAA020331Slat · debondedDURING SCHEDULED D-CHECK, FOUND NR 2 L/E SLAT DISBONDED ON UPPER SURFACE OUTBOARD END OF T/E WEDGE. REMOVED AND REPLACED NR 2 L/E SLAT PER MM.SDR SWAA020325Tee Chord · crackedDURING SCHEDULED D CHECK, FOUND VERTICAL FIN LT TEE CHORD CRACKED AT RUDDER STA 13.33. REPAIRED TEE CHORD PER SRM.SDR SWAA020293Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 1040, BETWEEN STR'S 2R AND 3R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA020283Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 1011, STR 4 L. REPAIRED STR PER SRM.SDR SWAA020273Web · corrodedDURING SCHEDULED D CHECK, FOUND WEB CORRO DED AT BS 1016, WL 208 & LBL 15 TO LBL 25. REPAIRED WEB PER SRM.SDR SWAA020274Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SVC DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA020238Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L AND 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA020229Web · crackedDURING SCHEDULED D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, LBL 10 TO LBL 12. REMOVED AND REPLACED WEB PER SWA ACO.SDR SWAA020247Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA020246Stiffener · crackedDURING SCHEDULED D CHECK, FOUND STIFFENER CRACKED AT BS 291.5, WL 259 RT. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA020237Tie Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED TIE CLIP PER SRM AND SWA TI.SDR SWAA020241Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, WL 207 ON BOTH RT AND LT SIDES. REPAIRED FRAME PER SRM.SDR SWAA013031Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LH OTBD AFT FLAP T/E CORNER DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA012615Panel · out of positionCOCKPIT DOOR EMERGENCY BLOW-OUT PANEL FELL OUT. INSTALLED PANEL PER MM.SDR SWAA012018Actuator · crackedDURING LANDING, LOST HYD SYS A, FOUND # 0 SPOILER ACTUATOR CRACKED. R&R SPOILER ACTUATOR PER MM.SDR SWAA011119Bracket · looseDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD MOUNT BRACKET LOOSE. SECURED BRACKET PER SRM.SDR SWAA011118Wire · exposedDURING SCHEDULED C4 CHECK, FOUND EEPLS WIRING EXPOSED AT ROW 14. INSTALLED TRACK COVER PER MM.SDR SWAA010854Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD VERTICAL CHORD CRACKED AT LBL 5.7, WL 184.5. REPAIRED CHORD PER SRM.SDR SWAA010792Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 1.0 FWD BULKHEAD VERTICAL BEAM WEB CRACK AT BS 180, RBL 17.1, WL 228. REPAIRED VERTICAL BEAM WEB PER SWA RA.SDR SWAA010791Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 3 BS 178 BULKHEAD WEB CRACKS AT WL 234, RBL 9.0 & WL 187, RBL 1.0 & LBL 1.0. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA010104Light · brokenEEPLS WIRING EXPOSED/BROKEN AND BULB INOP AT ROW 13. REPAIRED WIRING AND REPLACED BULB PER MM.SDR SWAA001450Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE DROPPED OUT OF CASE, BOTH BAR ENDS DISSENGAGED FROM ACFT BRACKETS. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000663Actuator · leakingDURING FLIGHT @ 28000 FEET, LOST A-SYS HYDRAULICS. R&R NR 3 FLIGHT SPOILER ACTUATOR DUE TO LEAK.SDR SWAA000553Warning Light · illuminatedABORTED TAKE-OFF - WITH THRUST LEVERS SET AT MID POSITION, NR 1 ENG T/R LIGHT ILLUMINATED AT OVERHEAD PANEL, MASTER CAUTION LIGHT ALSO ILLUMINATED. NO FAULT INDICATIONS ON EAU OPERATED AND INSPECTED NR 1 ENG T/R ASSY. NO ABNORMALITIES NOTED. RESET EAU ANSDR SWAA000534Bracket · looseDURING SCHEDULED C4 CHECK, FOUND BOTH AFT DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS LOOSE. TIGHTENED BRACKETS PER MM.SDR SWAA992117Light · crackedDURING SCHEDULED C3 CHECK, FOUND EEPLS TRACK CRACKED AT ROW 14. REMOVED AND REPLACED TRACK SECTION PER MM.SDR SWAA991711Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 8 - RBL 6.7. REPAIRED BULKHEAD PER SRM.SDR SWAA991168Connector · failedIN FLIGHT/ ENGINE SHUT DOWN--- DURING CLIMB NR 2 ENG OIL TEMP INDICATOR READ 150 DEGREES, 12 MINUTES LATER TEMP WENT UP TO 195 DEGREES. ALL OTHER ENG INDICATIONS NORMAL. REMOVED AND REPLACED NR 2 ENG OIL TEMP BULB CANNON PLUG AND OIL TEMP BULB AS A PRECAUTISDR SWAA981864Bulb · failedDURING SCHEDULED A2 CHECK, FOUND EMERGENCY LIGHT AT OVERHEAD BIN ROW 8 INOP. RELAMPED LIGHT, OPS CHECK GOOD PER BOEING MM.SDR SWAA981863Light · brokenDURING SCHEDULED A2 CHECK, FOUND FWD SERVICE DOOR EMERGENCY EXIT LIGHT IS BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY PER BOEING MM.SDR SWAA970546Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD WEB CRACKED AT LBL 4.7. REPAIRED PER BOEING SRM.SDR SWAA970545Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED AT BS 384, 20 BELOW 3RD CABIN WINDOW RIGHT SIDE. REPAIRED PER BOEING SRM.
Back to N528SW, cancelled Mar 27, 2018