N658SW, cancelled Mar 15, 2018
Service difficulty reports · 512
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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 SWAA2012081406686Actuator · malfunctionedCROSSFEED SELECTOR VALVE STUCK IN CLOSED POSITION. REMOVED AND REPLACED CROSSFEED VALVE ACTUATOR PER MM.SDR SWAA2013022112980Door · delaminatedRIGHT MAIN LANDING GEAR OUTER DOOR DELAMINATED AT OUTBOARD EDGE. DOOR REMOVED AND REPLACED PER MM.SDR SWAA2012073006272Sign · brokenRIGHT AFT EMERGENCY EXIT SIGN ASSY BROKEN. REMOVED AND REPLACED SIGN PER MM.SDR SWAA2012041603152Shear Tie · corrodedSHEAR TIE CORRODED AT BS 360, BETWEEN STR 27L AND STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA2012041303091Shear Tie · corrodedSHEAR TIE CORRODED AT BS 360, BETWEEN STR 27L AND STR 26L. REMOVED & REPLACED SHEAR TIE PER DWG & SRM.SDR SWAA2012042703528Splice · corrodedBUTT SPLICE CORRODED AT BS 360, STR 28L. REPAIRED SPLICE PER EA.SDR SWAA2012042503419Shear Tie · corrodedSHEAR TIE CORRODED AT BS 277, STR 26L. REMOVED AND REPLACED SHEAR TIE IAW ER AND EA.SDR SWAA2012042403361Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 285, STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA2012041803205Shear Tie · bentSHEAR TIE BENT AT BS 330, BETWEEN STR 27 AND 28 L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA2012040902893Stringer · corrodedSTRINGER CORRODED BETWEEN BS 259 TO BS 360, STR 25L. REMOVED AND REPLACED STRINGER IAW SRM AND DWG.SDR SWAA2012040202782Frame · corrodedFRAME CORRODED AT BS 311, STR 23L. REPAIRED FRAME IAW SRM.SDR SWAA2012042003288Stringer · damagedSTRINGER 23L DAMAGED AT BS 305. REPAIRED STRINGER PER EO.SDR SWAA2012043003605Skin · corrodedSKIN CORRODED AT BS 348, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SKIN ER AND DWG.SDR SWAA2012043003606Stringer · corrodedSTRINGER CORRODED BS 360, STR 27L. REPAIRED STRINGER IAW SRM.SDR SWAA2012042703527Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 361, STR 24L. REPAIRED SPLICE IAW EA.SDR SWAA2012042503418Skin · corrodedSKIN CORRODED AT BS 362, STR 26L. REPAIRED SKIN IAW SRM AND DWG.SDR SWAA2012042403360Frame · corrodedFUSELAGE FRAME CORRODED AT BS 351.25, BETWEEN STR 27- AND STR 28L. REPAIRED FRAME PER SRM.SDR SWAA2012040902848Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 312, BETWEEN STR 27R TO STR 28R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2012040202781Shear Tie · corrodedSHEAR TIE CORRODED AT BS 312, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2012032602566Web · corrodedWEB CORRODED BETWEEN BS 344 TO BS 350, STR 20L. REMOVED AND REPLACED WEB IAW SRM, DWG, AND AMM.SDR SWAA2012021301394Lens · looseEMERGENCY EXIT LENS 23 DEF (BULL NOSE) LOOSE. SECURED LENS PER MM.SDR SWAA117711Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT ASSY INOP. RELAMPED PER MM.SDR SWAA116508Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR, BS 290.50, WL 255.50 ON UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA116139Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND CENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, RBL 24.8. REPAIRED WEB PER EA.SDR SWAA115554Spoiler · delaminatedLT WING NR 1 SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER IAW MM.SDR SWAA114641Bulkhead · crackedDURING SCHEDULED 26Y CHECK, FOUND LT MLG WHEEL WELL VERTICAL BULKHEAD WEB CRACKED AT BS 663, LBL 43. REPAIRED WEB PER EA.SDR SWAA114647Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND STUB FLOORBEAM CHORD CRACKED AT BS 639, BETWEEN RBL 48 TO RBL 55. REPAIRED CHORD IAW EA.SDR SWAA114646Skin · delaminatedDURING SCHEDULED 26Y CHECK, FOUND LT WING T/E NR 2 SPOILER DELAMINATED ON UPPER SUFRACE AT FWD CENTER END. REMOVED AND REPLACED NR 1 SPOILER PER MM.SDR SWAA114645Skin · delaminatedDURING SCHEDULED 26Y CHECK, FOUND LT WING T/E NR 3 SPOILER DELAMINATED ON UPPER SUFRACE AT FWD CENTER END. REMOVED AND REPLACED NR 1 SPOILER PER MM.SDR SWAA114644Skin · delaminatedDURING SCHEDULED 26Y CHECK, FOUND LT WING T/E NR 1 SPOILER DELAMINATED ON UPPER SUFRACE AT FWD CENTER END. REMOVED AND REPLACED NR 1 SPOILER PER MM.SDR SWAA114643Shear Web · crackedDURING SCHEDULED 26Y CHECK, FOUND CREASE BEAM SHEAR WEB CRACKED BETWEEN BS 616 TO BS 639, STR 17R. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR SWAA114642Crease Beam · crackedDURING SCHEDULED 26Y CHECK, FOUND RT CREASE BEAM LOWER FLANGE CRACKED AT BS 639, STR 17R. REPAIRED BEAM IAW EA.SDR SWAA114525Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE ANGLE CORRODED AT BS 907, RBL 3. REPAIRED ANGLE PER SRM.SDR SWAA114450Wedge · delaminatedDURING SCHEDULED 26Y CHECK, FOUND RT WING O/B NR 4 SLAT WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA114399Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 24R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114339Stringer Clip · corrodedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 797, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114328Slat · delaminatedDURING SCHEDULED 26Y CHECK, FOUND RT WING O/B NR 5 SLAT DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA114329Stringer Clip · corrodedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 947, STR 27L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114330Stringer Clip · corrodedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 807, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114331Skin · delaminatedDURING SCHEDULED 26Y CHECK, FOUND LT WING T/E 0 SPOILER DELAMINATED UPPER SURFACE. REPAIRED SPOILER PER SRM.SDR SWAA114340Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 27L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114305Wedge · delaminatedDURING SCHEDULED 26Y CHECK, FOUND LT WING I/B NR 2 SLAT WEDGE DELAMINATED. REPAIRED WEDGE IAW SRM.SDR SWAA114261Web · corrodedDURING SCHEDULED 26Y CHECK, FOUND AFT CARGO COMPARTMENT WEB CORRODED BETWEEN BS 727A TO BS 727B, RBL 3. REPAIRED WEB PER SRM.SDR SWAA114168Crease Beam · crackedDURING SCHEDULED 26Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 616 TO BS 639, BETWEEN LBL 63 TO LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA113357ABattery Pack · inoperativeDURING SCHEDULED 2HC1 CHECK FOUND, L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY ASSY PER MM.SDR SWAA113356ASkin · crackedDURING SCHEDULED 2HC1 CHECK FOUND, R2 DOOR UPPER HINGE CUTOUT CRACKED. REPAIRED SKIN PER SRM.SDR SWAA111445Lens · looseFWD GALLEY EEPLS LENS LOOSE. SECURED LENS PER MM.SDR SWAA103770Floorbeam · corrodedDURING SCHEDULED MV2 CHECK, FOUND LT FLOORBEAM T-CHORD CORRODED AT BS 328, LBL 60. REMOVED AND REPLACED T-CHORD PER SRM.SDR SWAA103769Floorbeam · crackedDURING SCHEDULED MV2 CHECK, FOUND LT FLOORBEAM T-CHORD CRACKED AT BS 312. REMOVED AND REPLACED T-CHORD PER SRM.SDR SWAA100916Battery Pack · dischargedDURING SCHEDULED MV4 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHTS INOP AT ROW 4. REMOVED AND REPLACED BATTERY PACK PER MM.
Back to N658SW, cancelled Mar 15, 2018