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 SWAA030531Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 270.875 & BS 274, AT STR 16L. REPAIRED SKIN PER SRM.SDR SWAA030322Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030014Aileron · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT AILERON DELAMINATED ON LOWER SKIN BETWEEN NR 2 AND NR 3 HINGES. REMOVED AND REPLACED LT AILERON PER MM.SDR SWAA030021Slat · delaminatedDURING SCHEDULED C2 CHECK, FOUND NR 2 L/E SLAT DELAMINATED ON LOWER SURFACE. REMOVED AND REPLACED NR 2 L/E SLAT PER MM.SDR SWAA030020Slat · delaminatedDURING SCHEDULED C2 CHECK, FOUND NR 1 L/E SLAT DELAMINATED ON LOWER SURFACE. REMOVED AND REPLACED NR 1 L/E SLAT PER MM.SDR SWAA030019Lens · missingDURING SCHEDULED C2 CHECK, FOUND OVERHEAD BIN BULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 14 ABC. INSTALLED LENS PER MM.SDR SWAA023042Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022600Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT HORIZ STAB L/E SKIN CRACKED 90 OTBD OF ATTACH LUG. REPAIRED RT HORIZ STAB PER SRM.SDR SWAA021413Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED AT LT BS 352, WL 243. REPAIRED SKIN PER SWA EA.SDR SWAA021414Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED AT RT STA 502, WL 236. REPAIRED SKIN PER SRM.SDR SWAA021411Sign · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND BOTH LEFT AND RIGHT PHOTO-LUMINESCENT EMERGENCY EXIT STRIPS DELAMINATED AT ROW NR 9. REMOVED AND REPLACED STRIPS PER MM.SDR SWAA021412Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA021274Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA021254Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021205Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021173Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGERS CRACKED (2 EA) STR 13L BETWEEN BS 380 AND BS 400, AND BS 616, STR 4L. REPAIRED STRINGERS PER CASCADE ERO.SDR SWAA021171Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND SHEAR TIE CRACKED AT BS 360, BELOW STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA021122Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND SHEAR TIE CRACKED AT BS 360, STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA021047Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED (2 EA) AT BS 178, WL 234 AND LBL 15. REPAIRED WEB PER SRM.SDR SWAA020154Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKINS CRACKED (4 EA) AT STR 4R, BS'S 460, 500A, 500B AND 727E. REPAIRED SKINS PER SWA RA.SDR SWAA020040Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED (6 EA) BETWEEN BS 480 AND BS 486, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA020039Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 10R. REPAIRED SKIN PER SWA RA.SDR SWAA020038Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED 3.5 INCHES LONG AT BS 738, STR 20L. REPAIRED SKIN PER SWA RA.SDR SWAA012838Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED 1 1/4 INCH LONG AT BS 727, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA012837Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED 2 1/2 INCH LONG AT BS 500C+ 6, ABOVE STR 15R. REPAIRED SKIN PER SRM.SDR SWAA012801Slide · looseDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE VEIWING WINDOW LOOSE. SECURED WINDOW PER MM.SDR SWAA012515Window · cracked( DIVERSION )…………………………..R1 COCKPIT WINDOW ARCED & SHATTERED. R&R WINDOW & WINDOW HEAT CONTROLLER PER MM.SDR SWAA011909Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 3 EACH FUSELAGE SKIN CRACKS, BS 482, STRINGERS 10R & 4R, AND BS 787, STR 10L.. REPAIRED SKIN PER SWA RA.SDR SWAA011908Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STRINGER 10L. REPAIRED SKIN PER SWA RA.SDR SWAA011304Flashlight · inoperativeEMERGENCY FLASHLIGHT INOP IN AFT CABIN LOWER POSITION. R&R EMERGENCY FLASHLIGHT PER MM.SDR SWAA011166Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010851Wedge · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING NR 3 L/E SLAT T/E WEDGE DISBONDED, 75 PERCENT OF PANEL. REMOVED AND REPLACED NR 3 SLAT PER MM.SDR SWAA010238Cover · looseEEPLS TRACK COVER LOOSE AT ROW 9. SECURED TRACK COVER PER MM.SDR SWAA002592Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED EVAC SLIDE ASSY PER MM.SDR SWAA002572Engine · vibrationAIR TURNBACK, NR 2 ENGINE VIBRATION ON CLIMB-OUT. INSPECTED NR 2 ENGINE PER MM - NO ABNORMALITIES FOUND. RAN BOTH ENGINES AT T/O POWER FOR SEVERAL MINUTES. OK FOR SERVICE.SDR SWAA002378Slide · out of adjAFT SVC EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED SLIDE ASSY PER MM.SDR SWAA002210Control Cable · out of adjDIVERSION, T/E FLAPS INDICATED NOT FULLY RETRACTED AT ALTITUDE. L/E DEVICES SHOW FULLY RETRACTED. AUTO PILOT DISCONNECTED. RETARDED THROTTLES AND GEAR WARNING HORN SOUNDED. ADJUSTED FLAP CONTROL CABLES WFA, WFA AND FLAP FOLLOW-UP CABLES WFFA AND WFFB PER MSDR SWAA001880Skin · crackedON WALKAROUND, FOUND 3 INCH SKIN CRACK LT SIDE, NEAR WING ILLUMINATION LIGHT. REPAIRED SKIN PER SRM.SDR SWAA001035Switch · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT F/A''S EMERGENCY LIGHT SWITCH INOP. REMOVED AND REPLACED SWITCH PER MM.SDR SWAA000908Spar · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT ELEVATOR REAR SPAR CRACKED NEAR SECOND I/B TAB HINGE. REMOVED AND REPLACED LT ELEVATOR ASSY PER MM.SDR SWAA000903Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD LT SIDE CHORD CRACKED, WL 207. REPAIRED CHORD SECTION PER SRM.SDR SWAA000883Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED, BS 300, STRINGER 4L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA000877Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS AFT ENTRY DOOR CUTOUT UPPER FWD CORNER STUB FRAME CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA000876Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 986 FLOORBEAM UPPER SURFACE CORRODED. REMOVED AND REPLACED FLOORBEAM UPPER T-CAP PER SRM.SDR SWAA000868Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 516, STRINGER 10R. REPAIRED SKIN PER SRM.SDR SWAA000867Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 515, STRINGER 4R. REPAIRED SKIN PER SRM.SDR SWAA000866Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 947 FLOORBEAM CRACKED, LBL 56. REPAIRED BEAM PER SRM.SDR SWAA000852Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 344 FLOORBEAM UPPER SURFACE CORRODED, LBL 11. REPAIRED FLOORBEAM PER SRM.SDR SWAA000851Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD RIGHT O/B CHORD CRACKED, WL 207. REPAIRED CHORD SECTION PER SRM.SDR SWAA000838Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 312 FLOORBEAM UPPER SURFACE CORRODED, LBL 11 TO RBL 11. REPAIRED BEAM PER SRM.
Back to N312SW, cancelled Oct 31, 2011