N657SW, cancelled Mar 15, 2018
Service difficulty reports · 446
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 = 'N657SW' AND deregistration_id = 'N657SW-2018-03-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 = 'N657SW' AND deregistration_id = 'N657SW-2018-03-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 SWAA050594Stringer · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE STRINGER SPLICE BETWEEN BS 350 & BS 370, STR 28R. REPAIRED FUSELAGE STRINGER SPLICE PER SRM.SDR SWAA050593Stringer · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE STRINGER SPLICE AT BS 358, STR 27R. REPAIRED FUSELAGE STRINGER SPLICE PER SRM.SDR SWAA050458Shear Tie · corrodedDURING SPV, FOUND SHEAR TIE AT BS 360, STRINGER 27R, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA042160Tee Fitting · crackedDURING SCHEDULED C2 CHECK, FOUND FWD CARGO DOOR LOWER TEE CRACKED. REMOVED AND REPLACED FWD CARGO DOOR PER MM.SDR SWAA042159Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 500D, STRINGER 12R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042158Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA041242Bulkhead · crackedDURING SPV, FOUND BULKHEAD WEB AT BS 178, LBL 7 TO LBL 8, CRACKED. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA041157Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN BELOW L1 DOOR BS 335, LT LOWER SIDE, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041161Skin · corrodedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 540, STRINGER 28R, CORRODED. REPAIRED SKIN PER EA.SDR SWAA041082Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040718Slide · out of adjustR2 DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA040566Cover · crackedDURING SCHEDULED SERVICE CHECK, FOUND EEPLS COVER CRACKED AT ROW 14 DEF. REMOVED AND REPLACED EEPLS COVER PER MM.SDR SWAA032177Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031472Module · faultyABORTED TAKEOFF, WARNING HORN SOUNDED ASSOCIATED WITH L/E INDICATOR LIGHTS. REMOVED AND REPLACED L/E FLAP/SLAT POSITION IND MODULE PER MM.SDR SWAA031253Valve · faultyAIR TURNBACK, UNABLE TO PRESSURIZE CABIN. REMOVED AND REPLACED CABIN PRESSURE RELIEF SAFETY VALVE PER MM.SDR SWAA031202Motor · overheatedDIVERSION TO BOI, BURNING ODOR IN CABIN. REMOVED AND REPLACED GASPER AIR FAN PER MM.SDR SWAA030823Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER BFG ER.SDR SWAA030813Skin · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND NR 5 L/E SLAT OUTBOARD UPPER T/E WEDGE DELAMINATED. REPAIRED NR 5 L/E SLAT PER SRM.SDR SWAA030602Doubler · missingA 4 X 6 INCH PREVIOUS REPAIR MISSING AT NR 3 L/E SLAT UPPER SURFACE. REMOVED AND REPLACED NR 3 L/E SLAT PER MM.SDR SWAA030315Bushing · wornDURING SCHEDULED C1 CHECK, SWA SI 11139-55, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LEFT ELEVATOR TAB NR 1 HINGE HARDWARE AND BUSHING PER SWA SI AND MM.SDR SWAA022584Bearing · wornDURING SCHEDULED C4 CHECK, RT ELEVATOR FAILED FREEPLAY CHECK. REMOVED AND REPLACED RT ELEV TAB CONTROL ROD END BEARING AND BUSHING PER MM.SDR SWAA022522Hydraulic Line · leakingAIR TURNBACK, NOSE LANDING GEAR FAILED TO RETRACT AFTER TAKEOFF. REMOVED AND REPLACED HYDRAULIC HOSE TO NLG LOCK ACTUATOR PER MM.SDR SWAA021860Battery · dischargedDURING SCHEDULED RON, FOUND AFT OVERHEAD EMERGENCY EXIT DOOR LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA020874Hinge · wornDURING SCHEDULED C2 CHECK, FOUND EXCESSIVE AXIAL PLAY AT RT AND LT ELEVATOR TABS. REMOVED AND REPLACED NR 1 TAB HINGES PER MM.SDR SWAA020507Spoiler · delaminatedDURING WALK AROUND INSP, FOUND NR 6 SPOILER DELAMINATED. REMOVED AND REPLACED NR 6 SPOILER PER MM.SDR SWAA020184Lens · missingDURING SCHEDULED C1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED LENS PER MM.SDR SWAA020183Light · disconnectedDURING SCHEDULED C1 CHECK, FOUND CENTER CABIN CEILING EMERGENCY EXIT LIGHT INOP. RECONNECTED WIRING AND OPS CHECK GOOD PER MM.SDR SWAA012415Control Unit · erraticCARGO COMP FIRE INDICATION DURING FLIGHT LASTED ONLY 2 TO 3 SECONDS, REMAINDER OF FLIGHT NORMAL. REMOVED AND REPLACED CCU PER MM.SDR SWAA011849Slat · crackedDURING SCHEDULED C3 CHECK, FOUND # 1 & # 3 L/E SLATS TRAILING EDGE SKINS CRACKED ON AFT ROW OF RIVETS. REPAIRED SLATS PER SWA RA.SDR SWAA010436Indicator · failedDIVERSION, STANDBY ADI FAILED DURING CRUISE. RESET C/B, NO HELP. ALL OTHER SYSTEMS NORMAL. REMOVED AND REPLACED STANDBY HORIZON PER MM, OPS CHECK GOOD.SDR SWAA002637Lens · missingDURING SCHEDULED C1 CHECK, FOUND BULL NOSE EGRESS LIGHT LENS MISSING AT ROW 17ABC. INSTALLED LENS PER MM.SDR SWAA002384Light · malfunctionedDURING SCHEDULED D-CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE LIGHT DIM WHEN TESTED. REMOVED AND REPLACED LIGHT ASSY PER WDM, OHM & MM.SDR SWAA002273Skin · crackedDURING SCHEDULED D-CHECK, FOUND RT OVERWING EXIT DOOR SKIN CRACKED AT FASTENER HOLE, BS 637, WL 245. REPAIRED SKIN PER ER 00-1219.SDR SWAA002272Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STR ATTACH FITTING CORRODED AFT SIDE OF BS 727 BULKHEAD, STR 27L. REPAIRED STR PER SRM.SDR SWAA002229Rib · crackedDURING SCHEDULED D-CHECK, FOUND RT WING LOWER RIB CHORD CRACKED AT WBL 135.0, BETWEEN S2 & S3. REPAIRED RIB ER 00-1172.SDR SWAA002228Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD, LOWER SURFACE, CORRODED AT BS 986.5, LBL 14.5, WL 207.5. REMOVED AND REPLACED ENTIRE UPPER CHORD SECTION PER ER 00-1204.SDR SWAA002227Web · corrodedDURING SCHEDULED D-CHECK, FOUND BS 663 VERTICAL PRESSURE WEB CORRODED AT RBL 38, WL 197. REPAIRED PRESSURE WEB PER ER 00-1203.SDR SWAA002194Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT MLG BEAM STABILIZING LINK FITTING CORRODED. REMOVED AND REPLACED LINK FITTING PER ER 00-1220P1 AND DRW 65-45321.SDR SWAA002193Splice · crackedDURING SCHEDULED D-CHECK, FOUND STR SPLICE CRACKED AT BS 905, STR 14L. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA002195Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STR 14L CRACKED AT BS 905. REPAIRED STR PER SRM.SDR SWAA002187Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 906, LBL 69, WL 230. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA002150Support Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND RT WING MLG SUPPORT BEAM CORRODED AT 3 FASTENER HOLES. REPAIRED MLG SUPPORT PER ER 00-1175 AND SRM.SDR SWAA002143Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, LBL 59, WL 270. REPAIRED FRAME PER TR-A51-002 AND ER 00-1179.SDR SWAA002138Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB UPPER SURFACE AT BS 953, RBL 56, WL 208. REMOVED AND REPLACED DAMAGED WEB PER DWG 65-45855 AND SWA T1-A51-002.SDR SWAA002131Splice · crackedDURING SCHEDULED D-CHECK, FOUND STR SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA002130Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 616, LBL 52, WL 283. REPAIRED FRAME PER SRM.SDR SWAA002129Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT RBL 60, WL 270, BS 807 AND 827. REPAIRED FRAMES PER ER 00-1179 AND SRM.SDR SWAA002128Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT LBL 60, WL 270, BS 747, 807, 827, 847 AND 867. REPAIRED FRAMES PER ER 00-1179 AND SRM.SDR SWAA002086Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR GIRT BAR AFT BRACKET FLOOR FITTING CORRODED. REMOVED AND REPLACED CORRODED GIRT BAR BRACKET FITTING.SDR SWAA002095Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 907, WL 270, RBL 60. REPAIRED FRAME PER SRM.
Back to N657SW, cancelled Mar 15, 2018