N620SW, cancelled Nov 15, 2018
Service difficulty reports · 407
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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 SWAA053692Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053691Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA053690Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053665Angle · crackedDURING SCHEDULED D CHECK, FOUND VERTICAL STAB LT ANGLE CRACKED AT NR 7 RUDDER HINGE. REPAIRED ANGLE PER SRM.SDR SWAA053664Splice · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 908, STR 4L. REPAIRED STRINGER SPLICE PER SRM.SDR SWAA053663Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA053662Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA053661Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 578, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053647Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500C, LBL 1. REPAIRED SHEAR TIE PER SRM.SDR SWAA053646Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 480, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053645Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 480, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053644Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053643Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA053642Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053641Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053629Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053628Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986.5, BETWEEN RBL 20 TO RBL 41. REPAIRED FLOORBEAM PER SRM.SDR SWAA053118Skin · crackedDURING SCHEDULED C2 CHECK, FOUND RT HORIZONTAL STAB LOWER SKIN CRACKED AT INBD AFT SPAR, STAB STA 110. REPAIRED HORIZONTAL STAB PER SRM.SDR SWAA052573Ballast · inoperativeDURING SCHEDULED A2 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BALLAST PER MM.SDR SWAA052212Cover · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED COVER PER MM.SDR SWAA051760Glowstrip · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND PHOTOLUMINESCENT STRIP DELAMINATED AT FWD END OF CABIN. REMOVED AND REPLACED STRIP PER MM.SDR SWAA043609Panel · crackedDURING SCHEDULED C3 CHECK, FOUND KEEL BEAM LOWER PANEL BETWEEN MLG W/W CUTOUTS, CRACKED. REPAIRED PANEL PER SRM.SDR SWAA040085Battery · inoperativeAFT CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED AFT CABIN EMERGENCY FLASHLIGHT BATTERY PER MM.SDR SWAA032491Slide · wornDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EVACUATION SLIDE GIRT ASSY WORN. REMOVED AND REPLACED SLIDE ASYY PER MM.SDR SWAA031538Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 752, RBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031534Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 727D + 6, FROM RBL 3 TO LBL 12. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031533Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 772, FROM LBL 3 TO LBL 12. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031523Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 27L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA031294Control Cable · wornNO DEFLECTION ON RT AILERON DURING CONTROL INPUT. REMOVED AND REPLACED (3 EA) AILERON BUS CABLES, ABSB-4, ABSA-3 AND ABSB-3 PER MM.SDR SWAA030812Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA030600Hinge · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11139-55, FOUND LH ELEVATOR TAB # 4 HINGE WORN. R&R HARDWARE ON # 4 HINGE PER MM.SDR SWAA022220Lens · looseDURING SCHEDULED C3 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT AT ROW NR 1 LENS LOOSE. SECURED LENS PER MM.SDR SWAA022127Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE PER MM.SDR SWAA021387Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT INBD AFT T/E FLAP DELAMINATED ON BOTTOM SURFACE. REMOVED AND REPLACED LT INBD AFT T/E FLAP PER MM.SDR SWAA020342Pump · faultyAFTER 30 MIN IN FLT B-ELECTRIC HYD LOW PRESS LIGHT ILLUMINATED, WOULD NOT EXTINGUISH. FOUND B-PUMP WIRING BAD. REMOVED AND REPLACED PUMP PER MM.SDR SWAA011433Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA010648Engine · bird strikeAIR TURNBACK, DECLARED EMERGENCY. sMOKE REPORTED IN CABIN. RETURNED TO PHX & EVACUATED A/C THROUGH FWD ENTRY DOOR EVAC SLIDE. EVIDENCE OF BIRD STRIKE TO nr 2 ENG AT 3 O'CLOCK POSITION. BIRD REMAINS IN BOOSTER STAGES. FRESH OIL FOUND IN 5TH STAGE CHECK VALSDR SWAA010395Lens · looseDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA010232Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 RT SIDE CRACKED AT RBL 28.5. REMOVED AND REPLACED SIDE CHORD PER ACO.SDR SWAA010171Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 747 FLOORBEAM CRACKED AT RBL 14. REPAIRED FLOORBEAM PER SRM.SDR SWAA010165Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 860, LBL 3 & RBL 3. REPAIRED FLOORBEAM PER RA.SDR SWAA010164Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD LT SIDE CHORD CRACKED AT LBL 28.5, WL 207. REMOVED AND REPLACED SIDE CHORD PER ACO.SDR SWAA010152Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EXTERNAL FUSELAGE SKIN CRACKS AT BS 1064, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA010134Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SVC DOOR AFT LOWER FRAME CRACKED AT LOWER STOP OUTBOARD FASTENER. REPAIRED DOOR FRAME PER BAC DWG 69-69854.SDR SWAA010119Bracket · looseDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR GIRT ASSY FWD FLOOR BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA002613Cover · looseDURING PREFLIGHT INSPECTION, FOUND EEPLS TRACK COVER LOOSE AT EMERGENCY EXIT ROW. SECURED TRACK COVER PER MM.SDR SWAA001397Ballast · inoperativeDURING SCHEDULED C3 CHECK, FOUND RT EMERGENCY EXIT HATCH SIDEWALL LIGHT INOP. REMOVED AND REPLACED LIGHT BALLAST PER MM.SDR SWAA000096Cover · missingEEPLS MISSING COVER AT MID CABIN. REPAIRED WIRING AND REPLACED COVER PER MM.SDR SWAA991678Cover · looseDURING SCHEDULED C4 CHECK, FOUND EEPLS COVER LOOSE AT OVERWING EXITS. SECURED COVERS PER MM.SDR SWAA991519Coalescer Bag · dirtyOILY ACRID SULFUR SMELL IN THE CABIN DURING FLIGHT. REMOVED AND REPLACED RT A/C WATER SEPARATOR COALESCER BAG PER MM. OPERATED SYSTEM, ODOR WENT AWAY.
Back to N620SW, cancelled Nov 15, 2018