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 SWAA073548Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073547Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073431Stringer Splice · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED STRINGER SPLICE PER ER.SDR SWAA071778Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA071491Skin · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR SKIN CRACKED AT LOWER DOOR HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA071234Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA063928Lens · looseEMERGENCY EXIT OVERHEAD LIGHT LENS LOOSE AT ROW 2. SECURED LIGHT LENS PER MM.SDR SWAA063587Cover · looseFWD CABIN OVERHEAD EMERGENCY EXIT SIGN COVER LOOSE. SECURED COVER PER MM.SDR SWAA063158Lamp · inoperativeDURING SCHEDULED C4 CHECK, FOUND LOWER SIDEWALL EMERGENCY EXIT LIGHT INOP L1 DOOR. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA063157Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING INBOARD FORE FLAP DELAMINATED AT WBL 150. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA062227Lens · out of positionFWD CABIN OVERHEAD EMERGENCY EXIT SIGN LENS FELL OFF. INSTALLED SIGN LENS PER MM.SDR SWAA061670Cover · looseDURING SCHEDULED C3 CHECK, FOUND EEPLS COVER LOOSE AT ROW 15 ABC. SECURED EEPLS COVER PER MM.SDR SWAA061669Lens · damagedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR LOWER EMERGENCY EXIT LIGHT LENS DAMAGED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA061668Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 776, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA061087Cover · brokenR1 DOOR LOWER EMERGENCY EXIT SIGN LENS COVER BROKEN. R&R LIGHT ASSY PER MM.SDR SWAA053740Battery · inoperativeDURING SCHEDULED RON CHECK, FOUND FWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA053596Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA053383Cable Assy · misroutedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY IAW MM.SDR SWAA053076Battery Pack · inoperativeDURING SCHEDULED A2 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA052762Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND SEVERAL CABIN EEPLS LIGHTS INOP BETWEEN FWD GALLEY & ROW 5 DEF. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA052216Pressure Panel · crackedDURING SCHEDULED SERVICE CHECK, FOUND NLG WW LEFT UPPER ACCESS CUTOUT, AFT INBOARD CORNER CRACKED AT BS 249, LBL 2. REPAIRED WEB PER SWA EA.SDR SWAA052215Panel · crackedDURING SCHEDULED C4 CHECK, FOUND LEFT MLG W/W UPPER FWD CEILING PANEL CRACKED AT BS 664, LBL 39. MX FERRY TO DAL, REPAIRED PANEL PER SWA EA.SDR SWAA051068Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA050890Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R. REPAIRED FRAME PER PAE ER.SDR SWAA050053Module · faultyATB / DECLARED EMERGENCY. NLG RED UNSAFE LIGHT ILLUMINATED IN FLIGHT. NLG GREEN DOWN AND LOCKED LIGHT ILLUMINATED INTERMITTENTLY. REMOVED AND REPLACED M1214, PER MM.SDR SWAA043702Light · inoperativeDURING SCHEDULED D-CHECK, FOUND FWD RT EMERGENCY EXIT DOOR SLIDE LIGHT INOP. RELAMPED PER MM.SDR SWAA043697Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LOGITUDINAL FLOORBEAM UPPER CHORD AT BS 663, BL 0, CRACKED. REPAIRED CHORD PER ER.SDR SWAA043696Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND 5 EACH CRACKS ON LONGITUDINAL FLOORBEAM AT BS 727B, FROM LBL 43 TO RBL 47. REPAIRED FLOORBEAM PER ER.SDR SWAA043695Skin · wornDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN FROM BS 862 TO BS 887, BL 0 TO RBL 5, WORN. REPAIRED SKIN SECTION PER SRM.SDR SWAA043694Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 360, STRINGER 14R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA043693Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND 3 EACH SHEAR TIES CRACKED FROM BS 360, STRINGER 13L AND BS 400, STRINGER 14L. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA043692Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 460, STRINGER 13L, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA043691Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH FRAMES CRACKED AT BS 787, STRINGER 9R AND BS 827, STRINGER 9. REPAIRED FRAME SECTIONS PER SRM.SDR SWAA043690Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 727E, STRINGER 9R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA043689Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 986, BETWEEN LBL 47 AND RBL 47, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER EA.SDR SWAA043688Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO COMPARTMENT FRAME AT BS 492, STRINGER 24R, CRACKED. REPAIRED FRAME PER ER.SDR SWAA043687Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 663, STRINGER 2R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043647Spar · corrodedDURING SCHEDULED D-CHECK, FOUND VERTICAL STAB AFT SPAR LT AND RT PRIMARY CLEVIS FWD AND AFT LUGS CORRODED. REPAIRED STAB PER ER.SDR SWAA043646Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH FRAMES CRACKED BETWEEN BS 827 AND BS 867, STRINGER 9R. REPAIRED FRAME SECTIONS PER SRM.SDR SWAA043530Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 639, STRINGER 16R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043529Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 787, STRINGER 9L, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043505Structure · corrodedDURING SCHEDULED D-CHECK, FOUND ZEE CHORD AT BS 270, FROM LBL 11 TO RBL 11, CORRODED. REMOVED AND REPLACED ZEE CHORD PER SRM.SDR SWAA043504Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND L1 DOOR EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED AFT GIRT BAR FITTING PER SRM.SDR SWAA043503Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE AT BS 360, STRINGER 4L, CRACKED. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA043492Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 967, RBL 28, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA043491Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 500, STRINGER 26R, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043477Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 1016, LBL 6, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR SWAA043476Clip · crackedDURING SCHEDULED D-CHECK, FOUND 3 EACH STRINGER CLIPS CRACKED AT BS 400, STRINGER 4R AND STRINGER 4L, BS 520, STRINGER 16L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA043475Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 17L AT BS 195, CRACKED. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA043474Splice · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH STRINGER SPLICES CRACKED AT BS 907, STRINGER 4R AND STRINGER 4L. REMOVED AND REPLACED STRINGER SPLICES PER SRM.
Back to N682SW, cancelled May 6, 2015