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.
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
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 SWAA051944Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727A, STR 5L & STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051943Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, BETWEEN LBL 45 & RBL 45. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA051948Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA CRACKS AT BS 1016 PRESSURE BULKHEAD DOME CAP WEB, 6 & 7 O'CLOCK POSITIONS. REPAIRED WEB PER BFG ER.SDR SWAA051947Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051946Stringer · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 1010, STR 7L. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA051942Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 15 TO LBL 35, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA051941Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 17 TO RBL 50, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA051915Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 11L, STR 12L & STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051913Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 440, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051916Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051914Rib · crackedDURING SCHEDULED D-CHECK, FOUND LT WING LOWER RIB CRACKED AT WBL 135.5, BETWEEN STR 2 & STR 3. REPAIRED RIB PER BFG ER.SDR SWAA051912Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 CRACKS IN FRAME AT BS 380, STR 15R & STR 16R. REPAIRED FRAME PER SRM.SDR SWAA051911Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND LT CREASE BEAM WEB CRACKED AT BS 500C + 14. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA051910Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 480, STR 12L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051920Skin · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CORRODED BETWEEN BS 466 TO BS 470, LBL 1 TO RBL 1. REPAIRED SKIN PER SRM & BFG ER.SDR SWAA051919Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 460, LBL 18. REPAIRED FRAME PER SRM.SDR SWAA051918Skin · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 489, RBL 7. REPAIRED SKIN PER SRM.SDR SWAA051917Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500, LBL 4. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051905Floor Skin · crackedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOOR SKIN CRACKED AT BS 244, RBL 15. REPAIRED FLOOR SKIN PER SRM.SDR SWAA051896Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 706, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051878Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 706, STR 10L & STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051874Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 597, STR 7R & STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051873Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 616, STR 3L, STR 5L & STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051877Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME UPPER STRUCTURE IS CRACKED AT BS 663, STR 1L TO STR 3L. REPAIRED FRAME PER SRM.SDR SWAA051876Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051875Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 639, STR 17L, WL 210. REPAIRED FRAME CHORD PER SRM.SDR SWAA051128Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 489, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA051127Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 939 TO BS 942, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA050722Bolt · wornDURING SCHEDULED C4 CHECK, RT ELEVATOR TAB FAILED THE FREE PLAY CHECK. REMOVED AND REPLACED RT ELEVATOR TAB CONTROL PUSHROD BOLTS & SPACERS PER MM.SDR SWAA050712Frame · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR LOWER FRAME CRACKED AT AFT DOOR STOP FITTING CUTOUT. REMOVED AND REPLACED DOOR PER MM.SDR SWAA050390Slide · reads lowR1 DOOR EVAC SLIDE LOW PRESSURE IND. REMOVED AND REPLACED R1 DOOR EVAC SLIDE PER MM.SDR SWAA043435Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 12R. REPAIRED SKIN PER SRM.SDR SWAA043434Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 3 EA FUSELAGE SKIN CRACKS AT BS 370, STR 26L, BS 377, STR 19R, AND BS 366, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA043433Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS AT BS 767, STR 19L AND BS 727E, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA043386Skin · crackedFUSELAGE SKIN CRACKED AT BS 376, STR 8L. REPAIRED SKIN PER SRM.SDR SWAA042853Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 727E, STRINGER 20R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042546Rib · crackedDURING SPV, FOUND LT HORIZONTAL STAB LOWER RIB CHORD AT STATION 120, CRACKED. REMOVED AND REPLACED LT HORIZONTAL STAB RIB CHORD SECTION PER SRM.SDR SWAA042379Keelbeam · corrodedDURING SCHEDULED C4 CHECK, FOUND LOWER RT KEEL BEAM CHORD AT BS 500A, STRINGER 28R, CORRODED. REPAIRED KEEL BEAM PER EA.SDR SWAA042369Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED R2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA042368Cable · frayedDURING SCHEDULED C4 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED L2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA042034Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN AT BS 793.5, STRINGER 18L, BS 840, STRINGER 15L, CRACKED. REPAIRED SKIN PER EA & SRM.SDR SWAA041612Motor · failedAT 8000 FT AND BELOW EXPERIENCED SEVERAL LOUD BUMPS WHICH SHOOK. THE AIRCRAFT SOURCE SEEMED TO BE FROM RIGHT, SIDE SLIGHT YAW (NOT IN PEDALS). REMOVED AND REPLACED NR 2 ENGINE VBV MOTOR AND BLEED VALVE, PER MM. REMOVED AND REPLACED NR 2 ENGINE MEC AND CIT SESDR SWAA041349Cover · crackedR1 DOOR EVAC SLIDE PRESSURE IND LENS COVER CRACKED. REMOVED AND REPLACED LENS COVER PER MM.SDR SWAA041151Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 787, STRINGER 20L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040243Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 2 CRACKS ON FUSELAGE SKIN AT BS 390, STRINGER 17R. REPAIRED SKIN CRACKS PER SRM.SDR SWAA032630Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 3.4 LONG FUSELAGE SKIN CRACKED AT BS 415, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA031866Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 312, BELOW 18R. REPAIRED SKIN PER SRM.SDR SWAA031134Indicator · out of limitsAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031128Indicator · out of limitsAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031039Girt Bar · out of adjustFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to N312SW, cancelled Oct 31, 2011