N635SW, cancelled Nov 28, 2018
Service difficulty reports · 319
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 = 'N635SW' AND deregistration_id = 'N635SW-2018-11-28' 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 = 'N635SW' AND deregistration_id = 'N635SW-2018-11-28' 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 SWAA120519Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 947.5 TO BS 969, BETWEEN STR 15L TO STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA120505Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 947.5 TO BS 980, BETWEEN STR 15R TO STR 19R. REPAIRED SKIN IAW SRM.SDR SWAA120461Crossbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CROSS BEAM CORRODED AT BS 344, BETWEEN LBL 34 TO RBL 14. REPAIRED BEAM IAW SRM.SDR SWAA120460Structure · crackedDURING SCHEDULED 16Y CHECK, FOUND LT INNER CHORD CRACKED AT BS 616, WL 208. REPAIRED CHORD PER SW EA.SDR SWAA120458Support Angle · corrodedDURING SCHEDULED 16Y CHECK, FOUND SUPPORT ANGLE CORRODED BETWEEN BS 312 TO BS 344, LBL 64. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA120455Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND PRESSURE DECK ANGLE CRACKED AT BS 540, LBL 57. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA120454Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND R1 DOOR FRAME CRACKED AT UPPER EDGE OF LOWER INNER SKIN. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA120453Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND PRESSURE DECK ANGLE CRACKED BETWEEN BS 540 TO BS 548, LBL 32. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA120452Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA120451Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA120443Crossbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CROSS BEAM CORRODED AT BS 328, BETWEEN LBL 13 TO RBL 57. REPAIRED BEAM IAW SRM.SDR SWAA120423Doubler · corrodedDURING SCHEDULED 16Y CHECK, FOUND DOUBLER CORRODED BETWEEN BS 967 TO BS 986.5, BETWEEN STR 22R TO STR 25R. REMOVED AND REPLACED DOUBLER IAW SRM AND DWG.SDR SWAA120422Angle · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT ANGLE CORRODED BETWEEN BS 540 TO BS 548, RBL 31.5. REMOVED AND REPLACED ANGLE IAW EA AND DWG.SDR SWAA120421Angle · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT ANGLE CORRODED AT BS 773, LBL 12.5. REMOVED AND REPLACED ANGLE IAW EA.SDR SWAA120420Angle · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT ANGLE CORRODED AT BS 773, LBL 3.0. REMOVED AND REPLACED ANGLE IAW EA.SDR SWAA120419Angle · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT ANGLE CORRODED AT BS 773, RBL 3.0. REMOVED AND REPLACED ANGLE IAW EA.SDR SWAA120418Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 22R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120417Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND VERTICAL ANGLE CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA120416Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA120415Support Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND SUPPORT ANGLE CRACKED AT BS 540, BL 0. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA120414Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CRACKED AT BS 947.5, LBL 454.5+8. REPAIRED BEAM IAW SRM AND DWG.SDR SWAA120413Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA120386Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA120332Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120331Skin · delaminatedDURING SCHEDULED 16Y CHECK, FOUND RT WING AFT FLAP LOWER SKIN DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA120322Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 500D TO BS 500C, BETWEEN LBL 64 TO LBL 70. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR SWAA120222Lens · brokenDURING SCHEDULED 16Y CHECK, FOUND AFT LAV WALL EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA120192Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120144Cable · frayedDURING SCHEDULED 16Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA120143Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120142Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120141Cable · frayedDURING SCHEDULED 16Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE FRAYED. REMOVED AND REPLACED CABLE IAW DWG.SDR SWAA120112Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120111Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120110Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117803Bracket · corrodedDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH BRACKET CORRODED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA105449Block · looseDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR RETAINING BLOCK LOOSE. SECURED BLOCK PER MM.SDR SWAA104987Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING NR 6 SLAT OUTER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA104972Slide · out of adjustDURING SCHEDULED 2HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA104971Flap · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND LT WING I/B AFT FLAP O/B END TRAILING EDGE DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA103089Slide · unserviceableDURING SCHEDULED CV CHECK, FOUND L1 DOOR EVAC GIRT ASSY FRAYED. REMOVED AND REPLACED SLIDE ASSY PER MT.SDR SWAA103088Slide · out of positionDURING SCHEDULED CV CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF POSITION. REMOVED AND REPLACED SLIDE ASSY PER MT.SDR SWAA101510Flap · delaminatedDURING SCHEDULED 14Y CHECK, FOUND LT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA101435Flap · delaminatedDURING SCHEDULED 14Y CHECK, FOUND RT WING I/B AFT FLAP DELAMINATED ON O/B END. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA101434Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 668, RBL 24. REPAIRED BEAM PER ER.SDR SWAA101433Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 657 TO BS 669, LBL 24. REPAIRED BEAM PER ER.SDR SWAA101432Flap · chafedDURING SCHEDULED 14Y CHECK, FOUND LT WING O/B MID FLAP L/E CHAFED. REMOVED AND REPLACED MID FLAP PER MM.SDR SWAA101431Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 24.5. REPAIRED WEB PER ER.SDR SWAA101394Tab · delaminatedDURING SCHEDULED 14Y CHECK, FOUND RT WING AILERON TAB LOWER SURFACE O/B END DELAMINATED. REMOVED AND REPLACED TAB PER MM.SDR SWAA101379Wire · damagedDURING SCHEDULED 14Y CHECK, FOUND COCKPIT EMERGENCY EXIT LIGHT INOP. REPAIRED WIRE PER WDM.
Back to N635SW, cancelled Nov 28, 2018