N682SW, cancelled May 6, 2015
Service difficulty reports · 361
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 = 'N682SW' AND deregistration_id = 'N682SW-2015-05-06' 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 = 'N682SW' AND deregistration_id = 'N682SW-2015-05-06' 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 SWAA043473Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 344, STRINGER 22L, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043472Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 767, STRINGER 9L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA043462Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH STRINGER CLIPS CRACKED AT BS 380 STRINGER 9L AND BS BS 500A, STRINGER 16R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA043429Pressure Panel · crackedDURING SCHEDULED D-CHECK, FOUND MAIN LANDING GEAR W/W BEADED PRESS WEB CRACKED AT BS 665, RBL 42. REPAIRED WEB PER SRM.SDR SWAA043428Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FRAMES CRACKED AT BS 807 & BS 867, STR 9L. REPAIRED BOTH FRAMES PER SRM.SDR SWAA043404Web · crackedDURING SCHEDULED D-CHECK, FOUND FLOOR WEBS CRACKED AT BS 188 TO BS 196, STR 17L & STR 17R. REPAIRED WEBS PER SRM.SDR SWAA043403Frame · crackedDURING SCHEDULED D-CHECK, FOUND BS 188 STUB FRAMES CRACKED AT STR 17L & STR 17R. REMOVED AND REPLACED FRAMES PER SRM.SDR SWAA043402Angle · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD ANGLE CRACKED AT LBL 5.8, WL 196. REMOVED AND REPLACED ANGLE SECTION PER SRM.SDR SWAA043371Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH STRINGER CLIPS CRACKED FROM BS 727E TO BS 727D AND BETWEEN STRINGERS 5R AND 6R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA043370Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 727A, STRINGER 5L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043359Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 727D, STRINGER 5R, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043328Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 847, STRINGER 8L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA043121Light · brokenFWD ENTRY DOOR LOWER EMERGENCY EXIT LIGHT NEXT TO FLIGHT ATTENDANT SEAT BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY PER MM.SDR SWAA042892Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA042716Battery Pack · inoperativeDURING SCHEDULED A1 CHECK, FOUND LOWER EMERGENCY EXIT LIGHTS ON AFT SERVICE AND ENTRY DOORS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA042509Actuator · leakingON CLIMBOUT FROM LAX AT FL 238 THE RT MLG EXTENDED WITH THE HANDLE IN THE OFF POSITION. BOTH RED AND GREEN LIGHTS ILLUMINATED, SLOWED AIRCRAFT, GEAR RETRACTED. REMOVED AND REPLACED RT MLG UPLOCK ACTUATOR PER MM.SDR SWAA042302Circuit Card · faultyRIGHT MLG UNSAFE LIGHT INDICATION. AFTER CYCLING LANDING GEARS AND USING MANUAL EXTENSION WARNING INDICATION PERSISTED. REMOVED AND REPLACED M981 CIRCUIT CARD PER MM.SDR SWAA041792Battery · inoperativeDURING SCHEDULED PM CHECK, FOUND LOW LEVEL EMERGENCY EXIT LIGHTS AT FWD ENTRY AND FWD SERVICE DOORS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA041174Skin · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR SKIN AT UPPER AFT CUTOUT FOR HANDLE, CRACKED. REPAIRED CARGO DOOR SKIN PER EA.SDR SWAA041173Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 747, STRINGER 18 R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041160Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 747, STRINGER 18R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041116Circuit Card · failedAFTER TAKEOFF AND MOVING GEAR LEVER TO OFF POSITION BOTH RED AND RT MLG LIGHT ILLUMINATED. MOVED GEAR LEVER TO UP THEN OFF, LIGHTS EXTINGUISHED. REMOVED AND REPLACED RT MLG DOWNLOCK LOGIC CARD, ADJUSTED UPLOCK SENSOR, PER MM.SDR SWAA041008Skin · crackedDURING THRU FLIGHT CHECK, FOUND FUSELAGE SKIN AT BS 750, STRINGER 18R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040919Battery · inoperativeDURING SCHEDULED PM CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACK PER MM.SDR SWAA040455Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA032354Battery · inoperativeDURING SCHEDULED A1 CHECK, FOUND EMERGENCY EXIT LIGHTS INOP NEXT TO FWD GALLEY AND ENTRY DOORS. REMOVED AND REPLACED BATTERY PACK.SDR SWAA032230Keelbeam · corrodedDURING SCHEDULED C2 CHECK, FOUND KEEL BEAM CORRODED AT BS 500D + 10, STR 28R. REPAIRED KEEL BEAM PER SWA EA.SDR SWAA032218Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND EEPLS SECTION INOP IN CABIN. REPAIRED EEPLS PER MM.SDR SWAA032229Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD ENTRY DOOR LOWER HINGE CUT OUT. REPAIRED SKIN PER SRM.SDR SWAA032178Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031879Light · brokenDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR LOWER EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY PER MM.SDR SWAA031773Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 948, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA031585Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT WHEN OPENING THE DOOR. REINSTALLED SLIDE PER MM.SDR SWAA031435Battery Pack · faultyOVERWING EMERGENCY EXIT LIGHTS ILLUMINATE INTERMITTANTLY. REMOVED AND REPLACED OVERWING BATTERY PACKS (2 EA).SDR SWAA031302Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND BOTH FWD CABIN DOORS LOWER EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER BASE PER MM.SDR SWAA031118Light · brokenFWD ENTRY DOOR OVERHEAD EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT PER MM.SDR SWAA030703Fastener · wornDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH FITTING LOOSE. REMOVED AND REPLACED FASTENER PER SRM.SDR SWAA022974Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 518, STR 12L. REPAIRED SKIN PER MM.SDR SWAA022990Charger · inoperativeDURING SCHEDULED C3 CHECK, FOUND BOTH FWD ENTRY AND FWD SVC DOOR LOWER EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA022989Battery · dischargedDURING SCHEDULED C3 CHECK, FOUND AFT CABIN OVERHEAD BIN BULL NOSE EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA022988Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022160Bracket · wornDURING SCHEDULED C2 CHECK, SWA SI 11139-55, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR TAB CONTROL BRACKET PER MM.SDR SWAA022143Cover · looseDURING SCHEDULED C2 CHECK, FOUND EEPLS COVER LOOSE NEXT TO NR 3 GALLEY. SECURED COVER PER MM.SDR SWAA021467Receptacle · damagedDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED INNER RECEPTACLE PER MM.SDR SWAA021355Cap · missingDURING SCHEDULED C1 CHECK, FOUND EEPLS END CAP MISSING IN FWD CABIN. INSTALLED END CAP PER MM.SDR SWAA021354Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021018Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR FUSELAGE SKIN CRACKED AT BS 950, UPPER HINGE CUT OUT. REPAIRED SKIN PER SRM.SDR SWAA021064Cover · crackedDURING SCHEDULED 1/4D CHECK, FOUND EEPLS COVERS CRACKED AT FWD END. REMOVED AND REPLACED COVERS PER MM.SDR SWAA021070Frame · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAMES CORRODED (2 EA) BETWEEN STR'S 27L AND 27R, BS'S 807 AND 827. REPAIRED FRAMES PER SRM.SDR SWAA020136Battery · dischargedDURING SCHEDULED RON, FOUND EMERGENCY FLASHLIGHT INOP IN AFT CABIN TOP POSITION. REMOVED AND REPLACED BATTERY PER MM.
Back to N682SW, cancelled May 6, 2015