N309SW, cancelled May 22, 2017
Service difficulty reports · 454
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 = 'N309SW' AND deregistration_id = 'N309SW-2017-05-22' 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 = 'N309SW' AND deregistration_id = 'N309SW-2017-05-22' 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 SWAA013405Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR EXTERNAL SKIN CRACKED ON AFT EDGE, 8 INCHES FROM TOP. REPAIRED SKIN PER SWA RA.SDR SWAA013392Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND SKIN CRACKED AT FWD SERVICE DOOR AROUND LOWER HINGE. REPAIRED SKIN PER SRM.SDR SWAA013391Angle · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD VERTICAL CHORD ANGLE CRACKED, LBL 5.7, WL 190. REPAIRED VERTICAL CHORD ANGLE SECTION PER SRM.SDR SWAA013378Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED, BS 938, STRINGER 23R. REPAIRED SKIN PER SRM.SDR SWAA013377Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CORRODED, BS 480, BETWEEN STRINGERS 27L AND 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA013376Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER 28R CORRODED, BS 480. REPAIRED STRINGER PER SRM.SDR SWAA013375Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER 26L CORRODED, BS 500A. REPAIRED STRINGER PER SRM.SDR SWAA013367Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND BS 860 AND BS 859, LBL 3, LONGITUDINAL BEAM CORRODED AT NUT PLATE HOLES. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA013366Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD RT SIDE CHORD CRACKED, WL 207. REMOVED AND REPLACED SIDE CHORD PER SWA ACO.SDR SWAA013365Beam · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT SIDE STRINGER 18A SHEAR BEAM CRACKED AT BS 706. REPAIRED SHEAR BEAM PER SRM.SDR SWAA013356Light · inoperativeDURING SCHEDULED 1/4D CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHTS INOP AT ROWS 10 ABC AND 7 ABC. REMOVED AND REPLACED LIGHT ASSY'S PER MM.SDR SWAA013353Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 180 VERTICAL WEB CRACKED, WL 183, LBL 17. REPAIRED WEB PER SRM.SDR SWAA013352Slide · tornDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY TORN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA013357Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND KEEL BEAM CORRODED AT VERTICAL LEG, BETWEEN BS 514-BS 520, STRINGER 28R. REPAIRED PER SWA RA.SDR SWAA013349Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED, BS 933 TO BS 935, STRINGER 24R. REPAIRED SKIN PER SRM.SDR SWAA012941Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED 2 INCHES AT BS 727E + 12, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA012940Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, ABOVE STR 11L. REPAIRED SKIN PER SRM.SDR SWAA012939Skin · crackedDURING SCHEDULED C4 CHECK, FOUND KEEL BEAM SKIN CRACKED 2 INCHES BETWEEN MLG W/W CUT OUTS RH SIDE. REPAIRED SKIN PER SWA T1-153-009.SDR SWAA012729Skin · crackedDURING WALK AROUND INSPECTION FOUND FUSELAGE SKIN CRACKED 2.5 INCHES LONG AT BS 470, BETWEEN STR 15L & 16L. REPAIRED SKIN PER SRM.SDR SWAA012401Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED ( 5 LONG ) AT BS 947.6, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA012233Lens · looseEEPLS LENS LOOSE IN FWD CABIN. SECURED EEPLS LENS PER MM.SDR SWAA012111Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED APPROX 3.35 LONG, BS 380, STR 10L. REPAIRED SKIN PER SWA RA AND SRM.SDR SWAA011925Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA011207Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING INBD FOREFLAP DELAMINATED ON UPPER SURFACE. R&R FOREFLAP PER MM.SDR SWAA011208Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 5 LONG EXTERNAL FUSELAGE SKIN CRACK AT BS 500D, ABOVE STR 10L. REPAIRED SKIN PER SRM.SDR SWAA010270Gusset · crackedDURING SCHEDULED SERVICE CHECK, FOUND NOSE LANDING GEAR MAIN ACTUATOR UPPER ATTACH POINT GUSSET CRACKED. REMOVED AND REPLACED GUSSET BRACKET PER SRM.SDR SWAA010039Skin · crackedDURING SCHEDULED C1 CHECK, FOUND .75 INCH EXTERNAL FUSELAGE SKIN CRACK AT AFT SVC DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA010037Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 1 EXTERNAL FUSELAGE SKIN CRACK AT AFT ENTRY DOOR CUTOUT, UPPER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA010038Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 2.0 EXTERNAL FUSELAGE SKIN CRACK AT BS 727E, BELOW STR 18R. REPAIRED SKIN PER SRM.SDR SWAA010036Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 3.0 EXTERNAL FUSELAGE SKIN CRACK AT BS 270, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA010028Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR SIDEWALL EMERGENCY EXIT LIGHT BULBS INOP. REMOVED AND REPLACED BULBS PER MM.SDR SWAA002764Slide · detachedFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002278Battery · inoperativeLOWER AFT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA001866Skin · crackedDURING SCHEDULED C4 CHECK, FOUND .75 INCH CRACK ON RT HORIZONTAL STAB LWR SKIN SURFACE, 2 FWD OF BAL PNL 9208R. REPAIRED SKIN PER SRM.SDR SWAA001345Fan · failedAIR TURNBACK, AFTER TAKEOFF MODERATE TO SEVERE VIBRATION NOTED. C/W ACFT VIBRATION CONDITION INSP, FOUND RT A/C PACK TURBO FAN FAILURE. REMOVED AND REPLACED SAME PER MM.SDR SWAA991193Slide · deployedFWD ENTRY DOOR EVACUATION SLIDE ACCIDENTALLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991192Chord · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR NR 2 LOWER T-CHORD CRACKED. REMOVED AND REPLACED T-CHORD PER SRM.SDR SWAA991191Chord · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD CARGO DOOR NR 3 LOWER T-CHORD CRACKED. REMOVED AND REPLACED T-CHORD PER SRM.SDR SWAA991181Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND 4 EA SHEAR TIES CRACKED, BS 400 AND 440, STRINGER 14R, BS 460, STRINGER 14L, AND BS 360, STRINGER 13L. REPAIRED SHEAR TIES PER SRM.SDR SWAA991164Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM, BS 294.5, BL 0 - LBL 17. REPAIRED BEAM PER SRM.SDR SWAA991163Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT STRINGER 26L, BS 785. REPAIRED STRINGER PER SRM.SDR SWAA991140Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED BULKHEAD, BS 178, LBL 6.5. REPAIRED BULKHEAD PER SRM.SDR SWAA991139Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED STUB FRAME, BS 294, RBL 53. REPAIRED FRAME PER SRM.SDR SWAA991138Keel Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT KEEL BEAM, BS 520. REPAIRED BEAM PER SWA RA NR 1-353-2107 AND SRM.SDR SWAA991137Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM, BS 986 RBL 10-43. REPAIRED BEAM PER SWA RA NR 1-353-2103.SDR SWAA991136Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM, BS 312, AFT AND FWD FLANGES. REPAIRED BEAM PER SWA RA NR 1-353-2109.SDR SWAA991130Pressure Blkhd · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACK AT NOSE WHEEL WELL CEILING PRESSURE BULKHEAD AROUND AFT INBD ACCESS PANEL. REPAIRED PRESSURE BULKHEAD PER SWA RA NR 1-353-2106.SDR SWAA991129Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT BS 986 FLOORBEAM, LBL 29. REPAIRED BEAM PER SWA RA NR 1-353-2103.SDR SWAA991128Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT BS 328 FLOORBEAM, LBL 34. REPAIRED BEAM PER SWA RA NR 1-353-2108.SDR SWAA991122Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EA CRACKS, BS 178 BULKHEAD RBL 1 AND LBL1. REPAIRED BULKHEAD PER SRM.
Back to N309SW, cancelled May 22, 2017