N360SW, cancelled Jul 24, 2018
Service difficulty reports · 354
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 = 'N360SW' AND deregistration_id = 'N360SW-2018-07-24' 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 = 'N360SW' AND deregistration_id = 'N360SW-2018-07-24' 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 SWAA042802Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM AT BS 860, LBL 8 TO RBL 8, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA042779Hook · looseDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR EVAC SLIDE GIRT BAR STOW HOOK LOOSE. SECURED R1 DOOR EVAC SLIDE GIRT BAR STOW HOOK PER MM.SDR SWAA042765Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 827, STRINGER 23L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042247Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LEFT WING OUTBOARD T/E FORE FLAP DELAMINATED. REMOVED AND REPLACED LEFT OUTBOARD T/E FORE FLAP PER MM.SDR SWAA042246Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RIGHT WING NR 4 L/E SLAT WEDGE DELAMINATED. REMOVED AND REPLACED NR 4 L/E SLAT PER MM.SDR SWAA040806Battery · inoperativeFWD EMERGENCY FLASHLIGHT NOT CHARGING. REMOVED AND REPLACED FWD FLASHLIGHT BATTERY PER MM.SDR SWAA032668Tube · wornDURING T/E FLAP EXTENSION, LT T/E FLAP POSITION INDICATED 30, WHILE THE RT INDICATED 25. REMOVED AND REPLACED RT T/E FLAP TRANSMISSION TORQUE TUBE PER MM.SDR SWAA031819Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA031559Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D + 2, JUST BELOW STR 23L. REPAIRED SKIN PER SRM.SDR SWAA030342Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020788Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (8 EA) BETWEEN STR 7R AND 8R, BS'S 500, 480, 440, 400, 787, 827, 867 AND 907. REPAIRED FRAMES PER SRM.SDR SWAA020787Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (5 EA) BETWEEN STR 7L AND 8L, BS'S 380, 400, 827, 867 AND 907.. REPAIRED FRAMES PER SRM.SDR SWAA020746Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 500B, STR 10R. REPAIRED STR PER SRM.SDR SWAA020745Wedge · delaminatedDURING SCHEDULED D CHECK, FOUND NR 3 L/E SLAT INBD T/E WEDGE DELAMINATED. REPAIRED NR 3 L/E SLAT WEDGE PER SRM.SDR SWAA020744Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME AND SHEAR TIE CRACKED AT BS 967, BETWEEN STR 5L AND 7L. REPAIRED FRAME AND SHEAR TIE PER SRM.SDR SWAA020721Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA020711Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA020710Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (5 EA) AT BS 500D AT STR 4L, BS 616 AT STR 5R, BS 663 AT STR 10L, BS 639 AT STR 4L, BS 907 AT STR 8L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020709Web · crackedDURING SCHEDULED D CHECK, FOUND WEBS CRACKED (3 EA) AT BS 295 AT STR 12L, BS 295 AT STR 7L, BS 278 AT STR 14 R. REMOVED WEBS PER SRM.SDR SWAA020706Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 1040, BETWEEN STR 2R AND 3R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA020702Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 500D, STR 19R. REMOVED AND REPLACED STR TIE CLIP PER SRM.SDR SWAA020701Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 727A, STR 5R. REMOVED AND REPLACED STR TIE CLIP PER SRM.SDR SWAA020700Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STR TIE CLIP PER SRM.SDR SWAA020699Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER TIE CLIPS CRACKED (2 EA) AT STR 10R, BS 500 AND 500B. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020675Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (2 EA) AT BS 500C, STR 10R AND BS 700, STR 3R. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020674Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (2 EA) AT STR 4R, BS 727B AND 727C. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020662Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (2 EA) AT BS 500A, STR 10R AND BS 500D, STR 8R. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020654Bracket · corrodedDURING SCHEDULED D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE, BOTH FWD AND AFT GIRT BAR BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER MM.SDR SWAA020640Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, WL 208 AND LBL 25.5. REPAIRED FLOORBEAM PER SRM.SDR SWAA020649Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4R. REMOVED AND REPLACED STR CLIP PER MM.SDR SWAA020449Cover · missingEEPLS COVER MISSING AND WIRES EXPOSED AT LT OVERWING EMERGENCY EXIT. REMOVED AND REPLACED EEPLS LIGHT ASSY AND SECURED WIRES PER MM.SDR SWAA020119Cover · looseDURING SCHEDULED RON, FOUND EEPLS WIRING EXPOSED AT ROW NR 11. SECURED EEPLS COVER PER MM.SDR SWAA013164Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTANTLY DEPLOYED. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013086Frame · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND LT VERTICAL CHORD CRACKED .25 INCH LONG AT BS 178, WL 184 & LBL 5.7. REPAIRED CHORD PER SRM.SDR SWAA013073Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED 1.0 INCH LONG AT BS 179, WL 182 & LBL 17.0. REPAIRED WEB PER SWA RA 1-353-2712.SDR SWAA012040Lens · missingDURING SCHEDULED C1 CHECK, FOUND OVERHEAD EMERGENCY EXIT BULL NOSE LIGHT MISSING LENS AT ROW 2 DEF. INSTALLED EXIT LENS PER MM.SDR SWAA011314Wire · exposedEEPLS TRACK WIRING EXPOSED AT MID CABIN. RESECURED EEPLS WIRING PER MM.SDR SWAA011280Wire · exposedEEPLS TRACK WIRING EXPOSED. RESECURED EEPLS WIRES PER MM.SDR SWAA011125Wire · exposedDURING SCHEDULED C4 CHECK, FOUND EEPLS WIRING EXPOSED AT ROW 11. SECURED EEPLS WIRING PER MM.SDR SWAA010705Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT FWD ENTRY DOOR. INSTALLED LENS PER MM.SDR SWAA010714Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010278Cover · missingEEPLS TRACK COVER MISSING AND WIRES EXPOSED AT EMERGENCY EXIT ROW. SECURED WIRING AND REPLACED TRACK COVER PER MM.SDR SWAA001132Lens · brokenDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT LENS BROKEN AT FWD F/A SEAT BULKHEAD. R & R LENS PER MM.SDR SWAA000434Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA992004Warning System · activatedABOTED TAKEOFF, TAKEOFF WARNING SOUNDED. ALL CONTROLS IN NORMAL POSITION. C/W TAKEOFF WARNING TEST. OPS CK GOOD.SDR SWAA991992Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR FRAME CRACKED AROUND STOPS NR 3 AND NR 4. REMOVED AND REPLACED DOOR ASSY PER MM.SDR SWAA991985Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 1048 FRAME CRACKED BETWEEN STRINGERS 2R-3R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA991984Stiffener · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD BOTH VERTICAL STIFFENER CRACKED, LBL 28.5 AND RBL 28.5. REMOVED AND REPLACED VERTICAL STIFFENERS PER SRM.SDR SWAA991936Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991750Light · looseEEPLS WIRING LOOSE AT OVERWING EXIT. SECURED AND INSTALLED LOOSE WIRING PER MM.
Back to N360SW, cancelled Jul 24, 2018