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 SWAA071125Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R. REPAIRED FRAME PER SWA EA.SDR SWAA071126Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 665, LBL 24. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA071070Keelbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND KEEL BEAM CHORD CORRODED AT BS 520, LBL 6.5. REPAIRED KEEL BEAM CHORD PER SRM.SDR SWAA071050Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071017Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND RT WING NR 6 L/E SLAT SKIN LOWER SURFACE CRACKED. REPAIRED SLAT PER SRM.SDR SWAA070861Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 731D, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA064515Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA064232Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT INOP AT ROW 8 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064062Slide · out of adjustDURING SCHEDULED BWI CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA063569Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA063393Lens · dislodgedRIGHT OVERWING EMERGENCY EXIT LIGHT LENS FELL OFF. SECURED LIGHT LENS PER MM.SDR SWAA063047Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA063027Slide · low pressureDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA063026Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA063025Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA061467Frame · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR FRAME CRACKED AT FWD LOWER STOP FITTING. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA061263Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 731D, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA060528Bulb · inoperativeDURING SCHEDULED SPECIAL VISIT, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT SLIDE LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA060526Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING, BS 440, RBL 25. REPAIRED FRAME PER BFG ER.SDR SWAA060520Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA060491Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 178 BULKHEAD, RBL 5.7, WL 184. REPAIRED WEB PER BFG ER.SDR SWAA060449Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 359, STR 16L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA060364Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 359, STR 14L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA060347Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA060346Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CRACKED AT BS 807, STR 14R. REPAIRED STRINGER PER SRM.SDR SWAA060305Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND COCKPIT FLOOR WEB CRACKED BETWEEN BS 188 TO BS 196, RH SIDE, WL 207. REPAIRED FLOOR WEB PER SRM.SDR SWAA060314Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CRACKED AT BS 380, STR 15L. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA060281Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, RT SIDE, WL 207. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA060251Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 867, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054038Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA054037Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA054036Pressure Panel · crackedDURING SCHEDULED C3 CHECK, FOUND NLG W/W UPPER CEILING WEB CRACKED AT BS 251.625, RBL 7.75 & LBL 7.75. REPAIRED WEB PER SWA EA.SDR SWAA053908Module · burnedBURNING ODOR IN CABIN ALONG WITH SEVERAL MASTER CAUTION LIGHTS ILLUMINATED. FOUND LOCK FAIL LIGHT ASSY BURNT ON COCKPIT DOOR LOCK MODULE ASSY. REMOVED AND REPLACED COCKPIT DOOR LOCK MODULE ASSY PER MM.SDR SWAA052467Glowstrip · damagedDURING SCHEDULED SERVICE CHECK, FOUND FWD SECTION EEPLS PHOTO LUMINESCENT STRIP DAMAGED. REMOVED AND REPLACED STRIP PER MM.SDR SWAA051701Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA051459Hook · looseDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK LOOSE. SECURED HOOK PER SRM.SDR SWAA050375Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 935, STRINGER 25R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050358Skin · crackedDURING SCHEDULED CHECK, FOUND FUSELAGE SKIN AT BS 935, STRINGER 25R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043086Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND BOTH RT AND LT FWD OUTBOARD MLG HANGER FITTINGS CORRODED. REMOVED AND REPLACED BOTH RT AND LT HANGER FITTINGS PER EA.SDR SWAA043076Bushing · wornDURING SCHEDULED C3 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE BUSHING PER MM.SDR SWAA042964Pin · shearedDIVERSION, RT MLG UNSAFE LIGHT ILLUMINATED, AFTER LANDING GEAR RETRACTION ON TAKEOFF. CYCLED GEAR DOWN NORMAL INDICATION, LANDING GEAR TO UP POSITION RT MLG UNSAFE LIGHT ILLUMINATED. REMOVED AND REPLACED RT MLG TRUNNION ANTI ROTATION PIN PER MM.SDR SWAA042517Window Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND COCKPIT L1 WINDOW POST UPPER OUTBOARD CORNER CRACKED. REPAIRED WINDOW POST PER SRM.SDR SWAA042505Lamp · inoperativeDURING SCHEDULED 1/2D CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT AT ROW 3 ABC, INOP. RELAMPED LIGHT PER MM.SDR SWAA042450Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND LEFT WING RIB LOWER CHORD CRACKED AT WBL 135.5. REPAIRED RIB PER SWA EA.SDR SWAA042430Slide · out of adjustDURING SCHEDULED 1/2D CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA042415Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT HORIZONTAL STAB LOWER SKIN AT STATION 144, RT STATION 117, AFT SPAR CRACKED. REPAIRED STAB SKIN PER SRM.SDR SWAA042381Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TIE CLIP AT BS 663, STRINGER 10R, CRACKED. REMOVED AND REPLACED STRINGER TIE CLIP PER SRM.SDR SWAA042337Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 727B, STRINGER 22L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA042336Bracket · crackedDURING SCHEDULED 1/2D CHECK, FOUND R2 DOOR EVAC SLIDE FWD UPPER MOUNT BRACKET CRACKED. REMOVED AND REPLACED FWD UPPER BRACKET PER MM.SDR SWAA042192Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY AND BATTERY PER MM.
Back to N351SW, cancelled Sep 8, 2017