N660SW, cancelled Sep 19, 2016
Service difficulty reports · 531
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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 SWAA050095Bearing · wornDURING SCHEDULED C4 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR BEARING AND SLEEVE ON LT CLEVIS PER MM.SDR SWAA043561Light · looseEEPLS STRIP FROM ROW 6 ABC TO ROW 8 ABC, LOOSE. SECURED EEPLS STRIP PER MM.SDR SWAA043545Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED RT OUTBOARD T/E AFT FLAP PER MM.SDR SWAA042838Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 747, STRINGER 24R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042837Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 727E, STRINGER 19R, BS 747, STRINGER 20R. REPAIRED SKIN PER SRM.SDR SWAA042799Skin · crackedDURING SCHEDULED C3 CHECK, FOUND KEELBEAM SKIN AT BS 660, LBL 6.3, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041019Skin · delaminatedDURING SCHEDULED RON, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REPAIRED RT WING OUTBOARD T/E AFT FLAP PER SRM.SDR SWAA040853Cable · misroutedDURING SCHEDULED 1/2D CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA040852Light · looseDURING SCHEDULED C1 CHECK, FOUND RT FWD EEPLS TRACK LOOSE. RESECURED EEPLS TRACK PER MM.SDR SWAA040644Slide · out of adjustL2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040421Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STRINGER 24L. REPAIRED SKIN PER SRM.SDR SWAA040360Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727, STRINGER 24L. REPAIRED SKIN PER SRM.SDR SWAA032720Fitting · crackedDURING SCHEDULED C4 CHECK, FOUND LT MLG ACTUATOR BEAM HANGER FWD MOUNT FITTING CRACKED. REMOVED AND REPLACED HANGER MOUNT FITTING PER MM.SDR SWAA031958Slide · out of limitsDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031730Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SVC DOOR FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA031726Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED (4 EA) AT STR 4R, BS'S 597, 727B, 685 AND 706. REPAIRED SKIN PER SRM.SDR SWAA031725Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED (15 EA) AT STR 4L, BS'S 500D, 571, 602, 625, 626, 628, 630, 631, 632, 647, 649, 653, 658, 669 AND 706. REPAIRED SKIN PER SRM.SDR SWAA031690Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 450, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA031021Keelbeam · corrodedDURING SCHEDULED C3 CHECK, FOUND KEELBEAM CORRODED AT BS 500D + 10 LT. REPAIRED KEELBEAM PER SWA EA.SDR SWAA031001Keelbeam · crackedDURING SCHEDULED C2 CHECK, FOUND 1 INCH LONG CRACK AT KEELBEAM CENTER PANEL, BS 685, STRINGER 28L. REPAIRED KEEL BEAM PANEL PER SRM.SDR SWAA031000Lens · missingDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR LOWER EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY.SDR SWAA030999Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING T/E OUTBOARD AFT FLAP DELAMINATED AT LOWER SURFACE. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA030921Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED ( 4 EA ) AT BS 730 BELOW STR 19R, BS 727E ABOVE STR 23L, BS 764 ABOVE STR 20L & BS 730E BELOW STR 23R. REPAIRED SKIN PER SRM.SDR SWAA030914Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED ( 2 EA ) AT BS 725 @ STR 23R & BS 884 @ STR 24R. REPAIRED SKIN PER SRM.SDR SWAA030923Hinge Fitting · brokenDURING SCHEDULED A2 CHECK, FOUND BROKEN HINGE FITTING ON NR 4 GROUND SPOILER UPPER SIDE. R&R NR 4 GROUND SPOILER & OTBD ACTUATOR PER MM.SDR SWAA030922Structure · delaminatedDURING SCHEDULED A2 CHECK, FOUND RT INBD FOREFLAP DELAMINATED ON UPPER SURFACE. R&R RT INBD FOREFLAP PER MM.SDR SWAA030596Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030586Guide Arm · out of adjustFWD SERVICE DOOR ONLY OPENED PARTIALLY. ADJUSTED UPPER GUIDE ARM PER MM.SDR SWAA030091Skin · crackedDURING SCHEDULED SC CHECK, FOUND FUSELAGE SKIN CRACK BETWEEN BS 727D AND 727E AT STR 20L. REPAIRED SKIN PER SRM.SDR SWAA022896Battery · dischargedAFT LOWER EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA021610Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA021602Fitting · looseDURING SCHEDULED C3 CHECK, FOUND EMERGENCY EVAC SLIDE GIRT BAR ATTACH FITTINGS, LOOSE FASTENERS AT FWD ENTRY DOOR. SECURED FASTENERS PER MMSDR SWAA021331Battery · weakEMERGENCY EXIT LIGHTS ILLUMINATE WHEN SHIFTING PWR FROM A/C PWR TO GRD PWR. REMOVED AND REPLACED M1132 EMERGENCY LIGHT BATTERY PER MM.SDR SWAA020958Roller · wornBINDING IN AILERONS DURING FLAP MOVEMENT. REMOVED AND REPLACED CENTERING MECH CAM ROLLER PER MM.SDR SWAA020182Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT LIGHTS INOP AT FWD SERVICE AND AFT ENTRYWAYS. RELAMPED PER MM.SDR SWAA012656Flap · delaminatedDURING WALKAROUND INSPECTION FOUND LH INBD T/E FLAP DELAMINATED. R&R FLAP PER MM.SDR SWAA012145Housing · brokenDURING SCHEDULED A1 CHECK, FOUND EMERGENCY EXIT LIGHT BATTERY HOUSING FUSE BROKEN. REMOVED AND REPLACED BATTERY HOUSING PER MM.SDR SWAA011413Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011156Container · looseAFT SERVICE DOOR EMERGENCY EVAC SLIDE CONTAINER CAME LOOSE. INSPECTED SLIDE & RESECURED CONTAINER.SDR SWAA010575Charger · inoperativeDURING SCHEDULED RON CHECK, FOUND 2 BULLNOSE EMERGENCY EXIT LIGHTS INOP AT LEFT AFT CABIN. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA010485Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 665, LBL 32. REPAIRED BEADED WEB PER TR T1-353-046.SDR SWAA010484Gusset · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SVC DOOR CRACKED AT AFT LOWER CORNER GUSSET. REPAIRED GUSSET PER BAC DWG.SDR SWAA010452Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD VERTICAL CHORD CRACKED AT LBL 5.7, WL 184. REPAIRED VERTICAL CHORD PER SRM.SDR SWAA010451Lens · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS CRACKED. REPLACED LENS PER MM.SDR SWAA010420Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND 1.5 EXTERNAL FUSELAGE SKIN CRACK AT FWD SVC DOOR CUTOUT, AFT LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA010414Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND .75 INCH EXTERNAL FUSELAGE SKIN CRACK AT AFT SIDE OF EQUIPMENT EXHUAST CUTOUT. REPAIRED SKIN DOUBLER PER SWA ACO.SDR SWAA010388Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CORRODED AT BS 360. REPAIRED SHEAR TIE PER SRM.SDR SWAA010387Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2.5 CRACK AT NLG ACTUATOR SUPPORT WEB, BS 232, BL 0, WL 184. REPAIRED WEB PER SRM.SDR SWAA010386Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 BS 178 BULKHEAD WEB CRACKS AT WL 187.5, LBL 1 & RBL 1. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA010385Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500, RBL 1. REPAIRED FRAME PER SRM.
Back to N660SW, cancelled Sep 19, 2016