N342SW, cancelled Oct 26, 2017
Service difficulty reports · 250
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 = 'N342SW' AND deregistration_id = 'N342SW-2017-10-26' 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 = 'N342SW' AND deregistration_id = 'N342SW-2017-10-26' 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 SWAA041015Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM WEB AT RT BS 360 TO RT BS 380, LT BS 400 TO LT BS 420, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER EA.SDR SWAA041018Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 500B, STRINGER 20L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA041016Keelbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND RT KEEL BEAM FLANGE BS 500D + 2, AND RT KEEL BEAM FLANGE BS 522, CORRODED. REPAIRED KEEL BEAM FLANGE PER EA.SDR SWAA041003Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIPS AT BS 727B, STRINGER 25R, BS 727B, STRINGER 25L, BS 727D, STRINGER 23L, BS 727E, STRINGER 23L, BS 747, STRINGER 22L, CRACKED. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA041004Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOOR WEB AT BS 270 TO BS 277, CRACKED. REMOVED AND REPLACED FLOOR WEB PER SRM.SDR SWAA040419Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND RT AND LT MLG FWD HANGER FITTINGS CORRODED. REPAIRED PER EA.SDR SWAA040162Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND RT WING OUTBOARD AFT FLAP DELAMINATED AT INBOARD AFT CORNER. REMOVED AND REPLACED RT WING OUTBOARD AFT FLAP PER MM.SDR SWAA032829Skin · crackedDURING SCHEDULED PM CHECK, FOUND 3 EA FUSELAGE SKIN CRACKS AT BS 500+2, STR 10R, BS 500B, STR 10R, AND BS 787, STR 19L. REPAIRED SKIN SECTIONS PER SRM.SDR SWAA031518Door Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR FRAME CRACKED AT AFT LOWER DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA031517Skin · crackedDURING SCHEDULED C2 CHECK, FOUND LT WING SKIN CRACKED AT INBD FIXED L/E JUST OUTBD OF KRUGER FLAP. REPAIRED SKIN PER SWA EA.SDR SWAA030981Lens · brokenEMERGENCY EXIT LIGHT LENS BROKEN NEXT TO FWD F/A SEAT. REMOVED AND REPLACED EMERGENCY EXIT LIGHT LENS PER MM.SDR SWAA030736Pin · corrodedDURING SCHEDULED C1 CHECK, FOUND LT MLG TRUNION PIN CORRODED. REMOVED AND REPLACED LT MLG TRUNNION PIN PER MM.SDR SWAA030565Light · looseEEPLS SECTION LOOSE. SECURED EEPLS PER MM.SDR SWAA030181Frame · crackedDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR CUTOUT FWD CENTER STUB FRAME CRACKED. REPAIRED STUB FRAME PER SWA EA.SDR SWAA022529Battery · dischargedDURING SCHEDULED RON, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA020944Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 12R. REPAIRED SKIN PER SRM.SDR SWAA020072Slat · delaminatedDURING SCHEDULED C4 CHECK, FOUND NR 1 L/E SLAT DELAMINATED APPROX 2 INCH SQUARE ON TOP OTBD T/E. REPAIRED L/E SLAT PER SRM.SDR SWAA013123Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND BOTH FWD SVC AND FWD ENTRY DOOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA012719Lens · looseDURING SCHEDULED 1/4D CHECK, FOUND OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LOOSE & LENS MISSING AT ROW 3 ABC. SECURED LIGHT & INSTALLED LENS PER MM.SDR SWAA012673Rod End · corrodedDURING SCHEDULED 1/4D CHECK, FOUND BOTH LH ELEVATOR TRIM TAB ACTUATING ROD ENDS CORRODED AT FWD END. R&R ROD ENDS PER MM.SDR SWAA012686Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 814, LBL 18 TO RBL 3. REPAIRED FLOORBEAM PER SWA RA 1-353-2668.SDR SWAA011374Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT FOUND WEB CRACKED AT BS 178, LBL 27, WL 207. REPAIRED WEB PER SRM.SDR SWA002773Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 1.5 RT HORIZ STAB LOWER SKIN CRACKED AT REAR SPAR, 6'' OTBD OF ROOT. REPAIRED SKIN PER SRM.SDR SWAA002265Window · leakingAIR TURNBACK, PRESS AIR LEAK AROUND BOTTOM OF FIRST OFFICERS FORWARD WINDOW. RE-TORQUED ALL SCREWS ON WINDOW AND PER MM.SDR SWAA001131Skin · crackedDURING SCHEDULED C2 CHECK, FOUND KEELBEAM SKIN CRACKED BETWEEN RT SIDE OF WHEEL WELL. REPAIRED SKIN PER SRMSDR SWAA000535Cable · looseDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE RELEASE CABLE ATTACH BOLT LOOSE. TIGHTENED BOLT PER MM.SDR SWAA990667Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 986 WL 208 ON PREVIOUS REPAIR. REPAIRED BEAM PER ER 99-0269.SDR SWAA990666Spar · crackDURING SCHEDULED D-CHECK, FOUND THRU EDDY CURRENT INSPECTION, LT WING REAR SPAR CRACKED AT FASTENER HOLE (APPROX FROM WS 285 TO I/B). REPAIRED SPAR PER ER 99-0263.SDR SWAA990665Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 616, WL 202. REPAIRED FRAME PER ER NO NR 99-0270.SDR SWAA990633Skin · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AT BS 931 TO 986 WEB, WL 208, RBL 48 TO 55. REPAIRED WEB PER SRM.SDR SWAA990632Skin · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AT FUSELAGE SKIN AT BS 996 TO 1005 BETWEEN STRINGERS 2L-3L. REPAIRED PER SRM.SDR SWAA990631Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FLOORBEAM TOP FLANGE BS 947, LBL 53. REPAIRED PER SRM.SDR SWAA990630Skin · crackedDURING SCHEDULED D-CHECK, FOUND CRACKS EMITTING FROM NR 6 SLAT ON LOWER LE SKIN AT I/B AUX TRACK. REPAIRED PER ER 99-0228P1 AND BOEING DRAWING 65C30133.SDR SWAA990629Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 480, BETWEEN STRINGERS 8R TO 9R. REPAIRED FRAME PER ER NR 99-0306.SDR SWAA990628Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON AFT CARGO DOOR CUTOUT FRAME, BS 794 BETWEEN STRINGERS 22R TO 28R. REPAIRED FRAME PER SRM.SDR SWAA990613Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA CRACKED FRAMES AT BS 440 AND 480, BETWEEN STRINGERS 8L-9L. REPAIRED PER SRM AND ER NR 99-0283.SDR SWAA990612Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACK AT STRINGER 14L, BS 359. REPAIRED PER SRM.SDR SWAA990611Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACK AT DOOR CUT OUT FRAME, BS 492. REPAIRED FRAME PER SRM.SDR SWAA990598Frame · crackedDURING SCHEDULED D CHECK, FOUND 5 EA FRAMES CRACKED BETWEEN STR 8-9L, BS 827, 867, 907, AND BETWEEN STR 8-9R, BS 787, 867. REAPAIRED FRAMES PER ER NR 99-0283.SDR SWAA990581Frame · crackedDURING SCHEDULED D-CHECK, FOUND 4 FRAMES CRACKED AT BS 400, 440, 500C, 500A BETWEEN STRINGERS 8R-9R. REPAIRED PER SRM AND ER 99-0283.SDR SWAA990580Clip · crackedDURING SCHEDULED D-CHECK, FOUND 3 STRINGER CLIPS CRACKED AT BS 927 STRINGERS 27R, 26R AND 27L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA990579Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND THRU ULTRASONIC INSPECTION 2 CRACKS AT BULKHEAD WEB BS 178 LBL 5 AND RBL 5. REPAIRED PER SRM.SDR SWAA990578Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 4L CRACKED AT TWO FASTENER HOLES BS 907. REPAIRED PER SRM.SDR SWAA990577Frame · crackedDURING SCHEDULED D-CHECK, FOUND STUB FRAME CRACKED AT BS 295 RBL 54.5 WL 209. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA990569Floorbeam · misdrilledDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 967 WITH AN OBLONG HOLE THRU UPPER CHORD, RBL 51.5, WL 208. REPAIRED BEAM PER SRM.SDR SWAA990568Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND THRU ULTRASONIC INSPECTION 2 CRACKS AT BS 178 BULKHEAD, LBL 5-RBL 5. REPAIRED PER SRM.SDR SWAA990565Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND THRU ULTRASONIC INSPECTION, BULKHEAD CRACKED AT BS 178, LBL 7, WL 212. REPAIRED PER SRM.SDR SWAA961425Skin · gougedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 423, AT S18R. REPAIRED PER SWA RA 1-353-1575.SDR SWAA960500Fairing · unsecuredIN FLIGHT, NOTED NR 2 FLAP CANOE FAIRING LOOSE FROM MOUNT. AIRCRAFT RETURNED TO STL AND MADE AN UNEVENTFUL LANDING. INSPECTED, RESECURED FAIRING PIVOT BUSHING BOLT PER BOEING M/M.SDR SWAA950650Seal · failedEXPERIENCED NUMBER 1 ENGINE OIL PRESSURE DROP AND THE CREW PERFORMED ENGINE SHUTDOWN CHECKLIST. AIRCRAFT LANDED AT AMA WITHOUT INCIDENT. REPLACED OIL SEAL, LEAK CHECKED AND PERFORMED POWER ASSURANCE RUN PER BOEING M/M.
Back to N342SW, cancelled Oct 26, 2017