N312SW, cancelled Oct 31, 2011

Service difficulty reports · 320

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 = 'N312SW' AND deregistration_id = 'N312SW-2011-10-31'
  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.

SDR SWAA095645Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 500A, STR 21R. REPAIRED SKIN PER SRM.Sep 1, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA095587Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MM.Aug 29, 2009 · N312SW · Boeing 7373H4 · Escape SlideSDR SWAA094326Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 404, STR 26R. REPAIRED SKIN PER SWA EA.Jun 19, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA094000Skin · crackedDURING SCHEDULED 2HC1 CHECK, SKIN CRACKED AT BS 495, STR 9L. REPAIRED SKIN PER SRM.Jun 19, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA093999Skin · crackedDURING SCHEDULED 2HC1 CHECK, SKIN CRACKED AT BS 855, STR 17R. REPAIRED SKIN PER SRM.Jun 19, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA093998Light · looseDURING SCHEDULED 2HC1 CHECK, EEPLS LOOSE AT ROW 8. SECURED EEPLS PER MM.Jun 19, 2009 · N312SW · Boeing 7373H4 · Emergency LightingSDR SWAA093997Skin · crackedDURING SCHEDULED 2HC1 CHECK, SKIN CRACKED AT BS 947, STR 5R. REPAIRED SKIN PER SWA EA.Jun 19, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA093996Skin · crackedDURING SCHEDULED 2HC1 CHECK, SKIN CRACKED AT BS 906, STR 3L. REPAIRED SKIN PER SWA EA.Jun 19, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA093995Lens · looseBULLNOSE LIGHT LENS LOOSE AT ROW 2. SECURED LENS PER MM.Jun 19, 2009 · N312SW · Boeing 7373H4 · Emergency LightingSDR SWAA093353Keelbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LT KEEL BEAM CRACKED AT BS 713. REPAIRED BEAM PER SRM.May 21, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, KeelSDR SWAA093340Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT KEEL BEAM SHEAR TIE CORRODED AT BS 500D. REPAIRED SHEAR TIE PER BAC DWG.May 20, 2009 · N312SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA093339Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT KEEL BEAM CORRODED AT BS 500D. REPAIRED BEAM PER SRM.May 20, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, KeelSDR SWAA093338Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND R/H KEEL BEAM CORRODED AT BS 533. REPAIRED BEAM PER SRM.May 20, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, KeelSDR SWAA093337Stiffener · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD STIFFENER CORRODED BETWEEN BS 1016 TO BS 1018 AT SIX O'CLOCK POSITION. R&R STIFFENER PER SRM.May 20, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, BulkheadSDR SWAA093314Fuse · blownDURING SCHEDULED 24Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP BETWEEN ROW 2 TO ROW 3. R&R POWER SUPPLY FUSE PER MM.May 20, 2009 · N312SW · Boeing 7373H4 · Emergency LightingSDR SWAA093313Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND L/H KEEL BEAM CHORD CORRODED AT BS 727, LBL 8. R&R BEAM PER SRM.May 20, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, KeelSDR SWAA093304Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, STR 13R. REPAIRED FRAME PER AAR EA.May 20, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA093294Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND R/H KEEL BEAM CORRODED BETWEEN BS 625 TO BS 741, STR 27R. R&R BEAM PER SRM.May 20, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, KeelSDR SWAA093247Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, LBL 24.5. REPAIRED BEAM PER AAR EA.May 19, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Floor BeamSDR SWAA093246Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.May 19, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA093194Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 259.5, BETWEEN STR 20L TO STR 21L. REPAIRED SKIN PER SRM.May 14, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA093161Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.May 13, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA093146Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 986, BETWEEN STR 19R TO STR 20R. REMOVED AND REPLACED SHEAR TIE PER SRM.May 12, 2009 · N312SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA093145Fitting · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPT CRACKED SUPPORT BRACKET AT BS 727, RBL 25. REMOVED AND REPLACED T-FITTING PER SRM.May 12, 2009 · N312SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA093110Lens · looseDURING SCHEDULED 24Y CHECK, FOUND AFT CABIN EMERGENCY EXIT SIGN LENS LOOSE AT BS 907. SECURED LENS PER MM.May 12, 2009 · N312SW · Boeing 7373H4 · Emergency LightingSDR SWAA093109Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM LOWER CHORD CRACKED AT BS 663, RBL 24. REPAIRED BEAM PER AAR EA.May 12, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Floor BeamSDR SWAA093108Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 747, STR 25L. REPAIRED STRINGER PER SRM.May 12, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA093078Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 500D. REMOVED AND REPLACED SHEAR TIE PER SRM.May 12, 2009 · N312SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA092885Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME PER AAR EA.May 7, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA092777Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER EA.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA092776Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA092775Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER LONGITUDINAL FLOORBEAM CRACKED AT BS 707. REPAIRED BEAM PER SI.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Floor BeamSDR SWAA092774Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10L. REMOVED AND REPLACED CLIP PER SRM.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092773Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10L. REMOVED AND REPLACED CLIP PER SRM.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092772Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092771Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092770Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED CLIP PER SRM.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092769Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, STR 16R. REPAIRED FRAME PER SRM.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA092768Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA092767Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26R. REMOVED AND REPLACED CLIP PER SRM.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092766Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 28R TO STR 27R. REPAIRED FRAME PER SRM.May 3, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA092730Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED CLIP PER SRM.Apr 30, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092649Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.Apr 22, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA092648Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 5 L/E SLAT LOWER SKIN CRACKED AT OUTBOARD END. REPAIRED SKIN PER SRM.Apr 22, 2009 · N312SW · Boeing 7373H4 · Leading Edge DevicesSDR SWAA092589Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 9R. REMOVED AND REPLACED CLIP PER SRM.Apr 22, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092567Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16L. REMOVED AND REPLACED CLIP PER SRM.Apr 21, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092566Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME CRACKED AT BS 847, BETWEEN STR 1R TO STR 2R. REPAIRED FRAME PER SRM.Apr 21, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA092530Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10R. REMOVED AND REPLACED CLIP PER SRM.Apr 20, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092456Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED CLIP PER SRM.Apr 15, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA092455Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R. REMOVED AND REPLACED CLIP PER SRM.Apr 15, 2009 · N312SW · Boeing 7373H4 · Fuselage Main, Attach Fittings
Back to N312SW, cancelled Oct 31, 2011