N351SW, cancelled Sep 8, 2017
Service difficulty reports · 332
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 = 'N351SW' AND deregistration_id = 'N351SW-2017-09-08' 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 = 'N351SW' AND deregistration_id = 'N351SW-2017-09-08' 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 SWAA041717Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING NR 2 L/E SLAT UPPER T/E CORNER DELAMINATED. REMOVED AND REPLACED NR 2 L/E SLAT PER MM.SDR SWAA041110Frame · crackedDURING SPV, FOUND AFT CARGO DOOR FRAME CUTOUT AT BS 847, STRINGER 25R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA041098Stringer · crackedDURING SPV, FOUND STRINGER 25R, AT BS 896, CRACKED. REPAIRED STRINGER PER SRM.SDR SWAA040603Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT COOLING DUCT CUT OUT. REPAIRED SKIN PER EA.SDR SWAA032554Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EVACUATION SLIDE ASSY OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA032242Bracket · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND R1 DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER MM.SDR SWAA032241Stiffener · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD VERTICAL BEAM WEB CRACKED, WL 177, LBL 5.7. REPAIRED WEB PER SRM.SDR SWAA032240Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEB CRACKED, WL 199, RBL 6.5. REPAIRED WEB PER SRM.SDR SWAA032067Indicator · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031799Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MMSDR SWAA031305Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR ASSY OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA031288Slide · unserviceableDURING SCHEDULED RON, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031052Hook · looseDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EMERGENCY EVACUATION SLIDE GIRT BAR AFT HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA022554Tee Fitting · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR LOWER LONGITUDINAL T-CHORD CRACKED. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA022553Cable · misroutedDURING SCHEDULED CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022262Slide · out of positionDURING SCHEDULED RON, FWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022170Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021406Battery · dischargedBOTH FWD EMERGENCY FLASHLIGHTS INOP. REMOVED AND REPLACED BATTERIES PER MM.SDR SWAA021045Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020508Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT LOWER AFT CORNER OF FWD SVC DOOR CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA020503Connector · disconnectedDURING SCHEDULED 1/4D CHECK, FOUND EEPLS INOP IN FWD CABIN. RECONNECTED CONNECTORS AT BATTERY PACK PER MM.SDR SWAA020493Lens · looseDURING SCHEDULED 1/4D CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS PER MM.SDR SWAA020490Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SVC DOOR AFT FRAME CRACKED (2 EA) AT NR 3 STOP FITTING CUTOUT AND LOWER END. REPAIRED FRAME PER SWA T1.SDR SWAA020489Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SVC DOOR, UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA020481Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND WHEEL WELL CEILING PRESS WEB CRACKED AT BS 665, LBL 31. REPAIRED WEB PER SWA T1.SDR SWAA020480Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 770, LBL 7 AND LBL 17. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA020071Cover · brokenDURING SCHEDULED C1 CHECK, FOUND EEPLS COVER BROKEN AT ROW NR 4. REMOVED AND REPLACED EEPLS COVER PER MM.SDR SWAA013343Combustion Liner · damagedDURING SCHEDULED A2 CHECK, FOUND HOLE BURNED AT PANEL NR 3, AT NR 1 ENG COMBUSTION CHAMBER OUTER LINER, 12 O'CLOCK POS. (SIZE OF HOLE IS APPROX 3 TIMES THE SIZE OF THE NEAREST DILUTION HOLE). REMOVED AND REPLACED NR 1 ENG PER MM.SDR SWAA012654Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT LT OVERWING EXIT. RELAMPED LIGHT PER MM.SDR SWAA012653Socket · defectiveDURING SCHEDULED C4 CHECK, FOUND EEPLS LIGHT INOP (1 EA) AT AFT CABIN. REMOVED AND REPLACED LIGHT SOCKET PER MM.SDR SWAA012652Cap · missingDURING SCHEDULED C4 CHECK, FOUND EEPLS END CAP MISSING IN AFT CABIN. INSTALLED END CAP PER MM.SDR SWAA012370Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED ( 2 EA ) 1 INCH LONG, AT BS 178, WL 188, BLO. REPAIRED WEB PER SRM.SDR SWAA012369Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED AT BS 178 UPPER CORNER. R&R WEB PER SWA ACO.SDR SWAA012359Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEBS CRACKED ( 2 EA ) AT BS 178, WL 232, RBL 17.1 & LBL 17.1. R&R WEBS PER SRM.SDR SWAA011725Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE GIRT ASSY PER MM.SDR SWAA010822Slide · out of adjAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010689Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING OUTBD T/E AFT FLAP DELAMINATED AT INBD AFT CORNER. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA010677Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY AND SVC DOOR EMERGENCY EVAC SLIDE ASSY''S OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY''S PER MM.SDR SWAA010185Skin · crackedDURING WALK-AROUND INSPECTION, FOUND 1.5 INCH EXTERNAL FUSELAGE SKIN CRACK BETWEEN BS 500C & BS 520, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA002457Skin · crackedDURING SCHEDULED C1 CHECK, FOUND NR 6 L/E SLAT SKIN CRACKED AT TWO LOCATIONS; ONE EXTENDS ACROSS THREE FASTENERS AT OTBD AUX TRACK, THE SECOND EXTENDS ACROSS TWO FASTENERS AT OTBD END OF SLAT. REPAIRED SLAT PER SRM.SDR SWAA002456Panel · crackedDURING SCHEDULED C1 CHECK, FOUND 1.5 CRACK AT LOWER KEEL BEAM STRESS PANEL, BETWEEN MLG W/W CUTOUT, RT AFT SIDE. REPAIRED PANEL PER TI-153-009.SDR SWAA002342Transmitter · inoperativeDECLARED EMERGENCY. DURING APPROACH, SELECTED FLAPS 5 DEGREES; FLAPS SHOWED SPLIT ON IND; RT = 0 DEGREES, LT = 1 DEGREE, WITH FLAP SELECTOR IN 5 DEGREE POSITION. REMOVED AND REPLACED RT WING FLAP POSITION TRANSMITTER PER MM.SDR SWAA001574Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA001573Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND LT EMERGENCY EXIT LOWER LIGHT INOP. RELAMPED PER MM.SDR SWAA001071Outflow Valve · inoperativeAIR TURNBACK. UNABLE TO MAINTAIN CABIN PRESSURE. R&R LH A/C PACK VALVE AND 450 DEG MUSCLE LINE PER MM.SDR SWAA000861Indicator · dislodgedAFT ENTRY AND SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATORS OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA000275Indicator · dislodgedDURING SCHEDULED C2 CHECK, FOUND BOTH AFT ENTRY AND SERVICE DOOR EVACUATION SLIDE PRESS INDS OUT OF VIEW. REPOSITIONED BOTH SLIDE ASSY'S PER MM.SDR SWAA991631Connector · brokenDURING SCHEDULED D CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE EXTERIOR LIGHT CONNECTOR CAP BROKEN. REMOVED AND REPLACED LIGHT HOUSING PER MM.SDR SWAA991630Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AROUND AIR CONDITIONING GROUND SERVICE CONNECTION CUT OUT. REPAIRED SKIN PER SRM AND ER NR 99-6051A.SDR SWAA991612Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 328 FLOORBEAM UPPER CHORD CORRODED, RBL 20-RBL 40. REPAIRED BEAM PER SRM.
Back to N351SW, cancelled Sep 8, 2017