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 SWAA062111Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061821Drag Strut · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG LOWER DRAG STRUT UPPER BORE CORRODED. REMOVED AND REPLACED LOWER DRAG STRUT PER MM.SDR SWAA061820Bolt · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG TRUNNION BOLT CORRODED. REMOVED AND REPLACED TRUNNION BOLT PER MM.SDR SWAA061600Slide · dislodgedL1 DOOR EMERGENCY EXIT EVAC SLIDE FELL OUT, DID NOT DEPLOY. REINSTALLED L1 DOOR SLIDE PER MM.SDR SWAA060505Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 513B, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA060504Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 473, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA060155Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR AFT EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA060154Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 733D, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA060143Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT INOP ABOVE ROW 5 DEF. RESEATED LIGHT BULB. OPS CHECK GOOD PER MM.SDR SWAA060142Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT INOP ABOVE ROW 2 ABC. RESEATED LIGHT BULB. OPS CHECK GOOD PER MM.SDR SWAA060141Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT INOP ABOVE L1 DOOR. RESEATED LIGHT BULB. OPS CHECK GOOD PER MM.SDR SWAA060110Shear Tie · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 908, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA060109Lens · looseDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA053937Bulb · inoperativeDURING SCHEDULED C2 CHECK, FOUND R1 DOOR AFT EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA053936Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA053935Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA053934Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA053933Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 780, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA053932Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 347, STR 2L. REPAIRED SKIN PER SRM.SDR SWAA053388Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD CABIN EMERGENCY LIGHTS INOP AT FWD END. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA052622Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA052621Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 492, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA052620Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA051364Wheel · departedNR 3 MLG TIRE/WHEEL ASSY DEPARTED THE AIRCRAFT ON LANDING ROLL. INSPECTED RT MLG FOR WHEEL BEARING FAILURE. NO DAMAGE NOTED. REMOVED AND REPLACED NR 3 MLG TIRE/WHEEL ASSY, BRAKE ASSY & TRANSDUCER PER MM.SDR SWAA050431Battery · inoperativeDURING SCHEDULED C3 CHECK, FOUND OVERHEAD CENTER AISLE EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA050430Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 910, STRINGER 24R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050429Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP, DELAMINATED. REMOVED AND REPLACED LT WING T/E AFT FLAP PER MM.SDR SWAA050425Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT R2 DOOR CUTOUT FWD LOWER CORNER, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050033Lamp · inoperativeDURING SCHEDULED PM CHECK, FOUND FWD SERVICE DOOR EMERGENCY EXTERIOR LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA043135Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500B, STR 8L. REPAIRED SKIN PER SRM.SDR SWAA043134Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS AT BS 271, STR 15L AND STR 9L. REPAIRED SKIN PER SRM.SDR SWAA043010Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 500C + 13, BS 500D + 8, STRINGER 15L. REPAIRED SKIN SECTIONS PER EA.SDR SWAA043009Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 3 EACH FUSELAGE SKIN CRACKS AT BS 451, BS 486, BS 503, STRINGER 16R. REPAIRED SKIN SECTIONS PER EA.SDR SWAA043008Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 749, STRINGER 19L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042495Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 440, STRINGER 26L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042013Frame · corrodedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE FRAME AT BS 927, STRINGER 24L, CORRODED. REPAIRED FRAME SECTION PER SRM.SDR SWAA042012Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA041724Window · crackedRIGHT R1 COCKPIT WINDOW ARCHED AT CRUISE AND DEVELOPED A CRACK, WINDOW HEAT SELECTED OFF, QRH PROCEDURE COMPLETED, WINDOW DEVELOPED MORE SMALL CRACKS ON OUTER PANE. REMOVED AND REPLACED R1 COCKPIT WINDOW PER MM.SDR SWAA041187Skin · crackedFUSELAGE SKIN AT BS 500 D, STRINGER 15L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040959Light · dislodgedEMERGENCY EXIT NOT ARMED LENS FELL OUT. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA040907Actuator · inoperativeDIVERSION, ON FINAL APPROACH TO BUR T/E FLAPS WOULD NOT EXTEND PAST 5 DEGREES. T/E FLAPS WOULD NOT RETRACT, T/E FLAPS WOULD NOT RETRACT/EXTEND WITH ALT FLAP. REMOVED AND REPLACED HYDRAULIC FLAP DRIVE MOTOR PER MM.SDR SWAA040880Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 807, STRINGER 15L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040846Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 516, STRINGER 16L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040525Skin · bulgedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN BULGED AT BS 727 + 13, STRINGER 27R. REPAIRED SKIN PER ER.SDR SWAA040501Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAMES CRACKED AT BS 480, BS 827, BETWEEN STRINGER 8R AND STRINGER 9R, AND BS 807, BETWEEN STRINGER 8L AND STRINGER 9L. REPAIRED FRAME SECTIONS PER ER.SDR SWAA040503Web · crackedDURING SCHEDULED D CHECK, FOUND LT WING FSS 223, INBOARD OF FITTING (D) CRACKED AT WEB CHORD. REMOVED AND REPLACED WEB CHORD PER SRM AND ER.SDR SWAA040502Fitting · corrodedDURING SCHEDULED D CHECK, FOUND LT MLG STABILIZER FORWARD FITTING CORRODED. REMOVED AND REPLACED LT MLG FORWARD FITTING PER BAC DRAWING.SDR SWAA040490Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT UPPER OUTBOARD CORNER OF THE NR 1 WINDOW. REPAIRED SKIN PER SRM.SDR SWAA040489Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 480, BETWEEN STRINGER 8L AND STRINGER 9L. REPAIRED FRAME SECTION PER ER.SDR SWAA040476Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED IN AFT CARGO COMPARTMENT AT BS 767, RBL 8. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to N309SW, cancelled May 22, 2017