N357SW, cancelled Mar 22, 2018
Service difficulty reports · 356
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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 SWAA118239Doubler · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO BAY INTERNAL DOUBLER CORRODED AT BS 967, BETWEEN STR 26L TO STR 27R. REPAIRED DOUBLER PER MM.SDR SWAA118238Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 867, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA118237Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME IAW ER.SDR SWAA118164Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 27L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA118163Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 280, STR 19R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA118162Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND SKIN CORRODED BETWEEN BS 443 TO BS 489, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA118161Stringer Clip · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 794, STR 26R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118160Failsafe · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO BAY FRAME FAIL SAFE ANGLE CORRODED AT BS 727E, BETWEEN STR 27L TO STR 27R. REPAIRED ANGLE IAW SRM.SDR SWAA118159Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CORRODED AT BS 967, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA118158Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA118157Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 17R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA118156Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 727, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA118128Stringer Clip · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 927, STR 26R. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA118127Stringer Clip · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 807, STR 26R. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA118126Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA118021Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 328, BL 0. REMOVED AND REPLACED CHORD IAW SRM AND DWG.SDR SWAA118020Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO BAY SHEAR TIE CORRODED AT BS 927, BETWEEN STR 25R TOS TR 26R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA118045Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 18L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA118044Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 867, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA118043Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 727C+7, LBL 7.5. REPAIRED BEAM IAW SRM.SDR SWAA117976Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 460, STR 21L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA117975Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 25L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117974Web · corrodedDURING SCHEDULE 20Y CHECK FOUND, FWD CARGO DOOR WEB CORRODED BETWEEN BS 440 TO BS 492, BETWEEN RBL 23 TO RBL 30. REPAIRED WEB IAW SRM.SDR SWAA117973Shear Tie · corrodedDURING SCHEDULED 20Y CHECK FOUND, SHEAR TIE CORRODED AT BS 440, BETWEEN STR 27L TO STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA117972Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 727D, STR 25L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117971Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 727B, STR 25L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117970Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP RACKED AT BS 727A, STR 25R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117969Stringer Clip · crackedDURING SCHEDULE 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 727A, STR 26L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117967Floorbeam · corrodedDURING SCHEDULED 20Y CHECK FOUND, FLOORBEAM INNER CHORD CORRODED AT BS 727D+6, LBL 12. REPAIRED CHORD IAW EA.SDR SWAA117936Stringer Clip · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117935Frame · crackedDURING SCHEDULED 20Y CHECK FOUND, RT FRAME INNER CHORD CRACKED AT BS 616, WL 203. REPAIRED CHORD IAW EA.SDR SWAA117391Wedge · puncturedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING I/B AFT FLAP WEDGE PUNCTURED. REMOVED AND REPLACED WEDGE IAW MM.SDR SWAA117390Attach Fitting · brokenDURING SCHEDULED 2HC2 CHECK, FOUND LT WING NR 4 GROUND SPOILER ATTACH LUG AT O/B ACTUATOR BROKEN. REMOVED AND REPLACED SPOILER IAW MM.SDR SWAA117025Controller · faultyDIVERSION - ON CLIMBOUT, SMALL CABIN ALTITUDE NEEDLE POINTING AT "50." AT 10K, CARGO DIFF NEEDLE SHOWING 612. SWITCHES VERIFIED "FLT/AUTO" CABIN CLIMB MOVED BUT NOT IN NORMAL PATTERN. REMOVED AND REPLACED CABIN PRESSURE CONTROLLER PER MM.SDR SWAA116338Flap · delaminatedDURING SCHEDULE MV1 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA115633Slide · out of positionDURING SCHEDULED OTS CHECK, FOUND L1 DOOR EMERGENCY INADVERTANTLY FELL OUT, DID NOT DEPLOY. REINSTALLED SLIDE IAW MM.SDR SWAA111601Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA110859Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 420, BETWEEN STR 18R TO STR 19R. REPAIRED FRAME PER EA.SDR SWAA111045Skin · puncturedDURING SCHEDULED OTS CHECK, FOUND RT WING I/B FORE FLAP LOWER SURFACE PUNCTURED. REPAIRED FORE FLAP PER SRM.SDR SWAA107661Rod End · corrodedDURING SCHEDULED MV2 CHECK, FOUND RT ELEVATOR TAB ROD END CORRODED. REMOVED AND REPLACED ROD PER EA.SDR SWAA104887Lens · looseDURING SCHEDULED HC2 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA104745Flashlight · inoperativeAFT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA102498Sign · looseLT WING EMERGENCY EXIT LIGHT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA101906Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA097596Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 19L TO STR 20L. REPAIRED FRAME PER SI.SDR SWAA097550Stringer · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CRACKED AT BS 364, STR 4L. REPAIRED STRINGER SECTION PER SRM.SDR SWAA097526Sign · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD RT GALLEY EMERGENCY EXIT SIGN LIGHT CRACKED. REMOVED AND REPLACED SIGN PER MM.SDR SWAA097459Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097458Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 4L. REPAIRED FRAME PER SRM.SDR SWAA097406Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED CLIP PER SRM.
Back to N357SW, cancelled Mar 22, 2018