N302SW, cancelled Sep 29, 2014
Service difficulty reports · 369
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 = 'N302SW' AND deregistration_id = 'N302SW-2014-09-29' 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 = 'N302SW' AND deregistration_id = 'N302SW-2014-09-29' 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 SWAA052107Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 912, STR 4R. REPAIRED SKIN PER SWA EA.SDR SWAA051861Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS AT BS 500D + 18, STR 7R & STR 8R. REPAIRED SKIN PER SRM.SDR SWAA051860Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500A + 17, STR 8R. REPAIRED SKIN PER SRM.SDR SWAA051859Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727C + 8, STR 14R. REPAIRED SKIN PER SRM.SDR SWAA051383Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA051382Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440 TO BS 446, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA051381Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 16R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA051380Access Panel · crackedDURING SCHEDULED SERVICE CHECK, FOUND 4 EA CRACKS BELOW NLG W/W FWD ACCESS PANELS, LT & RT SIDE, BS 236 TO BS 243 + 1. REPAIRED WEB PER SWA EA.SDR SWAA043415Skin · crackedDURING WALKAROUND INSPECTION FOUND FUSELAGE SKIN CRACKED AT BS 727D+6, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA043279Cable · misroutedDURING SCHEDULED A2 CHECK, FOUND L2 DOOR EVAC SLIDE GIRT BAR CABLE MISROUTED. REROUTED L2 DOOR CABLE PER MM.SDR SWAA042655Bushing · wornDURING SCHEDULED C3 CHECK, RT ELEVATOR TAB FAILED FREE PLAY, CHECK. REMOVED AND REPLACED RT ELEVATOR TAB NR 1 HINGE BOLT AND BUSHING PER MM.SDR SWAA042615Cover · brokenBULLNOSE EMERGENCY EXIT LIGHT COVER AT ROW 4ABC, BROKEN. REMOVED AND REPLACED LIGHT COVER PER MM.SDR SWAA041600Hinge Bracket · crackedDURING SCHEDULED THRU CHECK, FOUND RT AND LT ELEVATOR TAB CONTROL ROD HINGE ATTACH EAR CRACKED. REMOVED AND REPLACED RT AND LT ELEVATOR TABS PER MM.SDR SWAA040774Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT EMERGENCY EXIT LIGHT INOP. RELAMPED AFT EMERGENCY EXIT LIGHT PER MM.SDR SWAA040645Slide · out of adjustDURING SCHEDULED D CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040631Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 887, STRINGER 21R. REPAIRED FRAME SECTION PER SRM.SDR SWAA040630Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 52 TO RBL 52, WL 208. REPAIRED FLOORBEAM SECTION PER SRM.SDR SWAA040629Support Beam · corrodedDURING SCHEDULED D CHECK, FOUND RT MLG SUPPORT BEAM CORRODED ON LOWER SURFACE. REPAIRED BEAM PER ER.SDR SWAA040617Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 706, STRINGER 11R, BS 616, STRINGER 7L. REPAIRED FRAMES SECTION PER SRM.SDR SWAA040616Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAMS UPPER CHORD CRACKED AT BS 664, BL 0, WL 208, BS 727A, RBL 45.5, WL 208. REPAIRED CHORDS PER ER.SDR SWAA040615Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 708, LBL 25, WL 203, BS 947, LBL 52, WL 208. REPAIRED WEB PER ER.SDR SWAA040613Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 480, BS 787, 907, STRINGER 9L ALSO AT BS 867, STRINGER 9R. REPAIRED FRAMES PER ER.SDR SWAA040612Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 360, STRINGER 10L, BS 277, WL 25, RBL 60 AND BS 727C, STRINGER 8L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040625Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 360 TO BS 380, LBL 65, WL 208. REPAIRED WEB PER SRM.SDR SWAA040624Attach Fitting · corrodedDURING SCHEDULED D CHECK, FOUND VERTICAL STAB AFT SPAR PRIMARY LUG AND AFT FACE CHAMFER CORRODED. REPAIRED VERTICAL STAB LUG PER ER.SDR SWAA040623Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BETWEEN STRINGERS 26L AND 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040622Channel · corrodedDURING SCHEDULED D CHECK, FOUND FLOOR ZEE CHANNEL CORRODED AT BS 270, FROM LBL 10 TO RBL 10, WL 208. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA040621Skin · corrodedDURING SCHEDULED D CHECK, FOUND DOUBLER CORRODED AT BS 442, BETWEEN STRINGERS 27R AND 28R. REPAIRED DOUBLER PER ER.SDR SWAA040620Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND PRESSURE BULKHEAD CRACKED AT BS 1016, LAP SPLICE 3 AND LAP SPLICE 4. REPAIRED BULKHEAD PER ER.SDR SWAA040619Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STRINGER 16L. REPAIRED FRAME PER SRM.SDR SWAA040618Stringer · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION ON STRINGER 27L, BS 380 TO BS 391 AND BS 400B + 15 TO BS 495. REPAIRED STRINGER PER SRM.SDR SWAA040614Bolt · corrodedDURING SCHEDULED D CHECK, FOUND LT MLG SIDE STRUT TO UNIVERSAL ATTACHMENT BOLT CORRODED. REMOVED AND REPLACED BOLT PER MM.SDR SWAA040597Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 460, STRINGER 14L, BS 595, STRINGER 7L, BS 597, STRINGER 8L, BS 706, STRINGER 11L, BS 616, STRINGER 2L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040596Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 878, STRINGER 10R, BS727E, STRINGER 5R, BS 578, STRINGER 8R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040595Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 747, STRINGERS 10R, 5R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040594Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727B, STRINGERS 5R, 2R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040593Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727D, STRINGERS 7R, 3R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040588Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727C, STRINGERS 5L, 6L, 7L, 8L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040587Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727D, STRINGERS 8L, 7L, 6L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040586Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727E, STRINGERS 7L, 5L, 4L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040585Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT THE FOLLOWING LOCATIONS STRINGER 9R, BS 837, BS 807, BS 787, BS 907. REPAIRED FRAMES PER ER.SDR SWAA040584Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT THE FOLLOWING LOCATIONS BS 460, STRINGER 14L AND BS 887, STRINGER 9L. REPAIRED FRAMES PER ER.SDR SWAA040592Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727C, STRINGERS 8R, 7R, 6R, 3R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040591Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727A, STRINGERS 7R, 6R, 4R, 2R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040590Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727A, STRINGERS 8L, 6L, 4L, 2L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040589Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727B, STRINGERS 9L, 8L, 5L, 2L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040583Skin · bulgedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN BULGED AT BS 795, BETWEEN STRINGER 26R AND STRINGER 27R. REPAIRED SKIN PER SRM.SDR SWAA040579Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BETWEEN STRINGER 28 L AND STRINGER 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040578Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 492, STRINGER 24R. REPAIRED FRAME PER SRM.SDR SWAA040577Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 259, LBL 11 AND RBL 11, WL 208. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.
Back to N302SW, cancelled Sep 29, 2014