N335SW, cancelled Jan 3, 2018
Service difficulty reports · 389
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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 SWAA030473Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND PAX WINDOW FRAMES CRACKED AT BS 530, STR 12R AND BS 450, STR 5R. REMOVED AND REPLACED BOTH WINDOW FRAMES PER SRM AND SWA AE.SDR SWAA030435Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND SHEAR TIE CRACKED AT BS 360, BELOW STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA030434Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICES CRACKED (2 EA) AT STR 4L, BS 360 & BS 908. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA030441Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (2 EA) AT BS 867, BELOW STR 13R AND BS 847, BELOW STR 14R. REPAIRED SKIN PER SWA ACO AND ERO.SDR SWAA022749Cover · crackedDURING SCHEDULED C3 CHECK, FOUND EEPLS COVERS CRACKED BETWEEN ROWS NR 6 AND NR 9. REMOVED AND REPLACED COVERS PER MM.SDR SWAA021888Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RT WING OTBD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED OTBD T/E AFT FLAP PER MM.SDR SWAA021887Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, ABOVE STR 14R. REPAIRED SKIN PER SRM.SDR SWAA013275Brake · out of adjBRAKES SPONGY, FOUND THE CLEARANCE BETWEEN THE LEFT NORMAL BRAKE METERING VALVE PLUNGER AND ROLLER OUT OF TOLERANCE. ADJUSTED SAME GAP TO WITHIN TOLERANCE IAW MM. PERFORMED BRAKE SYSTEM TEST AND A/C TAXI CHECK, BRAKES OPERATE NORMAL.SDR SWAA012908Slat · crackedDURING SCHEDULED C3 CHECK, FOUND ( 7 EA ) CRACKS AT # 2 L/E SLAT ON AFT ROW OF RIVETS LOWER T/E. REPAIRED SLAT PER SWA RA 1-357-1125.SDR SWAA012887Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED 2.5 INCHES AT BS 520, STR 12L. REPAIRED SKIN PER SRM.SDR SWAA011923Cover · looseEEPLS COVER NOT SECURED AT ROW 8. SECURED COVER PER MM.SDR SWAA011922Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA010665Coalescer Bag · dirtyAIR TURNBACK. SMOKE AND FUMES IN CABIN. FOUND WATER SEPARATOR BAGS DIRTY. REMOVED AND REPLACED BAGS AND RAN BOTH ENGINES AT 75 PERCENT N1 FOR 10 MINS. NO SMOKE OR FUMES NOTED. REPLACED WATER SEPARATOR BAGS AGAIN FOR MX CONVENIENCE OP''S CHECK GOOD PER MM.SDR SWAA002708Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIES CORRODED AT BS 767, STR 27R & BS 787, STR 26R TO STR 27R. REPAIRED SHEAR TIES PER SRM.SDR SWAA002709Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAMES CRACKED AT BS 440, STR 24R & BS 492.4, STR 24R. REPAIRED FRAMES PER SRM.SDR SWAA001102Girt Bar · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001101Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000659Transmitter · malfunctionedAIR TURNBACK -B- SYS HYD ELECTRIC PUMP LOW PRESS LIGHT ILLUMINATED. ALL HYD QTY AND PRESS INDICATORS NORMAL. R&R B-SYS HYD PRESS TRANSMITTER AND -B- SYS HYD ELECTRIC PUMP PER MM.SDR SWAA991954Axle · shearedON ARRIVAL TO GATE, FOUND RT NLG TIRE/WHEEL ASSY MISSING. FOUND NLG RT AXLE SHEARED JUST OUTBOARD OF INNER BEARING. REMOVED AND REPLACED LOWER STRUT ASSY AND REMOVED AND REPLACED BOTH NLG TIRE/WHEEL ASSY'S PER MM.SDR SWAA990401Frame · crackedDURING SCHEDULED C1 CHECK, FOUND A CRACK 3.7 INCH AFT LOWER CORNER OF R1 DOOR FRAME OF FUSELAGE. REPAIRED FRAME PER SRM.SDR SWAA981912Light · looseDURING SCHEDULED C3 CHECK, FOUND EMERGENCY EXIT LIGHT ASSY LOOSE ABOVE 5D. REPAIRED EMERGENCY LIGHT ASSY PER BOEING MM.\N\N\N\N\N\N\N\NREPLACED LIGHT & LENS ASSY'S AS PER BOEING MM.\N\N\N\N\N\N\N\N\N\NREPAIRED PER BOEING SRM.\N\N\N\N\N\N\N\N\N\N\N\N\N\N\N\NRESDR SWAA981177Chord · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED Z-CHORD AT BS 270 RBL 11, LBL 11 WL 208. REPAIRED PER BOEING SRM.SDR SWAA981176Skin · wornDURING SCHEDULED D-CHECK, FOUND FUSELAGE CROWN SKIN HAS A WORN AREA AT BS 967 TO 987, RBL 12 COMMON TO DORSAL FIN, BS 967 TO 986 LBL 12, 7, BS 920 TO 967 RBL 10. REPAIRED PER BOEING SRM.SDR SWAA981175Shear Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AT BS 472 TO 480, RBL 68, WL 208 ON SHEAR WEB. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981174Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED AFT CARGO FLOOR SUPPORT ZEE ANGLE LBL 21, UPPER SURFACE BETWEEN BS 736 AND BS 947. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981123Strap · corrodedDURING SCHEDULED D CHECK, FOUND TEAR STRAP CORRODED AT BS 794 TO 850, RBL 20.5. REPLACED PER BOEING SRM.SDR SWAA981109Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB AT BS 992, LBL 34, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981108Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME PAX CABIN UPPER LOBE STRUCTURE, RIGHT HAND SIDE AT BS 787 BETWEEN STR 8 AND 9. REPAIRED PER BOEING SRM.SDR SWAA981107Floorbeam · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED FLOORBEAM WEB AT BS 328, RBL 35, WL 206. REPAIRED PER BOEING SRM.SDR SWAA981106Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME PAX CABIN UPPER LOBE STRUCTURE LEFT HAND AT BS 727D BETWEEN STR 8 AND 9, BS 727D RIGHT HAND SIDE BETWEEN STR 8 AND 9 AND BS 747 RIGHT HAD SIDE BETWEEN STR 8 AND 9. REPAIRED PER BOEING SRM.SDR SWAA981105Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 344 TO 360, LBL 0, WL 208 AND BS 312 TO 328, RBL 35, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981104Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FUSELAGE FRAME AT BS 827, BETWEEN STR 8 AND 9 RT AND BS 827, BETWEEN STR 8 AND 9 RT. REPAIRED PER BOEING SRM.SDR SWAA981103Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FUSELAGE FRAME AT BS 480, BETWEEN STR 8 AND 9 RT, BS 500A BETWEEN STR 8 AND 9 RT AND BS 500C BETWEEN STR 8 AND 9 RT. REPAIRED PER BOEING SRM.SDR SWAA981102Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED PASSENGER COMPARTMENT, SHEAR WEB, CREASE BEAM, BETWEEN BS 400 TO 420, WL 208, LBL 64 TO 71, AND BS 460 TO 480, WL 208, LBL 69. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981101Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 993, LBL 25 TO 28, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981100Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FUSELAGE FRAME AT BS 787, BETWEEN STR 9 AND 9L, BS 907 BETWEEN STR 8 AND 9L AND BS 867 BETWEEN STR 8 AND 9L. REPAIRED PER BOEING SRM.SDR SWAA981099Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FUSELAGE FRAME AT RT HAT RACK SUPPORT BS 440 BETWEEN STR 8 AND STR 9 RT. REPAIRED PER BOEING SRM.SDR SWAA981098Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED AFT CARGO FLOOR SUPPORT AT BS 792 TO 801, RBL 8, WL 157. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981097Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED AFT CARGO FLOOR SUPPORT AROUND FASTENER HOLE AT BS 727E+3, LBL 2, WL 155, BS 773, LBL 11, WL 156, AND BS 754, RBL 3, WL 155. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981096Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED AFT CARGO FLOOR SUPPORT AROUND FASTENER HOLE AT BS 727D+5, RBL 8, WL 155, BS 727D+5, RBL 3, WL 155, AND BS 773, LBL 2, WL 175. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981091Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED AFT CARGO FLOOR SUPPORT AROUND FASTENER HOLE AT BS 773, RBL 8, WL 156. REPAIRED PER BOEING SRM.SDR SWAA981079Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT LOWER END CORNER AT BS 344, LBL 37, WL 285. REPAIRED PER BOEING SRM.SDR SWAA981078Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED AT BS 1037 BETWEEN STRS 12 AND 14 LT (SKIN). REPAIRED PER BOEING SRM.SDR SWAA981077Angle · wornDURING SCHEDULED D-CHECK, FOUND RT FUSELAGE TO VERTICAL STAB SKATE ANGLE WORN. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981069Intercostal · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED INTERCOSTAL AT BS 344 TO 360, LBL 11, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981068Angles · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FWD GALLEY DOORWAY LOWER SILL SUPPORT Z-ANGLES, NR 1, 3, 4. REPAIRED PER BOEING SRM.SDR SWAA981067Floor · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOOR WEB AT BS 1030, LBL 9, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981066Stringer · damagedDURING SCHEDULED D-CHECK, FOUND STRINGER 28L, AT BS 500+7 EFFECTS INSTALLATION OF VHF SUPPORT STRUCTURE MODIFICATION. REPAIRED SECTION OF STRINGER PER BOEING SRM.SDR SWAA981065Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED AFT CARGO FLOOR SUPPORT AROUND FASTENER HOLE AT BS 860, RBL 8, WL 164. REPAIRED PER BOEING SRM.SDR SWAA981064Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED AT BS 178 BULKHEAD WEB WL 197 TO 201.4, RBL 4.7. REMOVED AND REPLACED PER BOEING SRM.
Back to N335SW, cancelled Jan 3, 2018