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 SWAA082346Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME VERTICAL WEB CRACKED AT FWD ENTRY DOOR CUTOUT BS 303, STR 16L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082347Actuator · brokenDURING SCHEDULED BRDG CHECK, FOUND RIGHT WING NR 5 SPOILER OUTBOARD ACTUATOR CASTING BROKEN. REMOVED AND REPLACED ACTUATOR PER MM.SDR SWAA082324Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082239Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 25R. REPAIRED FRAME PER SRM.SDR SWAA082175Flap · delaminatedDURING SCHEDULED BRDG CHECK, FOUND RIGHT WING OUTBOARD T/E AFT INBOARD END DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA082174Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA082173Insert · pulledDURING SCHEDULED BRDG CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHT PANEL HAS ONE INSERT PULLED OUT. REMOVED AND REPLACED INSERT PER MM.SDR SWAA082172Skin · delaminatedDURING SCHEDULED BRDG CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP INBOARD UPPER AND LOWER SURFACE DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081481Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA076291Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075081Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074752Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074589Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA074428Battery · faultyAFT CABIN EMERGENCY EXIT LIGHTS WILL NOT SHUT OFF. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA072148Shear Tie · corrodedDURING SCHEDULED 14Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 22R. R&R SHEAR TIE PER SRM.SDR SWAA072147Bulkhead · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE BULKHEAD WEB CRACKED AT BS 178, RBL 10.5 TO RBL 12, WL 218. REPAIRED WEB PER SRM.SDR SWAA072116Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 514, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA072117Pushrod · corrodedDURING SCHEDULED 14Y CHECK, FOUND LT ELEVATOR TRIM TAB PUSH ROD FWD ROD END CORRODED. R&R TRIM TAB PUSH ROD PER MM.SDR SWAA072093Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 767 AND BS 787, STR 17R. REPAIRED WEB PER SRM.SDR SWAA072092Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 727D AND BS 727E, STR 17R. REPAIRED WEB PER SRM.SDR SWAA072075Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 747 AND BS 767, LBL 70. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA071974Bearing · wornDURING SCHEDULED 14Y CHECK, LEFT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR HORN BEARING PER MM.SDR SWAA071975Bearing · wornDURING SCHEDULED 14Y CHECK, RIGHT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR HORN BEARING PER MM.SDR SWAA070751Door · out of adjustLEFT OVERWING EMERGENCY EXIT DOOR OUT OF ADJUST. ADJUSTED DOOR PER MM.SDR SWAA070496Hook · looseDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA070497Lens · looseDURING SCHEDULED C1 CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LIGHT LENS PER MM.SDR SWAA064325Skin · delaminatedDURING SCHEDULED MV1 CHECK, FOUND LEFT WING OUTBOARD T/E AFT FLAP DELAMINATED ON INBOARD T/E. REPAIRED FLAP PER SRM.SDR SWAA062456Bushing · wornDURING SCHEDULED C3 CHECK, LT ELEVATOR TAB FAILED FREEPLAY CHECK. REMOVED AND REPLACED LT ELEVATOR INBOARD TAB BUSHING AND BOLT PER MM.SDR SWAA061092Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND LH AFT EMERGENCY EXIT SIDEWALL LIGHT INOP. R & R LIGHT ASSY PER MM.SDR SWAA061091Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA061058Wire · brokenDURING SCHEDULED SERVICE CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT TERMINAL WIRE BROKEN AT ROW 8 DEF. REMOVED AND REPLACED TERMINAL ENDS PER WDM.SDR SWAA060789Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEB CRACKED AT RBL 10, WL 234. REPAIRED WEB PER SRM.SDR SWAA060788Structure · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL CHORD CRACKED AT BS 184, RBL 5.7, WL 184. REPAIRED CHORD PER EA & SRM.SDR SWAA060590Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 733E, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA060589Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA053755Cylinder · damagedNR 1 MLG WHEEL/TIRE ASSY MISSING. FOUND LT MLG OTBD WHEEL AXLE DAMAGED. REMOVED AND REPLACED NR 1 AND NR 2 MLG WHEEL/TIRE ASSY, LT MLG INNER CYLINDER, TUBE SUPPORT AND METERING PIN. REMOVED AND REPLACED NR 1 AND NR 2 ANTI SKID TRANSDUCERS, NR 1 AND NR 2 BRASDR SWAA053498Bracket · looseDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FLOOR BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA052637Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING OTBD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA051631Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR CUTOUT, LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA051614Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS AT L2 DOOR UPPER HINGE CUTOUT & 1 EA AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA051034Slide · unserviceableDURING SCHEDULED A2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATING LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA050669Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACK AT BS 727D, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA050257Bearing · stickingCREW REPORTS AILERON CONTROL STICKING. REMOVED AND REPLACED RT CONTROL COLUMN BEARING PER MM.SDR SWAA043298Slide · out of adjustL1 AND L2 DOOR EVAC SLIDES WOULD NOT ARM. SWAPPED SLIDE POSITIONS PERT MM.SDR SWAA042913Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 COCKPIT WINDOW C/D POST CRACKED AT UPPER CORNER. REPAIRED SKIN PER SRM.SDR SWAA042912Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER FWD CORNER CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA042849Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 663.5, LBL 32, CRACKED. REPAIRED WEB PER SRM.SDR SWAA042848Skin · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING INBOARD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED RT WING T/E FLAP PER MM.SDR SWAA042847Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR FRAME CUTOUT AT UPPER STOP, CRACKED. REPAIRED FRAME PER SRM.SDR SWAA042835Slide · out of adjustDURING SCHEDULED 1/4D CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.
Back to N360SW, cancelled Jul 24, 2018