N335SW, cancelled Jan 3, 2018
Service difficulty reports · 389
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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 SWAA062957Glowstrip · crazedDURING SCHEDULED C4 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP CRAZED AT ROW 7 ABC TO ROW 10 ABC. REMOVED AND REPLACED EEPLS PHOTOLUMINESCENT STRIP PER MM.SDR SWAA062956Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED LOWER INBOARD SIDE. REMOVED AND REPLACED RT AFT FLAP PER MM.SDR SWAA062204Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA062203Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA062202Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA062201Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA061456Hinge Fitting · wornDURING SCHEDULED C3 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB NR 1 HINGE FITTING PER SRM.SDR SWAA061455Hinge Fitting · wornDURING SCHEDULED C3 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT ELEVATOR TAB NR 1 HINGE FITTING PER SRM.SDR SWAA060877Battery · inoperativeFWD GALLEY OUTBOARD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA053516Tab · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING AILERON TAB DELAMINATED. REMOVED AND REPLACED TAB PER MM.SDR SWAA053515Stiffener · crackedDURING SCHEDULED 1/4D CHECK, FOUND LEFT MLG W/W VERTICAL STIFFENER CRACKED AT BS 663 BULKHEAD, LBL 6.15. REPAIRED STIFFENER PER SWA EA.SDR SWAA053514Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND NR 4 L/E SLAT SKIN CRACKED AT ACTUATOR OUTBOARD STOP FITTING. REPAIRED SLAT PER SRM.SDR SWAA053496Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND NR 5 L/E SLAT SKIN CRACKED INBOARD OF ACTUATOR. REPAIRED SLAT PER SRM.SDR SWAA053495Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND NR 6 L/E SLAT SKIN CRACKED AT ACTUATOR INBOARD STOP FITTING. REPAIRED SLAT PER SRM.SDR SWAA053494Stringer Splice · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER SPLICE CHANNEL CRACKED AT BS 359, STR 15L. REMOVED AND REPLACED SPLICE CHANNEL PER SRM.SDR SWAA053452Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 967, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA053451Beltframe · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 500B, ABOVE RT GENERATOR FEEDER CABLES ACCESS HOLE. REPAIRED BELTFRAME PER SWA EA.SDR SWAA053450Mount · crackedDURING SCHEDULED 1/4D CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD ATTACH MOUNT CRACKED. REMOVED AND REPLACED FWD MOUNT PER MM.SDR SWAA052902Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 967, STR 21L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052774Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 519, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA052498Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA051699Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 766, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA051700Bushing · wornDURING SCHEDULED C4 CHECK, LT & RT ELEVATOR TABS FAILED THE FREE PLAY CHECK. REMOVED AND REPLACED LT & RT ELEVATOR TABS NR 1 HINGE BUSHINGS & HARDWARE.SDR SWAA050401Latch · out of adjustF/O'S ESCAPE SLIDE ROPE COVER RELEASE KNOB, STUCK. ADJUSTED AND LUBED LATCH PER MM.SDR SWAA050357Skin · wornDURING SCHEDULED SERVICE CHECK, FOUND UPPER FUSELAGE SKIN BETWEEN LEFT & RIGHT BS 870 AND BS 890, WORN. REPAIRED SKIN PER EA.SDR SWAA043680Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA043379Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING T/E OUTBOARD FORE FLAP DELAMINATED. REMOVED AND REPLACED LT FORE FLAP PER MM.SDR SWAA043324Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND SKIN AT BS 530, STRINGER 15R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042412Skin · crackedDURING SCHEDULED C1 CHECK, FOUND RT WING NR 4, 5, 6 L/E SLATS SKIN CRACKED. REPAIRED RT WING L/E SLATS SKIN PER EA.SDR SWAA042411Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA042410Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 760, STRINGER 19R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040382Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA040381Hook · out of adjustDURING SCHEDULED C3 CHECK, FOUND L1 DOOR EVAC SLIDE LATCH HOOK WITH TO LARGE OF A GAP. ADJUSTED L1 DOOR EVAC SLIDE HOOK PER MM.SDR SWAA040380Light · inoperativeDURING SCHEDULED C3 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA032398Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 925, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA031543Circuit Card · faultyAIR TURNBACK, LANDING GEAR WOULD NOT RETRACT. REMOVED AND REPLACED M991 CARDS ON E-11 LANDING GEAR LOGIC SHELF.SDR SWAA031152Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CRACKED, BS 947.5, LBL 53. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031105Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 661, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031104Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 794, RBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031102Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 500C + 16, LBL 19. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA031101Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA031103Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND BOTH LT/RT WINGS RIBS CRACKED ON THE LOWER SECTION AT WBL 135.5. REPAIRED LOWER CHORDS PER SWA EA.SDR SWAA031106Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA031097Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM CORRODED FROM BS 390 TO BS 500B, LT SIDE. REPAIRED CREASE BEAM PER SRM.SDR SWAA031096Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM CORRODED FROM BS 390 TO BS 500C + 17, RT SIDE. REPAIRED CREASE BEAM PER SRM.SDR SWAA031080Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIPS CRACKED (4 EA) AT BS 827 AT STR 25L, BS 847 AT STR 22L, BS 787 AT STR 25L & BS 807 AT STR 25L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA030834Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EMERGENCY EXIT LIGHT AT FLOOR LEVEL INOP. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY AND BATTERY PACK.SDR SWAA030486Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 767, STRINGER 14R. REPAIRED SKIN PER ERO.SDR SWAA030475Strap · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BEAR STRAP CRACKED AT BS 360, STR 4R. REPAIRED BEAR STRAP PER SRM AND ERO.SDR SWAA030474Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER 11R CRACKED AT BS 530. REPAIRED STRINGER PER ERO.
Back to N335SW, cancelled Jan 3, 2018